Business Question

Hire our professional essay experts at Gradehunters.net who are available online 24/7 for an essay paper written to a high standard at an affordable cost.


Order a Similar Paper Order a Different Paper

Assignment 3 is an individual-based project which requires you to conduct a one-way ANOVA with post hoc comparisons based on the pay rate of the different ethnic groups in the departments 17, 21, and 22. In doing so, you must do the following:

undefined

1. Compare the average pay rate of each ethnic group in departments 17, 21, and 22;
2. Conduct pair-wise post hoc comparisons for the ethnic groups in these departments:

undefined

  • 1.White – Black
  • 2.White – Hispanic
  • 3.White – Asian
  • 4.Hispanic – Black
  • 5.Hispanic – Asian
  • 6.Black – Asian

undefined

3. Create a graph displaying the group means; and,
4. Specify the null and alternative hypotheses for each of the statistical analyses.

undefined

Prior to completing items 1 – 4 above, you are required to research and synthesize articles/ publications on public sector compensation. This research must include at least one 1 publication and each article that you selected must be submitted with the assignment to verify that you conducted the research or a working web-link should be provided. Failure to submit the articles/ links that you selected will result in a 20 point deduction.

undefined

The synthesis of the publications must discuss the variables that were included in the research and their importance in analyzing public sector compensation. Include this synthesis into Background section of your report. For example, for this assignment your research might focus on finding whether there are differences in compensation among various ethnicities in the USA, and in the public sector in particular. You might want to check the following links I found on the topic, including US Bureau of Labor Statistics, SHRM, PewResearch:

undefined

undefined

You may want to use those links for your reports; however, you are not required to use them. I encourage you to do your own investigation of the topic. I do not expect everybody to have the same opinion on the topic; I will be looking into how thoroughly you build and support your argument.

undefined

After completing items 1 – 4, the following is required:
• Create ANOVA summary tables that contain the statistical results;
• Create a summary table that contains the average pay rate for each ethnic group in departments 17, 21, and 22 and results of t-tests of pairwise comparisons;
• Attach the Excel spreadsheets that contain the statistical output.
Failure to attach the Excel spreadsheets to the assignment to verify that you performed the analysis will result in a 30 point deduction.

undefined

The required structure of this written assignment is as follows:

undefined

Cover Sheet

undefined

I. Executive Summary
a. Research question; b. Data and Method; c. Main Conclusions

undefined

II. Background (lit review)

undefined

III. Problem Statement (Research question)

undefined

IV. Analysis (Data and Method; Results)

undefined

V. Conclusions and Recommendations (findings and policy implications)

undefined

VI. Bibliography

undefined

VII. Appendices

Writerbay.net

Everyone needs a little help with academic work from time to time. Hire the best essay writing professionals working for us today!

Get a 15% discount for your first order


Order a Similar Paper Order a Different Paper