Free calculator
Mean median mode range calculator
Paste a list of numbers (from Google Sheets, Excel, or plain text) and get mean, median, mode(s), range, plus count, sum, minimum, and maximum. Expand sorted list when n ≤ 24 to see how the median sits in the ordered data. The Google Sheets & Excel block below has AVERAGE, MEDIAN, MODE.SNGL, and range patterns.
When to use this calculator
Quick central tendency and range for a plain list—before you mirror the same logic in a workbook.
- Homework or self-study checks for mean, median, mode, and range on the same dataset.
- Compare mean vs median when outliers might pull the average away from the “typical” middle.
- Spot multiple modes (bimodal data) or no mode when every value is unique.
- Copy Sheets / Excel patterns below for
AVERAGE,MEDIAN, and mode helpers on the same range.
Start from a numeric list. The mean is the sum divided by how many values you have. The median is the middle after sorting—or the average of the two middle values when the count is even. The mode is the value that appears most often (there can be more than one, or none if every value is unique). The range is the largest value minus the smallest.
Mean
Mean = (sum of values) ÷ n. It is the same arithmetic average as AVERAGE on an unweighted list.
Median
Sort the data. If n is odd, the median is the middle entry. If n is even, take the average of the two central entries—the rule most homework and spreadsheet functions use.
Mode
Count how often each value appears. Any value tied for highest frequency is a mode. If every value appears exactly once, there is no mode in the usual textbook sense.
Range
Range = maximum − minimum on the same list. With one number, the range is 0.
We do not accept weighted observations, frequency tables, or quartiles / IQR on this page—and we do not print variance or standard deviation here.
For weighted means (value + weight per line), open the average calculator.
For variance and standard deviation with sample vs population control, open the standard deviation calculator.
FAQs on this page cover even-n medians, no mode, multiple modes, and spreadsheet function match-ups.
Google Sheets & Excel
In Google Sheets and Microsoft Excel with English function names, AVERAGE is the arithmetic mean, MEDIAN is the median, and MODE.SNGL returns one mode when several tie (use MODE.MULT as an array formula if you need every mode). Range here is MAX(range) − MIN(range). Replace A1:A99 with your range. If your Excel is not in English, use Formulas → Insert function to match your language pack.
=AVERAGE(A1:A99)Same sum ÷ n as this page’s mean for an unweighted list.
=MEDIAN(A1:A99)Matches this page: middle value, or average of two middles when n is even.
=MODE.SNGL(A1:A99)For every tied mode, use MODE.MULT as an array formula or tally frequencies manually—this page lists all modes when they tie.
=MAX(A1:A99)-MIN(A1:A99)Same spread definition as range on this page (not interquartile range).
Frequently asked questions
What is the difference between mean and median?
The mean is sum ÷ n—every value pulls the result. The median is the middle after sorting, so a few very large or very small outliers move the mean more than the median. Use the mean for symmetric, well-behaved data; use the median when you want a robust center.
How do you find the median when there is an even number of values?
Sort the list. With an even count, take the two middle numbers and average them. That matches common courses and MEDIAN in Google Sheets and English Excel.
Can there be no mode?
Yes. When every value appears exactly once, no value is “most frequent,” so we show no mode here. (Some lessons still list every value as a mode—we follow the no unique winner convention.)
What if there are multiple modes?
When two or more values tie for the highest count, each is a mode (bimodal, trimodal, …). This page lists all tied modes, sorted low to high.
How is range calculated?
Range = maximum − minimum on your list. With one value, min and max are the same, so range is 0.
Is this the same as your average calculator?
For a simple unweighted list, the mean here matches the simple mode on the average calculator. That tool also does weighted averages (value + weight per line), which this page does not.
Does this calculator include standard deviation?
No. For variance and standard deviation (spread around the mean), use the standard deviation calculator with sample or population mode.
Which Google Sheets or English Excel functions match this page?
AVERAGE for the mean, MEDIAN for the median, MODE.SNGL for one representative mode when ties exist, MAX−MIN for range. Use MODE.MULT if you need every mode returned as an array.
What are the German Excel names for these functions?
Typical Excel (Deutsch) names include MITTELWERT, MEDIAN, MODE.SNGL / MODE.MULT, MAX, MIN—confirm in Insert function if your build differs.
What are the French Excel names for these functions?
Typical Excel (français) names include MOYENNE, MEDIANE, MODE.SNGL / MODE.MULT, MAX, MIN—verify on your install.
How should I paste data from a spreadsheet?
Copy a column or row, paste into the box, and keep one number per cell as plain text. Tabs, newlines, spaces, semicolons, and many comma-separated lists work.
Do you show quartiles or interquartile range (IQR)?
Not in this version. This page focuses on mean, median, mode(s), and range for a simple list. Add quartiles in your statistics workflow when you need them.
Is this professional statistics advice?
No. It is a free educational calculator. For regulated reporting or research protocols, follow qualified experts and your organization’s methods.