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.