need help understanding this project

X ACCT 221 - Data Analytics Case Fina... "0 The demand for college graduates with data analytics skills has exploded, whilethe tools and techniques \\ evolve and change at a rapid pace. This case illustrates how data analytics can be 1 of 2 Excel. As you analyze this case, you will be learning how to drill-down into a company's a deeper understanding ofthe company's sales and how this information can be used ..,. \"WM. .....xing. Background This KAT 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. This is an individual assignment. No two excel les should look the same. Requirements All of these steps must be done in Excel. 75 Points To follow are the requirements for analyzing sales records in the data set. All of the answers to the following questions should be shown in Excel. Be as creative as you like. However, your answers should be clearly labeled, and it should be easy to identify. No manual calculations are allowed. if you need help, log on to Lyndia.com for assistance with Excel. 1. There are some typographical errors in the data set in the Region and Insurance Type elds. 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. Which state had the highest sales? What was the total dolEar amount? Which state had the lowest sales? What was the totai dollar amount? What is the average amount of insurance sold per state? How many insurance policies were sold in each state? e. Do any states fail to 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? in. 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? in. 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 map chart that shows total sales for each state. What can you surmise from this map chart? 9199'!\" 03.20.20 Overview Surveys of managers consistently show that they consider the lack ofadequate communications skills to be the greatest deficiency of the graduates they hire. Analytical, critical thinking and communication skills are among the most essential professional skills necessary for professional success. After analyzing the data in the case, you will learn how to communicate your findings. This is an individual assignment. No two PowerPoint presentations should look the same. Requirements All of these steps must be done in PowerPoint 75% Prepare a 10to 15-minute PowerPoint presentation that analyzes all the information you have gathered or created in the preceding requirements (The Excel File). At a minimum, you should discuss all of the questions on the previous page and explain how you got the answers to the questions. Please also explain the trends or takeaways that you see based on your Excel Analysis. You may be as creative as you like. However, at a minimum, each slide must contain audio. I'd prefer that the slides have audio and video. The slides should automatically transition to the next slide. Hint: You should create a PowerPoint document that reports yourfindings first. Afterthe document is created, you should add audio and video to the presentation. Please see the following link for assistance: htt s: su ort.office.com en-us article video-record- resentations-2570df'f5-f81c-40bc- b404