The next task is to conduct a simple regression using Microsoft Excel to create a market pay line. Enter the job evaluation points $($as $x)$ and weighted avcrage base pay rates $($as $Y)$ 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 $x$ axis$)$ and the respective weighted average market base pay $($on the $Y$ axis$)$ for each benchmark job.

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