Test 3 essay portion 595
MGT 595 01W Test 3 Essay Portion
Please read Comprehensive Case 1 (Running the numbers: Does it pay?) from the textbook. The dataset is provided in the D2L Week 14 module. Then, answer the two questions below.
1. Run descriptive analysis for Promotion, GPA, Sex, School, and Salary. Report only the meaningful analysis and explain why you think it is meaningful.
2. Use the dataset for Case 1 and perform an adequate test for each hypothesis. Interpret the results.
H1: The salaries of female employees are significantly higher than male employees.
H2: Salaries of employees graduating from different universities are significantly different.
***Provide a detailed explanation for your choice of analysis to test each hypothesis. Support it with multiple factors, such as the type of data and question.
***The interpretation of results must be relevant to the case.
*Use Excel to perform the analyses—copy-paste outputs into a Word document to show results.