- Get the count
- Calculate the sum
- From the count and the sum, calculate the average.
- From the average, get each deviation (error).
- Square each deviation (squared error).
- Add up the squares (sum of squared errors).
- Divide by (count - 1) (mean squared error. count - 1 is degrees of freedom).
- Take the square root.
- You now have the standard deviation.
Slightly different formula/method than the one you listed, but if you do some math, I imagine you'll find that they are equivalent and will give identical results.
Last edited by VernonDozier; Nov 7th, 2009 at 3:04 pm.
Reputation Points: 2614
Solved Threads: 687
Posting Expert
Offline 5,375 posts
since Jan 2008