KAT Insurance Corporation: Introductory Financial Accounting Data Analytics Case Requirements First you will need to complete the tutorial which leads you through step by step instructions for analyzing sales records of the tutorial data files. You will use these same steps to complete the requirements of the KAT Insurance project and answer the questions below. Once you have completed your work on the actual project data files you will use your spreadsheet to answer various questions on a Quiz related to the requirements of this assignment. Note there are 2 data files included here; one for the tutorial, and one for the actual project. Make sure you use the correct database for the project. Do not open the Quiz until you are done with the excel data set work and ready to use it to answer questions as you will only get one attempt. You are also required to upload your excel files (including analysis) for grading. For the KAT Insurance Data File complete the following requirements and make note of these items for your Quiz: . There are some typographical errors in the data set in the Region and Insurance Type fields. Find and correct these errors, Rank the states from the highest total insurance sales to lowest total insurance sales. Sort the data by sales, from highest to lowest. Which state had the highest sales? What was the total dollar amount? Which state had the lowest sales? What was the total dollar amount? What is the average amount of insurance sold per state? How many insurance policies were sold in each state? . Do any states not meet the $800,000 minimum sales level? What factors might impact a state's sales level? Sort the state data by average policy amount, from highest to lowest Rank the regions from the highest total insurance sales to lowest total insurance sales. . Which state had the highest average policy amount? . Which state had the lowest average policy amount? How could geographical region impact the average policy amount? Sort the data by sales, from highest to lowest. Create a graph to show total dollar amount of each type of insurance sold, by region. What does this graph show? (Please note your thoughts on this page) Who is the leading salesperson in each region? What is the total dollar amount sold for each type of insurance? Create a map chart that shows total sales for each state. What does this map chart illustrate for you! (Please note your thoughts on this pageWhich region had the lowest sales? What is the total dollar amount? What Factors may contribute to a region having lower sales than others? Which region had the highest sales? What is the total dollar amount? What factors may contribute to a region having higher sales than others? For the KAT Insurance Data File complete the following requirements and make note of these items for your Quiz: There are some typographical errors in the data set in the Region and Insurance Type fields. Find and correct these errors. Rank the states from the highest total insurance sales to lowest total insurance sales. Sort the data by sales, from highest to lowest Which state had the highest sales? What was the total dollar amount? Which state had the lowest sales? What was the total dollar amount? What is the average amount of insurance sold per state? How many insurance policies were sold in each state? Do any states not meet the $800,000 minimum sales level? . What factors might impact a state's sales level? Sort the state data by average policy amount, from highest to lowest. Rank the regions from the highest total insurance sales to lowest total insurance sales. Which state had the highest average policy amount? Which state had the lowest average policy amount? How could geographical region impact the average policy amount? Sort the data by sales, from highest to lowest.Create a graph to show total dollar amount of each type of insurance sold, by region. What does this graph show? (Please note your thoughts on this page) Who is the leading salesperson in each region? What is the total dollar amount sold for each type of insurance? Create a map chart that shows total sales for each state. What does this map chart illustrate for you? (Please note your thoughts on this page)Which region had the lowest sales? What is the total dollar amount? What Factors may contribute to a region having lower sales than others? Which region had the highest sales? What is the total dollar amount? What factors may contribute to a region having higher sales than others? A note on maps - if your version of excel is newer and uses 3D maps instead of the maps mentioned in the tutorial, follow this link to learn how to make a 3D map: 3D Maps You can use these instructions to create a 3D map showing total sales for each state. Please contact your instructor if you have any questions After completion of all the worksheets take some to time to analyze all the worksheets you have created and briefly discuss what you see being presented in the data once it has been formatted. Respond to each of the above questions in your excel workbook under a new tab labeled MY ANALYSIS What outcomes do you believe management of KAT Insurance would find most useful? What outcome(s) differed from what you might have expected? What questions could you ask about the regions populations to gain additional insight on these outcomes? 2.25 points Save Answer QUESTION 1 Which state had the highest sales? (Use the two letter state abbreviation) 2.25 points QUESTION 2 What was the total doilar amount of sales in the state with the highest sales?Enter dollars and cents do not use dollar signs or commas) 2.25 points QUESTION 3 Which state had the lowest sales? (Use the two letter state abbreviation) 2.25 points QUESTION 4 What was the total dollar amount of the state with the lowest sales? Enter dollars and cents do not use dollar signs or commus) 2.25 points QUESTIONS What is the average amount of insurance sold ber statenter dollars and cents do not use dolar sins of commas) QUESTION 6 2.25 points How many states not meet the 5800,000 minimum sales level? 2.25 points sa QUESTION 7 When you sort the state data by average policy amount from highost to lowest, which state had the highest average policy amount (Use the two letter state abbreviation) 2.25 points are QUESTIONS When you sort the state data by average policy amount from highest to lowest which state had the lowest average policy amount Use the two letter state abbreviation) 2.25 points Saver QUESTION 9 to lowest who is When you tank the regions from the highest total insurance sales to lowest total insurance sale and sort the data by sales from high the leading salesperson in the MIDWEST region? (answer is not case sensitive) KAT Insurance Corporation: Introductory Financial Accounting Data Analytics Case Requirements First you will need to complete the tutorial which leads you through step by step instructions for analyzing sales records of the tutorial data files. You will use these same steps to complete the requirements of the KAT Insurance project and answer the questions below. Once you have completed your work on the actual project data files you will use your spreadsheet to answer various questions on a Quiz related to the requirements of this assignment. Note there are 2 data files included here; one for the tutorial, and one for the actual project. Make sure you use the correct database for the project. Do not open the Quiz until you are done with the excel data set work and ready to use it to answer questions as you will only get one attempt. You are also required to upload your excel files (including analysis) for grading. For the KAT Insurance Data File complete the following requirements and make note of these items for your Quiz: . There are some typographical errors in the data set in the Region and Insurance Type fields. Find and correct these errors, Rank the states from the highest total insurance sales to lowest total insurance sales. Sort the data by sales, from highest to lowest. Which state had the highest sales? What was the total dollar amount? Which state had the lowest sales? What was the total dollar amount? What is the average amount of insurance sold per state? How many insurance policies were sold in each state? . Do any states not meet the $800,000 minimum sales level? What factors might impact a state's sales level? Sort the state data by average policy amount, from highest to lowest Rank the regions from the highest total insurance sales to lowest total insurance sales. . Which state had the highest average policy amount? . Which state had the lowest average policy amount? How could geographical region impact the average policy amount? Sort the data by sales, from highest to lowest. Create a graph to show total dollar amount of each type of insurance sold, by region. What does this graph show? (Please note your thoughts on this page) Who is the leading salesperson in each region? What is the total dollar amount sold for each type of insurance? Create a map chart that shows total sales for each state. What does this map chart illustrate for you! (Please note your thoughts on this pageWhich region had the lowest sales? What is the total dollar amount? What Factors may contribute to a region having lower sales than others? Which region had the highest sales? What is the total dollar amount? What factors may contribute to a region having higher sales than others? For the KAT Insurance Data File complete the following requirements and make note of these items for your Quiz: There are some typographical errors in the data set in the Region and Insurance Type fields. Find and correct these errors. Rank the states from the highest total insurance sales to lowest total insurance sales. Sort the data by sales, from highest to lowest Which state had the highest sales? What was the total dollar amount? Which state had the lowest sales? What was the total dollar amount? What is the average amount of insurance sold per state? How many insurance policies were sold in each state? Do any states not meet the $800,000 minimum sales level? . What factors might impact a state's sales level? Sort the state data by average policy amount, from highest to lowest. Rank the regions from the highest total insurance sales to lowest total insurance sales. Which state had the highest average policy amount? Which state had the lowest average policy amount? How could geographical region impact the average policy amount? Sort the data by sales, from highest to lowest.Create a graph to show total dollar amount of each type of insurance sold, by region. What does this graph show? (Please note your thoughts on this page) Who is the leading salesperson in each region? What is the total dollar amount sold for each type of insurance? Create a map chart that shows total sales for each state. What does this map chart illustrate for you? (Please note your thoughts on this page)Which region had the lowest sales? What is the total dollar amount? What Factors may contribute to a region having lower sales than others? Which region had the highest sales? What is the total dollar amount? What factors may contribute to a region having higher sales than others? A note on maps - if your version of excel is newer and uses 3D maps instead of the maps mentioned in the tutorial, follow this link to learn how to make a 3D map: 3D Maps You can use these instructions to create a 3D map showing total sales for each state. Please contact your instructor if you have any questions After completion of all the worksheets take some to time to analyze all the worksheets you have created and briefly discuss what you see being presented in the data once it has been formatted. Respond to each of the above questions in your excel workbook under a new tab labeled MY ANALYSIS What outcomes do you believe management of KAT Insurance would find most useful? What outcome(s) differed from what you might have expected? What questions could you ask about the regions populations to gain additional insight on these outcomes? 2.25 points Save Answer QUESTION 1 Which state had the highest sales? (Use the two letter state abbreviation) 2.25 points QUESTION 2 What was the total doilar amount of sales in the state with the highest sales?Enter dollars and cents do not use dollar signs or commas) 2.25 points QUESTION 3 Which state had the lowest sales? (Use the two letter state abbreviation) 2.25 points QUESTION 4 What was the total dollar amount of the state with the lowest sales? Enter dollars and cents do not use dollar signs or commus) 2.25 points QUESTIONS What is the average amount of insurance sold ber statenter dollars and cents do not use dolar sins of commas) QUESTION 6 2.25 points How many states not meet the 5800,000 minimum sales level? 2.25 points sa QUESTION 7 When you sort the state data by average policy amount from highost to lowest, which state had the highest average policy amount (Use the two letter state abbreviation) 2.25 points are QUESTIONS When you sort the state data by average policy amount from highest to lowest which state had the lowest average policy amount Use the two letter state abbreviation) 2.25 points Saver QUESTION 9 to lowest who is When you tank the regions from the highest total insurance sales to lowest total insurance sale and sort the data by sales from high the leading salesperson in the MIDWEST region? (answer is not case sensitive)