Standard Deviation Formula Excel Example. Microsoft classifies stdev as a compatibility function now replaced by the stdev s function. If the standard deviation value is lower then the frequency of the data points is closer to the mean average value.
To calculate the standard deviation of a data set you can use the stedv s or stedv p function depending on whether the data set is a sample or represents the entire population. In this example x 1 5 x 2 1 x 3 4 x 4 6 x 5 9 same numbers as above x 5 sample mean n 5 sample size. Average d8 d20 in cell g11.
In the example shown the formula in f7 is.
If data represents an entire population use the stdevp function. Stdev c5 c11 note. If data represents an entire population use the stdevp function. A risky stock will show a higher standard deviation while a safer stock such as blue chip companies like apple or coca cola will show a lower standard deviation.
