1. Consider a study on the number of accidents occurred in 10states of the United States of America in different cities for 3consecutive years. Create a PivotTable in Excel to answer thefollowing questions. The PivotTable should group the number ofaccidents into yearly bins and display the sum of accidentsoccurred each year in columns of Excel. Row labels should includethe accident locations and allow for grouping the locations intostates or viewing by city. You should also sort the PivotTable sothat the states with the greatest number of accidents between 2011and 2013 appear at the top of the PivotTable.

State	City	Number of accidents	Year
GA	Rock Spring	52	2011
GA	Doraville	44	2011
GA	Ellaville	67	2011
FL	Jacksonville	53	2011
GA	Stockbridge	72	2011
FL	Belleview	63	2012
AZ	Phoenix	69	2011
FL	Crestview	51	2012
IA	Johnston	48	2012
GA	Rockmart	44	2012
CO	Greenwood Village	53	2011
GA	Jonesboro	54	2011
GA	Decatur	76	2013
FL	Clearwater	76	2013
GA	Gray	57	2012
CA	Nevada City	76	2013
FL	Milton	61	2011
GA	Woodstock	78	2013
GA	Cumming	70	2012
GA	Statesboro	47	2013
FL	Palm Beach	42	2011
CO	Greeley	60	2012
FL	Sarasota	40	2011
FL	Apollo Beach	75	2011
AZ	Prescott	40	2012
FL	Port St. Lucie	61	2012
GA	Stockbridge	78	2012
GA	Atlanta	60	2011
CO	Windsor	43	2013
CO	Castle Rock	55	2011
GA	Clayton	58	2011 ....

                                                            

1. Which state had the greatest number of accidents between 2011and 2013?
2. How many accidents occurred in the state of Colorado (CO) in2012? In what cities did these accidents occur?
3. Use the PivotTable’s filter capability to view only theaccidents in Alabama (AL), Arizona (AZ), and Arkansas (AR) for theyears 2011 through 2013. What is the total number of accidents inthese states between 2011 and 2013?
4. Create a PivotChart to display a column chart that shows thetotal number of accidents in each year 2011 through 2013 in thestate of California. Adjust the formatting of this column chart sothat it best conveys the data. What does this column chart suggestabout accidents between 2011 and 2013 in California? Discuss.

Hint: You may have to switch the rowand column labels in the PivotChart to get the best presentationfor your PivotChart.

1. Hire-a-Car System rents three types of cars at two differentlocations. The profit made per day for each car type and company atthe two locations is listed below: