Person Based Structures In this assignment, you are asked to use the results of a salary survey and map out the pay levels for a fictional company based on the case below. Using a spreadsheet program, you will construct scatter- plot diagram that produces a pay policy line for the company. For this scatter-plot, you will need to define both grade and range. When you analyze this diagram. you will find some jobs with different point values in the same grade. This is as expected as grades group jobs that are similar. There could also be jobs with lower point values that are paid more than a job with a higher point value in the same grade. Finally, you need to comment on the results of this analysis. Are higher paying jobs with lower point values a concern? Explain why and what you would recommed to do about it. Case: Precision Engineering Precision Engineering is a small consulting firm. A salary survey was completed by an outside HFl firm and the results averaged. The results for the Benchmark jobs are presented below. They are mid-level professional jobs. Employee Degree Attained Years since graduation Salary (annual) 1 BSc 3 39,000 2 MS 6 58,800 3 MS 3 50,400 4 PhD 7 95,900 5 BSc 6 48,000 6 PhD 9 105,300 7 MS 4 53,500 8 PhD 3 77,100 9 BSc 7 51 .000 10 PhD 6 91 ,200 1 1 MS 9 67,200 12 MS 7 61 .600 13 PhD 4 82,800 14 BSc 9 57,000 15 BSc 4 42,000