Calculate the average pay for each ethnic group and the average pay for all of the ethnic groups combined.
Calculate the standard deviation of the pay for each ethnic group and the standard deviation for all of the ethnic groups combined.
Calculate the 95% CIs for the pay of each ethnic group and the 95% CI for all of the ethnic groups combined.
Prior to completing items 1 – 3 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 weblink should be provided. Failure to submit the articles/ links that you selected will result in a 20 point deduction.
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.
https://www.payscale.com/data/racial-wage-gap (Links to an external site.)
https://www.payscale.com/cbpr (Links to an external site.)
https://www.pewresearch.org/fact-tank/2016/07/01/racial-gender-wage-gaps-persist-in-u-s-despite-someprogress/ (Links to an external site.)
https://www.shrm.org/ResourcesAndTools/hr-topics/compensation/pages/racial-wage-gaps-persistence-poseschallenge.aspx (Links to an external site.)
https://www.bls.gov/opub/reports/race-and-ethnicity/2018/home.htm (Links to an external site.)
https://datausa.io/profile/geo/florida/#demographics (Links to an external site.)
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.
After completing items 1 – 3, the following is required:
• Create a table that summarizes the averages, standard deviations, and 95% Cis for each ethnic group and for
all of the ethnic groups combined;
• Create a graph displaying the average pay for each ethnic group and for all of the ethnic groups combined;
and,
• 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.
The required structure of this written assignment is as follows:
Cover Sheet
I. Executive Summary
a. Research question; b. Data and Method; c. Main Conclusions
II. Background (lit review)
III. Problem Statement (Research question)
IV. Analysis (Data and Method; Results)
V. Conclusions and Recommendations (findings and policy implications)