You have received a corrected data set from your $3$rd party consultant. There was some new data received which has changed the numbers for your key benchmark jobs you calculated in your last assignment from Module $6.$ Also, you have reviewed your internal job evaluation points with upper management, and you have determined the following job evaluation points for your jobs. The job evaluation points and the new weighted average pay for each benchmark jobs are shown in the following table:

Job Title

Job Evaluation Points

Weighted Survey Averages

Information Technology Director

$335$

$$120,000$

Compensation & Benefits Senior Manager

$285$

$$85,000$

Database Warehouse Analyst

$245$

$$64,000$

Operations Support Associate

$225$

$$56,000$

Recruiter

$200$

$$50,000$

Your assignment is to run a simple regression in Excel $[$to create your predicted pay line$]$ by entering your job evaluation points $($on the X axis$)$ and the respective weighted average market base pay $($on the Y axis$).$

From your regression analysis:

$1.$ What is your $"$R squared$*?[20$ points$]$

$2.$ What is the slope of your pay line? $[20$ points$]$

$3.$ What is your y$-$intercept of your pay line? $[20$ points$]$

$4.$ Write out the exact equation for your market pay line, and save it for next week's assignment. $[40$ points$]$