Cronbach Alpha

[Stevieray]

Is there a function in Excel for Cronbach Alpha? Or, does anyone know where
one can be bought? Is there an SAS function in Excel?

Thanks,

 

[David Biddulph]

Which of the suggestions that you found with a Google search have you tried?

 

[Stevieray]

David,

I found only one at (www.kittle.siu.edu/course/stats/Cronbach_alpha) and
have not yet tried it. I thought there might be one inside of excel. Have
you tried one from a Google search?

 

[David Biddulph]

It's not my specialist subject, but a newsgroup discussion in 2004 suggested
a simple Excel formula.
First thread found from:
http://groups.google.co.uk/groups?q=cronbach+alpha+excel&start=0&scoring=d

A web search at http://www.google.co.uk/search?q=cronbach+alpha+excel found
numerous references.
One of the recommendations was
http://www.gifted.uconn.edu/siegle/...ility and Validity/reliabilitycalculator2.xls
(see also
http://www.gifted.uconn.edu/Siegle/research/Instrument Reliability and Validity/Reliability.htm)
There were various other suggestions at
https://computer.justanswer.com/excel/15qaz-use-excel-calculate-cronbachs

I haven't looked at all the thousands of other references.

 

[Stevieray]

Thank you...

It's not my specialist subject, but a newsgroup discussion in 2004 suggested
a simple Excel formula.
First thread found from:
http://groups.google.co.uk/groups?q=cronbach+alpha+excel&start=0&scoring=d

A web search at http://www.google.co.uk/search?q=cronbach+alpha+excel found
numerous references.
One of the recommendations was
http://www.gifted.uconn.edu/siegle/...ility and Validity/reliabilitycalculator2.xls
(see also
http://www.gifted.uconn.edu/Siegle/research/Instrument Reliability and Validity/Reliability.htm)
There were various other suggestions at
https://computer.justanswer.com/excel/15qaz-use-excel-calculate-cronbachs

I haven't looked at all the thousands of other references.