🔢Moving Average
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
Definition
Example code
excel
=AVERAGE(B2:B8)Common mistake
Key takeaways
- 1A sliding window. Always the latest few values.
- 2Smooths noise. Daily bumps cancel each other out.
- 3Runs late. Turns show up after they happen.