Open the "Prep 2.2" Excel file. Data for the two parts can be found on different sheets. Use Excel for computation and charts. Next, using Word, answer the questions for each part, and copy and paste your charts below your written answers.Upload only the Word document to Canvas.

1. Open "transportation" sheet in "Prep 2.2" Excel file.

The city's Department of Transportation has been keeping track of accidents on a particularly dangerous stretch of highway. Early in this year, the city lowered the speed limit on this highway and increased police patrols. Data on number of accidents before and after the changes are presented in the Excel sheet.

• Did the change work? Is the highway safer?
• Construct a line chart (using Excel) to display these two sets of data.
• Copy and paste the chart from Excel into Word, and write a paragraph (150 words) describing the changes.

1. Open "gun control" sheet in "Prep 2.2" Excel file. (2 points)

• Construct a frequency distribution for each variable. Include a column for percentages.
• Construct pie and bar charts in Excel to display the distributions of sex, support for gun control, and level of education.
• In a Word document, write a paragraph (150 words) describing the data, and copy and paste the table and chart from Excel into Word (below your responses).

Support of Gun Level of Case number Sex Control Education Age Sex 1= Male 2= Female Support of Gun Control 1= In favor 2= Opposed HHOADHOPOWNWAH Level of Education 0= Less than HS 1= HS 2= Jr. college 3= Bachelor's 4= Graduate 14 15