lmagine that youre working at a different company but are still focusing on the job of a Customer Service Representative.There are 108 customer service representatives, and the pay range/grade midpoint for the job is $41,250.Using data found in the Practice sheet of the dataset below, respond to the following questions as if you were explaining the data to a manager who is not familiar with statistical terminology:Calculate the compa-ratio for each individual customer service representative. What is the highest and lowest compa-ratio that you observed?Calculate the overall average compa-ratio across all customer service representatives. What is it? Is the company compensating people noticeably below or above the pay range/grade midpoint (on average)?Create a scatterplot with the tenure and compa-ratio variables. Is there evidence of pay compression or inversion? How do you know?

Note: For the purposes of this exercise, imagine that your organization has concerns regarding pay compression among those working the Customer Service Representative job. The compa-ratio reflects how much employees are actually paid for a given job or pay grade as compared to the espoused pay structure and policies. A compa-ratio of 1.00 indicates that an employee (or group of employees) is paid at the midpoint of their pay range/grade, whereas a compa-ratio above 1.00 indicates that an employee (or group of employees) is paid above the midpoint of their pay range/grade, and a compa-ratio below 1.00 indicates that an employee (or group of employees) is paid below the midpoint. When considered in conjunction with tenure, compa-ratios can be used to evaluate whether pay compression (or inversion) is an issue.

Here is the Excel data:

