Skip to content
BENIBIX Learn

Moving Average

General🔢 Math & StatisticsStatistics

Also known as Rolling Average, Running Average

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

Think of it like

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

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.

Why it matters

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

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 code

excel
=AVERAGE(B2:B8)
Copied down a column, the seven-row range slides down one row each time.
The daily line jumps about. The 7-day average smooths it and shows the slow climb.

Common mistake

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

Key takeaways

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

Learn it properly