Use Excel to compute the Case $$Driving$$ and answer questions $20,21,$ and $22$

the following questions are from the Driving $($D$)$ case study.

$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 $\mathrm{.}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$)$