Total 10 1416266003 Hi, sahim Get a 7-day free trial to premium PDF tools. Start free trial The model is significant. Intercept YearCode Coefficients Standard Error -2062 2884.50 Stat P-value 3276.5 487.57 6.72 0.4928 8.65E-05 Sales -2,062 + 3,276.5 YearCode Intercept: The expected sales in YearCode 0 or Year 2013. YearCode: Annual sales growth of Diesel cars was 3,276.5. b) Using your regression model in part a) forecast sales for 2024, 2025, 2026. -2,062 + 3,276.5 (11) = 33,980 ALL TOOLS 2040 Sales 2025 Sales -2,062 + 3,276.5 (12) = 37,256 2026 Sales -2,062+ 3,276.5 (13) = 40,533 Export a PDF Edit text & images Convert to PDF Fill & Sign Organize pages Request e-signatures > Compress a PDF Combine files Protect a PDF c) Construct a plot that shows the observed sales for 2009-2019 and the fit line. Would you use the model to make forecasts for future years? The model doesn't appear to provide a good fit to the data. The model is under predicting sales and doesn't have enough slope the last couple years. I would not use this model for making predictions. 40000 35000 30000 25000 20000 15000 10000 5000 2012 2014 2016 2018 2020 2024 2026 2028 Sales -Forecast Page: 1 of 4 73°F Sunny Q Search QMM2410 W24 Chp 17 HW problems Ο Solution 品起 1 4 << > Q ENG 12:40 PM 4/14/2024 PRE Styles Sensitivity Add-ins F15 × ✓ fx A B C D E F G H | J K 1 2013 2800 2 2014 3577 3 2015 3139 4 2016 8469 5 2017 7331 6 2018 10972 7 2019 13573 8 2020 22634 9 2021 15077 10 2022 31430 11 2023 38524 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28