chap5_mid2_pivottable_solution

chap5_mid2_pivottable_solution - Nelson Phoenix Senior...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Employee Data Employee Compensation Analysis Name Location Title Gender Salary Previous Salary Increase Percentage Baker Chicago Analyst F $52,000 $45,000 $7,000 15.56% Charles Phoenix Analyst M $40,000 $35,000 $5,000 14.29% Goodman New York Senior Analyst M $100,000 $90,000 $10,000 11.11% Irving Miami Analyst F $47,500 $45,000 $2,500 5.56% Johnson Miami Analyst M $55,000 Jones Chicago Analyst F $42,500 $41,000 $1,500 3.66% Lang Chicago Analyst M $47,500 $42,000 $5,500 13.10% Milgrom Phoenix Analyst F $49,500 $45,000 $4,500 10.00% Mills Chicago Analyst F $38,500 $35,000 $3,500 10.00%
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Nelson Phoenix Senior Analyst M $57,500 $55,000 $2,500 4.55% Rubin Phoenix Analyst F $45,000 $40,000 $5,000 12.50% Smith New York Analyst M $65,000 $61,000 $4,000 6.56% Name Location Title Gender Salary Previous Salary Increase Percentage >0 Evaluation of Salary Increase Average Increase $4,636 9.71% Minimum Increase $1,500 3.66% franco galvez A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25...
View Full Document

Ask a homework question - tutors are online