The following question is a variation of question #6 (6-43) on the Week 3 Homework. The attached file is the original data file for the problem in the homework and you are to recode the gender variable with male as the reference category (all other elements remainthe same).

Scenario:A researcher wonders whether males get paid more, on average, than females at a large firm. She interviews 50 employees and collects data on each employee's hourly wage (Wage in $), years of higher education (Educ), years of experience (Exper), age (Age), and a Female dummy variable that equals 1 if female, 0 otherwise. Note that the question in the homework coded the gender variable with female as the reference category.

Attachthe completed Ror Excel file and a Word document with answers to the following questions:

1. What is the prediction equation or the sample regression equation?
2. Is the overall model significant? Reference the test-statistic and the p-value.
3. Are the individual slope coefficients significant? Reference the test-statistic and the p-value for each coefficient.
4. Interpret the slope coefficients.
5. If we were to create an alternative model with education and experience as the predictors, which measures of goodness of fit would be appropriate to compare the two models?