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
Leave a Reply