How To Work Out Standard Deviation In Excel?

Enter your data in a single column or row

Select an empty cell where you want the result

Use `=STDEV.S(range)` for a sample standard deviation

Use `=STDEV.P(range)` for a population standard deviation

Replace `range` with the cells containing your data, such as `A1:A10`

Press Enter to calculate the standard deviation

Use `=STDEV.S(A1:A10)` for sample data

Use `=STDEV.P(A1:A10)` for all data in the population

In newer Excel versions, `STDEV.S` and `STDEV.P` are the preferred functions

In older Excel versions, use `=STDEV(range)` for sample standard deviation

Check that your selected range includes only the values you want to analyze

Suggested for You

Trending Today