The accompanying dataset provides data on the monthly usage of natural gas (in millions of cubic feet) for a certain region over two years. Implement the Holt-Winters multiplicative seasonality model with no trend to find the forecast for periods 13-26, where α=0.6and γ=0.9. Then find the MAD for periods 13-24. Use the Holt-Winters multiplicative seasonality model with no trend to find the forecast for periods 13-18, periods 19-24, and then for periods 25 and 26. (Type integers or decimals rounded to two decimal places as needed.) Period Forecast 13 enter your response here 14 enter your response here 15 enter your response here 16 enter your response here 17 enter your response here 18 enter your response here Month Period Gas Usage Jan 1 250 Feb 2 234 Mar 3 149 Apr 4 140 May 5 54 Jun 6 33 Jul 7 31 Aug 8 28 Sep 9 29 Oct 10 40 Nov 11 89 Dec 12 195 Jan 13 234 Feb 14 242 Mar 15 253 Apr 16 137 May 17 35 Jun 18 32 Jul 19 26 Aug 20 25 Sep 21 29 Oct 22 38 Nov 23 83 Dec 24 192
The accompanying dataset provides data on the monthly usage of natural gas (in millions of cubic feet) for a certain region over two years. Implement the Holt-Winters multiplicative seasonality model with no trend to find the forecast for periods 13-26, where α=0.6and γ=0.9. Then find the MAD for periods 13-24. Use the Holt-Winters multiplicative seasonality model with no trend to find the forecast for periods 13-18, periods 19-24, and then for periods 25 and 26. (Type integers or decimals rounded to two decimal places as needed.) Period Forecast 13 enter your response here 14 enter your response here 15 enter your response here 16 enter your response here 17 enter your response here 18 enter your response here Month Period Gas Usage Jan 1 250 Feb 2 234 Mar 3 149 Apr 4 140 May 5 54 Jun 6 33 Jul 7 31 Aug 8 28 Sep 9 29 Oct 10 40 Nov 11 89 Dec 12 195 Jan 13 234 Feb 14 242 Mar 15 253 Apr 16 137 May 17 35 Jun 18 32 Jul 19 26 Aug 20 25 Sep 21 29 Oct 22 38 Nov 23 83 Dec 24 192
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.7: Exponential Smoothing Models
Problem 28P: The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present...
Related questions
Question
7, The accompanying dataset provides data on the monthly usage of natural gas (in millions of cubic feet) for a certain region over two years. Implement the Holt-Winters multiplicative seasonality model with no trend to find the
Use the Holt-Winters multiplicative seasonality model with no trend to find the forecast for periods 13-18, periods 19-24, and then for periods 25 and 26.
(Type integers or decimals rounded to two decimal places as needed.)
|
Period
|
Forecast
|
|---|---|
|
13
|
enter your response here
|
|
14
|
enter your response here
|
|
15
|
enter your response here
|
|
16
|
enter your response here
|
|
17
|
enter your response here
|
|
18
|
enter your response here
|
|
Month
|
Period
|
Gas Usage
|
|
|---|---|---|---|
|
Jan
|
1
|
250
|
|
|
Feb
|
2
|
234
|
|
|
Mar
|
3
|
149
|
|
|
Apr
|
4
|
140
|
|
|
May
|
5
|
54
|
|
|
Jun
|
6
|
33
|
|
|
Jul
|
7
|
31
|
|
|
Aug
|
8
|
28
|
|
|
Sep
|
9
|
29
|
|
|
Oct
|
10
|
40
|
|
|
Nov
|
11
|
89
|
|
|
Dec
|
12
|
195
|
|
|
Jan
|
13
|
234
|
|
|
Feb
|
14
|
242
|
|
|
Mar
|
15
|
253
|
|
|
Apr
|
16
|
137
|
|
|
May
|
17
|
35
|
|
|
Jun
|
18
|
32
|
|
|
Jul
|
19
|
26
|
|
|
Aug
|
20
|
25
|
|
|
Sep
|
21
|
29
|
|
|
Oct
|
22
|
38
|
|
|
Nov
|
23
|
83
|
|
|
Dec
|
24
|
192
|
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing