Question: how to calculate standard deviation in xls?
Answer: Calculate the mean (μ).
For each number, calculate the distance to the mean.
For each number, square this distance.
Sum (∑) these values.
Divide by the number of data points (N = 5).
Take the square root.
Fortunately, the STDEV. P function in Excel can execute all these steps for you.