Bug 85318

Summary:	Cronbach's alpha
Product:	LibreOffice	Reporter:	Edmund Laugasson <edmund.laugasson>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	medium	CC:	jbfaure, jmadero.dev
Version:	4.3.2.2 release
Hardware:	All
OS:	All
Whiteboard:	needsDevEval
i915 platform:		i915 features:

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.