Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 a. Construct a time series plot. What type of pattern exists in the data? Trend Pattern Seasonal Pattern Horizontal Pattern O Trend and Seasonal Pattern Question 11 5 pts b. Create the following dummy variables: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Create a variable t such that t = 1 for quarter 1 of year 1, t = 2 for quarter 2 of year 1, ..., t = 12 for quarter 4 of year 3. Use these dummy variables and t to develop an estimated regression equation to account for seasonal effects and any linear trend in the data. What is the forecast for quarter 1 of next year?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.7: Exponential Smoothing Models
Problem 29P: The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building...
icon
Related questions
Question

help  please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working

Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
4
6
7
2
2
3
6
3
3
5
6
4
5
7
8
a. Construct a time series plot. What type of pattern exists in
the data?
Trend Pattern
Seasonal Pattern
Horizontal Pattern
O Trend and Seasonal Pattern
Question 11
5 pts
b. Create the following dummy variables: Qtr1 = 1 if quarter
1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if
quarter 3, 0 otherwise. Create a variable t such that t = 1 for
quarter 1 of year 1, t = 2 for quarter 2 of year 1, ..., t = 12 for
quarter 4 of year 3. Use these dummy variables and t to
develop an estimated regression equation to account for
seasonal effects and any linear trend in the data. What is the
forecast for quarter 1 of next year?
Transcribed Image Text:Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 a. Construct a time series plot. What type of pattern exists in the data? Trend Pattern Seasonal Pattern Horizontal Pattern O Trend and Seasonal Pattern Question 11 5 pts b. Create the following dummy variables: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Create a variable t such that t = 1 for quarter 1 of year 1, t = 2 for quarter 2 of year 1, ..., t = 12 for quarter 4 of year 3. Use these dummy variables and t to develop an estimated regression equation to account for seasonal effects and any linear trend in the data. What is the forecast for quarter 1 of next year?
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,