Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise