Rasmussen College Sales Consultant Data Analysis Project

User Generated

Qhpxvr19

Business Finance

Rasmussen University

Description

The first of objective of this week's deliverable is to provide Robert M. Lopez with a business report presentation of your findings.

Use the modified spreadsheet that you submitted in Module 04 for this deliverable.
Your report should visually identify:

  • Outliers
  • Sales consultants trending towards noncompliance

Using the Excel spreadsheet as input, create a visual representation of the data. Use the visual representation of the data in a 2-3 slide PowerPoint of your findings.

The second objective of this week's deliverable is to provide Robert M. Lopez with an executive summary of your findings.

In a 2-3 page paper, APA formatted with references and citations, summarize your findings. Give proof for your analysis. Within your paper, explain the process you did to come up with the findings. Based on the findings, provide business recommendations to Mr. Lopez.

Unformatted Attachment Preview

Date of Sale Sales Consultant ID 10/1/2014 35353356 10/1/2014 66464667 10/3/2014 57575758 10/3/2014 75265980 10/5/2014 83748200 10/10/2014 26354410 10/11/2014 33407197 10/12/2014 40278386 10/13/2014 41107218 10/14/2014 26150025 10/20/2014 26354410 10/20/2014 26354410 10/20/2014 26356778 10/20/2014 26457518 10/20/2014 26520168 10/20/2014 26526109 10/25/2014 12658262 10/25/2014 26161204 10/25/2014 26531823 10/26/2014 33011618 10/26/2014 33255099 10/28/2014 33233704 10/28/2014 43207148 10/30/2014 26325752 10/30/2014 26621106 10/30/2014 26621106 10/31/2014 33135393 SC Last name Rucco Wiare Frank Manuter Travas Smith Heston Nova Buster Jones Smith Smith Dimit Hansen Vega Periter Wearever Uarlike Nayen Kite York Amisher Bush Regan Justin Justin Williams SC First Name Adriano F Carol P. Benjamin Victor Francisco A Debbie Kelly L Jeremy S Jacqueline M Jennifer Debbie Debbie Enrique Vanessa William Eugene Erick Yaniri A Alicia David N Alex V Aisha T Douglas B Andres A Micah Rae Micah Rae Clarence P State NY GA FL NY TX FL AR AR MS NY FL FL FL NY NY NY NY NY IL KY NY NY AR NY LA LA 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 NORTH SOUTH FL/HI NORTH SOUTH FL/HI SOUTHWEST SOUTHWEST SOUTHWEST NORTH FL/HI FL/HI FL/HI NORTH NORTH NORTH NORTH NORTH NORTH SOUTH NORTH NORTH SOUTHWEST NORTH SOUTH SOUTH SOUTH Territory Total Contracts DOWNSTATE NEW YORK ATLANTA-NORTH GEORGIA SOUTH FLORIDA DOWNSTATE NEW YORK SAN ANTONIO SOUTH FLORIDA ARKANSAS ARKANSAS MISSISSIPPI DOWNSTATE NEW YORK SOUTH FLORIDA SOUTH FLORIDA SOUTH FLORIDA DOWNSTATE NEW YORK DOWNSTATE NEW YORK DOWNSTATE NEW YORK DOWNSTATE NEW YORK DOWNSTATE NEW YORK ILLINOIS KENTUCKY DOWNSTATE NEW YORK DOWNSTATE NEW YORK ARKANSAS DOWNSTATE NEW YORK LOUISIANA LOUISIANA KENTUCKY 10 4 11 4 0 5 0 1 11 13 0 7 1 9 10 25 9 4 1 1 16 0 3 13 7 10 9 Total Sales Total Cancellations $30,291.00 1 $39,999.00 0 $92,829.00 1 $44,255.00 2 $0.00 0 $20,100.00 1 $7,881.00 0 $10,000.00 0 $83,641.00 5 $0.00 13 $0.00 0 $44,242.00 0 $555.00 0 $80,000.00 0 $45,000.00 0 $54,535.00 0 $24,222.00 0 $14,344.00 0 $6,566.00 0 $250.00 0 $50,000.00 1 $321.00 0 $600.00 0 $72,990.00 0 $35,000.00 0 $87,382.00 1 $21,222.00 0 Date of Sale Sales Consultant IDSC Last nameSC First Name State 11/1/2014 26354410 Smith Debbie FL 11/2/2014 33407197 Heston Kelly L AR 11/2/2014 40278386 Nova Jeremy S AR 11/2/2014 41107218 Buster Jacqueline MMS 11/3/2014 33011618 Kite David N KY 11/4/2014 33255099 York Alex V NY 11/5/2014 66464667 Wiare Carol P. GA 11/5/2014 35353356 Rucco Adriano F NY 11/5/2014 26520168 Vega William NY 11/5/2014 26152889 Smith Debbie FL 11/6/2014 26356778 Dimit Enrique FL 11/7/2014 26354410 Smith Debbie FL 11/8/2014 26531823 Nayen Alicia IL 11/10/2014 33233704 Amisher Aisha T NY 11/10/2014 43207148 Bush Douglas B AR 11/11/2014 26526109 Periter Eugene NY 11/12/2014 26457518 Hansen Vanessa NY 11/13/2014 12658262 Wearever Erick NY 11/15/2014 75265980 Manuter Victor NY 11/16/2014 57575758 Frank Benjamin FL 11/17/2014 26161204 Uarlike Yaniri A NY 11/23/2014 83748200 Travas Francisco A TX 11/27/2014 26621106 Justin Micah Rae LA 11/29/2014 26150025 Jones Jennifer NY 11/29/2014 33135393 Williams Clarence P KY 11/30/2014 26325752 Regan Andres A NY 11/30/2014 26621106 Justin Micah Rae LA Office Region Territory MIAMI FL/HI SOUTH FLORIDA Arkansas SOUTHWESTARKANSAS Arkansas SOUTHWESTARKANSAS Tri-State SOUTHWESTMISSISSIPPI LOUISVILLE SOUTH KENTUCKY MANHATTANNORTH DOWNSTATE NEW YORK ATLANTA SOUTH ATLANTA-NORTH GEORGIA MANHATTANNORTH DOWNSTATE NEW YORK MANHATTANNORTH DOWNSTATE NEW YORK MIAMI FL/HI SOUTH FLORIDA MIAMI FL/HI SOUTH FLORIDA MIAMI FL/HI SOUTH FLORIDA CHICAGO NORTH ILLINOIS BRONX NORTH DOWNSTATE NEW YORK Arkansas SOUTHWESTARKANSAS MANHATTANNORTH DOWNSTATE NEW YORK MANHATTANNORTH DOWNSTATE NEW YORK MANHATTANNORTH DOWNSTATE NEW YORK MANHATTANNORTH DOWNSTATE NEW YORK MIAMI FL/HI SOUTH FLORIDA MANHATTANNORTH DOWNSTATE NEW YORK EL PASO SOUTH SAN ANTONIO NEW ORLEANS SOUTH LOUISIANA MANHATTANNORTH DOWNSTATE NEW YORK LOUISVILLE SOUTH KENTUCKY MANHATTANNORTH DOWNSTATE NEW YORK NEW ORLEANS SOUTH LOUISIANA Total Contracts Total Sales 5 0 1 4 1 9 1 3 2 14 1 7 1 0 3 16 2 2 4 11 4 0 10 5 7 5 2 Total Cancellations $20,100.00 $0.00 $10,000.00 $4,000.00 $900.00 $30,000.00 $550.00 $10,300.00 $5,000.00 $1,000.00 $5,000.00 $500.00 $3,000.00 $0.00 $0.00 $20,000.00 $1,010.00 $211.00 $20,100.00 $500.00 $10,000.00 $0.00 $87,382.00 $0.00 $20,000.00 $20,000.00 $1,000.00 1 0 0 0 0 1 0 0 0 13 0 0 0 0 0 0 0 0 1 10 0 0 1 5 0 0 0 Date of Sale Sales Consultant IDSC Last name 12/1/2014 26354410 Smith 12/1/2014 40278386 Nova 12/1/2014 26621106 Justin 12/2/2014 66464667 Wiare 12/3/2014 41107218 Buster 12/3/2014 26354410 Smith 12/4/2014 57575758 Frank 12/5/2014 26621106 Justin 12/6/2014 83748200 Travas 12/6/2014 26150025 Jones 12/7/2014 26152889 Smith 12/8/2014 26621106 Justin 12/9/2014 26526109 Periter 12/9/2014 26161204 Uarlike 12/10/2014 33255099 York 12/11/2014 26520168 Vega 12/12/2014 35353356 Rucco 12/13/2014 26457518 Hansen 12/14/2014 75265980 Manuter 12/15/2014 33407197 Heston 12/19/2014 33011618 Kite 12/20/2014 26325752 Regan 12/21/2014 26356778 Dimit 12/22/2014 33135393 Williams 12/23/2014 33233704 Amisher 12/24/2014 26621106 Justin 12/30/2014 12658262 Wearever SC First Name Debbie Jeremy S Micah Rae Carol P. Jacqueline M Debbie Benjamin Micah Rae Francisco A Jennifer Debbie Micah Rae Eugene Yaniri A Alex V William Adriano F Vanessa Victor Kelly L David N Andres A Enrique Clarence P Aisha T Micah Rae Erick State FL AR LA GA MS FL FL LA TX NY FL LA NY NY NY NY NY NY NY AR KY NY FL KY NY LA NY Office MIAMI Arkansas NEW ORLEANS ATLANTA Tri-State MIAMI MIAMI NEW ORLEANS EL PASO MANHATTAN MIAMI NEW ORLEANS MANHATTAN MANHATTAN MANHATTAN MANHATTAN MANHATTAN MANHATTAN MANHATTAN Arkansas LOUISVILLE MANHATTAN MIAMI LOUISVILLE BRONX NEW ORLEANS MANHATTAN Region FL/HI SOUTHWEST SOUTH SOUTH SOUTHWEST FL/HI FL/HI SOUTH SOUTH NORTH FL/HI SOUTH NORTH NORTH NORTH NORTH NORTH NORTH NORTH SOUTHWEST SOUTH NORTH FL/HI SOUTH NORTH SOUTH NORTH Territory Total Contracts Total Sales Total Cancellations SOUTH FLORIDA 0 $0.00 0 ARKANSAS 5 $10,000.00 3 LOUISIANA 10 $0.00 10 ATLANTA-NORTH GEORGIA 9 $7,000.00 3 MISSISSIPPI 3 $4,000.00 0 SOUTH FLORIDA 1 $500.00 0 SOUTH FLORIDA 9 $2,000.00 5 LOUISIANA 1 $1,000.00 0 SAN ANTONIO 0 $0.00 0 DOWNSTATE NEW YORK 18 $7,000.00 5 SOUTH FLORIDA 14 $1,000.00 13 LOUISIANA 11 $0.00 11 DOWNSTATE NEW YORK 16 $20,000.00 0 DOWNSTATE NEW YORK 4 $10,000.00 0 DOWNSTATE NEW YORK 9 $30,000.00 1 DOWNSTATE NEW YORK 0 $5,000.00 0 DOWNSTATE NEW YORK 3 $10,300.00 0 DOWNSTATE NEW YORK 18 $7,000.00 10 DOWNSTATE NEW YORK 16 $20,000.00 0 ARKANSAS 0 $0.00 0 KENTUCKY 2 $900.00 0 DOWNSTATE NEW YORK 16 $20,000.00 0 SOUTH FLORIDA 1 $5,000.00 0 KENTUCKY 7 $20,000.00 0 DOWNSTATE NEW YORK 1 $0.00 0 LOUISIANA 2 $0.00 2 DOWNSTATE NEW YORK 16 $20,000.00 0 Deleted Columns 1. Sales system number. 2. Extract date. 3. Tax Type. The columns will be deleted because analaysis on to be made on sales consultants will be done without using the results.These fields will not be relevant when consultants information is not considered. Remaining Columns The remaining columns are related directly with the consultants in one way or another.These fields are important data in terms of regions,consultant name,date of sale,total contratcs ,sales or even cancellations made.These data sales consultants to maintain and others to do away with in regards to profitability of the business. e done without using them and without affecting the final output hese fields are important as they can be used in pivot tables in analysing lations made.These data will be utilized in making decisions on which business. Date of Sale Sales Consultant ID 10/1/2014 35353356 10/1/2014 66464667 10/3/2014 57575758 10/3/2014 75265980 10/5/2014 83748200 10/10/2014 26354410 10/11/2014 33407197 10/12/2014 40278386 10/13/2014 41107218 10/14/2014 26150025 10/20/2014 26354410 10/20/2014 26354410 10/20/2014 26356778 10/20/2014 26457518 10/20/2014 26520168 10/20/2014 26526109 10/25/2014 12658262 10/25/2014 26161204 10/25/2014 26531823 10/26/2014 33011618 10/26/2014 33255099 10/28/2014 33233704 10/28/2014 43207148 10/30/2014 26325752 10/30/2014 26621106 10/30/2014 26621106 10/31/2014 33135393 SC Last name Rucco Wiare Frank Manuter Travas Smith Heston Nova Buster Jones Smith Smith Dimit Hansen Vega Periter Wearever Uarlike Nayen Kite York Amisher Bush Regan Justin Justin Williams SC First Name Adriano F Carol P. Benjamin Victor Francisco A Debbie Kelly L Jeremy S Jacqueline M Jennifer Debbie Debbie Enrique Vanessa William Eugene Erick Yaniri A Alicia David N Alex V Aisha T Douglas B Andres A Micah Rae Micah Rae Clarence P State NY GA FL NY TX FL AR AR MS NY FL FL FL NY NY NY NY NY IL KY NY NY AR NY LA LA 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 NORTH SOUTH FL/HI NORTH SOUTH FL/HI SOUTHWEST SOUTHWEST SOUTHWEST NORTH FL/HI FL/HI FL/HI NORTH NORTH NORTH NORTH NORTH NORTH SOUTH NORTH NORTH SOUTHWEST NORTH SOUTH SOUTH SOUTH Territory Total Contracts DOWNSTATE NEW YORK ATLANTA-NORTH GEORGIA SOUTH FLORIDA DOWNSTATE NEW YORK SAN ANTONIO SOUTH FLORIDA ARKANSAS ARKANSAS MISSISSIPPI DOWNSTATE NEW YORK SOUTH FLORIDA SOUTH FLORIDA SOUTH FLORIDA DOWNSTATE NEW YORK DOWNSTATE NEW YORK DOWNSTATE NEW YORK DOWNSTATE NEW YORK DOWNSTATE NEW YORK ILLINOIS KENTUCKY DOWNSTATE NEW YORK DOWNSTATE NEW YORK ARKANSAS DOWNSTATE NEW YORK LOUISIANA LOUISIANA KENTUCKY 10 4 11 4 0 5 0 1 11 13 0 7 1 9 10 25 9 4 1 1 16 0 3 13 7 10 9 Total Sales Total Cancellations $30,291.00 1 $39,999.00 0 $92,829.00 1 $44,255.00 2 $0.00 0 $20,100.00 1 $7,881.00 0 $10,000.00 0 $83,641.00 5 $0.00 13 $0.00 0 $44,242.00 0 $555.00 0 $80,000.00 0 $45,000.00 0 $54,535.00 0 $24,222.00 0 $14,344.00 0 $6,566.00 0 $250.00 0 $50,000.00 1 $321.00 0 $600.00 0 $72,990.00 0 $35,000.00 0 $87,382.00 1 $21,222.00 0 Date of Sale Sales Consultant IDSC Last nameSC First Name State 11/1/2014 26354410 Smith Debbie FL 11/2/2014 33407197 Heston Kelly L AR 11/2/2014 40278386 Nova Jeremy S AR 11/2/2014 41107218 Buster Jacqueline MMS 11/3/2014 33011618 Kite David N KY 11/4/2014 33255099 York Alex V NY 11/5/2014 66464667 Wiare Carol P. GA 11/5/2014 35353356 Rucco Adriano F NY 11/5/2014 26520168 Vega William NY 11/5/2014 26152889 Smith Debbie FL 11/6/2014 26356778 Dimit Enrique FL 11/7/2014 26354410 Smith Debbie FL 11/8/2014 26531823 Nayen Alicia IL 11/10/2014 33233704 Amisher Aisha T NY 11/10/2014 43207148 Bush Douglas B AR 11/11/2014 26526109 Periter Eugene NY 11/12/2014 26457518 Hansen Vanessa NY 11/13/2014 12658262 Wearever Erick NY 11/15/2014 75265980 Manuter Victor NY 11/16/2014 57575758 Frank Benjamin FL 11/17/2014 26161204 Uarlike Yaniri A NY 11/23/2014 83748200 Travas Francisco A TX 11/27/2014 26621106 Justin Micah Rae LA 11/29/2014 26150025 Jones Jennifer NY 11/29/2014 33135393 Williams Clarence P KY 11/30/2014 26325752 Regan Andres A NY 11/30/2014 26621106 Justin Micah Rae LA Office Region Territory MIAMI FL/HI SOUTH FLORIDA Arkansas SOUTHWESTARKANSAS Arkansas SOUTHWESTARKANSAS Tri-State SOUTHWESTMISSISSIPPI LOUISVILLE SOUTH KENTUCKY MANHATTANNORTH DOWNSTATE NEW YORK ATLANTA SOUTH ATLANTA-NORTH GEORGIA MANHATTANNORTH DOWNSTATE NEW YORK MANHATTANNORTH DOWNSTATE NEW YORK MIAMI FL/HI SOUTH FLORIDA MIAMI FL/HI SOUTH FLORIDA MIAMI FL/HI SOUTH FLORIDA CHICAGO NORTH ILLINOIS BRONX NORTH DOWNSTATE NEW YORK Arkansas SOUTHWESTARKANSAS MANHATTANNORTH DOWNSTATE NEW YORK MANHATTANNORTH DOWNSTATE NEW YORK MANHATTANNORTH DOWNSTATE NEW YORK MANHATTANNORTH DOWNSTATE NEW YORK MIAMI FL/HI SOUTH FLORIDA MANHATTANNORTH DOWNSTATE NEW YORK EL PASO SOUTH SAN ANTONIO NEW ORLEANS SOUTH LOUISIANA MANHATTANNORTH DOWNSTATE NEW YORK LOUISVILLE SOUTH KENTUCKY MANHATTANNORTH DOWNSTATE NEW YORK NEW ORLEANS SOUTH LOUISIANA Total Contracts Total Sales 5 0 1 4 1 9 1 3 2 14 1 7 1 0 3 16 2 2 4 11 4 0 10 5 7 5 2 Total Cancellations $20,100.00 $0.00 $10,000.00 $4,000.00 $900.00 $30,000.00 $550.00 $10,300.00 $5,000.00 $1,000.00 $5,000.00 $500.00 $3,000.00 $0.00 $0.00 $20,000.00 $1,010.00 $211.00 $20,100.00 $500.00 $10,000.00 $0.00 $87,382.00 $0.00 $20,000.00 $20,000.00 $1,000.00 1 0 0 0 0 1 0 0 0 13 0 0 0 0 0 0 0 0 1 10 0 0 1 5 0 0 0 Date of Sale Sales Consultant IDSC Last name 12/1/2014 26354410 Smith 12/1/2014 40278386 Nova 12/1/2014 26621106 Justin 12/2/2014 66464667 Wiare 12/3/2014 41107218 Buster 12/3/2014 26354410 Smith 12/4/2014 57575758 Frank 12/5/2014 26621106 Justin 12/6/2014 83748200 Travas 12/6/2014 26150025 Jones 12/7/2014 26152889 Smith 12/8/2014 26621106 Justin 12/9/2014 26526109 Periter 12/9/2014 26161204 Uarlike 12/10/2014 33255099 York 12/11/2014 26520168 Vega 12/12/2014 35353356 Rucco 12/13/2014 26457518 Hansen 12/14/2014 75265980 Manuter 12/15/2014 33407197 Heston 12/19/2014 33011618 Kite 12/20/2014 26325752 Regan 12/21/2014 26356778 Dimit 12/22/2014 33135393 Williams 12/23/2014 33233704 Amisher 12/24/2014 26621106 Justin 12/30/2014 12658262 Wearever SC First Name Debbie Jeremy S Micah Rae Carol P. Jacqueline M Debbie Benjamin Micah Rae Francisco A Jennifer Debbie Micah Rae Eugene Yaniri A Alex V William Adriano F Vanessa Victor Kelly L David N Andres A Enrique Clarence P Aisha T Micah Rae Erick State FL AR LA GA MS FL FL LA TX NY FL LA NY NY NY NY NY NY NY AR KY NY FL KY NY LA NY Office MIAMI Arkansas NEW ORLEANS ATLANTA Tri-State MIAMI MIAMI NEW ORLEANS EL PASO MANHATTAN MIAMI NEW ORLEANS MANHATTAN MANHATTAN MANHATTAN MANHATTAN MANHATTAN MANHATTAN MANHATTAN Arkansas LOUISVILLE MANHATTAN MIAMI LOUISVILLE BRONX NEW ORLEANS MANHATTAN Region FL/HI SOUTHWEST SOUTH SOUTH SOUTHWEST FL/HI FL/HI SOUTH SOUTH NORTH FL/HI SOUTH NORTH NORTH NORTH NORTH NORTH NORTH NORTH SOUTHWEST SOUTH NORTH FL/HI SOUTH NORTH SOUTH NORTH Territory Total Contracts Total Sales Total Cancellations SOUTH FLORIDA 0 $0.00 0 ARKANSAS 5 $10,000.00 3 LOUISIANA 10 $0.00 10 ATLANTA-NORTH GEORGIA 9 $7,000.00 3 MISSISSIPPI 3 $4,000.00 0 SOUTH FLORIDA 1 $500.00 0 SOUTH FLORIDA 9 $2,000.00 5 LOUISIANA 1 $1,000.00 0 SAN ANTONIO 0 $0.00 0 DOWNSTATE NEW YORK 18 $7,000.00 5 SOUTH FLORIDA 14 $1,000.00 13 LOUISIANA 11 $0.00 11 DOWNSTATE NEW YORK 16 $20,000.00 0 DOWNSTATE NEW YORK 4 $10,000.00 0 DOWNSTATE NEW YORK 9 $30,000.00 1 DOWNSTATE NEW YORK 0 $5,000.00 0 DOWNSTATE NEW YORK 3 $10,300.00 0 DOWNSTATE NEW YORK 18 $7,000.00 10 DOWNSTATE NEW YORK 16 $20,000.00 0 ARKANSAS 0 $0.00 0 KENTUCKY 2 $900.00 0 DOWNSTATE NEW YORK 16 $20,000.00 0 SOUTH FLORIDA 1 $5,000.00 0 KENTUCKY 7 $20,000.00 0 DOWNSTATE NEW YORK 1 $0.00 0 LOUISIANA 2 $0.00 2 DOWNSTATE NEW YORK 16 $20,000.00 0 Deleted Columns 1. Sales system number. 2. Extract date. 3. Tax Type. The columns will be deleted because analaysis on to be made on sales consultants will be done without using the results.These fields will not be relevant when consultants information is not considered. Remaining Columns The remaining columns are related directly with the consultants in one way or another.These fields are important data in terms of regions,consultant name,date of sale,total contratcs ,sales or even cancellations made.These data sales consultants to maintain and others to do away with in regards to profitability of the business. e done without using them and without affecting the final output hese fields are important as they can be used in pivot tables in analysing lations made.These data will be utilized in making decisions on which business. Running head: SALES CONSULTANTS’ DATA ANALYSIS 1 Sales Consultants’ Data Analysis Desmond Fulton Rasmussen College Author Note This paper is being submitted on December 1 ,2019 for Sarah Dixon Introduction to Business Analysis and Intelligence SALES CONSULTANTS’ DATA ANALYSIS 2 Sales Consultants’ Data Analysis The collected information during the whole period signified the following impressions: There was a general decrease in the total sales made by the sales consultants. In October the personnel achieved their highest sales which then gradually reduced in November and further went down in December. The total number of cancellations shifted upwards irregularly. In October, the total writeoffs totaled to 25; in November, the number rose to 32, and by December, it was 63. However, the maximum number of cancellations a single consultant recorded in a month at 13. Out of the three months, FL/HI region had the highest number of cancellations twice i.e., in November and December. The highest number of contracts always came from the North region. The sales consultant who still managed this was Periter Eugene. At least three or more Sales consultants failed to make any sales for a month. In October, they were three, five in November and seven in December. The total number kept rising with time. Travis Francisco A from San Antonio, Heston Kelly L from Arkansas, and Amisher Aisha T from Downstate were consultants who showed a lack of emphasis on compliance (Gebelein, 1989). As consultants, their duty is to champion the products and services of the company by corresponding them to consumers’ wants (Homburg and Giering, 2001). They are charged with the responsibility of ensuring the company remains sustainable and competitive in the market (Furnham and Fudge, 2008). The three of them failed to achieve any sales for at least SALES CONSULTANTS’ DATA ANALYSIS two consecutive months. They exhibited poor skills in attaining goals and creating new opportunities. References Furnham, A., & Fudge, C. (2008). The five-factor model of personality and sales performance. Journal of Individual Differences, 29(1), 11-16. Gebelein, S. H. (1989). Profile of an internal consultant: roles and skills for building client confidence. Training & Development Journal, 43(3), 52-59. Homburg, C., & Giering, A. (2001). Personal characteristics as moderators of the relationship between customer satisfaction and loyalty—an empirical analysis. Psychology & Marketing, 18(1), 43-66. 3
Purchase answer to see full attachment
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

