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
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...
Related questions
Question
100%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
Recommended textbooks for you
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning