How do you calculate the mean?

Add all values in your dataset together to get the sum (Σxᵢ), then divide by the number of values (n). The formula is x̄ = Σxᵢ / n. For example, the mean of 4, 8, 6, 5, 3 is (4+8+6+5+3)/5 = 26/5 = 5.2.

What is the mean in statistics?

The mean (also called the arithmetic mean or average) is the sum of all values in a dataset divided by the number of values. It is a measure of central tendency that gives the typical or representative value of the data. The mean is denoted x̄ (sample mean) or μ (population mean).

Is the mean the same as the average?

Yes. In everyday usage and statistics, the arithmetic mean and the average are the same calculation: sum of all values divided by the count. The word 'mean' is the precise mathematical term; 'average' is the common language term for the same thing.

What is the mean formula?

The arithmetic mean formula is x̄ = Σxᵢ / n, where x̄ is the mean, Σxᵢ is the sum of all values (x₁ + x₂ + ... + xₙ), and n is the number of values. For a population mean the notation is μ = Σxᵢ / N, where N is the population size.

Can the mean be negative?

Yes. If a dataset contains negative numbers, the mean can be negative. For example, the mean of -10, -5, -3 is (-10 + -5 + -3)/3 = -18/3 = -6. The mean formula works identically for negative numbers — just add all values (including negative ones) and divide by the count.

What is the difference between mean and median?

The mean is the sum of all values divided by the count; it is affected by extreme values (outliers). The median is the middle value when data is sorted; it is not affected by outliers. For the data set 1, 2, 3, 4, 100: the mean is 22 but the median is 3. When data has extreme values, the median is often a better measure of the typical value.

What is the difference between sample mean and population mean?

The sample mean (x̄ = Σxᵢ/n) is calculated from a subset of data and is used to estimate the population mean. The population mean (μ = Σxᵢ/N) is calculated from every member of the entire group being studied. The formulas are identical — only the notation and interpretation differ. In most real-world analysis you work with the sample mean.

How do you find the mean of grouped data?

For grouped data (data given as frequency intervals): (1) Find the midpoint of each class interval. (2) Multiply each midpoint by its frequency: f × x. (3) Sum all the f × x products: Σ(f × x). (4) Sum all frequencies: Σf. (5) Divide: Mean = Σ(f × x) / Σf. For example, if interval 10–20 has frequency 5, its midpoint is 15 and its contribution is 5 × 15 = 75.

How do you calculate mean in Excel?

In Excel, use the AVERAGE function. Type =AVERAGE(A1:A10) and replace A1:A10 with your actual data range, then press Enter. Excel instantly returns the arithmetic mean. For the geometric mean use =GEOMEAN(range) and for the harmonic mean use =HARMEAN(range).

What are common mistakes when calculating the mean?

The most common mistakes are: (1) Forgetting to include all values in the sum. (2) Dividing by the wrong n — especially easy when data has zeros (zero is still a value). (3) Using the mean when the data has extreme outliers — the median is usually better in that case. (4) Confusing sample mean (x̄) with population mean (μ) and applying the wrong formula for variance. (5) Computing the mean of means without accounting for different group sizes — use a weighted mean instead.

Mean Calculator — Find the Mean of Any Dataset (With Steps)

Mean Calculator — x̄ = Σxᵢ / n

Enter numbers separated by commas, spaces, or new lines

Please enter valid numbers.

—

Arithmetic Mean (x̄)

Median —

Mode —

Range —

Count (n) —

Sum (Σ) —

Min / Max —

Variance (s²) —

Std Deviation (s) —

Q1 / Q3 —

IQR —

Value distribution

Step-by-Step Solution

What Is the Mean?

The mean (also called the arithmetic mean or average) is the sum of all values in a dataset divided by the number of values. It is the most widely used measure of central tendency in statistics, data analysis, business, science, and everyday life.

Mean Formula — Arithmetic Mean

x̄ = Σxᵢ / n

x̄ = sample mean (pronounced "x-bar")

