Question

The following times series shows the demand for a particular product over the past 10 months.

Month	Value
1	324
2	311
3	303
4	314
5	323
6	313
7	302
8	315
9	312
10	326

a. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE, MAPE and a forecast for month 11.

b. Calculate MSE and MAPE for three month moving average ?

c. Compare the three-month moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE?

Answer 1

a. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE, MAPE and a forecast for month 11.

For exponential smoothing we will assume the first month forecast value is same as actual.

For next forecast values we hhvae the formula

Eg: For month 4 we have F4 = A3 * 0.2 + F3*0.8

Month	Value	Forecast
1	324	324
2	311	324.000
3	303	321.400
4	314	317.720
5	323	316.976
6	313	318.181
7	302	317.145
8	315	314.116
9	312	314.293
10	326	313.834
11		316.267

MSE = mean squared error

where the error = actual - forecast

So we square the error.

MSE = ......We divide 9 because we have 9 pirs of the actual and forecast.

Month	Value	Forecast	Error	Error^2
1	324	324
2	311	324.000	-13.000	169.000
3	303	321.400	-18.400	338.560
4	314	317.720	-3.720	13.838
5	323	316.976	6.024	36.289
6	313	318.181	-5.181	26.841
7	302	317.145	-15.145	229.360
8	315	314.116	0.884	0.782
9	312	314.293	-2.293	5.256
10	326	313.834	12.166	148.010
11		316.267
Total				967.936
Mean				107.548

MAPE = mean absolute percentage error

Where percentage error = Absolute error / actual

MAPE =

Month	Value	Forecast	Error	Abs error	APE
1	324	324
2	311	324.000	-13.000	13	4.2%
3	303	321.400	-18.400	18.4	6.1%
4	314	317.720	-3.720	3.72	1.2%
5	323	316.976	6.024	6.024	1.9%
6	313	318.181	-5.181	5.181	1.7%
7	302	317.145	-15.145	15.145	5.0%
8	315	314.116	0.884	0.884	0.3%
9	312	314.293	-2.293	2.293	0.7%
10	326	313.834	12.166	12.166	3.7%
11		316.267
Total					24.7%
Mean					2.7%

b. Calculate MSE and MAPE for three month moving average ?

Moving average is where we first take the total of previous 'n' periods and then divide by 'n'.

So Eg: we have F4 = (sum (A1 + A2+ A3)/ 3

Month	Value	Moving Total	Forecast	Error	Error^2	Abs error	APE
1	324
2	311
3	303
4	314	938	312.667	1.333	1.778	1.333	0.4%
5	323	928	309.333	13.667	186.778	13.667	4.2%
6	313	940	313.333	-0.333	0.111	0.333	0.1%
7	302	950	316.667	-14.667	215.111	14.667	4.9%
8	315	938	312.667	2.333	5.444	2.333	0.7%
9	312	930	310.000	2.000	4.000	2.000	0.6%
10	326	929	309.667	16.333	266.778	16.333	5.0%
11		953	317.667				0 0 Add a comment Know the answer? Your Answer: Post as a guest Your Name: What's your source? Earn Coins Coins can be redeemed for fabulous gifts. Log In Sign Up Post as anonymous Post Your Answer Not the answer you're looking for? Ask your own homework help question Similar Questions The following time series shows the number of units of a particular product sold over the... The following time series shows the number of units of a particular product sold over the past six months. Month Units Sold 1 9 2 4 3 5 4 6 5 13 6 11 ​a. Compute the three-month moving average forecast for month 4. b. Compute the three-month moving average forecast for month 5. c. Compute the three-month moving average forecast for month 6. d. Compute the mean squared error (MSE) for the three-month moving average forecasts. e. Use α... Consider the following time series data. Month 1 2 3 4 5 6 7 Value 22... Consider the following time series data. Month 1 2 3 4 5 6 7 Value 22 11 18 10 17 21 13 A) What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a trend pattern.     The data appear to follow a horizontal pattern. The data appear to follow a cyclical pattern. B) Develop the three-month moving average forecasts for this time series. Month Time Series Value Forecast 1... Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24... Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24 13 20 12 19 23 15 Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal places. Do not round intermediate calculation. MSE: The forecast for month 8: (c) Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for... Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12... Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12 16 11 18 13 (b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 19 2 12 3 16 4 11 5 18 6 13 Compute MSE. (Round your answer to two decimal places.) MSE =   What is the forecast for week 7? (c) Use α = 0.2 to compute... (b) Develop the three-week moving average forecasts for this time series. (Round your answers to two... (b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 16 2 11 3 13 4 10 5 14 6 12 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (c) Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 16 2 11 3 13 4... Month 1 2 3 4 5 6 7 Value 25 14 21 13 20 24 16... Month 1 2 3 4 5 6 7 Value 25 14 21 13 20 24 16 (b) Develop the three-month moving average forecasts for this time series. Month Time Series Value Forecast 1 25 2 14 3 21 4 13 5 20 6 24 7 16 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for month 8? (c) Use α = 0.2 to compute the exponential smoothing forecasts for the time series. (Round... Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23... Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17 (a) Create a time series plot. What type of pattern exists in the data? - Select your answer -Positive trend patternHorizontal patternVertical patternNegative trend patternItem 2 (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal places. Do not round intermediate calculation.... Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24... Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24 15 21 12 19 21 16 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Graph (i)Graph (ii)Graph (iii)Graph (iv)Item 1 What type of pattern exists in the data? - Select your answer -Positive trend patternHorizontal patternVertical patternNegative trend patternItem 2 (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month... Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13... Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 A) What type of pattern exists in the data? (HORIZONTAL OR TREND) B) Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. If required, round your answers to two decimal places. Week Time Series Value Forecast 1 18 2 13 3 16 4 11 _______ 5 17 _______ 6 14 _______ MSE:... Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23... Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17 b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal places. Do not round intermediate calculation. MSE: The forecast for month 8: (c) Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast... ADVERTISEMENT Need Online Homework Help? Get Answers For Free Most questions answered within 1 hours. Ask a Question ADVERTISEMENT Active Questions Lindsay is 75 years old and us faced with the need to move to a nursing... asked 6 minutes ago In an experiment, the voltage across a resistor is V= (74.1 ± 0.4) V and the... asked 6 minutes ago Consider a binomial probability distribution with p=0.65 and n=8. Determine the probabilities below. a) P(x=2) b)... asked 13 minutes ago Using Tuples in python In this problem, you will be given an array A of integers... asked 13 minutes ago GIVE ME QUERIES: d) List Order IDs and the associated Customer Full Names for orders that... asked 18 minutes ago Hi. I want to make this cocktail sort method, but with the call sort(Comparable[] array). What... asked 22 minutes ago A long horizontal wire carries 14.0 A of current due north. What is the magnitude of... asked 29 minutes ago Use the Law of Sines to solve (if possible) the triangle. If two solutions exist, find... asked 29 minutes ago write a function to delete the largest item from a sorted (asc) Circular Linked List (a... asked 30 minutes ago In a two-page paper, research three examples of technologies that use quantum mechanics. Explain, in your... asked 38 minutes ago In Java: The maximum-valued element of an int-valued array can be recursively calculated as follows: •... asked 51 minutes ago A coin is tossed repeatedly; on each toss, a head is shown with probability p or... asked 59 minutes ago About Contact Terms of Use Privacy Policy Academic Honesty Policy Homework Answer Scanner App Report DMCA © 2022 JustAAA   user contributions licensed under cc by-sa 4.0