View the step-by-step solution to:

PA & Compensation Management (a) Using the following data set, calculate the line of best fit using the least-squares (regression/correlation...

PA & Compensation Management
(a) Using the following data set, calculate the line of best fit using the least-squares (regression/correlation analysis) method. The evaluated points for each organizational job (X) and the actual pay rate (Y) from survey data are shown below.

(b) Show all of your work step by step (including intermediate steps) as you work through our formula manually.

(c) Then check your calculations using any statistics or statistics-related program. Print/Save a copy of your work (printout of regression equation, descriptive statistics, and scatterplot).

(d) Using your results, find the rate of pay for an organizational job worth 210 points.

(e) Write a one-page summary of your results. In your summary, explain to a manager who does not have a good statistics background the use and benefits of the least-squares method for predicting pay rates using the job point evaluation method. Also, explain how well your model “fits” the data. Attach a copy of your file showing the statistics.

Job X Points Y Rate

A 50 \$2.00
B 75 \$2.30
C 100 \$2.65
D 125 \$3.05
E 150 \$3.50
F 175 \$4.00
G 200 \$4.60
H 225 \$5.29
I 250 \$6.08

a) and b)
X XY X² Y² 2
2.3
2.65
3.05
3.5
4
4.6
5.29 100
172.5
265
381.25
525
700
920
1190.25 2500
5625
10000
15625
22500
30625
40000
50625 4
5.29
7.0225
9.3025
12.25
16
21.16
27.9841 250
Sum = Y...

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
• -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents