Finding the Mean Enter the scores in one of the columns on the Excel spreadsheet see the example below. After the data have been entered place the cursor where you wish to have the mean average appear and click the mouse button. How to Use Excel to Find the Mean Median Mode Ranges.
2 3 4 9Step 2 Count up the amount of numbers in the set.
Note that you dont have to sort the data yourself before you apply Median just select the range of data. Average which is the arithmetic mean and is calculated by adding a group of numbers and then dividing by the count of those numbersFor example the average of 2 3 3 5 7 and 10 is 30 divided by 6 which is 5. For consistency it helps to enter the number in consecutive cells in either a row or column and for readability a column is betterStep 2 Enter the MODE function into the cell in which you wish to display the result. The arithmetic means mode and median are the base of any statistical analysis of data.