Download the Excel file provided below to complete this assignment. Perform the seven tasks listed below.
- Copy the traffic stops data tab to a new tab. Rename it to “working data”.
- In the newly created tab, sort the data by month.
- In the newly created tab, move the result of the traffic stop column next to the reason for the traffic stop.
- In the traffic stop reason column, replace the numbers with the short text reason provided in the data description tab.
- For all stops made by an officer with more than 20 years of service, highlight those rows in green shading.
- Create a pivot table to count the results of the traffic stop. What is the proportion for each type of result?
- Filter the data by driver gender. Select Female gender only. Copy these observations to a new tab. Of the female drivers only, what proportion are younger than 20 years old?