Reference no: EM133178763

For this project, you are required to answer the following questions. Some questions require a description of the process.  Other questions require that you show calculations and answers. Please take date as June 1, 2022, wherever mentioned. I received an incorrect answer before where the tutor took Jan 1 2021 as the date.

1. What is an outlier and how you would deal with outliers.
2. Discuss what is meant by job matching.  Use the following criteria for job matches: Benchmark Jobs 1, 2 and 3 must match at 80%; Benchmark Jobs 4 and 5 must match at 70%.  Eliminate data that does not meet the criteria.  Indicate what data has been eliminated.
3. Describe "aging the data" and then age the remaining data. Use an annual inflation rate of 1.8%.  The effective date of your new wage schedule will be June 1, 2022. Present the aged job rates.
4. Average the data for each benchmark job using the weighted mean.  Show your work and show the weighted mean for each benchmark job.
5. For the Market Line, what are the labels and values on the Y -axis and the labels and values on the X-axis. 
6. You have decided to use the "Match" pay policy. For Pay Line One, what are the labels and values on the Y-axis and X-axis. What are the values of the y-intercept and the slope of the regression line?
7. For Pay Line Two, using the values in the Job Evaluation System Table below, what are the labels and values on the Y-axis and the X-axis.
8. Using the "regression equation" and data from the Pay Line Two, calculate the Job Rate for each of the five pay grades.
9. Create the Wage Schedule for the hourly Job Family clearly indicating five specific wage ranges and overlaps. You determine the spread within each Pay Grade. The effective date will be June 1, 2022