Σxᵢ = sum of all values

n = number of values

For a population mean (when you have data on every member of the group, not just a sample), the notation changes to μ = Σxᵢ / N, where N is the population size. The formula is identical — only the notation differs.

How to Calculate the Mean — 3 Steps

Step-by-Step Example

Find the mean of: 4, 8, 6, 5, 3

Add all values (Σxᵢ)
4 + 8 + 6 + 5 + 3 = 26

Count the values (n)
There are 5 numbers in the dataset.

Divide sum by count
x̄ = 26 / 5 = 5.2

✓ Mean = 5.2. The average of 4, 8, 6, 5, 3 is 5.2.

Mean Calculator for Grouped Data

When your data is given as a frequency distribution table (class intervals with frequencies), you cannot simply average the raw values. Instead, you use the midpoint of each class interval and weight it by frequency.

Mean Formula — Grouped Data

x̄ = Σ(f · x) / Σf

f = frequency of each class

x = midpoint of each class interval

Σ(f·x) = sum of all (frequency × midpoint)

Σf = total frequency (= n)

Grouped Data Example

Student test scores — find the mean from this frequency table:

Marks (Interval)	Frequency (f)	Midpoint (x)	f × x
0 – 10	3	5	15
10 – 20	5	15	75
20 – 30	8	25	200
30 – 40	4	35	140
40 – 50	2	45	90
TOTAL	Σf = 22	—	Σ(f·x) = 520

Mean = Σ(f·x) / Σf = 520 / 22 = 23.64

✓ The mean mark is 23.64.

💡

How to use the calculator above for grouped data

Enter the midpoint of each class interval multiplied by its frequency as your dataset. For the example above, enter: 5, 5, 5, 15, 15, 15, 15, 15, 25, 25, 25, 25, 25, 25, 25, 25, 35, 35, 35, 35, 45, 45 — the calculator will return 23.64.

Types of Mean

There are three primary types of mean, each suited to different data situations. The arithmetic mean is the most common and is what most people mean when they say "average."

Most Common

Arithmetic Mean

x̄ = Σxᵢ / n

Sum of all values divided by count. Used for general datasets: exam scores, temperatures, sales figures. Sensitive to outliers.

Growth Rates

Geometric Mean

G = (x₁×…×xₙ)^(1/n)

The nth root of the product of all values. Used for compound growth, investment returns, and multiplicative processes. Requires all positive values.

Rates & Ratios

Harmonic Mean

H = n / Σ(1/xᵢ)

Number of values divided by the sum of reciprocals. Used for averaging rates like speed (distance/time) and price-to-earnings ratios. Always ≤ arithmetic mean.

💡

Which mean should you use?

For most everyday situations, use the arithmetic mean. For comparing growth rates over time (e.g., annual investment returns), use the geometric mean. For averaging rates where the denominator changes (e.g., average speed over different distances), use the harmonic mean. Always arithmetic ≥ geometric ≥ harmonic for positive values.

Mean vs Median vs Mode

Mean, median, and mode are all measures of central tendency — they each describe the "typical" value in a dataset, but in different ways. Knowing which to use is one of the most important skills in statistics.

Measure	Definition	Best When	Affected by Outliers?
Mean (x̄)	Sum ÷ Count	Symmetric data without extreme values	Yes — strongly
Median	Middle value when sorted	Skewed data or data with outliers (e.g., income)	No — robust
Mode	Most frequent value	Categorical data or finding the most common value	No

Outlier Impact Example

Why the median is better than the mean for income data

Five salaries: $30,000 · $35,000 · $40,000 · $42,000 · $1,000,000

Mean = ($30,000 + $35,000 + $40,000 + $42,000 + $1,000,000) / 5 = $229,400 — misleading! The $1M outlier drags the mean far from the typical salary.

✓

Median = middle value when sorted = $40,000 — much more representative of what a typical person earns.

✓ When data has extreme outliers, use the median. For symmetric data without outliers, the mean is ideal. See our Mean vs Median vs Mode guide for more.

