View Single Post
  #2  
Old 02-08-2007, 02:09 PM
bbartlog bbartlog is offline
Senior Member
 
Join Date: Nov 2006
Posts: 882
Default Re: Stupid Variance Question

- find the average value of your samples
- sum up the squares of all the differences between each sample and the average
- divide this sum by the number of samples less 1 (so 999 in your example)

If you don't want to do it by hand, Excel (and presumably its OpenOffice equivalent) has a nice variance calculation function (VAR).
Reply With Quote