Other questions: (1) What is the MAD for a = .37 (2) Which smoothing constant would you prefer?

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 27P: The file P13_27.xlsx contains yearly data on the proportion of Americans under the age of 18 living...
icon
Related questions
Question
Given the table below, complete the missing cell values applying the Exponential Smoothing method of forecasting and Mean
Absolute Deviation. Answer also the other 2 related questions below the table. Numbers with decimal should take 2 decimal
places.
Actual
Quarter Tonnage
Unloaded
1
2
3
4
5
6
7
8
175
160
170
160
160
170
180
200
Forecast for a=3
175
175.0
170.5
167.2
165.1
166.6
170.6
Sum of absolute deviation =
Absolute Deviation
for a = .3
Other questions:
(1) What is the MAD for a = .3?
(2) Which smoothing constant would you prefer?
0.00
15.00
0.50
10.35
4.93
13.45
29.41
80.89
Forecast for a = .6
175
166.0
168.4
163.4
161.3
166.5
174.6
Absolute Deviation
for a = .6
0.00
15.00
4.00
8.40
3.36
8.66
13.46
25.38
Transcribed Image Text:Given the table below, complete the missing cell values applying the Exponential Smoothing method of forecasting and Mean Absolute Deviation. Answer also the other 2 related questions below the table. Numbers with decimal should take 2 decimal places. Actual Quarter Tonnage Unloaded 1 2 3 4 5 6 7 8 175 160 170 160 160 170 180 200 Forecast for a=3 175 175.0 170.5 167.2 165.1 166.6 170.6 Sum of absolute deviation = Absolute Deviation for a = .3 Other questions: (1) What is the MAD for a = .3? (2) Which smoothing constant would you prefer? 0.00 15.00 0.50 10.35 4.93 13.45 29.41 80.89 Forecast for a = .6 175 166.0 168.4 163.4 161.3 166.5 174.6 Absolute Deviation for a = .6 0.00 15.00 4.00 8.40 3.36 8.66 13.46 25.38
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing