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

Question:

Consider the following time series data.

a. Construct a time series plot. What type of pattern exists in the data?
b. Use the following dummy variables to develop an estimated regression equation to account for any seasonal and linear trend 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 next year.