Gender Pay Gap - Data.xlsx

	A	B	C	D	E	F	G	H
1	Industry	Sum of pay weighting * hourly pay	Sum of weighting	Average hourly pay	Sum of pay weighting * hourly pay	Sum of weighting	Average hourly pay	Pay gap (%)
2	Accommodation and food service activities	6736861.26	704668	9.560333746	7598230.55	652384	11.64686833	-21.82%
3	Activities of extraterritorial organisations and bodies	322817.97	15409	20.94996236	870244.19	41135	21.15580868	-0.98%
4	Activities of households as employers of domestic personnel	198092.15	15404	12.85978642	30485.49	3759	8.11	36.94%
5	Administrative and support service activities	7052356.62	507575	13.89421587	8217179.33	496285	16.55737999	-19.17%
6	Agriculture, forestry and fishing	393101.46	36720	10.70537745	883564.87	70455	12.54083983	-17.15%
7	Arts, entertainment and recreation	4447806.47	306113	14.52994963	5054958.73	336607	15.0173904	-3.35%
8	Construction	6716262.35	299083	22.45618223	20026343.04	1083320	18.48608263	17.68%
9	Education	31175121.11	2091081	14.90861478	17810704.77	949504	18.75790388	-25.82%
10	Electricity, gas, steam and air conditioning supply	588791.71	29347	20.06309708	2655251.8	121741	21.81066198	-8.71%
11	Financial and insurance activities	13337131.98	581398	22.9397624	19845493.51	704457	28.17133411	-22.81%
12	Human health and social work activities	49044318.46	3203460	15.3097958	17527272.18	1009864	17.35607189	-13.37%
13	Information and communication	11520672.04	548991	20.98517469	26074417.32	985606	26.45521367	-26.07%
14	Manufacturing	11099635.01	674697	16.45128852	30542662.06	1804723	16.92373958	-2.87%
15	Mining and quarrying	822593.89	34947	23.53832632	2538360.39	119344	21.26927529	9.64%
16	Professional, scientific and technical activities	21842549.58	1062185	20.56379028	32489728.11	1348168	24.09916873	-17.19%
17	Public administration and defence; compulsory social security	23483834.23	1392094	16.8694314	26116843.33	1294549	20.1744726	-19.59%
18	Real estate activities	2587639.92	169877	15.23243241	3205790.66	160503	19.97340025	-31.12%
19	Transportation and storage	4576000.11	343881	13.30692917	14745891.92	981221	15.0281047	-12.93%
20	Water supply, sewerage, waste management and remediation activities	1177338.01	71052	16.57008965	3059885.75	178531	17.13924052	-3.43%
21	Wholesale and retail trade; repair of motor vehicles and motorcycles	19595703.53	1583300	12.37649437	24364578.55	1779897	13.68875758	-10.60%
22
23
24		SEX	Values
25		Female		Male		Grand Total
26	INDS07M	Sum of pay weighting	Sum of PIWT22	Sum of pay weighting	Sum of PIWT22	Sum of pay weighting	Sum of PIWT22
27		7670.7	947	8403.69	9709	16074.39	10656
28	Accommodation and food service activities	6736861.26	704668	7598230.55	652384	14335091.81	1357052
29	Activities of extraterritorial organisations and bodies	322817.97	15409	870244.19	41135	1193062.16	56544
30	Activities of households as employers; undifferentiated goods and services producing activities of households for own use	198092.15	15404	30485.49	3759	228577.64	19163
31	Administrative and support service activities	7052356.62	507575	8217179.33	496285	15269535.95	1003860
32	Agriculture, forestry and fishing	393101.46	36720	883564.87	70455	1276666.33	107175
33	Arts, entertainment and recreation	4447806.47	306113	5054958.73	336607	9502765.2	642720
34	Construction	6716262.35	299083	20026343.04	1083320	26742605.39	1382403
35	Education	31175121.11	2091081	17810704.77	949504	48985825.88	3040585
36	Electricity, gas, steam and air conditioning supply	588791.71	29347	2655251.8	121741	3244043.51	151088
37	Financial and insurance activities	13337131.98	581398	19845493.51	704457	33182625.49	1285855
38	Human health and social work activities	49044318.46	3203460	17527272.18	1009864	66571590.64	4213324
39	Information and communication	11520672.04	548991	26074417.32	985606	37595089.36	1534597
40	Manufacturing	11099635.01	674697	30542662.06	1804723	41642297.07	2479420
41	Mining and quarrying	822593.89	34947	2538360.39	119344	3360954.28	154291
42	Professional, scientific and technical activities	21842549.58	1062185	32489728.11	1348168	54332277.69	2410353
43	Public administration and defence; compulsory social security	23483834.23	1392094	26116843.33	1294549	49600677.56	2686643
44	Real estate activities	2587639.92	169877	3205790.66	160503	5793430.58	330380
45	Transportation and storage	4576000.11	343881	14745891.92	981221	19321892.03	1325102
46	Water supply, sewerage, waste management and remediation activities	1177338.01	71052	3059885.75	178531	4237223.76	249583
47	Wholesale and retail trade; repair of motor vehicles and motorcycles	19595703.53	1583300	24364578.55	1779897	43960282.08	3363197
48	Grand Total	221324982.2	13978833	267124600.1	14369527	488449582.2	28348360
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100