Find an Excel survey data file of 1994 Office of Personnel Management (OPM94), with variable names and definition. Please use the dataset to answer the following questions. When possible, please insert Excel outputs in your answers.
1. Test whether the mean salary for all federal employees is $36,050 at α=0.05. Please specify the null and alternative hypotheses and explain your finding.
2. Test whether the mean salary for all female federal employees is $29,000 at α=0.05. Please specify the null and alternative hypotheses and explain your finding.
3. Test the difference between male and female employees' average salaries. Are the means different? Please construct a 95% confidence interval for the difference and explain your finding.
4. Test whether the average salaries are the same among races. Please explain your finding.
5. Test whether the decision to leave federal services (exit) differs among individuals who have different years of working experience (yos)? Please explain your finding.
6. If assuming salary depends on gender, minority, years of education, and years of federal service, please run the regression and provide the regression equation with estimated coefficients. And please use this regression equation for question 7-10.
7. Find the coefficient of determination, R2. How fit is the regression model?
8. Which regression coefficient(s)is statistically significant? What is the effect of each statistically significant variable?
9. What is the expected salary of a female white employee with 16 years of education and federal experience? Please show the calculation.
10. Are there any other variables that could be included? Please test 1-2 additional variables listed in the dataset and explain your finding.
Must use data in attached excel file to answer questions.
Attachment:- Assignment Data.rar