0 10%% condition BUSI 291 final exam Summer 2022 (1) Zoom File Home Insert Draw Page Layout Formulas Data Modules yllabus Question 24 Calibr - 11 A A 1.5 pts scussions Paste ignment USE THE FOLLOWING INFORMATION FOR QUESTIONS 24 - 25 B I U V LA - EE izzes Carbon monoxide (CO) is a colorle vehicle emissions. Consider data on a s that is highly toxic. A major source of CO is moto Clipboard LZ rage CO emissions (grams per mile) for gasoline passenger Font 7 Alignment cars by production year from 2000 to 2018. Gasoline electric hybrids, but not electric cars, are Media included in the estimates. X V fx Year Gallery Create the time plot for these data in Excel. The forecast from the SLR (Simple Linear Regression method for 2019 is 2.186; include this forecast on the plot in a different color from the original Evaluation data. Include axis labels and a legend labeling the original data and the SLR forecast. You do not need to include a title. Year CO (grams per mile) Right-click on the plot and "Save as Picture..". Save as a PNG or JPEG file. Then in the text box 2000 16.028 below, choose Insert > Image > Upload Image. If you are having trouble saving the image from Excel click somewhere outside of the graph, then take a screenshot and crop it to include only the 2001 14.672 contents of the graph. 200 12.975 2003 11.866 2004 10.714 2005 9.759 2006 9.116 2007 8.457 2008 7.954 2009 7.48 12 2010 7.121 13 2011 6.839 14 2012 6.228 1 0 words > 15 201 5.775 16 2014 5.314 17 2015 4.898 Question 25 2 pts 18 2016 4.563 2017 4.183 For the data from the previous question, you will generate forecasts for the year 2019, Give answers to three decimal places as needed. 20 2018 3.941 grams/mile 21 Forecast for 2019 using mean method = Q 2-5 Q7-9 Q10-15 Q17-18 Q19-23 Q24-25 Forecast for 2019 using naive method = grams/mile Ready 2 Accessibility: Good to go What is the value of the drift? Give answer to three decimal places as needed. What is the forecast for 2019 using the drift method? Give answer to three decimal places as needed. Forecast for 2019 using drift method = grams/mile