What is the expected salary of a female white employee

Assignment Help Applied Statistics

Reference no: EM131470555

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: EM131470555

Questions Cloud

Discuss songs with which you are familiar that do likewise : Identify and discuss some songs with which you are familiar that do likewise. Have these songs affected ypour own thoughts and views on issues they address?

Submarine to reach a depht of 190 feet : How many minutes to the nearest tenth does it take the submarine to reach a depht of 190 feet?

How you can use assessment to document childrens work : How you can use assessment to document children's work. How you will use assessment to differentiate instruction for children who may have a special need.

Define the identified critical step of research in your word : Identify the most important step in the student's guide to research that you would need in order to analyze bullying.

What is the expected salary of a female white employee : What is the expected salary of a female white employee with 16 years of education and federal experience? Find the coefficient of determination

What is a condition precedent : What is a condition precedent, and how does it affect a party's duty to perform a contract?

What is the standard measure of compensatory damages : What equitable remedies can a court grant, and in what circumstances will a court consider granting them?

What is the clique-decision problem : Is it possible for a graph with 10 vertices and 14 edges to contain a 5-clique ? If, no, explain why. If, yes give an example.

What did you like about the show : Was there anything you didn't like about the show or a piece of work? How could this aspect be improved?

User Account

All Pages