Create a PivotTable to show the 10 states that have the highest percent of fatal collisions involving distracted driving. Place the PivotTable on the DistractedDriving worksheet. Use a calculated fiel…
Create a PivotTable to show the 10 states that have the highest percent of fatal collisions involving distracted driving. Place the PivotTable on the DistractedDriving worksheet. Use a calculated field name “DistractedDriving” (without the quotes) to determine the worst states (Hint: calculate by subtracting from 100). Show the 10 states with the highest percentage for fatal collisions involving distracted driving. Sort the PivotTable values from largest to smallest.
OR