You are viewing the article How to Calculate Standard Deviation in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 3,961 times.
This wikiHow teaches you how to calculate the standard deviation of a dataset in Microsoft Excel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fd/Calculate-Standard-Deviation-in-Excel-Step-1-Version-4.jpg/v4-728px-Calculate- Standard-Deviation-in-Excel-Step-1-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/fd/Calculate-Standard-Deviation-in- Excel-Step-1-Version-4.jpg/v4-728px-Calculate-Standard-Deviation-in-Excel-Step-1-Version-4.jpg”,”smallWidth”:460,”smallHeight”:346,” bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output”></div>”}
Open Microsoft Excel. Click or double-click the Microsoft Excel application with a white “X” icon on a dark green background. The Excel launch page opens.
- If you already have an Excel file containing the data you need to use, double-click the document to open it in Excel, then continue with the “Click on a blank cell” step.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/85/Calculate-Standard-Deviation-in-Excel-Step-2-Version-4.jpg/v4-728px-Calculate- Standard-Deviation-in-Excel-Step-2-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/85/Calculate-Standard-Deviation-in- Excel-Step-2-Version-4.jpg/v4-728px-Calculate-Standard-Deviation-in-Excel-Step-2-Version-4.jpg”,”smallWidth”:460,”smallHeight”:342,” bigWidth”:728,”bigHeight”:542,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Blank Workbook . This option is on the top left of the Excel launch page.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b1/Calculate-Standard-Deviation-in-Excel-Step-3-Version-4.jpg/v4-728px-Calculate- Standard-Deviation-in-Excel-Step-3-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b1/Calculate-Standard-Deviation-in- Excel-Step-3-Version-4.jpg/v4-728px-Calculate-Standard-Deviation-in-Excel-Step-3-Version-4.jpg”,”smallWidth”:460,”smallHeight”:341,” bigWidth”:728,”bigHeight”:540,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter the values that you want to use. Select the column you want to import, and then enter data into each cell in that column.
- For example, if you select column “A” as the input area, you can enter numbers in cells A1 , A2 , A3 , and so on.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6e/Calculate-Standard-Deviation-in-Excel-Step-4-Version-4.jpg/v4-728px-Calculate- Standard-Deviation-in-Excel-Step-4-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6e/Calculate-Standard-Deviation-in- Excel-Step-4-Version-4.jpg/v4-728px-Calculate-Standard-Deviation-in-Excel-Step-4-Version-4.jpg”,”smallWidth”:460,”smallHeight”:346,” bigWidth”:728,”bigHeight”:548,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the empty box. This will be the cell where you want to display the standard deviation value. You need to click this box to select.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/09/Calculate-Standard-Deviation-in-Excel-Step-5-Version-4.jpg/v4-728px-Calculate- Standard-Deviation-in-Excel-Step-5-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/09/Calculate-Standard-Deviation-in- Excel-Step-5-Version-4.jpg/v4-728px-Calculate-Standard-Deviation-in-Excel-Step-5-Version-4.jpg”,”smallWidth”:460,”smallHeight”:346,” bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter the formula to calculate the standard deviation. The formula that you need to enter in a blank cell is =STDEV.P( ) , where “P” stands for “Population” – overall. The population standard deviation is calculated based on the sum of the data points (N). [1] X Research Source
- If you want to find the standard deviation of the sample group (“Sample”), you need to enter =STDEV.S( ) here. The sample group standard deviation is calculated from the number of data points you have minus 1 (N-1).
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/10/Calculate-Standard-Deviation-in-Excel-Step-6-Version-4.jpg/v4-728px-Calculate- Standard-Deviation-in-Excel-Step-6-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/10/Calculate-Standard-Deviation-in- Excel-Step-6-Version-4.jpg/v4-728px-Calculate-Standard-Deviation-in-Excel-Step-6-Version-4.jpg”,”smallWidth”:460,”smallHeight”:347,” bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output”></div>”}
Add range of values. Between parentheses, enter the letter and number of the first cell containing the data, a colon (:) and then the letter and number of the last data cell.
- For example, if you enter data in column “A” from rows 1 to 10, the formula will be =STDEV.P(A1:A10) .
- If you only want to display the standard deviation of the values of a few scattered cells such as A1 , B3 and C5 , enter the cell names and separate them by commas (for example, =STDEV.P(A1,B3, C5) ).
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2c/Calculate-Standard-Deviation-in-Excel-Step-7-Version-4.jpg/v4-728px-Calculate- Standard-Deviation-in-Excel-Step-7-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2c/Calculate-Standard-Deviation-in- Excel-Step-7-Version-4.jpg/v4-728px-Calculate-Standard-Deviation-in-Excel-Step-7-Version-4.jpg”,”smallWidth”:460,”smallHeight”:342,” bigWidth”:728,”bigHeight”:541,”licensing”:”<div class=”mw-parser-output”></div>”}
Press ↵ Enter . Excel will execute the formula and display the standard deviation of the cells you selected.
Advice
- In most cases, the population standard deviation is used to calculate all the data points you have selected.
Warning
- The old =STDEV( ) formula no longer works on versions from Excel 2007 and earlier.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 3,961 times.
This wikiHow teaches you how to calculate the standard deviation of a dataset in Microsoft Excel.
Thank you for reading this post How to Calculate Standard Deviation in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: