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?

Fig: 1