# Question: Consider the following time series data a Construct a time series

Consider the following time series data:

a. Construct a time series plot. What type of pattern exists in the data?

b. Use a multiple regression 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 next year based on the model you developed in part b.

d. Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part b to capture seasonal effects and create a variable t such that t = 1 for quarter 1 in year 1, t = 2 for quarter 2 in year 1, . . . t = 12 for quarter 4 in year 3.

e. Compute the quarterly forecasts for next year based on the model you developed in part d.

f. Is the model you developed in part b or the model you developed in part d more effective? Justify your answer.

a. Construct a time series plot. What type of pattern exists in the data?

b. Use a multiple regression 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 next year based on the model you developed in part b.

d. Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part b to capture seasonal effects and create a variable t such that t = 1 for quarter 1 in year 1, t = 2 for quarter 2 in year 1, . . . t = 12 for quarter 4 in year 3.

e. Compute the quarterly forecasts for next year based on the model you developed in part d.

f. Is the model you developed in part b or the model you developed in part d more effective? Justify your answer.

**View Solution:**## Answer to relevant Questions

The quarterly sales data (number of copies sold) for a college textbook over the past three years follow: a. Construct a time series plot. What type of pattern exists in the data? b. Use a regression model with dummy ...Problems 1 and 2 used different forecasting methods. Which method appears to provide the more accurate forecasts for the historical data? Explain. Perform an analysis of the sales data for the Vintage Restaurant. Prepare a report for Karen that summarizes your findings, forecasts, and recommendations. Include the following: 1. A time series plot. Comment on the ...A consumer advocacy agency, Equitable Ernest, is interested in providing a service in which an individual can estimate their own credit score (a continuous measure used by banks, insurance companies, and other businesses ...Refer to the clustering problem involving the file FBS described in Problem 1. The NCAA has a preference for conferences consisting of similar schools with respect to their endowment, enrollment, and football stadium ...Post your question