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.