Maybe you should learn statistics a little better. It's been a while since I
took statistics but there are two ways to calculate standard deviation,
depending on wether you are using a sample or the whole population. Try
STDEVP function and you will get the same answer that you are calculating.

Look in the help on these functions to learn what they are doing. STDEV
uses n(n-1) and STDEVP uses n². Which are both correct depending on whether
it is a sample of the population, or the whole population.

"Ganapati Hegde" wrote:

Hi Microsoft Office,

The formula for Standard Deviation provided in Excel ( =STDEV(range) )gives
a different answer when compared with the answer got by manually calculating
the Standard Deviation formula provided in the Statistics text books.

E.g.: Numbers - 5, 6, 8 & 9. When calculated using Microsoft Excel =STDEV
(....) we get an answer 1.82574185835055

But when calculated using the Text book methods of calculating of the Std.
Dev. formula, we get 1.58113883008419

Please can you advise why there is a difference in the answers?

Please can you make appropriate changes in the future Microsoft Office
releases giving the breakup of the formulas used? May be in the HELP option.
Because there are millions of excel users who are completely dependent
(unaware) on the formule in excel.

Many thanks,

Ganapati Hegde
Mumbai, INDIA.
+91 98195 58330


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions