typographical errors in the data set in the Region and Insurance Type fields

This America Insurance Corporation data set is based on real-life data from a national insurance
company. The data set contains more than 65,000 insurance sales records from 2017. All data and
names have been anonymized to preserve privacy.
Requirements
To follow are the requirements for analyzing sales records in the data set.
1. There are some typographical errors in the data set in the Region and Insurance Type fields. Find
and correct these errors.
2. Rank the states from the highest total insurance sales to lowest total insurance sales. Sort the
data by sales, from highest to lowest.
a. Which state had the highest sales? What was the total dollar amount?
b. Which state had the lowest sales? What was the total dollar amount?
c. What is the average amount of insurance sold per state?
d. How many insurance policies were sold in each state?
e. Do any states not meet the $800,000 minimum sales level?
3. Sort the state data by average policy amount, from highest to lowest.
a. Which state had the highest average policy amount?
b. Which state had the lowest average policy amount?
4. Rank the regions from the highest total insurance sales to lowest total insurance sales. Sort the
data by sales, from highest to lowest.
a. Which region had the highest sales? What is the total dollar amount?
b. Which region had the lowest sales? What is the total dollar amount?
5. Who is the leading salesperson in each region?
6. What is the total dollar amount sold for each type of insurance? Create a graph to show total
dollar amount of each type of insurance sold, by region. What does this graph show?
7. Create a chart that shows total sales for each state. What can you surmise from this chart?
8. Analyze all the information you have gathered or created in the preceding requirements. What
trends or takeaways do you see? Explain.
Please have the answers for all 8 questions in ONE excel worksheet (tab), with supporting work in the
other sheets (tabs). For Q1, just detail what you corrected. After you are completed, write a maximum
two-page report (excluding any graphs or charts) with your findings, including visualizations for as many
questions as possible.