\begin{tabular}{r|r|r|r} & \multicolumn{1}{|c}{ A } & \multicolumn{1}{c}{ C } \\ \hline 1 & EmployeelD & Tenure & Compensation \\ \hline 2 & EEA3321 & 1.1 & 44708 \\ \hline 3 & EEA3322 & 1.3 & 44552 \\ \hline 4 & EEA3323 & 1.3 & 43822 \\ \hline 5 & EEA3324 & 1.4 & 44614 \\ \hline 6 & EEA3325 & 1.4 & 45770 \\ \hline 7 & EEA3326 & 1.6 & 44312 \\ \hline 8 & EEA3327 & 1.6 & 43335 \\ \hline 9 & EEA3328 & 1.6 & 45056 \\ \hline 10 & EEA3329 & 1.6 & 44943 \\ \hline 11 & EEA3330 & 1.6 & 43437 \\ \hline 12 & EEA3331 & 1.7 & 43920 \\ \hline 13 & EEA3332 & 1.7 & 43078 \\ \hline 14 & EEA3333 & 1.7 & 43221 \\ \hline 15 & EEA3334 & 1.9 & 44054 \\ \hline 16 & EEA3335 & 2.0 & 42869 \\ \hline 17 & EEA3336 & 2.0 & 44106 \\ \hline 18 & EEA3337 & 2.1 & 43612 \\ \hline 19 & EEA3338 & 2.1 & 44376 \\ \hline 20 & EEA3339 & 2.1 & 44881 \\ \hline 21 & EEA3340 & 2.1 & 44870 \\ \hline 22 & EEA3341 & 2.1 & 43340 \\ \hline 23 & EEA3342 & 2.2 & 42790 \\ \hline 24 & EEA3343 & 2.2 & 43729 \\ \hline 25 & EEA3344 & 2.2 & 43433 \\ \hline 26 & EEA3345 & 2.3 & 44299 \\ \hline 27 & EEA3346 & 2.3 & 44778 \\ \hline 28 & EEA3347 & 2.3 & 43317 \\ \hline 29 & EEA3348 & 2.3 & 43655 \\ \hline 30 & EEA3349 & 2.3 & 43559 \\ \hline 31 & EEA3350 & 2.3 & 43148 \\ \hline 32 & EEA3351 & 2.3 & 43075 \\ \hline 33 & EEA3352 & 2.4 & 43352 \\ \hline 34 & EEA3353 & 2.5 & 42990 \\ \hline 35 & EEA3354 & 2.5 & 43638 \\ \hline 36 & EEA3355 & 2.6 & 42678 \\ \hline 37 & EEA3356 & 2.6 & 42698 \\ \hline 38 & EEA3357 & 2.6 & 45446 \\ \hline 39 & EEA3358 & 2.7 & 44858 \\ \hline 40 & EEA3359 & 2.7 & 44089 \\ \hline 41 & EEA3360 & 2.7 & 44317 \\ 42 & EEA3361 & 2.7 & 44470 \\ \hline 43 & EEA3362 & 2.7 & 43433 \\ \hline 44 & EEA3363 & 2.7 & 42365 \\ \hline 45 & EEA3364 & 2.7 & 44136 \end{tabular} \begin{tabular}{|l|l|r|r|} \hline 1 & EmployeelD & Tenure & Compensation \\ \hline 45 & EEA3364 & 2.7 & 44136 \\ \hline 46 & EEA3365 & 2.8 & 40188 \\ \hline 47 & EEA3366 & 2.8 & 42980 \\ \hline 48 & EEA3367 & 2.8 & 45033 \\ \hline 49 & EEA3368 & 2.9 & 43560 \\ \hline 50 & EEA3369 & 2.9 & 44148 \\ \hline 51 & EEA3370 & 2.9 & 43416 \\ \hline 52 & EEA3371 & 2.9 & 43898 \\ \hline 53 & EEA3372 & 2.9 & 43557 \\ \hline 54 & EEA3373 & 3.0 & 44343 \\ \hline 55 & EEA3374 & 3.0 & 44168 \\ \hline 56 & EEA3375 & 3.1 & 43384 \\ \hline 57 & EEA3376 & 3.2 & 44444 \\ \hline 58 & EEA3377 & 3.2 & 43450 \\ \hline 59 & EEA3378 & 3.2 & 43452 \\ \hline 60 & EEA3379 & 3.2 & 43265 \\ \hline 61 & EEA3380 & 3.3 & 43807 \\ \hline 62 & EEA3381 & 3.3 & 46062 \\ \hline 63 & EEA3382 & 3.3 & 42850 \\ \hline 64 & EEA3383 & 3.3 & 42843 \\ \hline 65 & EEA3384 & 3.3 & 42181 \\ \hline 66 & EEA3385 & 3.4 & 43353 \\ \hline 67 & EEA3386 & 3.4 & 45108 \\ \hline 68 & EEA3387 & 3.4 & 43998 \\ \hline 69 & EEA3388 & 3.4 & 43046 \\ \hline 70 & EEA3389 & 3.5 & 43838 \\ \hline 71 & EEA3390 & 3.5 & 44999 \\ \hline 72 & EEA3391 & 3.5 & 43881 \\ \hline 73 & EEA3392 & 3.6 & 42648 \\ \hline 74 & EEA3393 & 3.6 & 45899 \\ \hline 75 & EEA3394 & 3.6 & 45091 \\ \hline 76 & EEA3395 & 3.7 & 44381 \\ \hline 77 & EEA3396 & 3.7 & 42830 \\ \hline 78 & EEA3397 & 3.7 & 43292 \\ \hline 79 & EEA3398 & 3.7 & 41710 \\ \hline 80 & EEA3399 & 3.7 & 41531 \\ \hline 81 & EEA3400 & 3.7 & 42045 \\ \hline 82 & EEA3401 & 3.7 & 43743 \\ \hline 83 & EEA3402 & 3.8 & 43916 \\ \hline 84 & EEA3403 & 3.8 & 45040 \\ \hline 85 & EEA3404 & 3.8 & 45572 \\ \hline 86 & EEA3405 & 3.9 & 44840 \\ \hline 87 & EEA3406 & 3.9 & 45444 \\ \hline 88 & EEA3407 & 42823 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 1 & EmployeelD & Tenure & Compensation \\ \hline 80 & EEA3399 & 3.7 & 41531 \\ \hline 81 & EEA3400 & 3.7 & 42045 \\ \hline 82 & EEA3401 & 3.7 & 43743 \\ \hline 83 & EEA3402 & 3.8 & 43916 \\ \hline 84 & EEA3403 & 3.8 & 45040 \\ \hline 85 & EEA3404 & 3.8 & 45572 \\ \hline 86 & EEA3405 & 3.9 & 44840 \\ \hline 87 & EEA3406 & 3.9 & 45444 \\ \hline 88 & EEA3407 & 3.9 & 42823 \\ \hline 89 & EEA3408 & 4.1 & 42509 \\ \hline 90 & EEA3409 & 4.1 & 43942 \\ \hline 91 & EEA3410 & 4.2 & 42980 \\ \hline 92 & EEA3411 & 4.2 & 42364 \\ \hline 93 & EEA3412 & 4.3 & 42702 \\ \hline 94 & EEA3413 & 4.3 & 42579 \\ \hline 95 & EEA3414 & 4.4 & 42196 \\ \hline 96 & EEA3415 & 4.4 & 43165 \\ \hline 97 & EEA3416 & 4.6 & 40975 \\ \hline 98 & EEA3417 & 4.7 & 42740 \\ \hline 99 & EEA3418 & 4.8 & 41654 \\ \hline 100 & EEA3419 & 5.0 & 40852 \\ \hline 101 & EEA3420 & 5.3 & 42156 \\ \hline 102 & EEA3421 & 5.4 & 42020 \\ \hline 103 & EEA3422 & 5.5 & 41596 \\ \hline 104 & EEA3423 & 5.6 & 42464 \\ \hline 105 & EEA3424 & 5.6 & 42023 \\ \hline 106 & EEA3425 & 5.6 & 42531 \\ \hline 107 & EEA3426 & 6.0 & 41759 \\ \hline 108 & EEA3427 & 6.5 & 41410 \\ 109 & EEA3428 & 6.5 & 41302 \\ 110 & & \\ 111 & & & \\ 112 & & & \\ 113 & & & \\ 114 & & & \\ \hline \end{tabular}