Use Excel to construct a two-way pivot table showing the number of workers for each combination of Occupation and Female (1 = Yes and 0 = No).

Worker	Earnings	Industry	Occupation	Ed	Female	Experience	Married	Age	Union
1	19388	1	0	6	0	45	1	57	0
2	49898	2	0	12	0	33	1	51	1
3	28219	0	3	12	0	12	1	30	0
4	83601	0	5	17	0	18	1	41	0
5	29736	0	4	8	0	47	1	61	1
6	50235	1	0	16	0	12	1	34	0
7	45976	0	2	12	0	43	1	61	1
8	33411	1	2	12	0	20	1	38	0
9	21716	0	5	12	1	11	0	29	0
10	37664	0	5	18	0	19	1	43	0
11	26820	0	5	18	0	33	0	57	1
12	29977	0	4	16	1	6	1	28	0
13	33959	0	5	17	1	26	1	49	1
14	11780	0	2	11	1	33	1	50	0
15	10997	0	4	14	0	0	0	20	0
16	17626	0	3	12	1	45	1	63	0
17	22133	0	5	16	1	10	0	32	1
18	21994	0	1	12	1	24	1	42	0
19	29390	0	0	13	0	18	1	37	0
20	32138	0	4	14	0	22	1	42	1
21	30006	1	3	16	1	27	1	49	0
22	68573	0	5	16	0	14	1	36	1
23	17694	0	4	8	1	38	1	52	0
24	26795	0	0	7	0	44	1	57	0
25	19981	0	4	4	0	54	1	64	0
26	14476	0	5	12	1	3	1	21	0
27	19452	0	4	13	0	3	0	22	0
28	28168	1	0	13	0	17	0	36	0
29	19306	0	5	9	1	34	1	49	1
30	13318	1	0	11	1	25	1	42	1
31	25166	0	4	12	1	10	0	28	0
32	18121	1	3	12	1	18	1	36	0
33	13162	1	0	12	0	6	0	24	1
34	32094	0	3	12	1	14	1	32	0
35	16667	0	3	12	0	4	0	22	0
36	50171	0	5	12	0	39	1	57	1
37	31691	1	0	12	0	13	0	31	0
38	36178	0	3	12	1	40	1	58	0
39	15234	0	1	12	1	4	0	22	0
40	16817	0	3	12	1	26	0	44	0
41	22485	0	3	12	0	22	0	40	0
42	30308	0	4	12	0	10	1	28	0
43	11702	0	2	14	1	6	1	26	0
44	11186	0	0	12	0	0	0	18	0
45	12285	0	1	12	1	42	1	60	0
46	19284	1	4	16	0	3	0	25	0
47	11451	1	0	12	1	8	1	26	0
48	57623	0	1	15	0	31	1	52	0
49	25670	0	3	13	1	8	0	27	1
50	83443	0	5	17	1	5	0	28	0
51	49974	1	1	16	0	26	1	48	1
52	46646	2	0	5	0	44	1	55	0
53	31702	0	3	12	1	39	1	57	0
54	13312	0	4	12	1	9	1	27	0
55	44543	0	2	18	0	10	1	34	0
56	15013	0	4	16	0	21	1	43	0
57	33389	0	1	14	0	22	0	42	0
58	60626	0	5	18	0	7	1	31	0
59	24509	0	5	14	1	15	0	35	0
60	20852	1	0	12	1	38	1	56	0
61	30133	2	0	10	0	27	1	43	0
62	31799	0	3	12	1	25	0	43	0
63	16796	0	4	12	1	14	1	32	0
64	20793	0	0	12	1	6	0	24	0
65	29407	0	4	10	0	19	0	35	0
66	29191	0	0	12	0	9	0	27	0
67	15957	0	2	12	1	10	0	28	0
68	34484	0	3	13	1	28	0	47	0
69	35185	1	3	14	1	12	1	32	0
70	26614	1	0	12	1	19	1	37	0
71	41780	0	0	12	0	9	1	27	0
72	55777	0	1	14	0	21	1	41	0
73	15160	0	4	8	1	45	0	59	0
74	66738	0	0	9	0	29	1	44	0
75	33351	0	5	16	1	4	1	26	0
76	33498	0	1	10	0	20	1	36	0
77	29809	0	4	8	1	29	0	43	0
78	15193	1	0	12	1	15	0	33	0
79	23027	0	4	14	0	34	1	54	1
80	75165	0	1	15	0	12	1	33	0
81	18752	0	4	11	1	45	0	62	1
82	83569	0	1	18	0	29	1	53	0
83	32235	0	3	12	1	38	1	56	0
84	20852	0	0	12	0	1	0	19	0
85	13787	0	4	11	0	4	1	21	0
86	34746	0	3	14	1	15	1	35	0
87	17690	0	1	12	0	14	1	32	0
88	52762	0	5	18	0	7	1	31	0
89	60152	0	5	16	0	38	1	60	0
90	33461	0	1	16	0	7	1	29	1
91	13481	0	4	12	0	7	0	25	0
92	9879	0	3	12	1	28	1	46	0
93	16789	0	3	13	1	6	1	25	0
94	31304	0	1	16	1	26	1	48	0
95	37771	0	5	15	0	5	0	26	0
96	50187	0	3	12	1	24	1	42	0
97	39888	0	3	12	0	5	0	23	0
98	19227	0	3	12	1	15	1	33	0
99	32786	1	0	11	0	37	1	54	1
100	28440	0	4	12	1	24	1	42	0