BE STUDENTS GUIDE -KAT X PROJECT: DATA ANALYX B KATInsurance Data Sprix 1014235-dt-content-rid-4066788_1/courses/ACCT418-01-SPRING-2020/STUDENTS%20GUID.. au student - Spring 2020.docx BIU AA EEEE Requirements Co 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? 5Who is the leading salesperson in each region BE STUDENTS GUIDE -KAT X PROJECT: DATA ANALYX B KATInsurance Data Sprix 1014235-dt-content-rid-4066788_1/courses/ACCT418-01-SPRING-2020/STUDENTS%20GUID.. au student - Spring 2020.docx BIU AA EEEE Requirements Co 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? 5Who is the leading salesperson in each region
