The data shown are quarterly revenues (in $thousands) from Roget's Books from 2013-Q1 through 2020-Q2. Quarter 2013-1 2013-2 2013-3 2013-4 2014-1 2014-2 2014-3 2014-4 2015-1 2015-2 2015-3 2015-4 2016-1 2016-2 2016-3 2016-4 2017-1 2017-2 2017-3 2017-4 Revenue 2372 2740 2518 4708 2392 2811 2685 4795 2812 2893 2848 4894 2687 2903 2674 4871 2844 2933 2791 5252 Quarter 2018-1 2018-2 2018-3 2018-4 2019-1 2019-2 2019-3 2019-4 2020-1 2020-2 Revenue 2725 2924 3118 5112 2777 2949 3237 5350 3035 3028 7:04 Click here for the Excel Data File, Data file should open in a new browswer window. Select "File" then "Save As" to download the file to your computer and be able to use it in Excel. a. Determine the regression equation. Regression equation: ŷ = (Round to 1 decimal places.) b. Determine the specific index for each quarter places.) ndexes should be in decimal form (e.g. 1.36 not 136). Rounded to 2 decimal Quarter Quarterly Index Q1 Q2 Q3 Q4 c. What are the estimated sales (forecast) for the next three quarters? Values in Sthousands. Round to 2 decimal places.) ০
The data shown are quarterly revenues (in $thousands) from Roget's Books from 2013-Q1 through 2020-Q2. Quarter 2013-1 2013-2 2013-3 2013-4 2014-1 2014-2 2014-3 2014-4 2015-1 2015-2 2015-3 2015-4 2016-1 2016-2 2016-3 2016-4 2017-1 2017-2 2017-3 2017-4 Revenue 2372 2740 2518 4708 2392 2811 2685 4795 2812 2893 2848 4894 2687 2903 2674 4871 2844 2933 2791 5252 Quarter 2018-1 2018-2 2018-3 2018-4 2019-1 2019-2 2019-3 2019-4 2020-1 2020-2 Revenue 2725 2924 3118 5112 2777 2949 3237 5350 3035 3028 7:04 Click here for the Excel Data File, Data file should open in a new browswer window. Select "File" then "Save As" to download the file to your computer and be able to use it in Excel. a. Determine the regression equation. Regression equation: ŷ = (Round to 1 decimal places.) b. Determine the specific index for each quarter places.) ndexes should be in decimal form (e.g. 1.36 not 136). Rounded to 2 decimal Quarter Quarterly Index Q1 Q2 Q3 Q4 c. What are the estimated sales (forecast) for the next three quarters? Values in Sthousands. Round to 2 decimal places.) ০
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section: Chapter Questions
Problem 41P
Related questions
Question
Transcribed Image Text:The data shown are quarterly revenues (in Sthousands) from Roget's Books from 2013-Q1 through 2020-Q2.
6.
Quarter
2013-1
2013-2
2013-3
2013-4
2014-1
2014-2
2014-3
2014-4
2015-1
2015-2
2015-3
2015-4
2016-1
2016-2
2016-3
2016-4
2017-1
2017-2
2017-3
2017-4
Revenue
2372
2740
2518
4708
2392
Quarter
2018-1
2018-2
2018-3
2018-4
2019-1
2019-2
2019-3
2019-4
2020-1
2020-2
Revenue
2725
2924
3118
5112
2777
2949
1:27:04
2811
2685
4795
2812
2893
2848
4894
2687
2903
2674
4871
2844
2933
3237
5350
3035
3028
2791
5252
Click here for the Excel Data File, Data file should open in a new browswer window. Select "File" then "Save As" to download the file to
your computer and be able to use it in Excel.
a. Determine the regression equation.
Regression equation: ŷ = |
(Round to 1 decimal places.)
b. Determine the specific index for each quarter
places.)
dexes should be in decimal form (e.g. 1.36 not 136). Rounded to 2 decimal
Quarter
Quarterly Index
Q1
Q2
Q3
Q4
c. What are the estimated sales (forecast) for the next three quarters?
Values in $thousands. Round to 2 decimal places.)
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 4 steps with 7 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,