canvas,ubc.ca/courses/97597/quizzes/533816/take AutoSave . on BUSI 291 final exam Summer 2022 (1) Sea Question 24 1.5 pt File Home Insert Draw Page Layout Formulas Data Review View USE THE FOLLOWING INFORMATION FOR QUESTIONS 24 - 25. Carbon mon adde (CO) is a colorless, odorless gas that is highly tendc. A major source of CO is moto Calibri 11 AA = = = General vehicle em ins. Consider data on average CO emissions (grams per mile) for gasoline passenger ~ % cars by production year from 2000 to 2018. Gasoline electric hybrids, but not electric cars, are Paste BIU - H - GA included in the estim Create the time plot for these data in Excel. The forecast from the SLR (Simple Linear Regression Clipboard Font Alignment Number ethod for 2019 is 2.186: include this forecast on the plot in a different color from the original data, include axis labels and a legend babeding the original data and the SL.R forecast. You do not need to include a title, A1 X V fx Year Right-click sin the plot and "Save as cture." Save as a PNG or JPEG file, Then in the text box house insert > image > Upload image. If you are having trouble saving the Image from Excel, CO U click somewhere outside of the graph, then take a s hot and crap it to include only the contends of the graph. Year CO (grams per mile) 2000 16.028 2001 14.672 2002 12.975 2003 11.866 2004 10.714 2005 9.759 2006 9.116 200 8.457 2008 7.954 2009 7.48 Bil 1 0 words to 2010 7.121 2011 6.839 2012 6.228 Question 25 2 pts 2013 5.775 2014 5.314 for the data from the previous question, you will generate forecasts for the year 2019. Give answer to steer decimal places as needed. 2015 4.898 Forecast for 2039 using mean method grams/mile 2016 4.563 2017 4.183 forecast for 2019 using naive method grams/mile 2018 3.941 What is the value of the drin? Give answer to three decimal places as need Q2-5 Q7-9 Q 10-15 Q 17-18 Q 19-23 Q24-25 Q 26-27 Q28 Ready 12 Accessibility Good to go What is the forecast for 2019 using the drift method? Gie answer to three decimal places as mended Forecast for 2019 asis duit an grams/mile