$1.$There are some typographical errors in the data set in the Region and Insurance Type fields. Find and correct these errors by using a pivot table. Hint: Create two pivot tables to answer this question. One for the Region and the other for the Insurance Type. Write a note on the sheet of the errors.

$2.$Analyze insurance sales by state by using a pivot table. Sort the data by$$ sales, from highest to lowest.

$3.$Analyze average insurance sales by state by using a pivot table. Sort the data by$$ average sales, from highest to lowest.

$4.$Analyze insurance sales by region by creating a pivot table. Sort the data by$$ sales, from highest to lowest.

$5.$Analyze insurance sales by salesperson within each region by creating a pivot table.

$6.$Analyze insurance sales by type and region now. Create a pivot table and then a graph to show total dollar amount of each type of insurance$$ sold, by region.

$7.$Analyze all the information you have gathered or created in the preceding requirements.