# 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?

-

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

Questions on MathOverflow are expected to relate to research level mathematics within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

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

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