A group of employees have filed a complaint with the human resources department about salary at the company. A random sample of 25 employees was taken to investigate the relationship between an employee's salary and four explanatory variables, as described below.

Salary = employee's annual salary (thousands of dollars), Male = 1 if employee is male, 0 otherwise, Experience = number of years employment at the company, Over50 = 1 if employee is over 50 years old, 0 otherwise, and MBA = 1 if employee has an MBA degree, 0 otherwise

Observation	Salary	Experience	Over50	MBA	Male
1	28.6	0	0	1	0
2	53.3	4	0	1	0
3	73.8	12	0	0	0
4	26	0	0	0	1
5	77.5	19	0	0	0
6	95.1	17	0	0	1
7	34.3	1	0	1	0
8	63.5	9	0	0	1
9	96.4	19	0	0	0
10	122.9	31	0	0	1
11	63.8	12	0	0	1
12	111.1	29	1	0	1
13	82.5	12	0	1	0
14	80.4	19	1	0	1
15	69.3	10	0	0	0
16	52.8	8	0	0	1
17	54	2	0	1	1
18	58.7	11	0	0	1
19	72.3	14	0	0	1
20	88.6	21	0	0	1
21	60.2	10	0	0	1
22	61	7	0	0	1
23	75.8	18	0	0	0
24	79.8	19	0	0	0
25	70.2	12	0	0	1

Use Excel to estimate the following model

Salary = b₀ + b₁ Male + b₂ Experience + b₃ Over50 + b₄ MBA

Write the results in equation form and carefully interpret each of the estimated slope coefficients. That is, what do the estimated coefficients measure?

What percentage of variations in salary is explained by this model?

Are the estimated coefficients statistically significant? Use the p-value approach and a 10% level of significance to carry out the tests. Clearly state your decision with a statement.

Use the estimated equation to predict the salary of a 40-year-old male employee with an MBA degree, and 10 years of experience.

Use the estimated equation to predict the salary of a 55-year-old male employee, with an MBA degree, and 10 years of experience.

Does the study provide statistical evidence of age discrimination? Explain.

Does the study provide statistical evidence of gender discrimination? Explain.