ID Salary Compa Midpoint Age Performance Rating Service 8 10 11 14 15 23 26 31 35 36 37 42 3 18 20 39 7 13 22 24 45 17 48 28 43 19 25 40 2 32 34 16...

Hello  Was wondering if I could get assistance with my BUS 308 week 5 assignment.  I have attached the required spreadsheet that contains the data required. the problem can be found of the Week 5 tab and the data required for the solutions can be found on the data tab in the same workbook.  Please note that all solutions must show work and tables used to reach each answer as demonstrated on the pervious weeks tabs 1-4.