Louisville, KY Fresno, CA 1 1 1 Organization 1 Number Incumbents Organization 2 Number Incumbents Organization 3 Number Incumbents Organization 4 Number Incumbents Organization 5 Number Incumbents Organization 6 Number Incumbents Organization 7 Number Incumbents Organization 8 Number Incumbents Organization 9 Number Incumbents Organization 10 Number Incumbents 4 Job Title New York, NY Executive Recruiter Payroll Specialist HR Generalist Executive Recruiter Payroll Specialist HR Generalist Executive Recruiter $78,948.00 $33,602.75 $73,165.97 $103,603.46 $29,841.23 $ 64,975.71 $92,006.00 2 12 8 7 3 1 $79,737.48 $34,274.81 $79,019.25 $104,639.50 $30,438.06 $70,173.77 $92,926.06 1 9 5 3 1 $68,684.76 $36,290.97 $72,434.31 $90,135.01 $32,228.53 $64,325.95 $80,045.22 5 84 35 7 61 23 5 $72,632.16 $32,930.70 $70,970.99 $95,315.18 $29,244.41 $63,026.44 $84,645.52 2 22 9 21 16 1 $90,790.20 $31,250.56 $79,750.91 $119,143.98 $27,752.35 $ 70,823.53 $105,806.90 1 5 2 1 12 3 1 $83,684.88 $35,954.95 $76,824.27 $109,819.67 $31,930.12 $68,224.50 $97,526.36 2 21 9 31 16 5. 2. $42,631.92 $36,963.03 $67,312.70 $55,945.87 $32,825.36 $59,777.65 $49,683.24 1 9 5 2 1 $72,869.00 $29,906.45 $65,849.38 $95,625.99 $26,558.70 $58,478.14 $84,921.54 3 37 13 5 17 0 $81,782.23 $33,266.73 $82,677.55 $107,322.82 $29,542.82 $73,422.55 $95,309.01 1 17 4 6 5 2 $93,158.64 $37,635.08 $65,556.71 $122,252.08 $33,422.18 $58,218.24 $108,567.08 2 13 7 2 12 Payroll Specialist HR Generalist $25,606.00 $55,754.00 18 4 $26,118.12 $60,214.32 9 5 $ 27,654.48 $55,196.46 43 21 $25,093.88 $54,081.38 16 4 $23,813.58 $60,771.86 8 1 $27,398.42 $58,541.70 11 3 $28,166.60 $51,293.68 3 1 $22,789.34 $50,178.60 22 9 $25,349.94 $63,002.02 7 2 $28,678.72 $49,955.58 10 3 1 1 4 4 Points Per Job Job Title Points Payroll Specialist HR Generalist Executive Recruiter Key Job #4 Key Job #5 Key Job #6 Consult O*net general information about the jobs you identified. Additionally, select three other key jobs for the organization you hope to work for. Conduct a job evaluation for each of these 6 jobs based on your understanding of each position. Include the job evaluation with your submission Remember the point of the job evaluation is to allocate points to the job relative to the importance of the job functions. Look through the data provided above. Are there any issues with the data (outliers, missing data, other concerns). If so, how do you propose to handle it? Do you drop outliers? Why or why not? Calculate The Measures of Central Tendency Job Title New York, NY Louisville, KY Fresno, CA Executive Recruiter Payroll Specialist HR Generalist Executive Recruiter Payroll Specialist HR Generalist Executive Recruiter Payroll Specialist HR Generalist Simple Mean AVERAGE Weighted Mean SUMPRODUCT()/SUM() Trimmed Mean (20%) TRIMMEAN().2 Range MAX() - MIN) 25th Percentile QUARTILE(1) 75th Percentile QUARTILE(3) Interquartile Range QUARTILE3 - QUARTILE1 Median MEDIAN Determine which measure(s) of central tendency you will use when creating a market pay line. Note that you may decide to use one or more measure. Discuss the merits of your choice and clearly explain your rationale. New York, NY Fresno, CA average pay average pay Next, plot the jobs on a market pay line for each of the localities. To Job Evaluation Points Louisville, KY do this, you will need to properly structure your data. The data need position with fewest to be ordered from lowest to highest in an array see the example to points average pay the right. Your horizontal (X) axis will be the job evaluation points. Your vertical (Y) axis will be the average pay rate using the position with the next measure(s) of central tendency you identified above. After you do highest points average pay this you will have a market pay line chart for each locality (a total of 3 position with the charts). highest points average pay average pay average pay average pay average pay Louisville, KY Fresno, CA 1 1 1 Organization 1 Number Incumbents Organization 2 Number Incumbents Organization 3 Number Incumbents Organization 4 Number Incumbents Organization 5 Number Incumbents Organization 6 Number Incumbents Organization 7 Number Incumbents Organization 8 Number Incumbents Organization 9 Number Incumbents Organization 10 Number Incumbents 4 Job Title New York, NY Executive Recruiter Payroll Specialist HR Generalist Executive Recruiter Payroll Specialist HR Generalist Executive Recruiter $78,948.00 $33,602.75 $73,165.97 $103,603.46 $29,841.23 $ 64,975.71 $92,006.00 2 12 8 7 3 1 $79,737.48 $34,274.81 $79,019.25 $104,639.50 $30,438.06 $70,173.77 $92,926.06 1 9 5 3 1 $68,684.76 $36,290.97 $72,434.31 $90,135.01 $32,228.53 $64,325.95 $80,045.22 5 84 35 7 61 23 5 $72,632.16 $32,930.70 $70,970.99 $95,315.18 $29,244.41 $63,026.44 $84,645.52 2 22 9 21 16 1 $90,790.20 $31,250.56 $79,750.91 $119,143.98 $27,752.35 $ 70,823.53 $105,806.90 1 5 2 1 12 3 1 $83,684.88 $35,954.95 $76,824.27 $109,819.67 $31,930.12 $68,224.50 $97,526.36 2 21 9 31 16 5. 2. $42,631.92 $36,963.03 $67,312.70 $55,945.87 $32,825.36 $59,777.65 $49,683.24 1 9 5 2 1 $72,869.00 $29,906.45 $65,849.38 $95,625.99 $26,558.70 $58,478.14 $84,921.54 3 37 13 5 17 0 $81,782.23 $33,266.73 $82,677.55 $107,322.82 $29,542.82 $73,422.55 $95,309.01 1 17 4 6 5 2 $93,158.64 $37,635.08 $65,556.71 $122,252.08 $33,422.18 $58,218.24 $108,567.08 2 13 7 2 12 Payroll Specialist HR Generalist $25,606.00 $55,754.00 18 4 $26,118.12 $60,214.32 9 5 $ 27,654.48 $55,196.46 43 21 $25,093.88 $54,081.38 16 4 $23,813.58 $60,771.86 8 1 $27,398.42 $58,541.70 11 3 $28,166.60 $51,293.68 3 1 $22,789.34 $50,178.60 22 9 $25,349.94 $63,002.02 7 2 $28,678.72 $49,955.58 10 3 1 1 4 4 Points Per Job Job Title Points Payroll Specialist HR Generalist Executive Recruiter Key Job #4 Key Job #5 Key Job #6 Consult O*net general information about the jobs you identified. Additionally, select three other key jobs for the organization you hope to work for. Conduct a job evaluation for each of these 6 jobs based on your understanding of each position. Include the job evaluation with your submission Remember the point of the job evaluation is to allocate points to the job relative to the importance of the job functions. Look through the data provided above. Are there any issues with the data (outliers, missing data, other concerns). If so, how do you propose to handle it? Do you drop outliers? Why or why not? Calculate The Measures of Central Tendency Job Title New York, NY Louisville, KY Fresno, CA Executive Recruiter Payroll Specialist HR Generalist Executive Recruiter Payroll Specialist HR Generalist Executive Recruiter Payroll Specialist HR Generalist Simple Mean AVERAGE Weighted Mean SUMPRODUCT()/SUM() Trimmed Mean (20%) TRIMMEAN().2 Range MAX() - MIN) 25th Percentile QUARTILE(1) 75th Percentile QUARTILE(3) Interquartile Range QUARTILE3 - QUARTILE1 Median MEDIAN Determine which measure(s) of central tendency you will use when creating a market pay line. Note that you may decide to use one or more measure. Discuss the merits of your choice and clearly explain your rationale. New York, NY Fresno, CA average pay average pay Next, plot the jobs on a market pay line for each of the localities. To Job Evaluation Points Louisville, KY do this, you will need to properly structure your data. The data need position with fewest to be ordered from lowest to highest in an array see the example to points average pay the right. Your horizontal (X) axis will be the job evaluation points. Your vertical (Y) axis will be the average pay rate using the position with the next measure(s) of central tendency you identified above. After you do highest points average pay this you will have a market pay line chart for each locality (a total of 3 position with the charts). highest points average pay average pay average pay average pay average pay