A statistical program is recommended. A certain company has been an authorized dealer for C&D marine radios for the past seven years. Suppose the quarterly sales values for the seven years of historical data are as follows. Year Quarter 1 Quarter 2 1 2 3 4 5 6 7 11 15 19 22 25 29 15 18 26 28 34 36 40 Quarter 3 Quarter 4 10 15 23 25 28 30 35 4 7 radios radios radios radios 12 18 21 20 27 Total Yearly Sales 36 51 76 90 105 111 131 (a) Use the following dummy variables to develop an estimated regression equation to account for any seasonal and linear trend effects in the data: x₁=1 if quarter 1, 0 otherwise; x₂-1 if quarter 2, 0 otherwise; and x₂ = 1 if quarter 3, 0 otherwise. (Let t= 1 denote the time series value in quarter 1 of year 1; t = 2 denote the time series value in quarter 2 of year 1;... and t28 denote the time series value in quarter 4 of year 7. Round your numerical values to three decimal places.) (b) Compute the quarterly forecasts for next year. (Round your answers to the nearest integer.) forecast for quarter 1 forecast for quarter 2 forecast for quarter 3 forecast for quarter 4

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
Chapter5: A Survey Of Other Common Functions
Section5.3: Modeling Data With Power Functions
Problem 6E: Urban Travel Times Population of cities and driving times are related, as shown in the accompanying...
icon
Related questions
Question
100%
A statistical program is recommended.
A certain company has been an authorized dealer for C&D marine radios for the past seven years. Suppose the quarterly sales values for the seven years of historical data are as follows.
Year Quarter 1 Quarter 2 Quarter 3
1
2
3
4
5
6
7
7
11
15
19
22
25
29
15
18
26
28
34
36
40
10
15
23
25
28
30
35
Quarter 4
4
radios
radios
radios
radios
7
12
18.
21
20
27
Total Yearly
Sales
36
51
76
90
105
111
131
(a) Use the following dummy variables to develop an estimated regression equation to account for any seasonal and linear trend effects in the data: x₁ = 1 if quarter 1, 0 otherwise; x₂ = 1 if quarter 2, 0 otherwise; and x3 = 1 if quarter 3, 0 otherwise. (Let t = 1 denote the time series value in quarter 1 of year 1; t = 2 denote
the time series value in quarter 2 of year 1; ... and t = 28 denote the time series value in quarter 4 of year 7. Round your numerical values to three decimal places.)
8 =
(b) Compute the quarterly forecasts for next year. (Round your answers to the nearest integer.)
forecast for quarter 1
forecast for quarter 2
forecast for quarter 3
forecast for quarter 4
Transcribed Image Text:A statistical program is recommended. A certain company has been an authorized dealer for C&D marine radios for the past seven years. Suppose the quarterly sales values for the seven years of historical data are as follows. Year Quarter 1 Quarter 2 Quarter 3 1 2 3 4 5 6 7 7 11 15 19 22 25 29 15 18 26 28 34 36 40 10 15 23 25 28 30 35 Quarter 4 4 radios radios radios radios 7 12 18. 21 20 27 Total Yearly Sales 36 51 76 90 105 111 131 (a) Use the following dummy variables to develop an estimated regression equation to account for any seasonal and linear trend effects in the data: x₁ = 1 if quarter 1, 0 otherwise; x₂ = 1 if quarter 2, 0 otherwise; and x3 = 1 if quarter 3, 0 otherwise. (Let t = 1 denote the time series value in quarter 1 of year 1; t = 2 denote the time series value in quarter 2 of year 1; ... and t = 28 denote the time series value in quarter 4 of year 7. Round your numerical values to three decimal places.) 8 = (b) Compute the quarterly forecasts for next year. (Round your answers to the nearest integer.) forecast for quarter 1 forecast for quarter 2 forecast for quarter 3 forecast for quarter 4
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer