You are viewing the article How to Calculate Mean and Standard Deviation in Excel 2007 at Lassho.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 59,405 times.
In this article, the wikiHow will show you how to find the mean and standard deviation of a set of numbers in Microsoft Excel 2007.
Steps
More data
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/28/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-1-Version-5.jpg/ v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-1-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 2/28/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-1-Version-5.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007- Step-1-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Open Microsoft Excel by clicking or double-clicking the application icon. It’s an icon with a green “X” on a blue and white background.
- If an Excel document already contains data, double-click it to open it in Excel 2007 and go straight to finding the mean.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2c/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-2-Version-5.jpg/ v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-2-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 2/2c/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-2-Version-5.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007- Step-2-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Select any cell as the first data point. Click once in the cell where you want to enter the first number.
- Select the cell on the column you want to use for the rest of the data.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/26/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-3-Version-5.jpg/ v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-3-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 2/26/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-3-Version-5.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007- Step-3-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Enter number. Enter the first number in your data.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9b/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-4-Version-5.jpg/ v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-4-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 9/9b/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-4-Version-5.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007- Step-4-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Press ↵ Enter to enter the number in the selected cell and move the cursor down to the next cell in the column.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/99/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-5-Version-5.jpg/ v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-5-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 9/99/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-5-Version-5.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007- Step-5-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Enter the remaining numbers. Type a data point, press Enter , and then repeat until all the data has been entered in the column containing the first data point. This makes it easier to calculate the mean and standard deviation.
Find the mean
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a1/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-6-Version-5.jpg/ v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-6-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ a/a1/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-6-Version-5.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007- Step-6-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Click on an empty cell to place the mouse pointer in that cell.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/84/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-7-Version-5.jpg/ v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-7-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 8/84/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-7-Version-5.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007- Step-7-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Enter the formula “average value” =AVERAGE( ) in the cell. [1] X Research Source
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8d/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-8-Version-4.jpg/ v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-8-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 8/8d/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-8-Version-4.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007- Step-8-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Place the cursor between the brackets by pressing the left arrow key once or by clicking between the brackets in the text box at the top of the document.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b5/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-9-Version-4.jpg/ v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-9-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ b/b5/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-9-Version-4.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007- Step-9-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Add your data domain. You can enter a data range by typing the name of the first cell in the data list, typing a colon, and then typing the name of the last cell in the column. For example, if the data runs from cell A1 to cell A11 , it would be A1:A11 in brackets.
- Your complete formula would be: =AVERAGE(A1:A11)
- If you want to calculate the average of several numbers (but not the whole data range), you can enter the name of each cell containing the numbers to be averaged in brackets and separate them by commas. For example, to find the mean of A1 , A3 , and A10 , we would type =AVERAGE(A1,A3,A10) .
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/94/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-10-Version-4.jpg/ v4-460px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-10-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 9/94/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-10-Version-4.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007- Step-10-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Press ↵ Enter to run the formula, displaying the average of the selected numbers in the current cell.
Find the standard deviation
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/dc/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-11.jpg/v4-460px- Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-11.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/dc/Calculate-Mean- and-Standard-Deviation-With-Excel-2007-Step-11.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-11.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click on any empty cell to place the mouse pointer there.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3f/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-12.jpg/v4-460px- Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-12.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3f/Calculate-Mean- and-Standard-Deviation-With-Excel-2007-Step-12.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-12.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter the formula “standard deviation” =STDEV( ) in the cell. [2] X Research Source
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/31/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-13.jpg/v4-460px- Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-13.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/31/Calculate-Mean- and-Standard-Deviation-With-Excel-2007-Step-13.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-13.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Place the mouse pointer between the brackets by pressing the left arrow key once or by clicking between the brackets in the text box at the top of the document.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1c/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-14.jpg/v4-460px- Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-14.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/1c/Calculate-Mean- and-Standard-Deviation-With-Excel-2007-Step-14.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-14.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Add data domain. You can enter a data range by typing the first cell name of the data list, typing a colon, and then typing the last cell name in the column. For example, if the data runs from cells A1 to A11 , it would be A1:A11 in brackets.
- Your complete formula would be: =STDEV(A1:A11)
- If you want to calculate the standard deviation of several numbers (but not a range of data), you can enter the name of each cell containing the related data between brackets and separate them by commas. For example, to find the standard deviations of A1 , A3 , and A10 , we use =STDEV(A1,A3,A10) .
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f5/Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-15.jpg/v4-460px- Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-15.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f5/Calculate-Mean- and-Standard-Deviation-With-Excel-2007-Step-15.jpg/v4-728px-Calculate-Mean-and-Standard-Deviation-With-Excel-2007-Step-15.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Press ↵ Enter to run the formula, calculate the standard deviation for the selected numbers, and display the result in the current cell.
Advice
- Changing any cell value in the data range will change all related formulas and corresponding results.
- You can also use the instructions above for newer versions of Excel (such as Excel 2016).
Warning
- Check the list of data points again before calculating the mean and standard deviation.
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 59,405 times.
In this article, the wikiHow will show you how to find the mean and standard deviation of a set of numbers in Microsoft Excel 2007.
Thank you for reading this post How to Calculate Mean and Standard Deviation in Excel 2007 at Lassho.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: