The Excel file BankData shows the values of the following variables for randomly selected 93 employees of a large bank. This real data set was used in a court lawsuit against discrimination.
= monthly salary in dollars (SALARY),
= years of schooling at the time of hire (EDUCAT),
= number of months of previous work experience (EXPER),
= number of months since the individual was hired by the bank (MONTHS),
= dummy variable coded 1 for males and 0 for females (MALE).
= the average salary for all male bank employees,
= the average salary for all female bank employees.
Task 1. Extract monthly salaries for males and females. Using “t-Test: Two-Sample: Assuming Unequal Variances” in Data Analysis of Excel, conduct the hypothesis test to determine whether , that is, there is evidence of wage discrimination for the bank employees. Use a 1% level of significance. State the two hypotheses to be tested, the value of the test statistic, the p-value of the test, your conclusion and its interpretation. Note. Two-Sample Hypothesis Tests are discussed on pages 215-219 in the textbook.
Task 2. Evidence of provides some support for a discrimination suit against the employer. It is recognized, however, that a simplecomparison of mean starting salaries might be insufficient to conclude that the female employees have been discriminated against. Obviously there are other factors that affect the starting salary to which the relation might be attributed. These factors have been identified as and .
Assume the following regression model,
and apply Regression in Data Analysis of Excel to find the estimated regression equation
1. Clearly show the estimated regression equation. Assuming that the values of and are fixed, what is the predicted average difference between the male and female salaries?
2. Is there a difference in the average salaries for all male and female employees after accounting for the effects of the three other independent variables? Use a 1% level of significance to answer this question by conducting the t test. State the two hypotheses to be tested, the value of the test statistic, the p-value of the test, your conclusion and its interpretation.
3. Using “Correlation” in Data Analysis of Excel, find the correlation matrix for and . Is there any
problem with multicollinearity?
4. What salary would you predict for a male employee with 12 years educations, 10 months of previous work experience, and with time hired equal to 15 months? What salary would you predict for a female employee with 12 years educations, 10 months of previous work experience, and with time hired equal to 15 months? What is the difference between the two predicted salaries? Compare this difference with that found in Task 1.
Use Microsoft Word to write a report with your name shown on the first page. The report should include all relevant Excel outputs (copy and paste them), so do not attach any separate Excel file.