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 Job Title Payroll Specialist HR Generalist Payroll Specialist Executive Recruiter Key Job #4 Key Job #5 Key Job #6 $25,606.00 18 $26,118.12 9 $27,654.48 43 $25,093.88 16 $23,813.58 Points Per Job Points 8 $27,398.42 11 $28,166.60 3 $22,789.34 22 $25,349.94 7 $28,678.72 10 Louisville, KY HR Generalist $55,754.00 4 $60,214.32 5 $55,196.46 21 $54,081.38 4 $60,771.86 1 $58,541.70 3 $51,293.68 1 $50,178.60 9 $63,002.02 2 $49,955.58 3 Executive Recruiter Payroll Specialist $33,602.75 $78,948.00 2 $79,737.48 1 $68,684.76 5 $72,632.16 2 $90,790.20 1 $83,684.88 2 $42,631.92 1 $72,869.00 3 $81,782.23 1 $93,158.64 2 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. 12 $34,274.81 9 $36,290.97 84 $32,930.70 22 $31,250.56 5 $35,954.95 21 $36,963.03 9 $29,906.45 37 $33,266.73 17 $37,635.08 13 Job Title New York, NY HR Generalist $73,165.97 8 $79,019.25 5 $72,434.31 35 $70,970.99 9 $79,750.91 2 $76,824.27 9 $67,312.70 5 $65,849.38 13 $82,677.55 4 $65,556.71 7 Executive Recruiter $103,603.46 7 $104,639.50 3 $90,135.01 7 $95,315.18 2 $119,143.98 1 $109,819.67 3 $55,945.87 2 $95,625.99 5 $107,322.82 6 $122,252.08 2 Payroll Specialist $29,841.23 3 $30,438.06 1 $32,228.53 61 $29,244.41 16 $27,752.35 12 $31,930.12 16 $32,825.36 1 $26,558.70 17 $29,542.82 5 $33,422.18 12 Fresno, CA HR Generalist $64,975.71 1 $70,173.77 1 $64,325.95 23 $63,026.44 4 $70,823.53 3 $68,224.50 5 $59,777.65 1 $58,478.14 4 $73,422.55 2 $58,218.24 4 Executive Recruiter $92,006.00 1 $92,926.06 1 $80,045.22 5 $84,645.52 1 $105,806.90 1 $97,526.36 2 $49,683.24 1 $84,921.54 0 $95,309.01 $108,567.08 1 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 Simple Mean Weighted Mean Trimmed Mean (20%) Range 25th Percentile 75th Percentile Interquartile Range Median Payroll Specialist AVERAGE Louisville, KY HR Generalist SUMPRODUCT()/SUM() TRIMMEAN() .2 MAX() - MIN() QUARTILE(1) QUARTILE(3) QUARTILE3 - QUARTILE1 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. Executive Recruiter Next, plot the jobs on a market pay line for each of the localities. To do this, you will need to properly structure your data. The data need to be ordered from lowest to highest in an array see the example to the right. Your horizontal (X) axis will be the job evaluation points. Your vertical (Y) axis will be the average pay rate using the measure(s) of central tendency you identified above. After you do highest points this you will have a market pay line chart for each locality (a total of 3 position with the next position with the highest points charts). Payroll Specialist Job Evaluation Points Louisville, KY position with fewest points average pay average pay average pay Job Title New York, NY HR Generalist New York, NY average pay average pay average pay Executive Recruiter Fresno, CA average pay average pay average pay Payroll Specialist Fresno, CA HR Generalist Executive Recruiter 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 Job Title Payroll Specialist HR Generalist Payroll Specialist Executive Recruiter Key Job #4 Key Job #5 Key Job #6 $25,606.00 18 $26,118.12 9 $27,654.48 43 $25,093.88 16 $23,813.58 Points Per Job Points 8 $27,398.42 11 $28,166.60 3 $22,789.34 22 $25,349.94 7 $28,678.72 10 Louisville, KY HR Generalist $55,754.00 4 $60,214.32 5 $55,196.46 21 $54,081.38 4 $60,771.86 1 $58,541.70 3 $51,293.68 1 $50,178.60 9 $63,002.02 2 $49,955.58 3 Executive Recruiter Payroll Specialist $33,602.75 $78,948.00 2 $79,737.48 1 $68,684.76 5 $72,632.16 2 $90,790.20 1 $83,684.88 2 $42,631.92 1 $72,869.00 3 $81,782.23 1 $93,158.64 2 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. 12 $34,274.81 9 $36,290.97 84 $32,930.70 22 $31,250.56 5 $35,954.95 21 $36,963.03 9 $29,906.45 37 $33,266.73 17 $37,635.08 13 Job Title New York, NY HR Generalist $73,165.97 8 $79,019.25 5 $72,434.31 35 $70,970.99 9 $79,750.91 2 $76,824.27 9 $67,312.70 5 $65,849.38 13 $82,677.55 4 $65,556.71 7 Executive Recruiter $103,603.46 7 $104,639.50 3 $90,135.01 7 $95,315.18 2 $119,143.98 1 $109,819.67 3 $55,945.87 2 $95,625.99 5 $107,322.82 6 $122,252.08 2 Payroll Specialist $29,841.23 3 $30,438.06 1 $32,228.53 61 $29,244.41 16 $27,752.35 12 $31,930.12 16 $32,825.36 1 $26,558.70 17 $29,542.82 5 $33,422.18 12 Fresno, CA HR Generalist $64,975.71 1 $70,173.77 1 $64,325.95 23 $63,026.44 4 $70,823.53 3 $68,224.50 5 $59,777.65 1 $58,478.14 4 $73,422.55 2 $58,218.24 4 Executive Recruiter $92,006.00 1 $92,926.06 1 $80,045.22 5 $84,645.52 1 $105,806.90 1 $97,526.36 2 $49,683.24 1 $84,921.54 0 $95,309.01 $108,567.08 1 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 Simple Mean Weighted Mean Trimmed Mean (20%) Range 25th Percentile 75th Percentile Interquartile Range Median Payroll Specialist AVERAGE Louisville, KY HR Generalist SUMPRODUCT()/SUM() TRIMMEAN() .2 MAX() - MIN() QUARTILE(1) QUARTILE(3) QUARTILE3 - QUARTILE1 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. Executive Recruiter Next, plot the jobs on a market pay line for each of the localities. To do this, you will need to properly structure your data. The data need to be ordered from lowest to highest in an array see the example to the right. Your horizontal (X) axis will be the job evaluation points. Your vertical (Y) axis will be the average pay rate using the measure(s) of central tendency you identified above. After you do highest points this you will have a market pay line chart for each locality (a total of 3 position with the next position with the highest points charts). Payroll Specialist Job Evaluation Points Louisville, KY position with fewest points average pay average pay average pay Job Title New York, NY HR Generalist New York, NY average pay average pay average pay Executive Recruiter Fresno, CA average pay average pay average pay Payroll Specialist Fresno, CA HR Generalist Executive Recruiter