Consider the number of bikes sold at a bicycle store over the past four years. Year 1 Sales, y Quarter 1 (Winter) 2 (Spring) 3 (Summer) 4 (Fall) 10 31 2 3 4 43 16 N 1 2 3 4 000 33 45 17 1 NM 9 10 11 12 13 34 48 19 Nm 13 14 15 16 15 37 51 21 Predator Constant Tim 02 03 Cot 8.7500 0.50000 210000 35000 45000 SE Cat 0.4281 0.03269 0.4782 04927 D900 20.44 13.27 43.91 69.41 912 P 0.000 0.000 0.000 0.000 0.000 03 04 33.5000 4.5000 0.4827 0.4900 43.91 0.000 69.41 0.000 9.18 0.000 S - 0.674200 R-Sq - 99.84 R-Sq(adj) 99.86 Please answer the following questions. 1. What is the estimated regression equation from the output? 2. Forecast the quarter 1 sales for the next year. (Please show the equation) 3. Forecast the quarter 2 sales for the next year. (Please show the equation) 4. Forecast the quarter 3 sales for the next year. (Please show the equation) 5. Forecast the quarter 4 sales for the next year. (Please show the equation) HTML Ed BI V A- A - IX E 31 1 x'x, EE E o N VG TT: 12pt Paragraph Consider the number of bikes sold at a bicycle store over the past four years. Year 1 Sales, y Quarter 1 (Winter) 2 (Spring) 3 (Summer) 4 (Fall) 10 31 2 3 4 43 16 N 1 2 3 4 000 33 45 17 1 NM 9 10 11 12 13 34 48 19 Nm 13 14 15 16 15 37 51 21 Predator Constant Tim 02 03 Cot 8.7500 0.50000 210000 35000 45000 SE Cat 0.4281 0.03269 0.4782 04927 D900 20.44 13.27 43.91 69.41 912 P 0.000 0.000 0.000 0.000 0.000 03 04 33.5000 4.5000 0.4827 0.4900 43.91 0.000 69.41 0.000 9.18 0.000 S - 0.674200 R-Sq - 99.84 R-Sq(adj) 99.86 Please answer the following questions. 1. What is the estimated regression equation from the output? 2. Forecast the quarter 1 sales for the next year. (Please show the equation) 3. Forecast the quarter 2 sales for the next year. (Please show the equation) 4. Forecast the quarter 3 sales for the next year. (Please show the equation) 5. Forecast the quarter 4 sales for the next year. (Please show the equation) HTML Ed BI V A- A - IX E 31 1 x'x, EE E o N VG TT: 12pt Paragraph