What is the MA3 forecast for Year 4, Q1? What is the weighted MA3 forecast for Year 4, Q1 with weights of 0.5, 0.33, and 0.17? What is the Exponential Smoothing forecast for Year 4, Q1 using alpha = 0.3? What is the Adjusted Exponential Smoothing forecast for Year 4, Q1 using alpha = 0.3 and beta = 0.5?

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter5: Inverse, Exponential, And Logarithmic Functions
Section5.6: Exponential And Logarithmic Equations
Problem 6E
icon
Related questions
Question
100%

What is the MA3 forecast for Year 4, Q1?

What is the weighted MA3 forecast for Year 4, Q1 with weights of 0.5, 0.33, and 0.17?

 
What is the Exponential Smoothing forecast for Year 4, Q1 using alpha = 0.3?
 
What is the Adjusted Exponential Smoothing forecast for Year 4, Q1 using alpha = 0.3 and beta = 0.5?
 
alpha
0.3
beta
0.5
Year
Quarter
Demand
МАЗ
MA5
WMA3
ES
Trend
AES
1
105
2
150
105.00
0.00
105.00
3
93
118.50
6.75
125.25
4
121
116.00
113.85
110.85
-0.45
110.40
1.
140
121.33
116.69
113.90
1.30
115.19
2.
170
118.00
121.80
125.74
121.73
4.56
126.29
3
105
143.67
134.80
151.77
136.21
9.52
145.73
150
138.33
125.80
132.40
126.85
0.08
126.93
3
200
141.67
137.20
138.55
133.79
3.51
137.31
2.
170
151.67
153.00
167.35
153.65
11.69
165.34
110
173.33
159.00
176.50
158.56
8.30
166.85
4
130
160.00
147.00
145.10
143.99
-3.14
140.85
136.67
152.00
130.20
139.79
-3.67
136.13
year
Ann. Dem.
year 4 prediction
s1
0.27
1
469
622.3333
s2
0.30
2
565
seasonally adjusted forecast for Year 4, Q1
s3
0.19
610
168.454
s4
0.24
SUMMARY OUTPUT
Regression Statistics
E Multiple R 0.841967
R Square
0.708909
Adjusted R 0.417818
Standard Ei 41.23308
Observatioi
3
2.
Transcribed Image Text:alpha 0.3 beta 0.5 Year Quarter Demand МАЗ MA5 WMA3 ES Trend AES 1 105 2 150 105.00 0.00 105.00 3 93 118.50 6.75 125.25 4 121 116.00 113.85 110.85 -0.45 110.40 1. 140 121.33 116.69 113.90 1.30 115.19 2. 170 118.00 121.80 125.74 121.73 4.56 126.29 3 105 143.67 134.80 151.77 136.21 9.52 145.73 150 138.33 125.80 132.40 126.85 0.08 126.93 3 200 141.67 137.20 138.55 133.79 3.51 137.31 2. 170 151.67 153.00 167.35 153.65 11.69 165.34 110 173.33 159.00 176.50 158.56 8.30 166.85 4 130 160.00 147.00 145.10 143.99 -3.14 140.85 136.67 152.00 130.20 139.79 -3.67 136.13 year Ann. Dem. year 4 prediction s1 0.27 1 469 622.3333 s2 0.30 2 565 seasonally adjusted forecast for Year 4, Q1 s3 0.19 610 168.454 s4 0.24 SUMMARY OUTPUT Regression Statistics E Multiple R 0.841967 R Square 0.708909 Adjusted R 0.417818 Standard Ei 41.23308 Observatioi 3 2.
ANOVA
df
ignificance F
SS
MS
Regression
1
4140.5
4140.5
2.4353495 0.362795
Residual
1 1700.167 1700.167
Total
2 5840.667
Coefficients andard Errc
t Stat
P-value
Lower 95% Upper 95% ower 95.0%Jpper 95.0%
Intercept
X Variable :
440.3333
62.98457
6.991131 0.0904475 -359.9615 1240.628 -359.9615 1240.628
45.5 29.15619 1.560561 0.3627951 -324.9645
415.9645 -324.9645 415.9645
Transcribed Image Text:ANOVA df ignificance F SS MS Regression 1 4140.5 4140.5 2.4353495 0.362795 Residual 1 1700.167 1700.167 Total 2 5840.667 Coefficients andard Errc t Stat P-value Lower 95% Upper 95% ower 95.0%Jpper 95.0% Intercept X Variable : 440.3333 62.98457 6.991131 0.0904475 -359.9615 1240.628 -359.9615 1240.628 45.5 29.15619 1.560561 0.3627951 -324.9645 415.9645 -324.9645 415.9645
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

What is the adjusted Exponential Smoothing forecast for Year 4, Q1 using alpha = 0.3 and beta = 0.5?

 

What is the predicted annual demand for year 4?

 

What is the seasonally adjusted forecast for year 4, Q1? 

Solution
Bartleby Expert
SEE SOLUTION
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage