module 04 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.

Submit your completed assignments to the drop box below. Please check the Course Calendar for specific due dates.

Save your paper as a Microsoft Word document. (Mac users, please remember to append the “.docx” extension to the filename.) Save your spreadsheet as a Microsoft Excel (.xls). The name of the files should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:

Jstudent_exampleproblem_101504

Attach is my previous data/ spread that I modified from Module 3. Please refer this spreadsheet for my Module 04 homework! Thanks a lot!