Hi, please check the files. In case of any adjustments or concerns, kindly let me know.Thank you!

Running head: SALES CONSULTANTS’ DATA ANALYSIS
1

Sales Consultants’ Data Analysis
Desmond Fulton
Rasmussen College
Author Note
This paper is being submitted on December 1 ,2019 for Sarah Dixon Introduction to Business
Analysis and Intelligence

SALES CONSULTANTS’ DATA ANALYSIS

2

Sales Consultants’ Data Analysis
Data classification to make the outliers become apparent
In essence, outliers refer to the values that are very high or even low in a way that they
occur far-off other data points. While the outliers at times signify occasional or scarce cases, they
might also seem to be a signal that some given data may not be in the right place as compared to
the rest of data of interest and a likely error in the data entry. Irrespective of what outliers implies
or emanates from, they can easily be acknowledged by means of numerous functions or operations
like sort, filter besides charts together with scatter plots. In our case, our data set outlier consulting
will be recognized by performance of the sort function on each the consultant’s Overall contracts,
Total sales and cancellations data besides using scatter plots to denote the respective data sets.
Outliers and sales consultants trending towards noncompliance

Outliers based on Total Contracts
30
25
20
15
10
5
0
0

20000000

40000000

60000000

80000000

100000000

Based on the entire Total Contracts, the contractor number 26526109 (Eugene Periter) is
the outlier contractor since his quantity of contracts projected far much higher and better than those
of different contracts. Nevertheless, based on the sales revenues, the rest of the three outliers
included the contractor IDs: 83748200, 33407197 and 26354410 since their overall sales incomes
of $0 did not go lower near rest of the sales revenues.

