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 lost progress, close any open files and load 3_4_data_table.xlsx from the Workbooks folder.