GRAD LEVEL HRM Linear Regression Job Evaluation Excercise, See attached document.

User Generated

SZW0492

Business Finance

Description

Complete the attached individual exercise. If you need assistance with conducting a trend (linear regression) analysis after watching the video on linear regression analysis using Excel, you may want to engage the services found on NetTutor. You may also use SPSS for your work if you are more familiar with that statistical package. Ensure you use references on this, and use APA format. Below is the link to the YouTube video for this exercise. The exercise is attached as a document.


Unformatted Attachment Preview

LIBERTY ENTERPRISES: JOB EVALUATION EXERCISE Listed below are 10 benchmark jobs and their point values derived from an internal job evaluation of positions at Liberty Enterprises using the point method. Job Administrative Assistant Technical Writer Accountant Information System Manager Treasurer Engineering Manager Electrical Engineer Human Resource Manager Financial Analyst Buyer Job Points 160 315 410 930 850 900 490 525 430 320 (a) Use O*NET to identify the annual median market wage for each of the jobs. (b) Using Excel, SPSS, another statistical program, or calculation by hand, determine the equation to construct a wage line representing the relationship between job points and annual median market wage. Let “W” represent the median market wage and “P” represent the job points. The wage line will be of the form W = aP + b where “a” is the slope of the line and “b” is the constant (intercept). (c) Using a total point range of 0-1600, identify 8 wage grades of 200 points each. Label the wage grades W1, W2, etc., up to W8. (d) Identify the wage grades for the 10 jobs identified above. Then, slot the following 5 jobs based on their point value. For each of the 5 jobs, (1) identify the wage grade and (2) calculate the estimated median market wage using the wage line equation from part (b). Chief Financial Officer Marketing Coordinator Field Sales Representative Nuclear Engineering Technician Foreman 1250 270 650 375 450 (e) Complete and submit the next page to fulfill your assignment. [NOTE: O*NET annual median wages tend to be lower than those encountered in actual business organizations. For actual market pricing data from a purchased survey from a reputable consulting firm would be preferred. Such a survey will also reflect differences in industry, organizational size, location, etc.] LIBERTY ENTERPRISES: JOB EVALUATION EXERCISE (HRM6632) Submitted by: (a) Median Market Wages (from O*NET) Job Administrative Assistant Technical Writer Accountant Information Systems Manager Treasurer Engineering Manager Electrical Engineer Human Resource Manager Financial Analyst Buyer Median Market Wage (b) Wage Line Equation: (c) Job Slotting Results Job Chief Financial Officer Marketing Coordinator Field Sales Representative Nuclear Engr. Technician Foreman Wage Grade Estimated Median Wage
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please let me know if there is anything needs to be changed or added. I will be also appreciated that you can let me know if there is any problem or you have not received the work Good luck in your study and if you need any further help in your assignments, please let me know Can you please confirm if you have received the work? Once again, thanks for allowing me to help you R MESSAGE TO STUDYPOOL NO OUTLINE IS NEEDED

https://www.studypool.com/discu
ss/4967854/grad-level-hrmlinear-regression-job-evaluationexcercise-see-attacheddocument
by Robert F

Submission date: 05-Nov-2017 12:25PM (UT C-0500)
Submission ID: 874605242
File name: job_evaluation_exercise___liberty_enterprises-1.docx (25.93K)
Word count: 527
Character count: 3200

https://www.studypool.com/discuss/4967854/grad-level-hrmlinear-regression-job-evaluation-excercise-see-attacheddocument
ORIGINALITY REPORT

0

%

SIMILARIT Y INDEX

0%

0%

0%

INT ERNET SOURCES

PUBLICAT IONS

ST UDENT PAPERS

PRIMARY SOURCE...


Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags