Notes on using StDevCoding.xls

This worksheet uses the new definitions of the Standard Deviation and Variance

Sum of squares of deviations:

Or for a frequency distribution

Sum of squares of deviations:

Then

Mean square deviation:

Root mean square deviation:

Sample variance:

Sample standard deviation:

The values and frequencies can be changed as can the value of a and b.