How to Calculate Mean and Standard Deviation With Excel 2007
This wikiHow teaches you how to find the mean (average) and standard deviation of a set of numbers in Microsoft Excel 2007. Open Microsoft Excel. Click or double-click the Excel app icon, which resembles a green 'X' on a green-and-white...
Adding Data
-
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 1
Open Microsoft Excel. Click or double-click the Excel app icon, which resembles a green "X" on a green-and-white background.- If you already have an Excel document that contains your data, double-click the document to open it in Excel 2007, then skip ahead to finding the mean.
-
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 2
Select a cell for your first data point. Click once the cell in which you want to enter your first number.- Be sure to select a cell in a column that you want to use for the rest of your points.
-
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 3
Enter a number. Type in one of your data points' numbers. -
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 4
Press ↵ Enter. Doing so will both enter the number into your selected cell and move your cursor down to the next cell in the column. -
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 5
Enter each of the rest of your data points. Type in a data point, press Enter, and repeat until you've entered all of your data points in the same column. This will make it easier to calculate the mean and the standard deviation of the list.
Finding the Mean
-
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 6
Click an empty cell. Doing so places your cursor in the cell. -
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 7
Enter the "mean" formula. Type =AVERAGE( ) into the cell.[1] -
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 8
Place your cursor in between the parentheses. You can press the left arrow key once to do this, or you can click in between the two parentheses in the text box at the top of the document. -
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 9
Add your data range. You can input a range of data cells by typing the name of the first cell in the list of data, typing a colon, and typing in the last cell name in the column. For example, if your list of numbers goes from cell A1 through cell A11, you would type in A1:A11 in between the parentheses.- Your completed formula should look something like this: =AVERAGE(A1:A11)
- If you want to calculate the mean of a few numbers (not a whole range), you can type each number's cell name between the parentheses and separate the names with commas. For example, to find the mean of A1, A3, and A10, you would type in =AVERAGE(A1,A3,A10).
-
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 10
Press ↵ Enter. Doing so will run your formula, causing the mean of your selected values to display in your currently selected cell.
Finding the Standard Deviation
-
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 11
Click an empty cell. Doing so places your cursor in the cell. -
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 12
Enter the "standard deviation" formula. Type =STDEV( ) into the cell.[2] -
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 13
Place your cursor in between the parentheses. You can press the left arrow key once to do this, or you can click in between the two parentheses in the text box at the top of the document. -
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 14
Add your data range. You can input a range of data cells by typing the name of the first cell in the list of data, typing a colon, and typing in the last cell name in the column. For example, if your list of numbers goes from cell A1 through cell A11, you would type in A1:A11 in between the parentheses.- Your completed formula should look something like this: =STDEV(A1:A11)
- If you want to calculate the standard deviation of a few numbers (not a whole range), you can type each number's cell name between the parentheses and separate the names with commas. For example, to find the standard deviation of A1, A3, and A10, you would type in =STDEV(A1,A3,A10).
-
How to Calculate Mean and Standard Deviation With Excel 2007 Picture 15
Press ↵ Enter. Doing so will run your formula, causing the standard deviation value for your selected values to display in your currently selected cell.
5 ★ | 1 Vote
You should read it
- How to Round in Excel
- How to enter formula data in Excel
- How to enter formulas in Excel
- Split data in columns in Excel
- Data type in C / C ++
- Data type in C #
- Data types in SQL Server
- How to name, comment and protect cells in Excel
- Turn off turn on the character repeat function in Excel
- Convert data types in C #
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- How to name a cell or Excel data area
May be interested
Instructions for creating and editing PDF on ZonePDF
How to create exams on Microsoft Forms
How to use the LOOKUP function in excel?
Delete horizontal lines in text on Microsoft Word
6 ways to fix Excel error not displaying spreadsheet content
52 computer keyboard shortcuts for super fast computer operation