From the course: Excel Data Analysis for Supply Chain: Forecasting

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Challenge solution

Challenge solution - Microsoft Excel Tutorial

From the course: Excel Data Analysis for Supply Chain: Forecasting

Start my 1-month free trial Buy for my team

Challenge solution

“

(upbeat music) - [Instructor] All right, so let's see the solution to this particular set of challenges. First thing we want to do is we want to do our four-period moving average. And remember, that's very simple. All we need to do is take the average of the four prior periods, and that's going to give us a four-period moving average for this particular period right here. And then if we want, we can just copy this down and it gives us nice little bit of data or forecast, rather. And then what we're going to do is we're going to then put this up on a chart. And there you go. Despite the chaotic quarterly data, we have a nice orange curve that allows us to see something that's a little bit smoother. All right, so now it's time for a three-period weighted moving average. And we're going to use a different set of weights. Again, remember, your weights, you get to choose how much weight to put on the most recent period and the oldest period. But the important thing is the weights must add…

Contents