Question

1. The Exel file Accounting Professionals.xls provides the results of a survey of 27 employees in a tax division of a Fortune 100 company. Use PivotTables to find a cross tabulation of the following. Copy and Paste your results and write 1-2 sentences summarizing your findings.
   1. The number of employees of each gender who have or do not have a CPA
   2. The number of employees in each age group who have or do not have a CPA

Employee        Gender  Years of Service.       Years Undergraduate Study       Graduate Degree?        CPA?    Age Group       
1       F       17      4       N       Y       5       
2       F       6       2       N       N       2       
3       M       8       4       Y       Y       3       
4       F       8       4       Y       N       3       
5       M       16      4       Y       Y       4       
6       F       21      1       N       Y       7       
7       M       27      4       N       N       7       
8       F       7       4       Y       Y       2       
9       M       8       4       N       N       3       
10      M       23      2       N       Y       5       
11      F       9       4       Y       Y       3       
12      F       8       2       N       N       2       
13      F       8       4       Y       N       2       
14      M       26      4       N       Y       6       
15      F       9       4       N       Y       2       
16      F       9       2       N       N       2       
17      M       19      2       Y       Y       4       
18      M       5       4       N       N       4       
19      M       19      4       Y       N       7       
20      M       20      4       N       N       6       
21      F       14      4       Y       Y       4       
22      M       31      4       N       N       7       
23      F       10      0       N       N       7       
24      F       10      4       N       Y       3       
25      M       26      4       Y       Y       6       
26      M       28      4       N       N       7       
27      F       5       4       N       Y       1       
                                                        
                                                Age Group       Age Range
                                                1       21-25
                                                2       26-30
                                                3       31-35
                                                4       36-40
                                                5       41-45
                                                6       46-50
                                                7       51-55
                                                8       56-60
                                                9       over 60
                                                        

Answer 1

Result:

The Exel file Accounting Professionals.xls provides the results of a survey of 27 employees in a tax division of a Fortune 100 company. Use PivotTables to find a cross tabulation of the following. Copy and Paste your results and write 1-2 sentences summarizing your findings.

1. The number of employees of each gender who have or do not have a CPA

Two-Way Table
Count of Gender	CPA
Gender	N	Y	Grand Total
F	6	8	14
M	7	6	13
Grand Total	13	14	27

Out of total 27 employees, 14 are female and 13 are male. Out of 14 female employees, 8 responded yes to CPA and 6 male employees replied yes to CPA.

2. The number of employees in each age group who have or do not have a CPA

Two-Way Table
Count of Age Group	CPA
Age Group	N	Y	Grand Total
21-25	0	1	1
26-30	4	2	6
31-35	2	3	5
36-40	1	3	4
41-45	0	2	2
46-50	1	2	3
51-55	5	1	6
56-60	0	0	0
Over 60	0	0	0
Grand Total	13	14	27

Majority of employees(15) are in the age range of 26 to 40 age group. In the age range 31-35, 3 responded YES to CPA and in the 36 to 40 age group, 3 responded YES to CPA.