Question

Monthy Proportion of On Tme Payments 80 82 84 83 83 84 85 84 82 83...

Monthy Proportion of On Tme Payments
80
82
84
83
83
84
85
84
82
83
84
83

Calculate the following for a 3-month moving average forecast; round each to 2 decimal places:

a. MFE

b. MAE

c. MSE

d. MAPE

0 0
Add a comment Improve this question Transcribed image text
Answer #1

The following is the data provided: Period Data January 80 February March April May June July August September October Novemb

The 3-month moving average forecasts are calculated in the table below: Period Data MA(3) Forecasts January February March Ap

Now, the following table shows the calculations of the corresponding error metrics: Period MA(3) Forecasts Abs. Error Error A

October 83.6667 83 - 83.6667 = 0.6667 (83 - 83.6667)2 = 0.4444 83-83.6667 83 0.8% 84 - 83 = 84-83 November 84 (84 - 83)2 = 1

Monthy Proportion of On Tme Payments (A) Forecast (F) A-F Abs (A-F)
80
82
84
83 82 1 1
83 83 0 0
84 83.3333 0.6667 0.6667
85 83.3333 1.6667 1.6667
84 84 0 0
82 84.3333 -2.3333 2.3333
83 83.6667 -0.6667 0.6667
84 83 1 1
83 83 0 0
Sum 1.3334 7.3334

MFE = sum of (A-F) / n = 1.3334/12 = 0.11

MAE =Mean Abs of (A-F) = 7.3334 / 9 = 0.82

Add a comment
Know the answer?
Add Answer to:
Monthy Proportion of On Tme Payments 80 82 84 83 83 84 85 84 82 83...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Please use the following data: Monthy Proportion of On Tme Payments 80 82 84 83 83...

    Please use the following data: Monthy Proportion of On Tme Payments 80 82 84 83 83 84 85 84 82 83 84 83 a. Calculate the following for a 3-month moving average forecast; round each to 2 decimal places: b. Calculate the following for an exponential smoothing forecast with alpha = 0.2; round each to 2 decimal places: c: Based on the MSE values that you calculated in Questions 1 & 2, what is the difference in the MSE for...

  • 1.Please use the Hawkins sheet. What is the MFE  , MAE  , MSE  , an...

    1.Please use the Hawkins sheet. What is the MFE  , MAE  , MSE  , and MAPE  for a three-month moving average forecast?  Round to two decimal places. 2.Please use the Hawkins sheet. What is the MFE  , MAE  , MSE  , and MAPE  for the exponential smoothing forecast with alpha = 0.2? Round to two decimal places. 3.Please use the Hawkins sheet. Based on the MSE values found in Questions 1 & 2, which forecast is best? ------------------------------------------------------------------ Thank you...

  • Pitcher 1 Pitcher 2 87 82 86 92 82 70 84 96 83 89 81 84 85 84 93 ...

    Pitcher 1 Pitcher 2 87 82 86 92 82 70 84 96 83 89 81 84 85 84 93 80 86 81 85 89 84 86 92 72 83 77 84 87 80 89 87 93 88 78 87 81 79 82 82 87 82 81 87 84 80 88 88 93 90 80 85 79 86 87 87 74 86 78 85 80 85 83 88 79 84 95 83 81 88 89 87 91 94 93 83 91...

  • 81. 82. 83. 84. 85. འདས་ Image #81 Image # 82 Image #83 Image # 84...

    81. 82. 83. 84. 85. འདས་ Image #81 Image # 82 Image #83 Image # 84 Image #85 A. Bacillus anthracis B. Streptococcus pyogenes C. Staphylococcus epidermidis D. Proteus mirabilis E Vibrio cholerae

  • Homework #6 NAME: (State numerical answers #1 Use the leffersonCommunityCollege data set to answe...

    Homework #6 NAME: (State numerical answers #1 Use the leffersonCommunityCollege data set to answer the following questions. #1.1 The 3-period Moving Average forecast for Period 10 is #1.2 The 5-period Moving Average forecast for Period 10 is The MSE, MAE, and MAPE scores for the 3-period and 5-period Moving Average models are: Section: 9:30 12:30 Also put your name on the top of the back of the page Circle one. to four decimal places) 3-period Moving Average S-period Moving Average...

  • Sales have been 80, 82, 88, 84, 89, and 85 during the last six weeks. The...

    Sales have been 80, 82, 88, 84, 89, and 85 during the last six weeks. The naïve forecast for next period is

  • Problem 15-03 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6...

    Problem 15-03 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6 Value 18 14 16 11 17 13 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: Mean absolute error (MAE) Mean squared error (MSE) Mean absolute percentage error (MAPE) Round your answers to two decimal places. MAE = MSE = MAPE = Using the average of all the historical data as a...

  • PLEASE ONLY ANSWER IF YOU CAN DO WHAT IS BLANK, I DON'T NEED HELP WITH WHAT...

    PLEASE ONLY ANSWER IF YOU CAN DO WHAT IS BLANK, I DON'T NEED HELP WITH WHAT IS FILLED OUT ALREADY. THANK YOU! Problem 15-03 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6 Value 1914 16 10 17 15 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: a. Mean absolute error (MAE) b. Mean squared error (MSE) c. Mean absolute percentage error...

  • Please help Consider the following time series data. 3 4 5 6 Week 12 18 14...

    Please help Consider the following time series data. 3 4 5 6 Week 12 18 14 Value 17 1018 15 Using the average of all the historical data as a forecast for the next period, compute the following measures of forecast accuracy. (Round your answers to two decimal places.) (a) mean absolute error MAE - (b) mean squared error MSE - (c) mean absolute percentage error MAPE 96 (d) What is the forecast for week 7?

  • Latest monthly sales for a company are as follows: Month Sales November 84 December 82 January...

    Latest monthly sales for a company are as follows: Month Sales November 84 December 82 January 103 February 89 March Compute a 3-Month weighted Moving Average forecast for March with the following weights: 3 for the most recent month 3 for 2 months ago 2 for 3 months ago

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT