How to Get the Standard Deviation in Excel?

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 cell range, such as `A1:A10`

Press `Enter`

To include only specific cells, select them directly in the formula

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

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

Use `=STDEV.P(A1:A10)` for a population

Suggested for You

Trending Today