View Single Post
Old January 31, 2013, 05:42 PM   #8
Evan Thomas
Join Date: July 7, 2008
Location: Upper midwest
Posts: 5,098
Without going all technical, standard deviation is a measure of how tightly a set of values clusters around the mean (arithmetic average) of those values: the smaller the SD, the less those values spread out around the mean.

Easy to calculate in Excel: the basic formula is =STDEV(number 1;number 2;...). Generally you'll replace "number 1..." with the cell references where the numbers can be found: so =STDEV(A1;A50) will give the standard deviation of the values in the cells from A1 to A50.

Easy as pi.

It's a pity that you can't just upload the spreadsheet here and insert it into your post as an attachment -- wouldn't it just raise the tone if we could all upload spreadsheets? Talk about responsible gun owners...
Never let anything mechanical know you're in a hurry.
Evan Thomas is offline  
Page generated in 0.03694 seconds with 7 queries