How do I do this in Excel? Thanks!
AmeriPlas produces 20-ounce plastic drinking cups that are
embossed with the names
of prominent beers and soft drinks. It has been observed that
demand for the cups has exhibited a
positive trend over time. The data file provided includes the
demand data by month for 2014 through
2017.
a. Fit a Holt model with (α,β) = (0.30,0.20) and another with (α,β)
= (0.25,0.15). Initialize both
models using the first six data points. Evaluate your models on the
basis of their performance
over a four-month holdout sample. Which of your two models would
you recommend and why?
b. For whichever model you recommended in Part A, use that model to
produce a point forecast
and prediction interval for demand in each of the next four months
in the future.
How do I do this in Excel? Thanks! AmeriPlas produces 20-ounce plastic drinking cups that are embossed with the names of
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am