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.