Bug 85318 - Cronbach's alpha
Summary: Cronbach's alpha
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.2.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevEval
Depends on:
Blocks: Cell-Formula
  Show dependency tree / graph
 
Reported: 2014-10-22 09:02 UTC by Edmund Laugasson
Modified: 2020-08-16 21:01 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Edmund Laugasson 2014-10-22 09:02:40 UTC 
I would calculate Cronbach's alpha - http://en.wikipedia.org/wiki/Cronbach%27s_alpha
If I know the formula - certainly I can calculate it but special function in spreadsheet calculation (Calc) would be appreciated.
This is used in statistical calculations and also scientifical data analysis.
Comment 1 Jean-Baptiste Faure 2014-10-23 17:59:55 UTC 
Which special function is missing from your point of view ?

Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested informations. Thank you for your understanding.

Best regards. JBF
Comment 2 Edmund Laugasson 2014-10-23 19:40:07 UTC 
The idea is to have exact function, which calculates Cronbach's Alpha from given data set. E.g. =CRONALPHA(data), =CALPHA(data) or similar. Data is range of cells containing research results. There could be also similar dialog window like here - http://www.real-statistics.com/wp-content/uploads/2012/12/reliability-dialog-box.png - also these other functions are needed for statistics.

Example calculations made here - http://www.real-statistics.com/reliability/cronbachs-alpha/ and also here - http://www.real-statistics.com/reliability/cronbachs-alpha/cronbachs-alpha-advanced/

Also it is written here - http://www.real-statistics.com/announcing-release-1-6/ - there seems to be such function like CRONALPHA.
This Cronbach's Alpha and other statistical function examples can be downloaded from here - http://www.real-statistics.com/free-download/
Sorry about MS Excel but at least there is possible to look into formulas and functions.
Hopefully will be these functions available in future also in LibreOffice Calc. Lot of people are asking about LibreOffice's statistical analysis pack like MS Excel has such (http://office.microsoft.com/en-us/excel-help/about-statistical-analysis-tools-HP005203873.aspx). I would propose to have such statistics already built-in into LibreOffice Calc. This means, that Cronbach's Alpha is not the only one function, what is needed. I understand, that it takes time to implement all these previously mentioned functions but it would be good to start step-by-step (function-by-function).
Comment 3 Joel Madero 2014-10-24 04:06:17 UTC 
Seems like a fine enhancement request. Marking as NEW.

Requesting dev eval because I think probably easy to implement.
Comment 4 Edmund Laugasson 2015-05-24 04:16:25 UTC 
Added Bug 91548 as feature request where described more aspects of data analysis. Still the current Cronbach's Alpha is important as other reliability functions and rest of real statistics functions.
Certainly there is analysis toolpak which needs also to be implemented in Calc.
Comment 5 Robinson Tryon (qubit) 2015-12-13 11:20:49 UTC Comment hidden (obsolete)