To assess how women are doing in the workforce, we have gathered data from 120 firms with 100 to 500 employees, and have recorded how many of the top 25 highest paid employees are female. Use the data provided in Top25_Female.xlsx:What is the overall proportion of females in the top 25? NOTE: Enter a numerical value only, and round your response to4digits after the decimal point. For example, you would enter the proportion of .34561 (equivalent to 34.561%) as.3456in the box below; and .34566 (or 34.566%) as.3457.

Firm	Total # of Employees	# of Female in top 25
1	170	15
2	355	10
3	233	16
4	191	12
5	191	18
6	374	11
7	318	6
8	291	16
9	106	14
10	201	12
11	106	18
12	111	15
13	355	13
14	343	11
15	160	10
16	174	15
17	169	14
18	339	16
19	288	13
20	235	12
21	236	9
22	389	13
23	128	8
24	155	10
25	242	14
26	361	10
27	226	11
28	118	12
29	301	15
30	159	12
31	113	16
32	142	12
33	360	6
34	106	10
35	199	14
36	355	17
37	211	14
38	468	8
39	204	11
40	321	13
41	355	10
42	111	19
43	146	17
44	250	12
45	249	11
46	145	10
47	160	16
48	150	18
49	176	18
50	230	18
51	192	7
52	179	8
53	302	11
54	150	8
55	105	16
56	158	14
57	143	20
58	134	19
59	106	16
60	174	16
61	224	19
62	108	15
63	175	12
64	463	10
65	161	4
66	376	11
67	270	19
68	111	20
69	212	10
70	162	12
71	119	9
72	255	12
73	155	14
74	373	13
75	287	7
76	207	13
77	167	7
78	124	9
79	212	13
80	217	15
81	393	13
82	261	12
83	222	12
84	301	10
85	242	12
86	242	15
87	222	10
88	195	14
89	213	4
90	248	11
91	305	11
92	380	13
93	275	12
94	149	9
95	154	13
96	213	11
97	212	12
98	108	12
99	122	10
100	153	11
101	179	18
102	274	10
103	260	22
104	150	11
105	260	11
106	303	12
107	184	15
108	246	13
109	303	12
110	171	13
111	420	10
112	284	13
113	210	12
114	324	12
115	244	11
116	206	13
117	113	15
118	104	18
119	139	12
120	357	18