Consider the following time series: Quarter Year 1 Year 2 Year 3 80 74 65 69 61 51 48 50 43 68 71 82 a. Construct a time-series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern? b. Use multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtrl = 1 if quarter 1,0 else; Qtr2 = 1 if quarter 2,0 else; Qtr3 = 1 if quarter 3,0 else. c. Compute the quarterly forecasts for next year.

College Algebra
1st Edition
ISBN:9781938168383
Author:Jay Abramson
Publisher:Jay Abramson
Chapter6: Exponential And Logarithmic Functions
Section6.8: Fitting Exponential Models To Data
Problem 1TI: Table 2 shows a recent graduate’s credit card balance each month after graduation. a. Use...
icon
Related questions
Question
Consider the following time series:
Quarter
Year 1
Year 2
Year 3
80
74
65
69
61
51
48
50
43
68
71
82
a. Construct a time-series plot. What type of pattern exists in the data? Is there an indication
of a seasonal pattern?
b. Use multiple linear regression model with dummy variables as follows to develop an
equation to account for seasonal effects in the data. Qtrl = 1 if quarter 1,0 else; Qtr2 = 1 if
quarter 2,0 else; Qtr3 = 1 if quarter 3,0 else.
c. Compute the quarterly forecasts for next year.
Transcribed Image Text:Consider the following time series: Quarter Year 1 Year 2 Year 3 80 74 65 69 61 51 48 50 43 68 71 82 a. Construct a time-series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern? b. Use multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtrl = 1 if quarter 1,0 else; Qtr2 = 1 if quarter 2,0 else; Qtr3 = 1 if quarter 3,0 else. c. Compute the quarterly forecasts for next year.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Similar questions
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Algebra and Trigonometry (MindTap Course List)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning