Question

How do I fomulate standard deviation problem in excel

Answer 1

Solution:

Standard deviation = Sqrt(summation(Xi-Xbar)^2/n) for population standard deviation

For sample standard deviation = Sqrt(summation(Xi-Xbar)^2/(n-1))

For population in excel formula is Stdev.P(Data range)

For sample in excel formula is Stdev.S(Data range)

You can calculate standard deviation for Population and standard deviation.

For manually in excel, Calculate mean, than calculate (Xi-Xbar) than (Xi-Xbar)^2 than calculate summation and decide by n or (n-1) according to population or standard deviation.