Complete individually or in groups 1) Calculuate the salary midpoint using

Question
Complete individually or in groups 1) Calculuate the salary midpoint using the pay policy line 2) Calculuate the min/max pay range for each pay grade 3) Using IF statements, identify which employees are green/red circled 4) Calculuate compa-ratio 5) Create a Pivot Table, calculating each property's average compa-ratio 6) Create a Pivot Table, calculuating each property's average salary Answer in groups 1) Which property has the lowest average compa-ratio? 2) How many green circled employee are there? What do you recommend doing with them? 3) How many red circled employees are there? What do you recommend doing with them?
Question image 1