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.
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
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).
Seems like a fine enhancement request. Marking as NEW.
Requesting dev eval because I think probably easy to implement.
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.
Migrating Whiteboard tags to Keywords: (needsDevEval)