📊 Average / Mean Calculator

Enter numbers separated by commas, spaces, or new lines. You can paste directly from Excel or Google Sheets.

Quick Example Datasets
📊

Enter your numbers and click Calculate

Mean, median, mode, range, standard deviation, and step-by-step working will appear here. You can paste numbers directly from a spreadsheet.

⚠️ Values changed — click Calculate to refresh.

Mean, Median, Mode & More — Formulas & When to Use Each

Mean, median, and mode are three different ways to describe the "centre" of a dataset. Each tells you something different — and choosing the wrong one can be misleading.

The Three Measures of Central Tendency

Arithmetic Mean (Average)
Mean = Σx ÷ n
Sum all values, divide by count
Example: (2+4+6+8) ÷ 4 = 5
Sensitive to outliers — one extreme value pulls the mean
Median (Middle Value)
Sort → pick middle (or avg of 2 middles)
Odd count: middle value. Even count: avg of two middle values
Example (odd): 2,3,5,7,9 → median = 5
Example (even): 2,3,5,7 → median = (3+5)÷2 = 4
Not affected by outliers — best for skewed data (house prices)
Mode (Most Frequent)
Most frequently occurring value
Can have multiple modes (bimodal, multimodal) or no mode
Example: 2,3,3,5,7 → mode = 3
Best for categorical data (favourite colour, most common size)

Weighted Average

Weighted Mean
Weighted Mean = Σ(xᵢ × wᵢ) ÷ Σ(wᵢ)
Example: Grades 80 (weight 3) and 90 (weight 2)
= (80×3 + 90×2) ÷ (3+2) = 420 ÷ 5 = 84

Standard Deviation

Population vs Sample SD
σ = √[Σ(x−μ)² ÷ N]
Population (σ): divide by N — use when you have all data
Sample (s): divide by N−1 — use when data is a sample
Measures how spread out values are from the mean

When Mean Misleads: House Prices

1
Prices: $200k, $210k, $220k, $230k, $2,000k
2
Mean = $572k — misleadingly high due to one mansion
3
Median = $220k — better represents the typical home
✓ For skewed data with outliers, use median, not mean

Average & Statistics Quick Reference (2026)

Quick lookup for common statistical measures and when to use each type of average.

Which Average to Use — Decision Guide

SituationBest MeasureWhyAvoid
House prices / salariesMedianOutliers (mansions, CEO pay) skew the meanMean
Test scores (no outliers)MeanNormally distributed, outliers rareMode
Most popular shoe sizeModeCategorical — "most common" is what mattersMean
Grading with weighted assignmentsWeighted meanFinal exam worth more than homeworkSimple mean
Stock price trendMoving averageSmooths daily noise to show trendSimple mean
Olympic judgingTrimmed meanRemoves highest/lowest scores to prevent biasMean
Survey data (Likert scale)Mean or medianMean if symmetric; median if skewed responsesMode only
Grouped/binned dataGrouped meanIndividual values unknown; only frequencies availableSimple mean

Mean vs Median — Example Comparison

DatasetMeanMedianModeNote
Symmetric: 2,4,6,8,10 6 6 None Mean ≈ Median
Right-skewed: 2,3,4,5,50 12.8 4 None Mean skewed by outlier
Repeated: 3,3,5,7,9,9,9 6.43 7 9 Mean ≈ Median
All same: 4,4,4,4,4 4 4 4 Mean ≈ Median
Two modes: 1,2,2,3,4,4,5 3 3 2,4 Mean ≈ Median
No mode: 1,2,3,4,5,6 3.5 3.5 None Mean ≈ Median
Exam scores: 55,70,72,78,90,95 76.67 75 None Mean skewed by outlier

Standard Deviation Interpretation

SD relative to meanInterpretationExample
Very low (SD < 5% of mean)Values are tightly clustered around the meanFactory output with tight tolerances
Low (SD 5–15% of mean)Moderate consistencyStudent test scores in a well-taught class
Moderate (SD 15–30% of mean)Noticeable spreadInvestment returns year-on-year
High (SD > 30% of mean)High variability; outliers likelyHouse prices in a mixed neighbourhood
68-95-99.7 rule (normal dist.)68% within 1 SD, 95% within 2 SD, 99.7% within 3 SDHeights, IQ scores, measurement errors

Average Calculator — Frequently Asked Questions

Everything you need to know about calculating means, weighted averages, medians, modes, and choosing the right measure for your data.