The next task is to conduct a simple regression using Microsoft Excel to create a market pay line. Enter the job evaluation points (as 𝑥 ) and weighted avcrage base pay rates (as 𝑌 ) for each benchmark job and generate the regression results.

” Task D: Conduct a simple regression in Excel to create a market pay line by entering the job evaluation points (on the 𝑥 axis) and the respective weighted average market base pay (on the 𝑌 axis) for each benchmark job.

Identify the slope and 𝑦-intercept and write the equation for the market pay line.