How To Find Standard Deviation In Excel?

Enter your data in 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(A1:A10)` for sample data

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

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

You can also use the Data Analysis ToolPak if enabled

Go to the Data tab

Select Data Analysis

Choose Descriptive Statistics

Select your input range

Check Summary statistics

Click OK

Suggested for You

Trending Today