Mean Median Mode in Excel and Sheets
All Calculators Practice Questions
Excel and Google Sheets can find the mean, median and mode of a set of numbers. Put one number in each cell, check that the cells contain numbers rather than text, and use the formulas below. This guide shows a small example you can check by hand.
See also: step-by-step guide to finding mean, median and mode.
How do you enter data in a spreadsheet?
Type the numbers 2, 3, 3, 6 and 11 in cells A2 to A6, one value per row. Do not type commas between separate values in the same cell. Select a blank cell for each answer. This layout works in Excel and Google Sheets.
How do you calculate the mean?
Type =AVERAGE(A2:A6). The five values total 25, so the mean is 25 ÷ 5 = 5. AVERAGE ignores blank cells, but text and numbers stored as text may cause confusing results. Check the cell formats before calculating.
How do you calculate the median?
Type =MEDIAN(A2:A6). The values are already sorted: 2, 3, 3, 6, 11. The middle value is 3, so the median is 3. For an even number of values, MEDIAN averages the two middle values.
How do you find the mode?
In Excel, type =MODE.SNGL(A2:A6). The value 3 appears twice, more often than any other value, so the mode is 3. Excel MODE.MULT can return multiple modes; in current Excel it can spill into neighboring cells. Google Sheets supports MODE and MODE.MULT; check the function name available in your version.
How do you make a frequency table?
Write each distinct number in column C: 2, 3, 6, 11. In D2, type =COUNTIF($A$2:$A$6,C2) and copy it down. The frequencies are 1, 2, 1 and 1. Their total should equal the number of numeric observations, which is five.
What errors should you check?
A #N/A result for a mode can mean there are no repeated values. A #NAME? error can mean the function is misspelled or unsupported in your spreadsheet version. If the result looks wrong, inspect blank cells, text-formatted numbers, hidden rows and the selected cell range.
Worked example table
| Cell | Value |
|---|---|
| A2 | 2 |
| A3 | 3 |
| A4 | 3 |
| A5 | 6 |
| A6 | 11 |
Answers: mean = 5, median = 3, mode = 3, range = 11 − 2 = 9.
Frequently asked questions
Can I use AVERAGE in Google Sheets?
Yes. Use =AVERAGE(A2:A6) for the same sample data.
Does MEDIAN need sorted data?
No. The spreadsheet sorts values internally for the calculation.
What if two numbers tie for mode?
Use MODE.MULT where available to return multiple most-frequent values.
Does AVERAGE count empty cells?
No. Empty cells in a referenced range are ignored.
Can I check my spreadsheet answer online?
Yes. Compare the same dataset with the main statistics calculator.
Next, use the mean median mode calculator, try the practice worksheets, or read the mean formula guide.