Calculation of Cronbach's alpha in spreadsheet: An alternative to costly statistics software

Abstract

[...]we provided an alternative way to calculate Cronbach's alpha, backed by theoretical knowledge. OpenOffice(TM) Calc is free spreadsheet software which is a part of Apache OpenOffice(TM) software package (The Apache Software Foundation, Los Angeles, California, USA). The formula for calculation of α is:[2],[3] [INLINE:1] Where, k = number of items (question/statement) in questionnaire Si = SD of ith item St = SD of sum score We wrote A12 cell text as [INSIDE:1] for ease of identification and the right adjacent cell (B12) equation was written as "= COUNT (B2:E2)/(COUNT (B2:E2)-1)".