Question: answer in excel with the correct formulas please 3. A company has used three different methods to forecast sales for the past five months. Use
answer in excel with the correct formulas please
3. A company has used three different methods to forecast sales for the past five months. Use MAD and MSE to evaluate the performance of the three methods. a) Which forecasting method performed best? Period 1 2 Actual 10 8 12 Method A 10 11 12 13 14 Method B 9 10 8 12 11 Method C 8 11 10 11 12 3 4 11 5 12 b) Which of these is actually the nave method? 3. A company has used three different methods to forecast sales for the past five months. Use MAD and MSE to evaluate the performance of the three methods. a) Which forecasting method performed best? Period 1 2 Actual 10 8 12 Method A 10 11 12 13 14 Method B 9 10 8 12 11 Method C 8 11 10 11 12 3 4 11 5 12 b) Which of these is actually the nave method
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
