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

Question:

Consider the following time series:

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

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: 978-1111532222

13th edition

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

Question Posted: