2026-08-07 9 min

Average Calculator

Calculate mean, median, mode and geometric mean for any dataset with a distribution diagram and step-by-step working.

Calculator

Data Values (comma or newline separated)
Results update live as you type
Status:Mean 22.1429n = 7Median 23.0000

Results

Average (Mean)
22.1429
Count (n)7
Sum (Σx)155.0000
Geometric Mean16.4128
Median23.0000
Mode23, 38
Average = 155.0000 / 7 = 22.1429

Results

Optimal

Average (Mean)

22.1429

Sum 155.0000 / n 7

Median

23.0000

Sorted middle value

Mode

23, 38

Repeats 2×

Geometric Mean

16.4128

nth root of product

Count (n)

7

Values analyzed

Sum (Σx)

155.0000

Total of all values

Range

36.0000

2.0000 to 38.0000

Descriptive statistics for the pasted set. Mean follows every value including outliers — compare with the median before deciding.

Visualizations

Dataset Values

10#1
2#2
38#3
23#4
38#5
23#6
21#7

Quartile Spread

Min–Median58%
Median–Max42%

Mean Within Range

Mean position56%

Mean vs Median

Mean22.1

Formula

The mean spreads the total evenly; the median splits sorted order; the mode votes by frequency; the geometric mean compounds multiplicatively.

mean = Σx / n

Alternative Form

median = sorted middle · mode = most frequent · geomean = (Πx)^(1/n)

Variables

SymbolNameUnitDescription
ΣxSumvalueTotal of all entries
nCountcountNumber of values
x̄MeanvalueΣx / n
GGeometric meanvaluePositive-only multiplicative center

Explanation

Use the mean for symmetric additive data, the median under skew/outliers, the mode for most-common questions, and the geometric mean for growth rates.

Derivation

Sum once O(n); sort O(n log n) for median; tally map for mode; product + pow(1/n) for geomean (positive only).

Step-by-Step Calculation

Follow each step to understand how the result is calculated from your inputs.

Step 1

Parse entries and count them.

n = count
n:7
Intermediate: 10, 2, 38, 23, 38, 23…
Result: 7 values
Step 2

Sum every value.

Σx
Sum:155.0000
Intermediate: Additive accumulation
Result: Σx = 155.0000
Step 3

Divide the sum by the count for the arithmetic mean.

mean = Σx / n
Σx:155.0000
n:7
Intermediate: 155.0000 / 7
Result: Mean = 22.1429
Step 4

Sort and take the middle (average the two middles if even).

median
Sorted:2, 10, 21, 23, 23, 38, 38
Intermediate: n = 7 (odd)
Result: Median = 23.0000
Step 5

Tally frequencies for the mode; take nth root of the product for geometric mean.

mode · geomean = (Πx)^(1/n)
Mode:23, 38
Geometric:16.4128
Intermediate: Top frequency 2
Result: Mode: 23, 38; Geomean: 16.4128
Step 6

Compare mean vs median to sniff skew and outliers.

|mean − median| vs range/4
Mean:22.1429
Median:23.0000
Range:36.0000
Intermediate: Gap 0.8571
Result: Roughly symmetric — mean is representative
Final Answer
22.1429

Worked Examples

See how the calculator works with different scenarios.

Scenario

Textbook walkthrough.

Inputs

Values:2, 7, 19, 24, 25

Calculation

Sum 77 / 5

Result

15.4

Interpretation

Even spread; median 19 vs mean 15.4 hints mild left skew.

Understanding Your Result

Your Result: Average (Mean): 22.1429

Typical range: Mean ≈ median when symmetric; gaps beyond range/4 flag skew.

What This Means

Mean = fair-share value; median = middle person; mode = most common; geomean = sustained growth rate. Range frames the spread.

Why It Matters

Averages drive grades, pricing, KPIs and science — but the wrong center (mean under skew) reverses decisions.

Professional Interpretation

Quote mean ± spread for symmetric data, median + quartiles for skewed, geomean for rates; never average subgroup means unweighted.

Recommendations

  • •Plot or sort before quoting
  • •Pair mean with median
  • •Use geomean for growth
  • •Weight subgroup means by n
  • •Flag outliers explicitly

Educational Content

Introduction

Central tendency compresses a dataset to one representative number. Which one depends on shape, scale type and question asked.

Concept Explanation

Additive center (mean), order center (median), frequency center (mode), multiplicative center (geometric); harmonic for equal-distance rates; trimmed for outlier resistance.

Applications

▸Grades and GPA
▸ARPU, AOV, CAC, CLV
▸Sports ratings and averages
▸Lab measurement means
▸Quality-control X-bar charts
▸Polling and economic indicators

Benefits

  • •One-number summaries
  • •Comparable across groups
  • •Feeds inference (SE = σ/√n)
  • •Dashboard-friendly KPIs
  • •Teaches distribution thinking

