Skip to Main Content

Formulas

Using Formulas in Statistics

SUM function

COUNT function

Mean: SUM/COUNT

Deviation Score: (=Mean/original score)

Squared Deviation Score: (=Deviation Score^2)

SQRT function

Variance: (=SUM of Squared Deviation Score/COUNT)

Standard Deviation: =SQRT of Variance.

Z-score: (=Deviation Score/Standard Deviation)