What is the expected salary of a female

Reference no: EM131470165

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

Reference no: EM131470165

Questions Cloud

Write an r function to calculate body mass index : Data Management and Programming for Epidemiology - Write an R function to calculate Body Mass Index Calculate the number and proportion

Which of the specific environmental hr challenges : Which of the specific environmental and organizational HR challenges identified in this chapter will be most important in healthcare in the next 20 years?

How did you become aware of people being treated differently : When and how did you become aware of people being treated differently because of race, culture, or religion? Explain.

Recommend a strategy for financial administrators : Recommend a strategy for financial administrators to balance the tension between having inventory on hand when it is needed versus carry cost to organization.

What is the expected salary of a female : What is the expected salary of a female white employee with 16 years of education and federal experience? Please show the calculation

Discuss the lack of mentoring and networking : For the past 20 years, Metropolitan Hospital celebrated the fact that 50 percent of its new hires in management positions had been women.

Linux distribution to perform name resolution : Discuss how you would configure your Linux distribution to perform name resolution using DNS

Contrast data flow diagram : Compare and contrast Data Flow diagram and Use Case diagram. Which one would you use to communicate with the business users

Conduct a brief financial analysis of the chosen company : Conduct a brief financial analysis and review of the chosen company's financial statements for at least three consecutive years.

User Account

All Pages