How To Work Out Standard Deviation On Excel?

Enter your data into a single column or row

Click an empty cell where you want the result

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

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

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

Press Enter

Use `STDEV.S` when your data is a sample

Use `STDEV.P` when your data includes the entire population

Suggested for You

Trending Today