Use Excel to compute the Case Driving and answer questions 20, 21, and 22 under Chapter XIV, section 11. The plot/table from Excel must be included to support your answers. You must include computed results, such as plot(s)/tables of your exercise

20. (D#5) What is the correlation between age and how often the person chooses to drive in inclement weather? Is this correlation statistically significant at the .01 level? Are older people more or less likely to report that they drive in inclement weather? (relevant section, relevant section ) 21. (D#8) What is the correlation between how often a person chooses to drive in inclement weather and the percentage of accidents the person believes occur in inclement weather? Is this correlation significantly different from 0? (relevant section, relevant section )

22. (D#10) Use linear regression to predict how often someone rides public transportation in inclement weather from what percentage of accidents that person thinks occur in inclement weather. (Pubtran by Accident)

(a) Create a scatter plot of this data and add a regression line. (b) What is the slope? (c) What is the intercept? (d) Is the relationship at least approximately linear? (e) Test if the slope is significantly different from 0. (f) Comment on possible assumption violations for the test of the slope. (g) What is the standard error of the estimate? (relevant section, relevant section, relevant section)