Question: ChIS1 Two servers at a restaurant predict (using some mental model how many guests will come to dinner over the next four days. The first

ChIS1 Two servers at a restaurant predict (using
ChIS1 Two servers at a restaurant predict (using
ChIS1 Two servers at a restaurant predict (using some mental model how many guests will come to dinner over the next four days. The first server predicts the number of guests to be 23 for Day 1, 25 for Day 2, 30 for Day 3, and 28 for Day 4. The second server predicts 26, 27, 28, 29 for the four respective days. The actual attendance turns out to be 30, 22, 31, and 25 You may use the Excel: 15- Problem Calculator For your answer provide a table of the Forecast Errors in this format copy the table and it it in for your answer FE MSE MAE First Method Second Method Which of the methods, if any, we unbiased? Which of the methods has the better prediction Why? Question Completion Status Naive MSE Moving Ave MSE Exponential Smoothing FE MSE MAE FE MAE FE MAE 5.0 15.0 13.0 5.0 150 13.0 Month Actual Nalve Moving Ave Exp Smooth 1 62 2 58 3 42 58.0 4 37 42 54.0 548 5 52 37 45.7 51.2 6 39 52 43.7 51.4 7 39 39 42.7 48.9 8 43 39 43.3 46.9 9 63 43 40.3 46.1 10 49 63 48.3 11 56 49 51.7 49.4 12 56 56.0 50.7 Ave See the results for each of the methods in the ORANGE Which method would you use for your fing in the Why would you choose this method 0.0 25.0 225.0 169.0 0.0 16.0 400.0 1960 17.0 6.3 4.7 3.7 0.3 22.7 0.7 289,0 40.1 21.8 13.4 0.1 513.8 0.4 18 64.0 316.8 0.6 153.6 983 155 284.1 0.3 22.7 0.7 17,8 -0.8 12.4 9.9 39 -16.9 0.5 -6.6 2.7 2.6 17.8 0.8 12.4 9.9 3.9 16.9 0.5 6.6 2.7 4.0 20.0 140 -2.0 80 -0.7 03 495 49.0 20.0 14.0 7.0 BO 9.6 64.0 8.0 8.0 7.5 7,5 102.2 0.0 127.1 106.8 7.9

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!