Using your files from the Power BI tutorial on KAT Insurance, answer the following questions: 2 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 in NC? TX? d How many insurance policies were sold in NC? TX? e Do any states not meet the $800,000 minimum sales level? (Y/N)? Which one(s)? 3 a Which state had the highest average policy amount? b Which state had the lowest average policy amount? 4 Which region had the highest sales? What is the total dollar amount? 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 (in millions)? HINT: change your graph to get the total Create a graph to show total dollar amount of each type of insurance sold, by region. What does this graph show? NJ $1,146,182.72 MA $697.75 $801,545.86 $695.41 1297 1247 No NJ CT Northeast New England $9,770,475.20 $5,075,358.05 Midwest, Dave; New England, Sara; North Central, Mario; Northeast, Matt; Southeast, Jennifer; West, Peter Region Auto Disability Home Life Professional Northeast Southeast 1.97M 1.46M | 1.84M 0.86M 3.65M 1.57M 1.19M 1.54M 0.60M 3.32M Midwest 1.62M 1.14M 1.54M 0.62M 3.27M North Central 1.43M 0.99M 1.39M 0.55M 2.92M West 1.46M 1.08M 1.43M 0.54M 2,84M New England 1.02M 0.70M 0.96M 0.33M 2.07M 7 Analyze all the information you have gathered or created in the preceding requirements. What trends or takeaways do you see? Explain.