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

Question

Question

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

math Statistics-And-Probability

Answer 1

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

Answer 2

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

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?