Moving averages
The leadership team at Bananas is goal planning for next month, and they're curious about what sales might be. They want us to forecast this for them using historical data.
There are many different forecasting methodologies, so in this exercise, we'll focus on two different forecasts that can be calculated easily in Excel: simple moving average (SMA) and weighted moving average (WMA).
If you've lost progress, open up 3_4_data_table.xlsx
from the Workbooks folder.
This exercise is part of the course
Data Analysis in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
