chap5_mid2_pivottable_solution

chap5_mid2_pivottable_solution - F $38,500 $35,000 $3,500...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Analysis of Salary Increase
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
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
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: F $38,500 $35,000 $3,500 10.00% 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% 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...
View Full Document

This note was uploaded on 04/28/2010 for the course IS 6 taught by Professor 6 during the Spring '10 term at Alfred State College.

Page1 / 3

chap5_mid2_pivottable_solution - F $38,500 $35,000 $3,500...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online