Sample Mean vs Population Mean

The distinction matters in inferential statistics, where you draw conclusions about a large group (population) from a smaller group (sample).

Feature	Sample Mean (x̄)	Population Mean (μ)
Symbol	x̄ (x-bar)	μ (mu)
Formula	Σxᵢ / n	Σxᵢ / N
When used	Working with a subset of data	Have data on entire group
Purpose	Estimate the population mean	Exact description of population
Example	Average height of 100 surveyed students	Average height of all students in a school

The variance formula also differs: sample variance divides by n−1 (Bessel's correction) while population variance divides by N. The calculator on this page uses the sample formula (n−1).

Common Mistakes When Calculating the Mean

Mistake 1

Forgetting to include zeros

Zero is a valid data point. If a student scores 0 on a test, that 0 must be included in both the sum and the count. Leaving it out inflates the mean. Example: mean of 0, 5, 10 is 5, not 7.5.

Mistake 2

Using the mean when data has extreme outliers

A single extreme value can drag the mean far from the typical value. Always check for outliers first. If they exist and aren't errors, report the median alongside the mean, or use the median as your primary measure.

Mistake 3

Averaging means without weighting for group size

If Class A (10 students) has a mean of 70 and Class B (30 students) has a mean of 80, the combined mean is NOT (70+80)/2 = 75. The correct combined mean is (10×70 + 30×80) / 40 = 77.5. Use a weighted mean whenever groups have different sizes.

Mistake 4

Confusing sample variance with population variance

Sample variance divides by n−1; population variance divides by N. Using the wrong denominator produces a biased estimate. Most statistical software and this calculator use n−1 by default (sample formula).

Mistake 5

Using arithmetic mean for growth rates

If an investment grows 50% in year 1 and falls 50% in year 2, the arithmetic mean of the returns is 0% — implying you broke even. But $100 → $150 → $75 means you lost 25%. The geometric mean correctly captures this: G = √(1.5 × 0.5) − 1 = −13.4%.

How to Calculate Mean in Excel and Google Sheets

Both Excel and Google Sheets have identical functions for calculating the mean and related statistics:

What to Calculate	Excel / Google Sheets Formula	Notes
Arithmetic mean	=AVERAGE(A1:A10)	Replace range with your cells
Geometric mean	=GEOMEAN(A1:A10)	Requires all positive values
Harmonic mean	=HARMEAN(A1:A10)	Requires all positive values
Median	=MEDIAN(A1:A10)	—
Mode	=MODE(A1:A10)	Returns most frequent value
Sample variance	=VAR(A1:A10)	Divides by n−1
Sample std deviation	=STDEV(A1:A10)	Divides by n−1
Weighted mean	=SUMPRODUCT(values,weights)/SUM(weights)	No built-in function

Learn

Mean in Statistics

Full guide with examples and applications

Learn

Weighted Mean

When some values matter more than others

Calculator

Mean, Median & Mode Calculator

All three central tendency measures at once

Calculator

Standard Deviation Calculator

Variance and standard deviation with steps

Blog

Mean vs Median vs Mode

When to use each measure of central tendency

Learn

Descriptive Statistics

Complete guide to summarising data

Statistics Fundamentals Home

Mean Calculator — x̄ = Σxᵢ / n

Step-by-Step Solution

What Is the Mean?

How to Calculate the Mean — 3 Steps

Find the mean of: 4, 8, 6, 5, 3

Mean Calculator for Grouped Data

Student test scores — find the mean from this frequency table:

Types of Mean

Arithmetic Mean

Geometric Mean

Harmonic Mean

Mean vs Median vs Mode

Why the median is better than the mean for income data

Sample Mean vs Population Mean

Common Mistakes When Calculating the Mean

Forgetting to include zeros

Using the mean when data has extreme outliers

Averaging means without weighting for group size

Confusing sample variance with population variance

Using arithmetic mean for growth rates

How to Calculate Mean in Excel and Google Sheets

Related Calculators and Guides