Jane is trying to forecast demand for her store, using Exponential Smoothing, using a = 0.75. Fill in the missing cells with correct values

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...
icon
Related questions
Question

Jane is trying to forecast demand for her store, using Exponential Smoothing, using  = 0.75.
Fill in the missing cells with correct values

Jane is trying to forecast demand for her store, using Exponential Smoothing, using a =
0.75.
Fill in the missing cells with correct values
A
B
C
E
F
Enroll-
Quarter ment
313
285
1
Year
Forecast
Error
Abs Error
2
1997
1
313
3
2
313
4
312
292
20
20
4
339
307
32
32
1998
1
359
331
28
28
320
8
356
328
28
28
4
385
349
36
?
10
1999
1
396
376
20
20
11
367
12
397
373
24
24
13
4
423
391
32
32
14
2000
1
415
16
Alpha =
0.75
MAD =
N 3
Transcribed Image Text:Jane is trying to forecast demand for her store, using Exponential Smoothing, using a = 0.75. Fill in the missing cells with correct values A B C E F Enroll- Quarter ment 313 285 1 Year Forecast Error Abs Error 2 1997 1 313 3 2 313 4 312 292 20 20 4 339 307 32 32 1998 1 359 331 28 28 320 8 356 328 28 28 4 385 349 36 ? 10 1999 1 396 376 20 20 11 367 12 397 373 24 24 13 4 423 391 32 32 14 2000 1 415 16 Alpha = 0.75 MAD = N 3
Expert Solution
steps

Step by step

Solved in 3 steps with 2 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,
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning