Course Project- Classify and Analyze Data
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
No Assistance Required
Disabled / Stranded Motorist
Maintenance of Traffic During Accidents
Debris Removal and Abandoned Vehicles
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.