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.
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
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.
Swipe sideways to compare columns.
| 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 |
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.
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:
Swipe sideways to compare columns.
| 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.
Worked example 1: test scores
Worked example 2: daily temperatures
Worked example 3: monthly sales
Worked example 4: fitness steps
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 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 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.
Swipe sideways to compare columns.
| 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) |
Swipe sideways to compare columns.
| 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 |
That one $200,000 salary pulls the mean up by $31,250, because the mean uses every value. 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.
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.
Swipe sideways to compare columns.
| Class | Grade | Credits | Grade × Credits |
|---|---|---|---|
| Math | 85 | 3 | 255 |
| English | 90 | 4 | 360 |
| History | 78 | 2 | 156 |
| Total | 9 | 771 |
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 applies the grade-point scale and credits for you, and 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.
How to Calculate Averages in Excel
Excel makes averages quick with the AVERAGE function. The same formulas work in Google Sheets.
Swipe sideways to compare columns.
| 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 |
Swipe sideways to compare columns.
| 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 |
Swipe sideways to compare columns.
| 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) |
For a full spreadsheet walkthrough, including why a plain AVERAGE gives the wrong GPA, read weighted averages and GPA in Excel.
Real-World Applications of Averages
Swipe sideways to compare columns.
| 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 or read percentage change calculation.
Practice Problems (With Answers)
Problem 1: find the average of 4, 8, 12, 16, 20
Problem 2: find the average of 15, 25, 35, 45
Problem 3: a student scores 78, 85, 92, 88 and 90 on five tests. What is their average?
Problem 4: find the weighted average of grade 85 (3 credits), grade 90 (4 credits) and grade 78 (2 credits)
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?
Swipe sideways to compare columns.
| Problem | Answer |
|---|---|
| 1 | 12 |
| 2 | 30 |
| 3 | 86.6 |
| 4 | 85.67 |
| 5 | $1,414.29 |
Common Average Mistakes (And How to Avoid Them)
Swipe sideways to compare columns.
| 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.
Written by
Do The Calculation Team
Do The Calculation
Do The Calculation is built by a small team of data analysts and spreadsheet developers. Where a guide depends on a published formula, standard, or government rule, the calculator it links to names that source directly so you can check the number yourself.
About the team