By definition standard deviation has divisor 'N' .(adsbygoogle = window.adsbygoogle || []).push({});

But in Microsoft Excel the "STDEV" function gives 'N-1' as divisor.

This may not be major issue to many of the people. But the command "STDEV"

makes many users feel that this is standard deviation, i.e. it has divisor 'N'. Misleading...is not it?

**Physics Forums - The Fusion of Science and Community**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Standard deviation in Excel.

Loading...

Similar Threads - Standard deviation Excel | Date |
---|---|

I Standard Deviation Versus Sample Size & T-Distribution | Dec 20, 2017 |

I Standard deviation of data after data treatment | Oct 15, 2017 |

I Generating a random sample with a standard deviation | Aug 11, 2017 |

**Physics Forums - The Fusion of Science and Community**