=STDEV(number1, [number2], ...)One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single STDEV formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
number1:
The first number or range of numbers for which you want to calculate the standard deviation.
number2:
[Optional] Additional numbers or ranges of numbers for which you want to calculate the standard deviation. You can include up to 255 additional arguments.
The Standard Deviation is a statistical measure that quantifies the amount of variation or dispersion in a set of values. In simpler terms, it tells you how spread out the numbers in your data set are. A low standard deviation means that the values tend to be close to the mean (average) of the set, while a high standard deviation indicates that the values are spread out over a wider range.
In Excel, calculating the standard deviation is straightforward, thanks to built-in functions that simplify the process. The most commonly used functions for this purpose are STDEV.P for the entire population and STDEV.S for a sample of the population.
Imagine you are analyzing the test scores of a group of students to understand their performance:
| StudentID | Score |
|---|---|
| 1 | 85 |
| 2 | 90 |
| 3 | 78 |
| 4 | 92 |
| 5 | 88 |
You want to calculate the standard deviation of these scores to assess how consistent the students' performances are.
To calculate the standard deviation in Excel, you would use one of the following formulas:
=STDEV.P(B2:B6)=STDEV.S(B2:B6)In these formulas:
B2:B6 is the range of cells containing the test scores.When you apply the STDEV.S formula to the Test Scores Table, the output will give you the standard deviation of the scores. Let's say the calculated standard deviation is approximately 5.12. This indicates that the scores vary by about 5.12 points from the average score.
If the average score of the students is 86.6, a standard deviation of 5.12 suggests that most students scored between approximately 81.48 and 91.72. This range indicates a moderate level of consistency in student performance.
Calculating standard deviation in Excel is beneficial for several reasons:
STDEV.P for population data and STDEV.S for sample data.Understanding and calculating standard deviation in Excel is essential for anyone working with data, providing valuable insights into the nature of the data set and aiding in effective decision-making.
Happy Excel-ing!
You have a table where Column A contains the test scores of students in a class, and you want to assess the variability of their performance. You can use the STDEV function to calculate the standard deviation of the test scores. This provides insights into how consistently students are performing and helps identify whether the class is performing uniformly or if there are significant disparities in scores, which can inform teaching strategies and targeted interventions.
Beyond the STDEV function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.