Bug 85318 - Cronbach's alpha
Summary: Cronbach's alpha
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.3.2.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: needsDevEval
Keywords:
Depends on:
Blocks:
 
Reported: 2014-10-22 09:02 UTC by Edmund Laugasson
Modified: 2014-10-24 04:06 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments

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.


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.