The TechSales_Rep (https://ezto.mheducation.com/extMedia/bne/Jaggia_ba_2e/Capsto

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:
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 conduct hypothesis tests (one-sample mean/proportion, two-sample means/proportions, mean difference) using the starter code here (https://jsu.instructure.com/courses/39555/files/4903817?verifier=GzApYIRxUVp8pzDaElJsrUcQYGSMSbe45mFOUg4U&wrap=1).
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%3Db8876039-cab1-4371-acac-ff4f23075691-4587%26custom_arc_start_at%3D0)
To earn full credit on this assignment, submit a document that interprets (https://jsu.instructure.com/courses/39555/files/4903686?verifier=xQihqqtDkzkrdTvk1jmJZ7F2ttxLoQvePDjvfNUB&wrap=1) the results of the following statistical tests:
• Determine how average salary compares to the average salary for Tech Sales Reps in Birmingham, AL (https://www.salary.com/research/salary/listing/technical-sales-salary/birmingham-al)
of $81,974.00.
•
Determine if average salary differs by whether or not the employee completed college
◦
assuming unequal variances (Welch’s test)
◦
assuming equal variances (pooled-variance test)
•
Determine if there is an average difference in age between groups A and B (assuming groups A and B are dependent)
•
Determine if the proportion of females is more than the proportion for
Tech Sales Reps in the US (https://www.zippia.com/technical-sales-representative-jobs/demographics/)
of 26.7%.
•
Create an appropriate graph (using techniques from previous projects) to model they salary variable by college completion (y/n) that includes:
◦
Informative Title
◦
Axis labels
◦
data labels and/or legend
◦
brief explanation