This case, “Designing A Pay Structure (Links to an external site.)Links to an external site.,” can be accessed in the Student Development materials available from the SHRM website.
The student workbook can be found under the link above, or by searching the SHRM website. Make sure to select “Student Development” to filter results.
Use the attached form to complete/fill out the case study.
Task C – Determine if there are outliers (i.e., extreme data points)
Task D – Conduct a simple regression in Excel to create a market pay line by entering into an Excel spreadsheet the correct job evaluation points (on the x axis) and the respective weighted average market base pay (on the y axis) for each benchmark job.
Task E – Record your resulting R squared on the provided_form.
Follow the same path above with the RSQ function.
Task F – Calculate the predicted base pay for each benchmark job and enter results into the provided form.