Limitations

  • •Hides shape and bimodality
  • •Mean bends to outliers
  • •Meaningless for categories
  • •Subgroup paradoxes (Simpson)
  • •Geomean needs positives

Best Practices

  • •Show spread with center
  • •Prefer median when skewed
  • •Weight by sample size
  • •Trim for judging-style data
  • •Use moving averages for trends

Common Misconceptions

Myth: Mean, median, mode are interchangeable.
Truth: They answer different questions and diverge under skew.
Myth: Averaging percentages is always fine.
Truth: Different denominators need weighting by underlying counts.
Myth: Bigger samples change the mean.
Truth: Bigger samples stabilize it (law of large numbers), converging to μ.
Myth: Average describes the whole distribution.
Truth: Pair it with spread, shape and n — or be misled.

Practical Tips

  • •Sort the data before trusting the mean
  • •Report median alongside mean
  • •Use geometric mean for growth rates
  • •Weight subgroup averages by size
  • •Check repeats for the mode
  • •Scale moving averages to the trend
  • •Document n with every average

Common Mistakes

Quoting mean for skewed pay-like data
Lead with the median; show the mean as secondary.
Averaging subgroup means directly
Weight each mean by its n first.
Averaging percentages on unequal bases
Recompute from total points over total possible.
Ignoring a bimodal mode
Report both modes — two humps mean two stories.
Using geomean with zeros/negatives
Shift methodology: geomean requires positives.

Assumptions

This calculator makes the following assumptions to provide estimates:

Numeric Input: Non-numeric tokens are ignored.
Equal Weighting: Unweighted arithmetic mean by default.
Positive-Only Geomean: Geometric shown only when all values positive.
Exact Parsing: Commas and newlines both split.
Local Compute: Statistics computed in-browser.

Limitations

Be aware of these limitations when using this calculator:

No Weighting UI: Weighted means need manual SUMPRODUCT.
Outlier Sensitivity: Mean follows extremes; see median.
Chart Sampling: Diagrams cap plotted points for clarity.
No Inference: Descriptive only — no CIs or tests.

Frequently Asked Questions

Answers to common questions about this calculator.

What is an average?
The arithmetic mean: sum of values divided by count. It summarizes the center alongside median (middle sorted value) and mode (most frequent). This calculator reports all three plus the geometric mean.
How do you calculate the average?
Sum every value and divide by how many there are: Average = Σx / n. Example: (2+4+6+8+10)/5 = 30/5 = 6.
What is the difference between mean, median, and mode?
Mean uses every value (outlier-sensitive); median is the sorted middle (robust); mode is the most common value. Symmetric data aligns all three.
What is the geometric mean?
The nth root of the product, for rates and growth (investment returns, ratios). Requires positive values and never exceeds the arithmetic mean.
What is the harmonic mean?
n divided by the sum of reciprocals — correct for averaging rates over equal distances. Harmonic ≤ geometric ≤ arithmetic.
What is a weighted average?
Values times weights over total weight: Σ(w·x)/Σw. Grades (40% assignments + 60% exams) and portfolio returns are weighted.
Can the average be misleading?
Yes — outliers and skew distort it (nine $30k incomes + one $3M gives a $327k mean). Check median, spread and shape alongside.
How do outliers affect the average?
One extreme pulls the sum directly: {1,2,3,4,100} averages 22 while the median is 3. Larger samples dilute single outliers.
What is the average of subgroup averages?
Only valid unweighted when groups match in size; otherwise weight by n: (20·80 + 30·70)/50 = 74, not 75.
What is the relationship between average and standard deviation?
Mean locates the center; standard deviation measures spread around it. Together (plus shape) they describe the distribution; CV = SD/mean compares variability.
What is the difference between population and sample mean?
Population μ = ΣX/N (whole group); sample x̄ = Σx/n estimates it. Standard error σ/√n shrinks as samples grow (law of large numbers).
How do you calculate average in Excel?
=AVERAGE(range) for the mean; GEOMEAN for geometric; MEDIAN for median; SUMPRODUCT(values,weights)/SUM(weights) for weighted.

Related Calculators

Explore more calculators related to this topic.

Related Guides

Deepen your understanding with these educational resources.

Glossary

Technical terms used in mortgage calculations explained in plain language.

Arithmetic mean
Sum divided by count.
Median
Sorted middle value.
Mode
Most frequent value.
Geometric mean
nth root of the product.
Harmonic mean
n over sum of reciprocals.
Weighted average
Mean with per-value weights.
Trimmed mean
Mean after cutting extremes.
Range
Max minus min.
Standard error
SD of the sampling distribution (σ/√n).
Simpson's paradox
Subgroup trends reversing when pooled.

Authoritative References

Trusted sources and standards referenced by this calculator.

Applicable Standards

Common Core 6.SP (center and spread)NCTM Data Analysis expectations

Was This Calculator Helpful?

Page Information

Last Updated:

2026-08-07

Version:

2.0.0

License:

Free to use for educational and professional purposes.