How To Find A Standard Deviation In Excel?

Enter your data into a single column or row

Click an empty cell where you want the result to appear

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

Select the range of cells containing your data

Close the formula with `)`

Press `Enter`

Use `=STDEV.P(` if your data represents an entire population

Select the range of cells containing your data

Close the formula with `)`

Press `Enter`

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

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

Use the `Data Analysis` ToolPak if you want a built-in analysis tool

Go to the `Data` tab

Click `Data Analysis`

Choose `Descriptive Statistics`

Select your input range

Check `Summary statistics`

Click `OK`

Suggested for You

Trending Today