How to Use STDEV to Calculate Sample Standard Deviation in Excel

Written by

in

In Excel, use STDEV.S to calculate the sample standard deviation and STDEV.P to calculate the population standard deviation. In older workbooks, you can continue using the compatible STDEV function. Sample data must contain at least two numerical values; the 10 measurements in the example produce a sample standard deviation of approximately 27.46392 when calculated with =STDEV.S(A3:A12), with a mean of 1328.6.

Source:Dataconomy · Read original

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *