How to Do SD in Excel?

Enter your data in a single column

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

Press Enter

To calculate by menu, go to the Data tab

Click Data Analysis

Select Descriptive Statistics

Choose your input range

Check Summary statistics

Click OK

Read the standard deviation result in the output

Suggested for You

Trending Today