Course Project - Classify and Analyze Data

User Generated

kbknatvr123

Business Finance

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 one page paper, APA formatted with references and citations, 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.

Paper is APA formatted with references and citations

Save your paper as a Microsoft Word document.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Date of Sale
10/1/2014
10/1/2014
10/3/2014
10/3/2014
10/5/2014
10/10/2014
10/11/2014
10/12/2014
10/13/2014
10/14/2014
10/20/2014
10/20/2014
10/20/2014
10/20/2014
10/20/2014
10/20/2014
10/25/2014
10/25/2014
10/25/2014
10/26/2014
10/26/2014
10/28/2014
10/28/2014
10/30/2014
10/30/2014
10/30/2014
10/31/2014

Sales Consultant IDSC Last name
35353356
Rucco
66464667
Wiare
57575758
Frank
75265980
Manuter
83748200
Travas
26354410
Smith
33407197
Heston
40278386
Nova
41107218
Buster
26150025
Jones
26354410
Smith
26354410
Smith
26356778
Dimit
26457518
Hansen
26520168
Vega
26526109
Periter
12658262
Wearever
26161204
Uarlike
26531823
Nayen
33011618
Kite
33255099
York
33233704
Amisher
43207148
Bush
26325752
Regan
26621106
Justin
26621106
Justin
33135393
Williams

Cancelation Ratio

SC First Name State
Adriano F
NY
Carol P.
GA
Benjamin
FL
Victor
NY
Francisco A TX
Debbie
FL
Kelly L
AR
Jeremy S
AR
Jacqueline M MS
Jennifer
NY
Debbie
FL
Debbie
FL
Enrique
FL
Vanessa
NY
William
NY
Eugene
NY
Erick
NY
Yaniri A
NY
Alicia
IL
David N
KY
Alex V
NY
Aisha T
NY
Douglas B
AR
Andres A
NY
Micah Rae
LA
Micah Rae
LA
Clarence P
KY

Office
MANHATTAN
ATLANTA
MIAMI
MANHATTAN
EL PASO
MIAMI
Arkansas
Arkansas
Tri-State
MANHATTAN
MIAMI
MIAMI
MIAMI
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
CHICAGO
LOUISVILLE
MANHATTAN
BRONX
Arkansas
MANHATTAN
NEW ORLEANS
NEW ORLEANS
LOUISVILLE

Region
Territory
Total Contracts
NORTH
DOWNSTATE NEW YORK
10
SOUTH
ATLANTA-NORTH GEORGIA
4
FL/HI
SOUTH FLORIDA
11
NORTH
DOWNSTATE NEW YORK
4
SOUTH
SAN ANTONIO
0
FL/HI
SOUTH FLORIDA
5
SOUTHWESTARKANSAS
0
SOUTHWESTARKANSAS
1
SOUTHWESTMISSISSIPPI
11
NORTH
DOWNSTATE NEW YORK
13
FL/HI
SOUTH FLORIDA
0
FL/HI
SOUTH FLORIDA
7
FL/HI
SOUTH FLORIDA
1
NORTH
DOWNSTATE NEW YORK
9
NORTH
DOWNSTATE NEW YORK
10
NORTH
DOWNSTATE NEW YORK
25
NORTH
DOWNSTATE NEW YORK
9
NORTH
DOWNSTATE NEW YORK
4
NORTH
ILLINOIS
1
SOUTH
KENTUCKY
1
NORTH
DOWNSTATE NEW YORK
16
NORTH
DOWNSTATE NEW YORK
0
SOUTHWESTARKANSAS
3
NORTH
DOWNSTATE NEW YORK
13
SOUTH
LOUISIANA
7
SOUTH
LOUISIANA
10
SOUTH
KENTUCKY
9
184

Total Sales
$30.291,00
$39.999,00
$92.829,00
$44.255,00
$0,00
$20.100,00
$7.881,00
$10.000,00
$83.641,00
$0,00
$0,00
$44.242,00...


Anonymous
This is great! Exactly what I wanted.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags