Complete the forecasting worksheets for: Nave Average Moving Average Weighted Moving Average using the weights of .8,
Fantastic news! We've Found the answer you've been seeking!
Question:
Complete the forecasting worksheets for:
Naïve
Average
Moving Average
Weighted Moving Average using the weights of .8, .15, and .05 with .8 being the most current, then .15, then .05
Expon A using an alpha level of .75
Expon B will automatically be .25 when A is .75
Exponential Solver
What is the best alpha level as determined by the Exponential Solver?
Which is the best forecasting option for MAE? What is the MAE?
Which is the best forecasting option for MAPE? What is the MAPE?
Period | Sales |
1 | 115 |
2 | 118 |
3 | 128 |
4 | 122 |
5 | 135 |
6 | 128 |
7 | 135 |
8 | 132 |
9 | 132 |
10 | 135 |
Related Book For
Statistics for Business Decision Making and Analysis
ISBN: 978-0321890269
2nd edition
Authors: Robert Stine, Dean Foster
Posted Date: