# How to Calculate an Average Step by Step: A Complete Guide

Add up the numbers, count them, and divide the sum by the count. Step-by-step worked examples for test scores, temperatures, sales and steps, plus weighted averages, mean vs median vs mode, Excel formulas and practice problems.

---

- **Canonical URL:** https://dothecalculation.com/blog/math/how-to-calculate-an-average
- **Category:** Math
- **Author:** Do The Calculation Team
- **Published:** 2026-09-22
- **Reading time:** 10 min read
- **Publisher:** Do The Calculation (https://dothecalculation.com)
- **Methodology:** https://dothecalculation.com/methodology

---

## How to Calculate an Average Step by Step

Calculating an average is one of the most useful math skills you will ever learn. Whether you are a student checking your grades, a business owner analysing sales, or someone tracking fitness progress, averages help you make sense of numbers.

Many people rely on an average calculator for quick answers. Knowing how to calculate an average by hand gives you a deeper grasp of the math and lets you check your work with confidence.

In this guide, you will learn:

- What an average is, in simple terms
- The average formula, explained step by step
- How to calculate an average, with worked examples
- The types of average: mean, median and mode
- How to calculate a weighted average
- How to calculate averages in Excel
- Real-world uses in grades, sports, business and fitness
- Practice problems with answers
- Common mistakes and how to avoid them

Tool: [Try the Average Calculator](https://dothecalculation.com/calculators/average-calculator) — Paste a list of numbers to get the mean, median, mode, minimum and maximum at once, with an option to set outliers aside and see how much they move the result.

## Quick Answer: How Do You Calculate an Average?

To calculate an average:

- Add up all the numbers to find the sum.
- Count how many numbers there are to find the count.
- Divide the sum by the count.

**The average formula**

```
Average = Sum of all numbers ÷ Count of numbers
```

**Simple example**

```
Numbers: 10, 20, 30, 40, 50
Sum: 10 + 20 + 30 + 40 + 50 = 150
Count: 5
Average: 150 ÷ 5 = 30
```

**Quick reference**
| Numbers | Sum | Count | Average |
| --- | --- | --- | --- |
| 2, 4, 6 | 12 | 3 | 4 |
| 10, 20, 30 | 60 | 3 | 20 |
| 5, 10, 15, 20 | 50 | 4 | 12.5 |
| 1, 2, 3, 4, 5 | 15 | 5 | 3 |

> **Key insight** — The average is a single value that stands in for the whole set. If every number were replaced by the average, the total would stay the same. That makes it the balance point of the data, which is not always the middle value; the middle value is the median.

## What Is an Average?

An average (also called the mean, or arithmetic mean) is a single number that represents the typical value in a set of numbers. It is calculated by adding all the numbers together and dividing by how many numbers there are.

**Example: test scores**

```
Scores: 75, 80, 85, 90, 95
Average: (75 + 80 + 85 + 90 + 95) ÷ 5 = 425 ÷ 5 = 85
```
- The typical score is 85.

### Why averages matter

- They summarise large amounts of data in one number.
- They help you compare different groups.
- They track changes over time.
- They help you make informed decisions.

## The Average Formula

The average formula is simple and powerful:

**Written mathematically**

```
Average = (x₁ + x₂ + x₃ + ... + xₙ) ÷ n
```
- x₁, x₂, x₃ ... are the numbers in your set.
- n is how many numbers there are.

**Key terms**
| Term | What it means | Example |
| --- | --- | --- |
| Sum | The total when you add all the numbers | 10 + 20 + 30 = 60 |
| Count | How many numbers there are | 3 numbers |
| Average | Sum ÷ Count | 60 ÷ 3 = 20 |

## How to Calculate an Average: Step by Step

Every simple average comes down to the same three steps. Here they are with the set 12, 15, 18, 20, 25.

- Step 1: Add up all the numbers (find the sum). 12 + 15 + 18 + 20 + 25 = 90.
- Step 2: Count how many numbers there are (find the count). There are 5.
- Step 3: Divide the sum by the count. 90 ÷ 5 = 18.

> **Answer** — The average of 12, 15, 18, 20 and 25 is 18.

### Worked example 1: test scores

**Average of 85, 92, 78, 90, 88**

```
Step 1: 85 + 92 + 78 + 90 + 88 = 433
Step 2: 5 numbers
Step 3: 433 ÷ 5 = 86.6
```
- The average test score is 86.6.

### Worked example 2: daily temperatures

**Average of 72, 68, 75, 70, 74, 71, 69 (°F)**

```
Step 1: 72 + 68 + 75 + 70 + 74 + 71 + 69 = 499
Step 2: 7 numbers
Step 3: 499 ÷ 7 = 71.2857...
```
- The average temperature is 71.3°F, rounded to one decimal place.

### Worked example 3: monthly sales

**Average of $12,000, $15,000, $10,000, $18,000, $14,000**

```
Step 1: 12,000 + 15,000 + 10,000 + 18,000 + 14,000 = 69,000
Step 2: 5 numbers
Step 3: 69,000 ÷ 5 = 13,800
```
- Average monthly sales are $13,800.

### Worked example 4: fitness steps

**Average of 8,500, 10,200, 7,800, 9,100, 11,000, 6,500, 8,900 steps**

```
Step 1: 8,500 + 10,200 + 7,800 + 9,100 + 11,000 + 6,500 + 8,900 = 62,000
Step 2: 7 numbers
Step 3: 62,000 ÷ 7 = 8,857.14...
```
- The average is about 8,857 steps a day.

Two of these answers are not whole numbers, and that is normal. An average only comes out whole when the sum divides evenly by the count. Keep the full decimal until the last step and round once at the end; [rounding rules: a complete guide](/blog/math/rounding-rules-complete-guide) covers how many places to keep. If you need the result as a fraction instead, such as 12.5 = 25/2, [how to convert decimals to fractions](/blog/math/how-to-convert-decimals-to-fractions) shows the method.

## Types of Averages: Mean, Median and Mode

There are three main types of average. Each tells you something different about your data.

**The three averages of 2, 4, 4, 6, 10**
| Type | Definition | Example |
| --- | --- | --- |
| Mean | Sum ÷ Count | (2 + 4 + 4 + 6 + 10) ÷ 5 = 26 ÷ 5 = 5.2 |
| Median | Middle value when sorted | 4 (the third of five values) |
| Mode | Most frequent value | 4 (appears twice) |

**When to use each**
| Situation | Use this |
| --- | --- |
| Evenly spread data, no outliers | Mean |
| Data with outliers or a long tail | Median |
| Categories or the most common choice | Mode |
| A quick single-number summary | Mean |

**Example with an outlier: five salaries**

```
$40,000, $45,000, $42,000, $48,000, $200,000
Mean: $375,000 ÷ 5 = $75,000
Median (sorted: 40, 42, 45, 48, 200 thousand): $45,000
```
- Four of the five people earn less than the mean. The median describes a typical salary far better.

That one $200,000 salary pulls the mean up by $31,250, because the mean uses every value. [Mean vs median vs mode](/blog/math/mean-vs-median-vs-mode) works through a larger payroll to show exactly how far one extreme value moves each measure, and when each one is the honest number to report. To measure how spread out the values are around the mean, see [standard deviation explained](/blog/math/standard-deviation-explained).

## How to Calculate a Weighted Average

A weighted average gives different weights (importance) to different values. Use it when some numbers count more than others, such as a 4-credit class against a 2-credit class.

**Weighted average formula**

```
Weighted Average = Sum of (Value × Weight) ÷ Sum of Weights
```

**Example: course grades weighted by credits**
| Class | Grade | Credits | Grade × Credits |
| --- | --- | --- | --- |
| Math | 85 | 3 | 255 |
| English | 90 | 4 | 360 |
| History | 78 | 2 | 156 |
| Total |  | 9 | 771 |

**Result**

```
Weighted Average = 771 ÷ 9 = 85.666... ≈ 85.67
```
- A simple average of 85, 90 and 78 would give 84.33, which ignores that English carries twice the credits of History.

### When to use a weighted average

- GPA, where classes carry different credits
- Final grades, where the exam is worth more than homework
- Investment returns, where different amounts are invested
- Survey scores, where some groups are larger than others

For grade point averages specifically, the [GPA calculator](/calculators/gpa-calculator) applies the grade-point scale and credits for you, and [how to calculate weighted GPA](/blog/templates/how-to-calculate-weighted-gpa) works through category weights and credit hours by hand. To work out a course grade from weighted categories, use the [grade calculator](/calculators/grade-calculator).

## How to Calculate Averages in Excel

Excel makes averages quick with the AVERAGE function. The same formulas work in Google Sheets.

**Method 1: the AVERAGE function**
| Step | Action | Formula |
| --- | --- | --- |
| 1 | Enter the numbers in cells | A1:A5 = 10, 20, 30, 40, 50 |
| 2 | Click an empty cell | B1 |
| 3 | Type the formula | =AVERAGE(A1:A5) |
| 4 | Press Enter | Result: 30 |

**Method 2: sum and count by hand**
| Step | Action | Formula |
| --- | --- | --- |
| 1 | Sum the numbers | =SUM(A1:A5) → 150 |
| 2 | Count the numbers | =COUNT(A1:A5) → 5 |
| 3 | Divide | =SUM(A1:A5)/COUNT(A1:A5) → 30 |

**Method 3: weighted average**
| Step | Action | Formula |
| --- | --- | --- |
| 1 | Enter values and weights | A1:A3 = values, B1:B3 = weights |
| 2 | Calculate the weighted sum | =SUMPRODUCT(A1:A3, B1:B3) |
| 3 | Calculate the sum of weights | =SUM(B1:B3) |
| 4 | Divide | =SUMPRODUCT(A1:A3, B1:B3)/SUM(B1:B3) |

> **Blank cells and zeros** — AVERAGE skips empty cells and text but includes cells that contain 0. A missed test left blank is ignored; the same test entered as 0 pulls the average down. Decide which you mean before you fill in the sheet.

For a full spreadsheet walkthrough, including why a plain AVERAGE gives the wrong GPA, read [weighted averages and GPA in Excel](/blog/templates/excel-weighted-average-and-gpa).

## Real-World Applications of Averages

**Where averages are used**
| Application | Example | Why it matters |
| --- | --- | --- |
| Education | GPA, test scores | Track academic performance |
| Business | Average sales, revenue | Measure performance |
| Sports | Batting average, points per game | Compare players |
| Health | Average heart rate, steps | Track fitness |
| Weather | Average temperature | Understand climate |
| Finance | Average return | Evaluate investments |
| Shopping | Average price | Compare costs |
| Social media | Average engagement | Measure content performance |

Real-world example: a student with test scores of 85, 92, 78, 90 and 88 has an average of 433 ÷ 5 = 86.6. That single number tells them how they are doing overall, and comparing it term by term shows whether they are improving. To express that change as a percentage, use the [percentage calculator](/calculators/percentage-calculator) or read [percentage change calculation](/blog/math/percentage-change-calculation).

## Practice Problems (With Answers)

### Problem 1: find the average of 4, 8, 12, 16, 20

**Solution**

```
Sum = 4 + 8 + 12 + 16 + 20 = 60
Count = 5
Average = 60 ÷ 5 = 12
```

### Problem 2: find the average of 15, 25, 35, 45

**Solution**

```
Sum = 15 + 25 + 35 + 45 = 120
Count = 4
Average = 120 ÷ 4 = 30
```

### Problem 3: a student scores 78, 85, 92, 88 and 90 on five tests. What is their average?

**Solution**

```
Sum = 78 + 85 + 92 + 88 + 90 = 433
Count = 5
Average = 433 ÷ 5 = 86.6
```

### Problem 4: find the weighted average of grade 85 (3 credits), grade 90 (4 credits) and grade 78 (2 credits)

**Solution**

```
Weighted sum = (85 × 3) + (90 × 4) + (78 × 2) = 255 + 360 + 156 = 771
Sum of weights = 3 + 4 + 2 = 9
Weighted average = 771 ÷ 9 ≈ 85.67
```

### Problem 5: a store’s daily sales for a week are $1,200, $1,500, $1,100, $1,800, $1,400, $1,600 and $1,300. What is the average daily sale?

**Solution**

```
Sum = 1,200 + 1,500 + 1,100 + 1,800 + 1,400 + 1,600 + 1,300 = 9,900
Count = 7
Average = 9,900 ÷ 7 = 1,414.2857... ≈ $1,414.29
```

**Answers summary**
| Problem | Answer |
| --- | --- |
| 1 | 12 |
| 2 | 30 |
| 3 | 86.6 |
| 4 | 85.67 |
| 5 | $1,414.29 |

## Common Average Mistakes (And How to Avoid Them)

**Eight mistakes and their fixes**
| Mistake | What goes wrong | Fix |
| --- | --- | --- |
| 1. Forgetting to divide by the count | Adding the numbers and stopping there | Always divide the sum by the count |
| 2. Counting values incorrectly | Missing or double-counting numbers | Count carefully and check your list |
| 3. Not accounting for weights | Using a simple average for weighted data | Use the weighted average formula |
| 4. Ignoring outliers | One extreme value skews the average | Look at the median as well when the data is skewed |
| 5. Rounding too early | Rounding each value before the final step | Keep full precision until the end |
| 6. Confusing the mean with the median | Reporting the wrong type of average | Know the difference and choose the one that fits the data |
| 7. Not checking the answer | Assuming the calculation is correct | Multiply the average by the count; it should give the sum |
| 8. Using the wrong data | Including numbers that do not belong in the set | Double-check your data source |

The check in mistake 7 takes seconds: in worked example 1, 86.6 × 5 = 433, which matches the sum, so the average is right.

## Frequently Asked Questions

**What is an average?**

An average (or mean) is a single number that represents the typical value in a set of numbers. It is calculated by adding all the numbers and dividing by how many there are.

**How do you calculate an average step by step?**

First add all the numbers to find the sum. Then count how many numbers there are. Finally divide the sum by the count.

**What is the average formula?**

Average = Sum of all numbers ÷ Count of numbers.

**How do you calculate an average of percentages?**

If every percentage is out of the same total, such as five tests each marked out of 100, average them like any other numbers. If the totals differ, go back to the underlying numbers: 45 out of 50 (90%) and 8 out of 10 (80%) is 53 out of 60, which is 88.3%, not the 85% you get by averaging the two percentages.

**What is the difference between average and median?**

The average (mean) is the sum divided by the count. The median is the middle value when the numbers are sorted. The median is better for data with outliers, such as salaries or house prices.

**How do you calculate a weighted average?**

Multiply each value by its weight, add those products, then divide by the sum of the weights.

**What is a good average?**

It depends on the context. A good test average depends on your school’s grading scale, and a good sales average depends on your own past results and your industry. Compare the average with a benchmark that fits what you are measuring.

**How do you calculate an average in Excel?**

Use the AVERAGE function, for example =AVERAGE(A1:A10). For a weighted average, use =SUMPRODUCT(values, weights)/SUM(weights).

**What is the difference between mean, median and mode?**

The mean is the sum divided by the count. The median is the middle value. The mode is the most frequent value.

**Can an average be a decimal?**

Yes. An average is a decimal whenever the sum does not divide evenly by the count, even if every number in the set is whole.

**What is a moving average?**

A moving average is an average over a rolling period, such as the last 7 days, recalculated each day as the oldest value drops off and the newest is added. It smooths out day-to-day swings so the trend is easier to see.

---

_Source: [Do The Calculation](https://dothecalculation.com/blog/math/how-to-calculate-an-average). Quote freely with attribution and a link to this page._