The file FDICBankFailures contains data on failures of federally insured banks between $2000$ and $2012.$ Create a PivotTable in Excel to answer the following questions. The PivotTable should group the closing dates of the banks into yearly bins and display the counts of bank closures each year in columns of Excel. Row labels should include the bank locations and allow for grouping the locations into states or viewing by city. You should also sort the PivotTable so that the states with the greatest number of total bank failures between $2000$ and $2012$ appear at the top of the PivotTable.