Business

Using the VLOOKUP function, combine information contained on the DEMOGRAPHICS, JOB DATA, and SALARY INFO worksheets from the “Job Data Exercise” file, such that all data points per individual are included on a single worksheet.

Be careful to ensure that you convert data so that it is uniform for all incumbents (i.e., salary)…
remember, there are 2080 hours in a standard work year, so to calculate an hourly rate from salary, you
would divide the salary by the number of hours in the year. To convert from hourly to salary, you would do
the opposite and multiply the hourly rate by the number hours in a year.
For the five jobs listed below, conduct a t-test (using the T.TEST function) for independent samples to
determine if a statistically significant difference exists between the average compensation for men and
women.

o • Associate Construction Manager

o • Construction Manager

o • Group Manager

o • Project Manager

o • Sr Engineer 1

Draft a 500 word discussion of your findings. Include:

A table indicating the avg hourly rate for men and women for each job (you will have to calculate these in EXCEL) and indicate if they are statistically different based on the t-test.

Assume one or more do show significant differences to the detriment of women,

PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET A GOOD DISCOUNT