This needs done on excel and I am bad on Excel if anyone can help, thank you!
Regression problems - do ON excel. 7. Year Number of Collisions (thousands) 1992 4.9 1995 4.6 2000 3.5 2005 3.1 2010 2.1 2014 2.3 a) Draw a scatterplot with correct labels MAKE SURE YOU RECODE THE YEAR TO YEARS SINCE 1992 b) Draw a trendline and write the equation of the line on your graph. Interpret the value of the slope and the y-intercept MAKE SURE YOU INCLUDE APPROPRIATE UNITS for the slope c) Use your model to predict how many collisions occurred in 2012. Did you perform interpolation or extrapolation? d) Use your model to predict when there will be 1.0 thousand collisions. Are you skeptical about this number? What assumption(s) are we making with this prediction e) Find the horizontal intercept. What does it mean in the context of this problem? Are you skeptical about this number? What assumption(s) are we making with this prediction 8. The consumer price index (CPI) is calculated by the US department of Labor. It is a measure of the relative price of a typical market basket of goods in a given year. The percentage increase int eh CPI from one year to the next gives one measure of the annual rate of inflation compared to a base year in this case it is year 1995) Year 2008 2009 2011 2014 2015 2018 CPI 210.2 215.9 225.7 234.5 236.5 238 a) Create a row between Year and CPI and place a label and the data for Years since 2008" b) Draw a scatter diagram with correct labels c) Draw a trendline and write the equation of the line on your graph. Interpret the value of the slope and the y-intercept MAKE SURE YOU INCLUDE APPROPRIATE UNITS for the slope d) Use your model to predict the CPL in 2013. Did you interpolate or extrapolate? e) Use your model to predict when the CPI will be 242. Round your answer to the nearest year Regression problems - do ON excel. 7. Year Number of Collisions (thousands) 1992 4.9 1995 4.6 2000 3.5 2005 3.1 2010 2.1 2014 2.3 a) Draw a scatterplot with correct labels MAKE SURE YOU RECODE THE YEAR TO YEARS SINCE 1992 b) Draw a trendline and write the equation of the line on your graph. Interpret the value of the slope and the y-intercept MAKE SURE YOU INCLUDE APPROPRIATE UNITS for the slope c) Use your model to predict how many collisions occurred in 2012. Did you perform interpolation or extrapolation? d) Use your model to predict when there will be 1.0 thousand collisions. Are you skeptical about this number? What assumption(s) are we making with this prediction e) Find the horizontal intercept. What does it mean in the context of this problem? Are you skeptical about this number? What assumption(s) are we making with this prediction 8. The consumer price index (CPI) is calculated by the US department of Labor. It is a measure of the relative price of a typical market basket of goods in a given year. The percentage increase int eh CPI from one year to the next gives one measure of the annual rate of inflation compared to a base year in this case it is year 1995) Year 2008 2009 2011 2014 2015 2018 CPI 210.2 215.9 225.7 234.5 236.5 238 a) Create a row between Year and CPI and place a label and the data for Years since 2008" b) Draw a scatter diagram with correct labels c) Draw a trendline and write the equation of the line on your graph. Interpret the value of the slope and the y-intercept MAKE SURE YOU INCLUDE APPROPRIATE UNITS for the slope d) Use your model to predict the CPL in 2013. Did you interpolate or extrapolate? e) Use your model to predict when the CPI will be 242. Round your answer to the nearest year
