Grouped Frequency Data
Assuming a frequency distribution with class midpoints stored in range x and frequencies in range f:
Sample size, n =SUM(f) Sample total, $$\sum$$ fx =SUMPRODUCT(f, x) Sample mean, $$\sum$$ fx/n =SUMPRODUCT(f, x)/SUM(f) Corrected sum of squares, Sxx =SUMPRODUCT(f, x, x)-SUMPRODUCT(f, x)^2/SUM(f) Sample variance, s2 =(SUMPRODUCT(f, x, x)-SUMPRODUCT(f, x)^2/SUM(f))/(SUM(f)-1) Sample standard deviation, s =SQRT(Sample variance)