Consider the following time series data: a. Construct a time series plot. What type of pattern exists

Question:

Consider the following time series data:

Consider the following time series data:  a. Construct a time series

a. Construct a time series plot. What type of pattern exists in the data?
b. Use an Excel or LINGO model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise.
c. Compute the quarterly forecasts for nextyear.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

An Introduction To Management Science Quantitative Approaches To Decision Making

ISBN: 226

13th Edition

Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Cam

Question Posted: