Course Project- Classify and Analyze Data

Course Project- Classify and Analyze Data Project description Use the modified spreadsheet that you submitted in Module 03 for this deliverable. Examine the fields in the spreadsheet. Classify, sort, or group the data in a way that the outliers become apparent. An example would be to sort by the total cancellations. Keep all data, but highlight the sales consultants that are outliers. Submit the newly modified spreadsheet. In a 1 page paper, you will analyze the data for trends that span over the course of the entire data set. Identify sales consultants that indicate a progression towards noncompliance. Explain why you have identified them. Florida Turnpike System - Road Ranger Calls Type of Call Year 2013 Year 2014 No Assistance Required 22,091 31,223 Disabled / Stranded Motorist 32,674 32,122 Maintenance of Traffic During Accidents 4,284 2,040 Debris Removal and Abandoned Vehicles 41,837 30,882 How would this data be best presented? Consider different types of charts and graphs that would best depict the data. After creating a visual representation, provide a short summary of the data. Include any percentage of increase or decrease from year to year.