The following data shows the quarterly sales of the LukeHydro tents at a Aubrey Sporting Goods Store. The store owner wants to forecast the quarterly sales for the next year. (a) Construct a time series plot. What type of pattern exists in the data? (b) Use dummy variables and multiple regression to find a multiple regression equation that accounts for seasonal effects in the data (c) Based on this model, estimate the quarterly sales for the fourth year. Year 1 1 1 1 2 2 2 2 3 3 3 3 4 4 4 4 Quarter 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 a Q1 a Q2 Q3 Sales 74 53 61 82 71 45 65 87 67 57 58 78

Functions and Change: A Modeling Approach to College Algebra (MindTap Course List)
6th Edition
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Bruce Crauder, Benny Evans, Alan Noell
Chapter3: Straight Lines And Linear Functions
Section3.CR: Chapter Review Exercises
Problem 15CR: Life Expectancy The following table shows the average life expectancy, in years, of a child born in...
icon
Related questions
Question
2
3 The following data shows the quarterly sales of the LukeHydro tents at a Aubrey Sporting Goods Store.
4 The store owner wants to forecast the quarterly sales for the next year.
5
6
(a) Construct a time series plot. What type of pattern exists in the data?
7
8
(b) Use dummy variables and multiple regression to find a multiple regression equation that accounts for seasonal effects in the data.
9
10 (c) Based on this model, estimate the quarterly sales for the fourth year.
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Year
1
1
1
1
2
2
2
2
3
3
3
3
4
4
4
4
Quarter
1
2
3
4
1
2
3
4
1
2
3
4
1
2
34
Q1
Q2
Q3
Sales
74
53
61
82
71
45
65
87
67
57
58
78
Transcribed Image Text:2 3 The following data shows the quarterly sales of the LukeHydro tents at a Aubrey Sporting Goods Store. 4 The store owner wants to forecast the quarterly sales for the next year. 5 6 (a) Construct a time series plot. What type of pattern exists in the data? 7 8 (b) Use dummy variables and multiple regression to find a multiple regression equation that accounts for seasonal effects in the data. 9 10 (c) Based on this model, estimate the quarterly sales for the fourth year. 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Year 1 1 1 1 2 2 2 2 3 3 3 3 4 4 4 4 Quarter 1 2 3 4 1 2 3 4 1 2 3 4 1 2 34 Q1 Q2 Q3 Sales 74 53 61 82 71 45 65 87 67 57 58 78
Expert Solution
steps

Step by step

Solved in 5 steps with 17 images

Blurred answer
Similar questions
Recommended textbooks for you
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
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
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