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.

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.

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.