Using a PIVOT table with the attached data file, determine the following:

1. The average years of service for employees between ages 21-25 inclusive.

2. The average years of service for those employees in the 31-35 (inclusive) age group without graduate degrees?

3. The average years of service for employees in the 26-30 (inclusive) year age bracket who have a graduate degree and a CPA?

Accounting Department Survey Data Employee Gender Years of Servic Years Undergraduate St Graduate Degree CPA? Age Group 17 Y 41-45 26-30 Y 31-35 31-35 36-40 51-55 N 51-55 N 31-35 10 23 11 31-35 12 N 26-30 13 N 26-30 14 26 15 Y 26-30 26-30 19 Y 36-40 36-40 19 51-55 20 46-50 14 36-40 31 51-55 10 51-55 10 31-35 26 28 51-55 21-25 5 0550 55 05550000000500555055 553552 Gi-4333-45533-433-353 55 161161161116666 1661-1611 e423 335523 4 32242233 5 4 3 5 5 3 4 5 2 PA Y N Y N Y Y N Y N Y Y N N Y Y N Y N N N Y N N Y Y N Y te N N Y Y Y N N Y N N Y N Y N N N Y N Y N Y N N N Y N N rg 424 4 4 1 4 4 4 242444224444404444 aY Di 9 0410068 f 17 6 8 8 10 22 617 78 23 9 8 8 26 99 19 5 5 01 1 2 13112 2 rt Y e nd F F M F M F M F M M F F F M F F M M M M F M F F M M F g, G 01234561 012345678901234567 -1 1 2 3 4 5 6 7 8 9 1122222222 111 - 11 - 1 AE