Question: Need help with MSE and MAPE The table below shows actual and forecasted nubmers of accounts serviced by a company. Compute MAD, MSE, and MAPE

Need help with MSE and MAPE The table below showsNeed help with MSE and MAPE

The table below shows actual and forecasted nubmers of accounts serviced by a company. Compute MAD, MSE, and MAPE for the following data, showing actual and forecasted numbers of accounts serviced. (Enter whole number values in the table below for Error, IErrorl, and Error 2. Round the lErrorl/Actual to three decimals. Enter O where necessary, do not leave any cells blank. Negative values should be indicated with a minus sign, i.e. -2. Round MAD, MSE and MAPE to 3 decimal places.) Answer is not complete. Period Actual Forecast Error] Error2 A- F(Error) 3 1 127 124 124 124 125 2 -1 3 (Error/Actual) X 100 2.362 0.806 2.419 0.775 127 -3 9 1 9 1 1 1 4 129 3 1 3 1 1 1 0 128 1 5 129 130 -1 0.775 6 131 132 -1 0.763 7 133 133 0 0.000 0 2 8 137 135 2 4 1.460 Answer is complete but not entirely correct. MAD 1.500 MSE 3.250 X MAPE 3.120 X

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!