SALES CONSULTANTS’ DATA ANALYSIS

3

Outliers based on Total Sales
$100,000.00
$90,000.00
$80,000.00
$70,000.00
$60,000.00
$50,000.00
$40,000.00
$30,000.00
$20,000.00
$10,000.00
$0.00
0

20000000

40000000

60000000

80000000

100000000

Conversely, the outliers for the respective data set known as “Total Cancellations” refers
to the consultant ID 26526109 who held a total number of cancellations projecting very high and
beyond the stipulated range of the rest of the consultants’ cancellations.

outliers based on Total Cancellations
14
12
10
8
6
4

2
0
0

20000000

40000000

60000000

80000000

100000000

Essentially, based on the data set analysis, most of the sales consultants with a
noncompliance progression included the consultant with IDs: 26152889, 26526109, 33407197,

SALES CONSULTANTS’ DATA ANALYSIS

4

83748200, 33255099, 33233704 and 26354410. These respective consultants hold a progression
rate towards noncompliance since they hold the highest quantity of cancelations as well as the
least contracts numbers.
Recommendations to Mr. Lopez
Most logical research typically targets should examine a specific phenomenon so as to
find out the causal and impact of how things carry on the manner in which they do. For this
situation, data gathered should be recorded, deciphered and broke down to introduce the data or
results to the applicable stakeholders (Furnham & Fudge, 2008). Consequently, spreadsheet
program is the best particularly when processing statistical data. In this situation, the data speaks
to sales data for different states for a period October...


Anonymous
This is great! Exactly what I wanted.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags