Alice runs a company of 30 employees. In the annual report that Alice presented to shareholders, she made the following statements: Statement 1: "Equality is a core value of our company. To promote equality, we employ the same number of men and women." Statement 2: "Three-fifths of our company's female employees are paid higher than male employees of the same rank, although women in the workforce tend to make less money than men. Your assignment has two parts: 1. Analyze the employee salary data (EmployeeSalary.xlsx) in JMP to assess whether Alice's statements are correct. Was Alice lying? Why or why not? Provide the relevant statistics and/or visualize your findings to support your conclusion. (5 points - Correctly assess statement 1; 5 points - Correctly assess statement 2; 5 points - Provide relevant statistical evidence to support your assessment of statement 1; 5 points - Provide relevant statistical evidence to support your assessment of statement 2) Hint: Data is provided in Excel. Import the dataset into JMP and start from there. 2. Analyze the dataset in JMP to come up with your own assessment of equity in Alice's company. Do you see evidence of pay equity between female and male employee? Why or why not? First, state your conclusion. Then, provide relevant statistics (e.g., average) and visualize your findings to support your conclusion. (10 points - Unambiguously state your conclusion regarding pay equity, which may or may not be consistent with Alice's claim 1; 10 points - Provide relevant statistical evidence to support your conclusion; 10 points - Demonstrate capability to analyze data from different angles and draw your own conclusion/assessment) Hint: Pick the appropriate summary measures and chart(s) that effectively present your findings and convey your points. Position Supervisor Sales intern Manager Sales intern Supervisor Sales representative Supervisor Supervisor Sales representative 1 Manager Sales representative Sales representative Manager Sales intern 5 Manager - Manager 3 Supervisor Sales representative Sales representative 1 Manager Supervisor Sales representative : Sales intern Sales representative Sales representative Sales representative Sales representative Sales representative Sales representative Sales representative Salary($) Gender 71,500 Female 14,000 Female 140,000 Female 13,000 Male 75,500 Male 44,000 Female 79,500 Male 72,500 Male 67,500 Male 135,000 Male 69,000 Female 41,000 Female 172,000 Male 14,000 Female 160,000 Female 148,500 Male 74,000 Female 39,000 Female 37,000 Female 125,000 Female 75,500 Female 34,250 Female 13,000 Male 43,750 Male 34,000 Male 36,000 Male 35,000 Female 40,000 Male 34,500 Male 38,500 Male Alice runs a company of 30 employees. In the annual report that Alice presented to shareholders, she made the following statements: Statement 1: "Equality is a core value of our company. To promote equality, we employ the same number of men and women." Statement 2: "Three-fifths of our company's female employees are paid higher than male employees of the same rank, although women in the workforce tend to make less money than men. Your assignment has two parts: 1. Analyze the employee salary data (EmployeeSalary.xlsx) in JMP to assess whether Alice's statements are correct. Was Alice lying? Why or why not? Provide the relevant statistics and/or visualize your findings to support your conclusion. (5 points - Correctly assess statement 1; 5 points - Correctly assess statement 2; 5 points - Provide relevant statistical evidence to support your assessment of statement 1; 5 points - Provide relevant statistical evidence to support your assessment of statement 2) Hint: Data is provided in Excel. Import the dataset into JMP and start from there. 2. Analyze the dataset in JMP to come up with your own assessment of equity in Alice's company. Do you see evidence of pay equity between female and male employee? Why or why not? First, state your conclusion. Then, provide relevant statistics (e.g., average) and visualize your findings to support your conclusion. (10 points - Unambiguously state your conclusion regarding pay equity, which may or may not be consistent with Alice's claim 1; 10 points - Provide relevant statistical evidence to support your conclusion; 10 points - Demonstrate capability to analyze data from different angles and draw your own conclusion/assessment) Hint: Pick the appropriate summary measures and chart(s) that effectively present your findings and convey your points. Position Supervisor Sales intern Manager Sales intern Supervisor Sales representative Supervisor Supervisor Sales representative 1 Manager Sales representative Sales representative Manager Sales intern 5 Manager - Manager 3 Supervisor Sales representative Sales representative 1 Manager Supervisor Sales representative : Sales intern Sales representative Sales representative Sales representative Sales representative Sales representative Sales representative Sales representative Salary($) Gender 71,500 Female 14,000 Female 140,000 Female 13,000 Male 75,500 Male 44,000 Female 79,500 Male 72,500 Male 67,500 Male 135,000 Male 69,000 Female 41,000 Female 172,000 Male 14,000 Female 160,000 Female 148,500 Male 74,000 Female 39,000 Female 37,000 Female 125,000 Female 75,500 Female 34,250 Female 13,000 Male 43,750 Male 34,000 Male 36,000 Male 35,000 Female 40,000 Male 34,500 Male 38,500 Male
