Reliability analysis

[Jack]

Hi there:

Do you know if reliability analysis (Cronbach Alpha) can
be performed in Excel using data analysis? Thanks for
your help.

Jack

 

[Jerry W. Lewis]

If you have 15 observations on each of 4 variables, in A115

put =SUM(A11) into E1 and copy down through E15
put =VAR(A1:A15) into A16 and copy across through E16

Chronbach Alpha is
=(1-E16/SUM(A1616))/(1-1/COUNT(A1616))

Jerry