TechSales Rep Data Analysis

The TechSales_Rep (https://ezto.mheducation.com/extMedia/bne/Jaggia_ba_2e/Capstone/excel_data_file/TechRep_Sales_Subset.xlsx) data contain records of 21,990 sales representatives from the hardware and software product groups of a high-tech company. For each employee, the data include socio-demographic and education information, salary, sales performance, and a personality indicator. Also included in the data is the net promoter score, which is an indicator of customer satisfaction with each sales representative. The variables are summarized in the following table:

Data Explanation

Variable

Description

Employee

Unique ID for each sales representative

Business

One of the two product groups: Hardware and Software

Age

Employee’s actual age

Female

1 for female, 0 otherwise

Years

The number of years the employee has been employed at the company

College

Whether or not the employee has a 4-year college degree (Yes/No)

Personality

Four personality types based on the Myers-Briggs Personality assessment:

Analyst: This personality type exemplifies rationality. Analysts tend to be open-minded and strong-willed. They like to work independently and usually approach things from a very practical perspective.

Diplomat: Diplomats care about people and tend to have a lot of empathy toward others. They exemplify cooperation and diplomacy.

Explorer: Explorers are highly practical and can think on their feet. They tend to be very good at making quick, rational decisions in difficult situations.

Sentinel: Sentinels are cooperative and practical. They like stability, order, and security. People with this personality type tend to be hard working and meticulous.

Certificates

The number of relevant professional certifications each employee has earned

Feedback

The average feedback score that each employee receives from his or her peers and supervisor on the 360-degree annual evaluation. The possible scores range from 0 (lowest) to 4 (highest).

Salary

Annual base salary of each employee

NPS

The net promoter score (NPS) is a key indicator of customer satisfaction and loyalty.

Using R/RStudio we will create tabular and graphical methods to examine the salaries of sales representatives along with other variables of interest using this code. (https://jsu.instructure.com/courses/39555/files/4879527?verifier=VNshYt1rFjTkOi4ghVP3pP3zIXRg1Txgc9TduNUv&wrap=1)

The video below provides a guided tutorial for Project 2.

Launch External Tool (https://jsu.instructure.com/courses/39555/external_tools/retrieve?display=borderless&url=https%3A%2F%2Fjsu.instructuremedia.com%2Flti%2Flaunch%3Fcustom_arc_launch_type%3Dbare_embed%26custom_arc_media_id%3Daae7bfeb-cee9-4eae-9759-94ef46b28ecf-4314%26custom_arc_start_at%3D0)

View color options (https://jsu.instructure.com/courses/39555/files/4879532?verifier=g4UzltFAaAIiSCDXi9K48V7Ppa7fjpvKls8gwIM4&wrap=1)

View symbols (https://jsu.instructure.com/courses/39555/files/4879539?verifier=CGUdqT3GFHoVYaZbBZSqudLhaX08gaAZlEQpR7nf&wrap=1)

To earn full credit on this assignment, submit a document that includes and briefly explains any insights gained from the following displays:

•

frequency distribution and relative frequency distribution for all categorical variables

•

bar chart (any categorical variable)

•

grouped bar chart (any two categorical variables)

•

histogram (any quantitative variable)

•

pie chart (for Personality Type)

•

scatterplot (any two quantitative variables)

•

scatterplot by group (any two quantitative variables separated by categorical variable)

***All graphs must have an informative title, axis labels and/or legend, and updated color schemes***