The Handy Calculators logoTheHandyCalculators.com

    Average Calculator

    Find the mean (average), median, mode, range, sum, and count for any list of numbers.

    Autosave on

    Parsed: 7 numbers

    Mean (average)
    20.2857
    Median
    20
    Mode
    No mode
    Sum
    142
    Count
    7
    Min
    12
    Max
    30
    Range
    18

    Paste numbers separated by commas, spaces, tabs, or new lines — it works with copy-pasted columns straight out of a spreadsheet. The calculator returns the mean, median, mode, sum, count, min, max, range, and a handful of related descriptive statistics in one shot, so you can audit a dataset without opening Excel.

    Mean, median, mode — and why the right one matters

    The arithmetic mean is the most familiar 'average': add every value and divide by the count. It is the right measure when your data is roughly symmetric and free of extreme outliers. The median is the middle value once the list is sorted (or the average of the two middle values for even-length lists). The mode is the value that appears most often.

    Choosing the wrong one is the most common stats mistake in news reporting. US household income is a textbook example: the mean is pulled upward by a small number of very high earners, so it always exceeds the median by a wide margin. The Census Bureau publishes the median ($80,610 in 2023) precisely because it represents the 'typical' household better than the mean ($114,500) would.

    Worked example: a small sales dataset

    Suppose your team's weekly sales (in thousands) are: 18, 22, 19, 24, 19, 21, 95. Count = 7. Sum = 218. Mean = 218 / 7 ≈ 31.1. Sorted, the list is 18, 19, 19, 21, 22, 24, 95 — median = 21 (the middle value). Mode = 19 (it appears twice). Min = 18, Max = 95, Range = 77.

    The mean of 31.1 misleads anyone glancing at the table because it suggests an average week pulls in $31k. Six of the seven weeks are below that. The 95 is almost certainly an outlier — a one-off enterprise deal or a data-entry error. Reporting both the mean and the median, with the range to flag the spread, gives a reader the full picture in one line.

    If you suspect outliers are systematic rather than rare, use a trimmed mean (drop the top and bottom 10%) or compute the median directly. This calculator surfaces both so you do not have to choose blind.

    Spread, outliers, and what the calculator does not show

    Range (max − min) is the simplest spread measure but is dominated by outliers. Two datasets can have the same range and very different shapes.

    Standard deviation and variance describe how tightly the data cluster around the mean. For those, use our Standard Deviation Calculator, which also handles sample vs population denominators correctly.

    Quartiles and the interquartile range (IQR) are robust to outliers — Q1 is the 25th percentile, Q3 the 75th, and IQR = Q3 − Q1 captures the middle half of your data. Datasets with the same mean and standard deviation but different IQRs often have very different practical meaning.

    If your numbers represent rates, percentages, or anything multiplicative (investment returns, population growth), use the geometric mean instead of the arithmetic mean. The geometric mean of 1.10 and 0.90 is √(1.10 × 0.90) ≈ 0.995, not the arithmetic mean of 1.00.

    Frequently asked questions

    What is an average?

    Most often 'average' means the arithmetic mean: sum of values ÷ count of values. The mean of 4, 8, 12 is 24 ÷ 3 = 8.

    Mean vs median vs mode?

    Mean = sum/count. Median = middle value when sorted. Mode = most frequent value. The median is more robust to outliers — one billionaire in a sample of 100 people barely moves the median income but blows up the mean.

    How is median calculated for an even-length list?

    Sort the list, then average the two middle values. Median of 1, 3, 5, 9 is (3 + 5) / 2 = 4.

    What if there's no repeating value?

    There's no mode. Some textbooks report 'no mode'; others say every value is a mode. This calculator shows 'No mode' when all values appear exactly once.

    Can I paste a column from Excel or Google Sheets?

    Yes — copy any column or row and paste. The parser splits on commas, spaces, tabs, semicolons, and newlines, so almost any format works.

    Does it handle negative numbers and decimals?

    Yes. Mix positives, negatives, and decimals freely (e.g. -1.5, 2, 3.75, -0.25).

    By Larius software engineer, NC real estate broker & CRE/business appraiserLast reviewed: June 2026Reviewed by the Handy Calculators editorial teamHow we build calculators

    More in Math Tools

    General-purpose math: percentages, percent change, averages, proportions, slope/grade, fractions, descriptive statistics, and a full scientific calculator.

    See hub →
    Browse all Education →