Test the difference between male and female employees

Reference no: EM131471805

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, R². 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.

Attachment:- Assignment File.rar

Reference no: EM131471805

Questions Cloud

Find difference in form required of contracts for goods : Discuss the difference in form required of contracts for the sale of goods when the sale price is $500 or more and when the price is less than $500.

Explain challenges facing managers in managing generational : Explain the challenges facing managers in managing generational differences and negative behavior in the workplace

Solve a contemporary social and criminal justice issue : Identify a clear thesis statement to address your chosen criminal and social justice issue - Summarize your chosen social and criminal justice issue.

Conditions as requiring heavy physical lifting : The job description for the position listed the educational requirements which Mr. Felix claims to have met.

Test the difference between male and female employees : Test the difference between male and female employees' average salaries. Are the means different

Critical analysis of the article : Summarize the article's thesis and main points in one or two paragraphs. at maximum and critically evaluate the relevance of the data.

Explain the receipt and acceptance exception : Does part payment make an oral contract for goods worth more than $500 enforceable?

Why is force-field analysis important : Why is Force-Field analysis important? What are three reasons why firms fail to innovate?

Discuss ways in which the five major concepts : cuss ways in which the five major concepts (roles, norms and conformity, status systems, group size, and group cohesiveness) affect group behaviour.

User Account

All Pages