## Why does Excel/Wolfram come up with differnt stdev than I do? [closed]

Hi folks,

I plugged the following set of numbers into Excel:

[600 470 170 430 300]

I found the mean (394), summed the numbers, divided by 5 to get variance (21704). I then did the square root to find stdev (147.32).

Using Excel or Wolfram Alpha's variance and stdev function give me differnt numbers, variance 27130 and stdev 164.71 respectively. Why? I believe I am following the equation as listed on Wikipedia, my stat text book, and the following page:

http://www.mathsisfun.com/data/standard-deviation.html

What am I missing?

-
Maybe math.stackexchange.com/questions/15098/… can help you. – Shai Covo Feb 4 2011 at 0:38

## closed as off topic by Andrey Rekalo, Dmitri Pavlov, Tim Perutz, David Roberts, Yemon ChoiFeb 4 2011 at 1:06

The unbiased variance estimator normalizes by $n-1$, instead of $n$. This may be the difference you're seeing.