# Moving Average

> The mean of the last few values, done again each day. It smooths out the bumps.

**Field:** General Knowledge  
**Category:** Math & Statistics  
**Also known as:** Rolling Average, Running Average

## Think of it like

It is like judging a team on its last five games. One game does not tell you much.

## Definition

A moving average is the mean of the last few values, worked out again at each new step. A 7-day moving average adds up the latest 7 days and divides by 7. The next day, the oldest day drops off and the new day joins. This smooths out the bumps from one day to the next. The trend underneath becomes easier to see.

## Example

Visits to Lucy's blog jump between 200 on Sundays and 900 on Tuesdays. Her 7-day moving average stays near 550. That lets her see the slow rise from month to month.

## Example code

```excel
=AVERAGE(B2:B8)
```

Copied down a column, the seven-row range slides down one row each time.

## Why it matters

Raw daily numbers are noisy. A moving average shows whether things are really going up or down.

## Common mistake

Forgetting that it runs behind. A sudden change shows up in the average days later.

## Three principles

- **A sliding window.** Always the latest few values.
- **Smooths noise.** Daily bumps cancel each other out.
- **Runs late.** Turns show up after they happen.

## Related terms

- [Mean (Average)](https://learn.benibix.com/term/general/mean)
- [Median](https://learn.benibix.com/term/general/median)
- [Outlier](https://learn.benibix.com/term/general/outlier)
- [Line Chart](https://learn.benibix.com/term/design/line-chart)

## Taught in

- [Mean, Median and Mode](https://learn.benibix.com/learn/general-math/mean-median-and-mode): Statistics, 4/10

![A line chart over five weeks. A thin, jagged line jumps up and down every day. A thick, smooth line runs through it and climbs slowly, labelled 7-day moving average.](https://learn.benibix.com/diagrams/gen-moving-average.svg)

---

Source: https://learn.benibix.com/term/general/moving-average
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-20
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
