A construction company builds permanent docks and seawalls along the southern shore of Long Island, New York. Although the firm has been in business only five years, revenue has increased from $298,000 in the first year of operation to $1,074,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars. Quarter Year 1 Year 2 Year 3 Year 4 Year 5 1 15 32 70 87 171 2 105 141 160 207 287 3 170 240 321 379 440 4 8 21 43 77 176 (a) Construct a time series plot. What type of pattern exists in the data? O The time series plot shows only seasonal effects. The time series plot shows only a linear trend. O The time series plot shows neither a linear trend nor seasonal effects. O The time series plot shows both a linear trend and seasonal effects. (b) Use the following dummy variables to develop an estimated regression equation for the time series data (in $1,000s) to account for seasonal effects in the data. x, 1 if quarter 1, 0 otherwise; x = 1 if quarter 2, 0 otherwise; x = 1 if quarter 3, 0 otherwise. (c) Based on the model you developed in part (b), compute estimates of quarterly sales (in $1,000s) for year 6. quarter 1 forecast quarter 2 forecast quarter 3 forecast $ quarter 4 forecast thousand thousand thousand thousand (d) Lett 1 refer to the observation in quarter 1 of year 1; t = 2 refer to the observation in quarter 2 of year 1;... and t = 20 refer to the observation in quarter 4 of year 5. Using the dummy variables defined in part (b) and t, develop an estimated regression equation for the time series data (in $1,000s) to account for seasonal effects and any linear trend in the time series. (Round your numerical values to one decimal place.) 6:09 PM
A construction company builds permanent docks and seawalls along the southern shore of Long Island, New York. Although the firm has been in business only five years, revenue has increased from $298,000 in the first year of operation to $1,074,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars. Quarter Year 1 Year 2 Year 3 Year 4 Year 5 1 15 32 70 87 171 2 105 141 160 207 287 3 170 240 321 379 440 4 8 21 43 77 176 (a) Construct a time series plot. What type of pattern exists in the data? O The time series plot shows only seasonal effects. The time series plot shows only a linear trend. O The time series plot shows neither a linear trend nor seasonal effects. O The time series plot shows both a linear trend and seasonal effects. (b) Use the following dummy variables to develop an estimated regression equation for the time series data (in $1,000s) to account for seasonal effects in the data. x, 1 if quarter 1, 0 otherwise; x = 1 if quarter 2, 0 otherwise; x = 1 if quarter 3, 0 otherwise. (c) Based on the model you developed in part (b), compute estimates of quarterly sales (in $1,000s) for year 6. quarter 1 forecast quarter 2 forecast quarter 3 forecast $ quarter 4 forecast thousand thousand thousand thousand (d) Lett 1 refer to the observation in quarter 1 of year 1; t = 2 refer to the observation in quarter 2 of year 1;... and t = 20 refer to the observation in quarter 4 of year 5. Using the dummy variables defined in part (b) and t, develop an estimated regression equation for the time series data (in $1,000s) to account for seasonal effects and any linear trend in the time series. (Round your numerical values to one decimal place.) 6:09 PM
Chapter12: Sequences, Series And Binomial Theorem
Section12.3: Geometric Sequences And Series
Problem 12.58TI: What is the total effect on the economy of a government tax rebate of $500 to each household in...
Related questions
Question
i need the answer quickly
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 27 images
Recommended textbooks for you
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781337278461
Author:
Ron Larson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781337278461
Author:
Ron Larson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning