Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Health Care Labs is a medical research company that performs drug testing for large pharmaceutical companies. A salary survey was completed by an outside HR
Health Care Labs is a medical research company that performs drug testing for large pharmaceutical companies. A salary survey was completed by an outside HR firm and the results averaged. The results for the Benchmark jobs are presented below. They are mid-level professional jobs. Job Salary J.E. Points* A 95,000.00 340 B 90,000.00 289 C 85,000.00 262 D 77,500.00 262 E 85,000.00 250 F 77,500.00 215 G 62,600 231 H 61,200 220 I 56,400 169 * J.E. stands for "Job Evaluation" Instructions Follow these instructions to construct your pay policy line: Plot the job data provided into Excel then produce a scatter plot diagram. Mark the Salary Scale on the vertical axis and the JE Points on the horizontal axis. In the scatter plot, add a trend or best-fit line through the middle of all the job data plotted. In the scatter plot, construct a set of pay boxes. If you cannot overlay the pay boxes, you will need to create a second scatter plot. See the article on Salary Chart: Plot Markers on Floating Bars by Jon Peltier for help. Below the pay box chart, provide a written justification. This should include a rationale for the number of boxes
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started