Question: Please finish both part 2 and 3 Part 2: Fill in the yellow cells with measure of forecast error. Round off to two decimal places

Please finish both part 2 and 3 Part 2: Fill inPlease finish both part 2 and 3

Part 2: Fill in the yellow cells with measure of forecast error. Round off to two decimal places TOT You may find it helpful to use the orange cells for intermediate calculations. Don't round off intermediate values in final calculations. Period Demand Forecast Error Abs Error Error2 abser/demand 1 10316.00 10300.00 2 12443.00 10565.00 3 11717.00 10562.00 4 11035.00 10755.00 5 12173.00 11377.75 6 11015.00 11842.00 7 11039.00 11485.00 8 11934.00 11315.50 9 11694.00 11540.25 10 10420.00 11420.50 Forecast CFE MAD MSE MAPE Part 3: Answer the questions below Forecast A CFE 22 MAD 11.5 MSE 177 MAPE 0.11 (forecast errors below are based on different data than that shown above) Forecast B Forecast C -2.2 15 14.5 12.6 149 -156 0.21 0.16 Question 1: Which measure of forecast error is incorrect. Identify the mistake by indicating both the measure of forecast error and the specific forecast (A, B, or C) in the green box Question 2: Which forecast (A, B, or C) has the largest squared errors? Identify the error type (e.g. CFE, MAD, MSE, MAPE) and the Forecast (e.g. A, B, C) -- in the green box. Question 3: Which forecast (A, B, or C) is the least 'biased'? Identify the error type (e.g. CFE, MAD, MSE, MAPE) and the Forecast (e.g. A, B, C) -- in the green box

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!