Using VehicleFailureData, summarize the data for failures in top 10 (maximum number

of vehicle failures) states by constructing the following:

a) Relative and percent frequency distributions

b) Bar chart

c) Pie chart

d) Find top three states with maximum number of vehicles failures.

Note: First insert a Pivot Table, then drag and drop State under Row and Value fields. Then

select Data Tab and arrange Total (second column, which represents the total number of

vehicle failures) in descending order (largest to smallest). Now select the top 10 states.