The Excel file BankData shows the values of the followingvariables for randomly selected 93 employees of a large bank. (Avery similar data set was used in a court lawsuit againstdiscrimination.)  

Let

= 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 that the individual was hired by the bank(MONTHS),

= dummy variable coded 1 for males and 0 for females (MALE).

Using the t-test studied in Section 10.2, you couldfind some evidence that the mean salary of all male employees isgreater than the mean salaries of all female employees, and henceprovide some support for a discrimination suit against theemployer. It is recognized, however, that asimplecomparison of the mean salaries might beinsufficient to conclude that the female employees have beendiscriminated against. Obviously there are other factors thataffect the salary. These factors have been identifiedas  and  defined above.

Assume the following multiple linear regression model,

,

and apply Regression in Data Analysis of Excel with the 99%confidence level (see pages 312 – 314) to find the estimatedregression equation

.

Note. Of course, Input Y Range is A1:A94, Input X range isB1:E94, and Labels should be checked.

1. Clearly show the estimatedregression equation. What is the percentage of variation in thesalary explained by this equation? Assuming that the valuesof  and  are fixed, what is the estimateddifference between the predicted monthly salaries of male andfemale employees?

2. What salary would you predict for amale employee with 12 years educations, 10 months of previous workexperience, and with the time hired equal to 15 months? What salarywould you predict for a female employee with 12 years educations,10 months of previous work experience, and with the time hiredequal to 15 months? What is the difference between the twopredicted salaries? Compare this difference with that stated inTask 1.

3. Is there a significant differencein the predicted salaries for male and female employees afteraccounting for the effects of the three other independentvariables? To answer this question, conduct the ttest forthe significance of at a 1% level of significance. Clearly show thenull and alternative hypotheses to be tested, the value of the teststatistic, the p-value of the test, your conclusion andits interpretation; see pages 322 – 323 and 333 – 335.

SALARY	EDUCAT	EXPER	MONTHS	MALE
5620	10	12	22	1
5040	8	14	3	1
5100	9	36	15	1
5100	10	55	2	1
5220	12	29	14	1
5400	12	37	21	1
5400	12	38	11	1
5400	12	39	3	1
5400	10	48	8	1
5400	10	60	11	1
5700	15	74	5	1
6000	15	88	21	1
6000	12	98	12	1
6000	12	113	17	1
6000	12	115	14	1
6000	15	123	33	1
6000	14	152	11	1
6500	14	173	19	1
6000	15	150	13	1
6400	15	136	32	1
6000	15	156	12	1
6900	15	180	33	1
6000	15	156	16	1
6000	16	145	13	1
6300	15	220	17	1
6600	15	164	16	1
7800	15	259	33	1
6600	15	216	16	1
6840	15	142	17	1
6900	16	175	20	1
6900	15	132	24	1
8100	16	315	33	1
6300	15	187	30	1
6400	15	231	33	1
4620	10	12	22	0
4020	10	12	7	0
4290	12	5	10	0
4380	8	6	7	0
4380	8	8	6	0
4380	12	3	7	0
4380	12	4	10	0
4380	12	5	6	0
4440	10	11	2	0
4500	12	12	3	0
4500	12	8	19	0
4620	12	52	13	0
4800	10	70	20	0
4800	12	52	23	0
4800	12	11	12	0
4800	12	75	17	0
4800	12	63	22	0
4800	12	144	24	0
4800	12	163	12	0
4800	15	228	26	0
4800	12	381	10	0
4800	16	214	15	0
4980	10	318	25	0
5100	10	96	33	0
5100	12	36	15	0
5100	12	59	14	0
5100	10	115	1	0
5100	10	165	4	0
5100	15	123	12	0
5160	12	118	12	0
5220	10	102	29	0
5220	12	127	29	0
5280	10	90	11	0
5280	12	190	31	0
5280	12	107	11	0
5400	10	113	34	0
5400	12	128	33	0
5400	12	126	11	0
5400	12	112	33	0
5400	12	98	22	0
5400	12	82	29	0
5400	12	169	27	0
5400	12	124	31	0
5400	15	94	13	0
5400	15	49	27	0
5400	15	121	21	0
5400	15	122	33	0
5520	12	97	17	0
5520	12	196	32	0
5580	12	133	30	0
5640	12	155	9	0
5700	12	123	23	0
5700	12	117	25	0
5700	15	151	17	0
5700	15	161	11	0
5700	15	241	34	0
6000	12	121	30	0
6000	15	244	22	0
6120	12	209	21	0