{"id":5351,"date":"2024-01-03T23:22:33","date_gmt":"2024-01-03T23:22:33","guid":{"rendered":"https:\/\/marriott-stats.com\/nigels-blog\/?p=5351"},"modified":"2024-01-08T15:19:17","modified_gmt":"2024-01-08T15:19:17","slug":"uk-ethnicity-pay-gap-trends-2012-2022","status":"publish","type":"post","link":"https:\/\/marriott-stats.com\/nigels-blog\/uk-ethnicity-pay-gap-trends-2012-2022\/","title":{"rendered":"Pay Gap Trends #7 &#8211; UK Ethnicity Pay Gap 2012 to 2022"},"content":{"rendered":"<p>In November 2023, the Office of National Statistics (ONS) resumed publishing <a href=\"https:\/\/www.ons.gov.uk\/employmentandlabourmarket\/peopleinwork\/earningsandworkinghours\/articles\/ethnicitypaygapsingreatbritain\/2012to2022\" target=\"_blank\" rel=\"noopener\">estimates of the UK Ethnicity Pay Gap<\/a> after a 3 year hiatus for the Covid19 pandemic.\u00a0 I have organised this data into a user-friendly (hopefully!) Microsoft Excel spreadsheet which allows you to see how the median hourly pay has changed between 2012 &amp; 2022 for a variety of ethnicities &amp; other categories.\u00a0 This article explains how you can use this spreadsheet and why you must look at ethnicity pay gap data in a different way than you would for gender pay gap data.<\/p>\n<p><!--more--><\/p>\n<h5><span style=\"color: #800000;\"><strong>Click here to download my spreadsheet <a style=\"color: #800000;\" href=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-Ethnicity-Pay-Gap-Trends-2012-to-2022-version-2023-v1.xlsx\">ONS Ethnicity Pay Gap Trends 2012 to 2022 &#8211; version 2023 v1<\/a><\/strong><\/span><\/h5>\n<p>Please read the HELP page and the rest of this article before you start using it.\u00a0 You are free to reproduce any chart or table but I would appreciate it if you could credit me for creating these.<\/p>\n<h5><span style=\"color: #008000;\"><strong>Layout of ONS Ethnicity Pay Gap Trends 2012 to 2022<\/strong><\/span><\/h5>\n<p>There are a number of worksheets (some hidden, some protected but password-free) but the most important are these &#8211;<\/p>\n<ul>\n<li><strong>HELP<\/strong> &#8211; this lists the main worksheets and briefly explains what each does<\/li>\n<li><strong>C_Trends<\/strong> &#8211; using this, you can look at the trends in median hourly pay for any two categories (which are denoted as reference &amp; comparator) between 2012 &amp; 2022.<\/li>\n<li><strong>C_Intersectional<\/strong> &#8211; here, you can look at the intersection between any two ethnicities and other categories such as sex, age and whether born in the UK or not for a specific year.<\/li>\n<li><strong>C_Regions<\/strong> &#8211; here, you can look at how median hourly pay varies by ethnicity and region for a specific year.<\/li>\n<li><strong>PvtData<\/strong> &#8211; A pivot table with all the data used in the above worksheets and more.\u00a0 You can reformat this pivot table to whatever you want.<\/li>\n<li><strong>ONS_Data<\/strong> &#8211; This is the source data worksheet for the pivot table and the 3 output worksheets above.<\/li>\n<\/ul>\n<p>There are a number of other <strong>ONS_<\/strong> named worksheets which are explained in the <strong>HELP<\/strong> worksheet and are worth familiarising yourself with.<\/p>\n<p>The three <strong>C_<\/strong> worksheets (Trends, Intersection, Regions) are explained in detail in separate sections below.\u00a0 Before I do so, I want to explain how the ONS estimate ethnicity pay gaps using the <strong>Annual Population Survey.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #008000;\"><strong>What is the Annual Population Survey?<\/strong><\/span><\/h5>\n<p>You may already be familiar with ONS estimates of the UK gender pay gap which has been published annually since 1997.\u00a0 These are based on a random sample of HMRC payroll data which is known as <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/when-will-the-gender-pay-gap-disappear\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #ff0000;\"><strong>ASHE<\/strong><\/span> (which I describe in more detail here<\/a>).\u00a0 For tax and historical reasons, HMRC always hold a record of your age and sex hence why the ASHE dataset can be created and used for estimating gender pay gaps.\u00a0 However, HMRC do not hold records of your ethnicity (rightly so) which means ONS need to use a different dataset known as <span style=\"color: #0000ff;\"><strong>APS<\/strong><\/span> or <a href=\"https:\/\/www.ons.gov.uk\/employmentandlabourmarket\/peopleinwork\/employmentandemployeetypes\/methodologies\/annualpopulationsurveyapsqmi\" target=\"_blank\" rel=\"noopener\"><strong>Annual Population Survey<\/strong><\/a> to estimate ethnicity pay gaps.<\/p>\n<p>The APS is a subset of the larger <a href=\"https:\/\/www.ons.gov.uk\/employmentandlabourmarket\/peopleinwork\/employmentandemployeetypes\/methodologies\/labourforcesurveyuserguidance\" target=\"_blank\" rel=\"noopener\"><strong>Labour Force Survey<\/strong><\/a> (LFS) which measures many of our national employment statistics.\u00a0 Not every respondent is asked for their salary and hours information and not everyone invited to respond actually responds.\u00a0 As a result, whilst the sample in theory could be of a similar size to the ASHE sample used for gender pay gap reporting, the reality in 2022 is that the current sample size of <strong>47,000<\/strong> is only a quarter of what it could be.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5354 aligncenter\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-APS-Sample-Sizes.png\" alt=\"\" width=\"445\" height=\"278\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-APS-Sample-Sizes.png 2100w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-APS-Sample-Sizes-300x188.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-APS-Sample-Sizes-1024x640.png 1024w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-APS-Sample-Sizes-768x480.png 768w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-APS-Sample-Sizes-1536x960.png 1536w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-APS-Sample-Sizes-2048x1280.png 2048w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-APS-Sample-Sizes-450x281.png 450w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-APS-Sample-Sizes-1320x825.png 1320w\" sizes=\"auto, (max-width: 445px) 100vw, 445px\" \/><\/p>\n<p>Part of the reason for this is the COVID19 pandemic which made it harder to reach respondents.\u00a0 Prior to the pandemic, the sample size was almost twice as large.\u00a0 The fall in sample size is also seen in the wider Labour Force Survey and t<a href=\"https:\/\/www.ons.gov.uk\/employmentandlabourmarket\/peopleinwork\/employmentandemployeetypes\/methodologies\/labourforcesurveyplannedimprovementsanditsreintroduction\" target=\"_blank\" rel=\"noopener\">he ONS is concerned about this<\/a> and is actively investigating ways of improving the situation.\u00a0 The question we need to consider at this point is whether the APS is still good enough for measuring ethnicity pay gaps?<\/p>\n<p>In my opinion, it is still good enough because our main purpose when using this data is to compare trends between different groups.\u00a0 If our goal was to measure a national statistic of some kind, I would be more concerned since falling sample sizes could introduce a bias.\u00a0 Our goal though is comparison and even if there is an overall bias, it will only be problematic if the bias is more severe for some ethnicities than for others.\u00a0 I do not see evidence of such differential bias yet and therefore I still consider the <strong>APS<\/strong> to be suitable for ethnicity pay gap analysis.\u00a0 As will be seen in the forthcoming <strong>C_Trends<\/strong> section, the spreadsheet tracks sample weights over time and so far I am not seeing different trends in these by ethnicity.<\/p>\n<p>Unlike <span style=\"color: #ff0000;\"><strong>ASHE<\/strong><\/span> which takes its pay data direct from HMRC records, <strong>APS<\/strong> is a survey that asks respondents for their ethnicity, pay and hours information on top of other variables.\u00a0 That creates a potential source of additional error in the way people choose to respond to this question which is a voluntary one as well.\u00a0 To see the full list of questions asked in the Annual Population Survey, you can <a href=\"https:\/\/www.ons.gov.uk\/file?uri=\/employmentandlabourmarket\/peopleinwork\/employmentandemployeetypes\/methodologies\/labourforcesurveyuserguidance\/volume62022.pdf\" target=\"_blank\" rel=\"noopener\">download the user guide for 2022 here<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #008000;\"><strong>How does ONS measure UK ethnicity pay gaps?<\/strong><\/span><\/h5>\n<p>For each respondent, ONS calculate the hourly pay in a similar way to that done for gender pay gap reporting.\u00a0 The method is not quite identical since it is not possible for the interviewer to break down the respondent pay slips into different elements.\u00a0 Also the survey is carried out throughout the year unlike <span style=\"color: #ff0000;\"><strong>ASHE<\/strong><\/span> which is based on the 5th April of each year.<\/p>\n<p>Once calculated, ONS can then calculate the median hourly pay for each category of interest.\u00a0 All the <a href=\"https:\/\/www.ons.gov.uk\/employmentandlabourmarket\/peopleinwork\/earningsandworkinghours\/datasets\/ethnicitypaygapsrawpaygaps\" target=\"_blank\" rel=\"noopener\">raw data tables can be downloaded from the ONS website here<\/a>.\u00a0 I have used tables 1 to 8 from this link to create the spreadsheet you&#8217;ve downloaded and you will find a description of each table in the <strong>ONS_TABLES<\/strong> worksheet of your spreadsheet.<\/p>\n<p>In your spreadsheet, you will find the following <strong>5<\/strong> categories available for your analysis &#8211;<\/p>\n<ul>\n<li><strong>Ethnicity<\/strong> &#8211; two options, <span style=\"color: #0000ff;\"><strong>Big 5<\/strong><\/span> and <strong><span style=\"color: #ff0000;\">ONS18<\/span><\/strong><\/li>\n<li><strong>Sex<\/strong> &#8211; Men and Women<\/li>\n<li><strong>Age<\/strong> &#8211; 16 to 29 years old and 30 or older.<\/li>\n<li><strong>Where Born<\/strong> &#8211; In the UK or outside the UK.<\/li>\n<li><strong>Region<\/strong> &#8211; Scotland, Wales and the 9 regions of England.<\/li>\n<\/ul>\n<p>The <span style=\"color: #ff0000;\"><strong>ONS18<\/strong> <\/span>ethnicities are the ethnicities used in the 2021 census in England &amp; Wales.\u00a0 In 2021, this list consisted of 19 ethnicities but one (White-Roma) was new and is not used in the <strong>APS<\/strong>.\u00a0 The remaining <strong>18<\/strong> ethnicities can then aggregated into <strong>5<\/strong> higher level ethnic groups which are known as <span style=\"color: #0000ff;\"><strong>Big 5<\/strong><\/span>.\u00a0 In earlier releases, ONS also offered a 3rd category <strong>Binary<\/strong> where all non-white ethnic minorities were aggregated into a single category which used to be denoted as <strong>BAME<\/strong>.<\/p>\n<p>The table below shows the ethnicity profile of England and Wales in 2011 &amp; 2021 using <span style=\"color: #ff0000;\"><strong>ONS18<\/strong> <\/span>ethnicities which are then aggregated into <span style=\"color: #0000ff;\"><strong>Big 5<\/strong><\/span> and <strong>Binary<\/strong> as shown.\u00a0 Note that here <span style=\"color: #0000ff;\"><strong>Big 5<\/strong><\/span> is actually Big 6 but in the <strong>APS<\/strong>, White British &amp; White Other are combined into a single White category.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5355\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-Census-Ethnicity-Profile-of-Eng-Wal.png\" alt=\"\" width=\"706\" height=\"414\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-Census-Ethnicity-Profile-of-Eng-Wal.png 935w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-Census-Ethnicity-Profile-of-Eng-Wal-300x176.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-Census-Ethnicity-Profile-of-Eng-Wal-768x450.png 768w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-Census-Ethnicity-Profile-of-Eng-Wal-450x264.png 450w\" sizes=\"auto, (max-width: 706px) 100vw, 706px\" \/><\/p>\n<p>The shorthand codes shown in the table here (W-B, A-I, B-A, etc) are also used in your spreadsheet.<\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #008000;\"><strong>The importance of trends, sample sizes &amp; confidence intervals<\/strong><\/span><\/h5>\n<p>If you compare the <a href=\"https:\/\/www.ons.gov.uk\/employmentandlabourmarket\/peopleinwork\/earningsandworkinghours\/articles\/ethnicitypaygapsingreatbritain\/2012to2022\" target=\"_blank\" rel=\"noopener\">latest ONS release (November 2023)<\/a> with the <a href=\"https:\/\/www.ons.gov.uk\/employmentandlabourmarket\/peopleinwork\/earningsandworkinghours\/articles\/ethnicitypaygapsingreatbritain\/2019\" target=\"_blank\" rel=\"noopener\">previous release (October 2019),<\/a> you will see a number of changes, all of which I strongly welcome.\u00a0 They are &#8211;<\/p>\n<ol>\n<li>The abandonment of Binary ethnicity pay gaps.<\/li>\n<li>Including 95% confidence intervals alongside published pay gaps.<\/li>\n<li>Including sample sizes and population weight in data downloads.<\/li>\n<li>Specifying a minimum category size of 26.<\/li>\n<li>The emphasis on analysing long term trends rather than single year figures.<\/li>\n<\/ol>\n<p>The most common mistake I see among employers who attempt to analyse their payroll by ethnicity is the belief that all the complexity of such data can be reduced to a single statistic, namely the binary ethnicity pay gap which measures the difference between the median hourly pay of white employees and the median hourly pay of non-white employees.\u00a0 This happens because employers are mistakenly trying to replicate the gender pay gap reporting process which is centred around a binary gender pay gap statistic.<\/p>\n<p>The UK gender pay gap reporting system is inherently <strong>binary<\/strong> from the point of view of its metrics and reporting. It was a copy and paste of the Office of National Statistics (ONS) process <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/when-will-the-gender-pay-gap-disappear\/\">used since 1997 to measure the UK&#8217;s gender pay gap<\/a>. The ONS process was designed by statisticians for statisticians <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/pay-gaps-no-gender-or-ethnicity-pay-gap-in-2029\/\">and was never intended to be used by HR professionals<\/a> with no understanding of statistics. I consider this to be one of the reasons why mandatory gender pay gap reporting <a href=\"https:\/\/www.linkedin.com\/posts\/nigelmarriottcstat_genderpaygap-paygaps-gender-activity-7049336505319731200-nAeX\/?utm_source=share&amp;utm_medium=member_desktop\">has not had an observable effect on the UK gender pay gap<\/a> since 2017.<\/p>\n<p>Ethnicity is not binary as evidenced by the recent 2021 census <a href=\"https:\/\/www.ons.gov.uk\/methodology\/classificationsandstandards\/measuringequality\/ethnicgroupnationalidentityandreligion#ethnic-group\">which listed up to 19 ethnicities to choose from<\/a>. White and ethnic minority populations are not of equal size like men and women, they are majority and minority. <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/my-response-to-cred-recommendation-re-ethnicity-pay-gaps\/\">The ethnic majority to ethnic minority ratio varies enormously between geographical areas in the UK <\/a>unlike gender which has virtually the same ratio of men and women in all areas.<\/p>\n<p>These are the fundamental reasons why I have repeatedly said <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/my-review-of-uk-government-ethnicity-pay-gap-reporting-guidance\/\" target=\"_blank\" rel=\"noopener\">a binary ethnicity pay gap statistic is meaningless and actionless<\/a> so I am delighted the ONS now agree with me and will no longer publish such pay gaps.\u00a0 That doesn&#8217;t make the ONS report perfect as they continue to focus on pay gaps rather than representation gaps (<a href=\"https:\/\/marriott-stats.com\/nigels-blog\/ethnicity-pay-gap-reporting-using-income-quarters\/\" target=\"_blank\" rel=\"noopener\">which I first called for in 2020<\/a>) but they have also added new features which mitigate the worse features of pay gap statistics.<\/p>\n<p>The most important of these to my mind is the addition of <strong>95% Confidence Intervals<\/strong> to estimates of pay gaps.\u00a0 <img loading=\"lazy\" decoding=\"async\" class=\" wp-image-5359 alignright\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-conf-interval-demo.png\" alt=\"\" width=\"260\" height=\"232\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-conf-interval-demo.png 448w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-conf-interval-demo-300x268.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-conf-interval-demo-392x350.png 392w\" sizes=\"auto, (max-width: 260px) 100vw, 260px\" \/>The chart here shows an example of these which will appear again in the next section on <strong>C_Trends<\/strong> so I won&#8217;t explain everything now.\u00a0 What this shows is for every <strong>\u00a31<\/strong> paid per hour to the reference ethnicity (happens to be ONS18 White-British), the comparator ethnicity (happens to be ONS18 Black-Other) is paid so many pence more or less as shown by the black dashes.\u00a0 \u00a0If one had focused solely on these dashes, one might think there is a trend from 2012 when the comparator was paid <strong>13p<\/strong> more than the reference to 2022 when the comparator was paid <strong>13p<\/strong> less than the reference.<\/p>\n<p>However, the APS sample size for the reference ethnicity is low having fallen from <strong>100<\/strong> to <strong>50<\/strong> over that time which means there has to be a large margin of error in the estimate of the difference.\u00a0 This is what the 95% confidence intervals as represented by the shaded green bars either side of each black dash shows.\u00a0 The typical interpretation of these is that there is <strong>95%<\/strong> chance the true difference between reference and comparator lies within the range shown e.g. for 2012, the comparator is estimated to be paid between <strong>6p<\/strong> less and <strong>35p<\/strong> more than the reference and by 2022, the comparator is estimated to be paid between <strong>26p<\/strong> less and <strong>2p<\/strong> more than the reference.\u00a0 In both years, the no pay gap scenario of when the comparator is paid the same as the reference i.e. the difference is <strong>0p<\/strong>, is not ruled out because that scenario lies within the 95% confidence interval as is the case for all years between 2012 &amp; 2022.<\/p>\n<p>This does not mean we can conclude there is no pay gap between the comparator and reference, the wide confidence intervals are instead telling us to be cautious and not draw strong conclusions.\u00a0 The low sample size for the reference in this instance demands from us a respect for the laws of chance which tell us that significant changes from year to year can and will occur.\u00a0 By including such confidence intervals, the ONS force their readers to take note of this.<\/p>\n<p>I should point out the current APS sample size of 47,000 is typical of many large employers (The <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/why-the-dwp-median-gender-pay-gap-is-not-zero\/\" target=\"_blank\" rel=\"noopener\">Department for Work &amp; Pensions<\/a> employ twice as many).\u00a0 Most employers though will have a lot less than this and so consequently, their confidence intervals will be wider than this.\u00a0 This issue is much less common in gender because the ratio of men to women is basically equal wherever you are in the UK so even small employers are likely to have sample sizes sufficient to enable reasonable conclusions.\u00a0 With ethnicity though, some sample sizes will be very small and by using confidence intervals, one can convey the impact of such small sample sizes.<\/p>\n<p>In fact, the ONS have now instituted a policy of not calculating confidence intervals when the comparator sample size is <strong>25<\/strong> or less.\u00a0 They still publish the pay gap but it is explicitly flagged as statistically unreliable.\u00a0 One the features I did like about t<a href=\"https:\/\/marriott-stats.com\/nigels-blog\/my-review-of-uk-government-ethnicity-pay-gap-reporting-guidance\/\" target=\"_blank\" rel=\"noopener\">he new government guidance for ethnicity pay gap reporting<\/a> was its recommendation for a minimum category size of as least 50 be used for external reports and of at least 20 for internal reports.\u00a0 What the ONS have done is broadly consistent with the government recommendations especially when we bear in mind that the ONS report is prepared and written by professional statisticians whereas employer reports are written by HR professionals with little or no statistical skills.<\/p>\n<p>The other new feature of the ONS ethnicity pay gap reports is the greater emphasis on looking at long term trends rather than recent year on year changes.\u00a0 When one is working with small sample sizes, this is the only way to look at ethnicity pay gaps and is why I created the <strong>C_Trends<\/strong> worksheet in your spreadsheet.<\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #008000;\"><strong>How to use C_TRENDS<\/strong><\/span><\/h5>\n<p>This worksheet is split into 3 parts from left to right.<\/p>\n<ul>\n<li>On the left, you can state which categories you wish to designate as the reference and comparator.<\/li>\n<li>In the middle, you will find the output charts and tables.<\/li>\n<li>On the right are background calculations for the charts which you should ignore and not touch unless you know what you are doing.<\/li>\n<\/ul>\n<p>The reference &amp; comparator categories are specified by changing what is shown in the yellow cells in rows 5 &amp; 6 in columns C to G.\u00a0 The options you can enter here are shown below row 6 and in the dropdown lists provided.\u00a0 Note the orange cells in row 5 are currently formulas but once you understand why those formulas are being used, you can overwrite the formulas if you wish.<\/p>\n<p>In row 4 above these user input cells, you are told which set of ethnicities can be used with the other categories.\u00a0 The ONS does not publish all possible combinations of data hence why I put the reminder there.\u00a0 In short &#8211;<\/p>\n<ul>\n<li>When Region = GB and Sex, Age and Born are set to ALL, you can use either ONS18 or Big5 ethnicities.<\/li>\n<li>When using other regions, you can only use Big 5 ethnicities (W, B, A, M, O)<\/li>\n<li>When using Sex and Age categories, you can only use ONS18 ethnicities (W-B, B-C, A-P, etc)<\/li>\n<li>When using Born categories, you can use either ONS18 or Big5.<\/li>\n<li>You cannot use a combination of Region, Age, Sex, Born categories, you must choose only one of these 4 options at a time.<\/li>\n<\/ul>\n<p>In order for confidence intervals to be displayed properly, the reference ethnicity must be <strong>W<\/strong> (when using Big5) or <strong>W-B<\/strong> (when using ONS18).\u00a0 You can use different references if you want but the confidence intervals will not be shown if you do this.<\/p>\n<p>Let&#8217;s now look at the charts and tables in the middle part of the worksheet.\u00a0 To demonstrate this, enter <strong>W-B<\/strong> for the reference ethnicity in cell G5 and <strong>B-O<\/strong> in cell G6 for the comparator ethnicity.\u00a0 These are the ethnicities I used to demonstrate the confidence interval chart earlier and the full chart output looks like this.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5361 aligncenter\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-O.png\" alt=\"\" width=\"656\" height=\"366\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-O.png 892w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-O-300x167.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-O-768x429.png 768w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-O-450x251.png 450w\" sizes=\"auto, (max-width: 656px) 100vw, 656px\" \/><\/p>\n<p>This shows the pay gap &amp; confidence intervals chart you saw earlier along with the actually median hourly pay for W-B &amp; B-O on the left which is used to calculate the pay gap on the right.\u00a0 At the top of the graphic is a statement of what the reference and comparator ethnicities are.\u00a0 In the labels of the left hand chart, the average sample size over the years 2012 to 2022 is shown for the reference (<strong>52,271<\/strong>) and comparator (<strong>82<\/strong>) ethnicities.<\/p>\n<p>Looking at actual median hourly pay in the left hand chart, what do you see?\u00a0 The immediate feature are the large swings year on year in the median hourly pay of B-O whereas the median W-B pay shows fairly steady increases.\u00a0 Note I&#8217;ve added the national minimum hourly wage (for adults) for reference which has increased by over <strong>50%<\/strong> since 2012.\u00a0 The increase for W-B pay doesn&#8217;t quite match that but if one were to compare 2012 &amp; 2022 only for B-O pay, one would see almost no change.<\/p>\n<p>The above is the backdrop to the pay gap &amp; confidence interval chart.\u00a0 Recall, I showed earlier that we could not rule out the no pay gap scenario in each year even though the black dashes appear to show a downward trend.\u00a0 When you combine the two charts, which do you think is more likely; the apparent trend is real or the apparent trend is an artifact of the laws of chance given the low sample size for B-O ethnicity?\u00a0 My conclusion would be the latter.<\/p>\n<p>Analysing trends and determining whether they are real or not is a training course I run all the time.\u00a0 You can find out <a href=\"https:\/\/marriott-stats.com\/identifying-trends-in-data-making-forecasts\/\" target=\"_blank\" rel=\"noopener\">more details here<\/a> and I will running this <a href=\"https:\/\/rss.org.uk\/training-events\/training\/public-courses\/introduction-to-statistics\/identifying-trends-and-making-forecasts\/\" target=\"_blank\" rel=\"noopener\">via the Royal Statistical Society<\/a> if you would like to book a place.\u00a0 One of the tools I teach when trying to identify the underlying trend in data is the concept of a <strong>centred moving average<\/strong>.\u00a0 This is shown in the pay gap &amp; confidence interval chart as a dashed green line which represents the 5 year centred moving average.\u00a0 This is apparently showing a slow underlying flip from a small pay gap in favour of B-O to a small pay gap against B-O.\u00a0 In fact the trend here is not statistically significant but that is not the same as saying there is no trend, just that we can&#8217;t be certain there is a trend.<\/p>\n<p>In addition to the charts, the middle part of this worksheet includes a set of tables as below.\u00a0 Note the reference and comparator ethnicities are W-B and B-O respectively.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5362 aligncenter\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-O-TABLE.png\" alt=\"\" width=\"728\" height=\"292\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-O-TABLE.png 892w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-O-TABLE-300x120.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-O-TABLE-768x308.png 768w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-O-TABLE-450x181.png 450w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/p>\n<p>This table shows the numbers displayed in the charts plus some more information.\u00a0 First you can see the actual sample sizes for each year and a colour coding system is used to denote small sample sizes which is red for <strong>&lt;20<\/strong>, orange for <strong>&lt;50<\/strong> and yellow for <strong>&lt;100<\/strong>.\u00a0 This colour code is used throughout the spreadsheet.<\/p>\n<p>The second additional piece of information are the two <strong>Sample Weights<\/strong> in the last 2 columns on the right.\u00a0 The APS estimates the number of people working in the UK by ethnicity which allows ONS to design a sample that is representative of the working age population by ethnicity.\u00a0 For example, if <strong>5%<\/strong> of temployees belong to ethnicity <strong>A<\/strong>, then one would expect <strong>5%<\/strong> of the APS sample to belong to A.\u00a0 If in fact <strong>6%<\/strong> of APS sample were from A, then that ethnicity would be oversampled and the sample weight would <strong>0.83<\/strong> (= <strong>5%\/6%<\/strong>) i.e. less than <strong>1<\/strong>.\u00a0 If only <strong>4%<\/strong> of APS were from A, then the ethnicity would be undersampled and the sample weight would be <strong>1.25<\/strong> (= <strong>5%\/4%<\/strong>) i.e. greater than <strong>1<\/strong>.<\/p>\n<p>For W-B, the sample weight is more or less <strong>1<\/strong> whilst B-O varies between <strong>1.3<\/strong> &amp; <strong>1.6<\/strong> indicating that ethnicity is undersampled, suggesting a difficulty with recruitment.\u00a0 What would concern me here is less whether an ethnicity is under or over sampled but whether there is a clear trend to the sample weight away from 1 that could indicate an emerging bias in the pay gap estimate.\u00a0 Here I see no trend since the variation year on year is consistent with small sample sizes.<\/p>\n<p>Before I move on, I want to point out that throughout the spreadsheet, I display pay gaps using the format of for every <strong>\u00a31<\/strong> paid to the median reference employee, the median comparator employee is paid <strong>Xp<\/strong> less or more or they are paid <strong>\u00a3x.yz.<\/strong>\u00a0 The ONS continue to use the same format as gender pay gap reporting i.e. a pay gap of <strong>+10%<\/strong> means the median comparator employee is paid <strong>10%<\/strong> LESS than the median reference employee.\u00a0 I have never liked the standard reporting format as it is easy to misunderstand as I <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/gender-pay-gap-data-and-12-ways-to-improve-it\/\" target=\"_blank\" rel=\"noopener\">explain in the 1st point of this article<\/a>.<\/p>\n<p>Finally all charts in the spreadsheet are editable which means you can change the scales and colours if you wish.<\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #008000;\"><strong>How to use C_INTERSECTIONAL<\/strong><\/span><\/h5>\n<p>The intersectional tables shown in this worksheet can only be produced if you use <span style=\"color: #ff0000;\"><strong>ONS18<\/strong> <\/span>ethnicities, not Big 5.\u00a0 This worksheet runs off the ethnicities entered in <strong>C_Trends<\/strong> and provides a breakdown by <strong>Age, Sex<\/strong> and <strong>Where Born<\/strong> for the year of your choice which you can enter in the yellow cell E3.\u00a0 The example below shows the breakdown for 2022 for a comparison between the W-B (White-British) and B-C (Black Caribbean) ethnicities.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5364 aligncenter\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-C-Intersection.png\" alt=\"\" width=\"1249\" height=\"199\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-C-Intersection.png 1249w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-C-Intersection-300x48.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-C-Intersection-1024x163.png 1024w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-C-Intersection-768x122.png 768w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2012-2022-Trends-W-B-and-B-C-Intersection-450x72.png 450w\" sizes=\"auto, (max-width: 1249px) 100vw, 1249px\" \/><\/p>\n<p>Starting from the left, the first figures shown are the median hourly pay for W-B and B-C which are the same as those shown for 2022 in <strong>C_Trends<\/strong>.\u00a0 Below these, you can see that for every <strong>\u00a31<\/strong> paid to the median W-B employee, the median B-C employee is paid <strong>98p<\/strong> i.e. a small pay gap that is actually not significant when you look at the confidence intervals shown in <strong>C_Trends<\/strong>.\u00a0 Whilst this worksheet does not show confidence intervals, you can always get an idea of what these are by using <strong>C_Trends.<\/strong><\/p>\n<p>The first intersectional table is for <strong>Place of Birth<\/strong> which is either in the UK or overseas.\u00a0 For every <strong>\u00a31<\/strong> paid to the median UK born W-B employee, the median UK born B-C employee is paid slightly more at <strong>\u00a31.02<\/strong>.\u00a0 However, among those born overseas, the median B-C employee is paid <strong>76p<\/strong> for every \u00a31 paid to the median W-B employee which is a considerable gap.\u00a0 If one looks at the actual medians themselves, it is apparent that one reason for this is because for every <strong>\u00a31<\/strong> paid to the median W-B employee born in the UK, the median W-B employee born overseas is paid <strong>\u00a31.17<\/strong> which is what is shown in the Ratio column.<\/p>\n<p>The next table looks at <strong>Age<\/strong> which compares young employees with middle aged and older employees.\u00a0 This shows among those under 30, the median B-C employee is paid <strong>\u00a31.06<\/strong> for every <strong>\u00a31<\/strong> paid to the median W-B employee but this flips around among those over 30 where the median B-C employee is paid <strong>94p.<\/strong><\/p>\n<p>The last table looks at <strong>Sex<\/strong> with men as the reference category.\u00a0 I find this table the most interesting one here as this shows a clear <strong>interaction<\/strong> (the correct statistical term for intersectional) between ethnicity and age.\u00a0 Among men, the median B-C employee is paid less than the median W-B employee but among women, this is the other way around.\u00a0 Among W-B employees, the median man is paid more than the median women but among B-C employees, the median woman is paid more than the median man.\u00a0 When placed in order by median hourly pay from highest to lowest, the order is W-B man, B-C woman, B-C man, W-B woman.<\/p>\n<p>In addition to these tables, further tables are given underneath which showing the working age population, sample size and sample weights.\u00a0 These are there to help you decide if the observed intersections are likely to be the result of small sample sizes.\u00a0 For example, you might at first find the concept of White-British employees being born overseas somewhat unlikely and indeed, only <strong>3%<\/strong> of all W-B employees are born overseas which differs from Black-Caribbean employees where <strong>26%<\/strong> are born overseas.\u00a0 When you look at the working population table though you can see whilst a small population as a percentage, the overseas born White British population is in fact twice the size of the entire Black-Caribbean population.<\/p>\n<p>&nbsp;<\/p>\n<h5><strong><span style=\"color: #008000;\">How to use C_REGIONS<\/span><\/strong><\/h5>\n<p>This time, you can only analyse the data using <span style=\"color: #0000ff;\"><strong>Big5<\/strong><\/span> ethnicities.\u00a0 These are already preloaded into this worksheet along with the regions and the only thing you can change is which year to display which can be controlled by changing the value in the yellow cell H2.\u00a0 Another feature you can control is to suppress data where the sample size is below a certain threshold.\u00a0 This threshold is controlled by the yellow cell in H3.<\/p>\n<p>In the table shown here for 2022, all combinations of region and Big 5 ethnicity with a sample size less than<strong> 50<\/strong> are greyed out. <img loading=\"lazy\" decoding=\"async\" class=\" wp-image-5367 alignright\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2022-by-Region-Big5-TABLE.png\" alt=\"\" width=\"259\" height=\"226\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2022-by-Region-Big5-TABLE.png 374w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2022-by-Region-Big5-TABLE-300x261.png 300w\" sizes=\"auto, (max-width: 259px) 100vw, 259px\" \/> This table starts in cell B5 of the worksheet but the table is repeated lower down in cell B45 this time without any greying out of the data.\u00a0 The sample sizes appear on the right hand side in cell S5 and the confidence intervals appear on the left hand side in cell B27.<\/p>\n<p>The data in the table shown above is then plotted in the chart below.\u00a0 You are able to edit the chart so as to display certain ethnicities only rather than all ethnicities.\u00a0 By supressing small sample size estimates, the chart becomes easier to read.\u00a0 Note the order of the regions has been laid out based roughly on distance from London with the furthest away first before ending up in London.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5366 aligncenter\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2022-by-Region-Big5-Chart.png\" alt=\"\" width=\"404\" height=\"363\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2022-by-Region-Big5-Chart.png 544w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2022-by-Region-Big5-Chart-300x269.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2022-by-Region-Big5-Chart-390x350.png 390w\" sizes=\"auto, (max-width: 404px) 100vw, 404px\" \/><\/p>\n<p>A regional pattern should be apparent to you here and it is one I have seen before.\u00a0 Pay is highest in London followed by the commuter belt surrounding London in the East and South East regions.\u00a0 Further afield, little difference between regions is apparent.<\/p>\n<p>This pattern motivates the London effect table shown below the chart.\u00a0 One of the main reasons why ethnicity pay gap analysis cannot be done in the same way as for gender is because the ethnicity profile of London is so different from the rest of the UK.\u00a0 If you look at the first table below, you can see only <strong>10%<\/strong> of white employees work in London compared to roughly <strong>40%<\/strong> of all ethnic minorities.\u00a0 That means when you look at national median hourly pay, the figures for ethnic minorities are likely to be affected by the disproportionate number working in London and thus receiving a premium in pay.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5368 aligncenter\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2022-by-Region-Big5-LONDON.png\" alt=\"\" width=\"407\" height=\"349\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2022-by-Region-Big5-LONDON.png 544w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2022-by-Region-Big5-LONDON-300x257.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2024\/01\/ONS-EPG-2022-by-Region-Big5-LONDON-409x350.png 409w\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" \/><\/p>\n<p>This disparity can create some apparent paradoxical results which is a phenomena known as <strong>Simpson&#8217;s Paradox<\/strong>.\u00a0 I have written about this before in my article &#8220;<a href=\"https:\/\/marriott-stats.com\/nigels-blog\/does-novartis-have-a-gender-pay-gap-or-not\/\" target=\"_blank\" rel=\"noopener\"><em>What is the gender pay gap at Novartis?<\/em><\/a>&#8221; and such effects are much more likely to happen when analysing ethnicity.\u00a0 In the second table, the median hourly pay for all permutations of region and ethnicity are all shown using the national median hourly pay for white employees as the reference i.e. <strong>\u00a31<\/strong>.\u00a0 So for example, although the median Other employee is paid less than the median White employee in all 3 regions, the fact that nearly half of Other employees are based in London means the median Other employee nationally is paid more than the median white employee nationally.<\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #008000;\"><strong>In conclusion<\/strong><\/span><\/h5>\n<p>As an instruction guide for my spreadsheet, this is a definitely a long one!\u00a0 I had no choice but to take time to go through it in this detail because it is so important you grasp that ethnicity pay gap analysis is not the same as gender pay gap analysis.\u00a0 You will have to pay attention to sample sizes, think about what minimum sample sizes should be specified and become comfortable with confidence intervals if you insist on focusing on median hourly pay.\u00a0 Most of all, you will have to look at trends over time and learn how to interpret these.\u00a0 This is what the ONS has now decided to do with their ethnicity pay gap reports and I commend them for making these changes.<\/p>\n<p>&nbsp;<\/p>\n<h5><strong><span style=\"color: #993300;\">&#8212; Would you like to comment on this article? &#8212;-<\/span><\/strong><\/h5>\n<p>Please do leave your comments on either of these <a href=\"https:\/\/www.linkedin.com\/posts\/nigelmarriottcstat_nigel-marriott-marriottnigel-on-x-activity-7150142561012060160-b5Cs?utm_source=share&amp;utm_medium=member_desktop\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #008000;\"><strong>LinkedIn<\/strong><\/span><\/a> or <a href=\"https:\/\/twitter.com\/MarriottNigel\/status\/1744371634037735769\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #008000;\"><strong>X\/Twitter<\/strong><\/span><\/a> threads.<\/p>\n<h5><strong><span style=\"color: #993300;\">&#8212; Subscribe to my newsletter to receive more articles like this one! &#8212;-<\/span><\/strong><\/h5>\n<p>If you would like to receive notifications from me of news, articles and offers relating to diversity &amp; pay gaps, please <span style=\"color: #008000;\"><strong><a style=\"color: #008000;\" href=\"https:\/\/marriott-stats.com\/nigels-blog\/subscribe-to-our-newsletter\/\" target=\"_blank\" rel=\"noopener\">click here to go to my Newsletter Subscription page<\/a><\/strong><\/span> and tick the Diversity category and other categories that may be of interest to you.\u00a0 You will be able to unsubscribe at anytime.<\/p>\n<h5><span style=\"color: #993300;\"><strong>&#8212; Want to know more about pay gaps?\u00a0 &#8212;<\/strong><\/span><\/h5>\n<p>You will find a full list of my pay gap &amp; diversity related articles <span style=\"color: #008000;\"><strong><a style=\"color: #008000;\" href=\"https:\/\/marriott-stats.com\/nigels-blog\/stats-training-materials-pay-gap-analytics\/\" target=\"_blank\" rel=\"noopener noreferrer\">here which are grouped by theme<\/a><\/strong><\/span>.<\/p>\n<h5><span style=\"color: #993300;\"><strong>&#8212; Can I help you to close your pay gap? &#8212;<\/strong><\/span><\/h5>\n<p>I offer the following services to my clients who want to define, measure, analyse, improve &amp; control their pay gaps.<\/p>\n<ol>\n<li><a href=\"https:\/\/marriott-stats.com\/pay-gap-analytics\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #993300;\"><strong><span style=\"color: #008000;\">Analysis<\/span><\/strong><\/span> <\/a>&#8211; I can dig deep into your data to identify the key drivers of your pay gaps.\u00a0 I can build a model using a large number of variables such as pay band, seniority, job function, location, etc and use this to identify the priority areas for closing your gaps.<\/li>\n<li><a href=\"https:\/\/marriott-stats.com\/introduction-to-pay-gap-analytics\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #993300;\"><strong><span style=\"color: #008000;\">Training<\/span><\/strong><\/span><\/a> &#8211; I run training courses in basic statistics which are designed for non-statisticians such as people working in HR.\u00a0 The courses will show you how to perform the relevant calculations in Microsoft Excel, how to interpret what they mean for you and how to incorporate these in an action plan to close your gaps.<\/li>\n<li><a href=\"https:\/\/marriott-stats.com\/expert-witness\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #993300;\"><strong><span style=\"color: #008000;\">Expert Witness<\/span><\/strong><\/span><\/a> &#8211; Has your gender pay gap data uncovered an issue resulting in legal action?\u00a0 Need an expert independent statistician who can testify whether the data supports or contradicts a claim of discrimination?\u00a0 I have experience of acting as an expert witness for either plaintiff or defendant and I know how to testify and explain complex data in simple language that can be easily understood by non-statisticians.<\/li>\n<\/ol>\n<p>If you would like to have a no-obligation discussion about how I can help you, <strong><span style=\"color: #008000;\"><a style=\"color: #008000;\" href=\"https:\/\/marriott-stats.com\/contact-us\/\" target=\"_blank\" rel=\"noopener noreferrer\">please do contact me<\/a><\/span><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In November 2023, the Office of National Statistics (ONS) resumed publishing estimates of the UK Ethnicity Pay Gap after a 3 year hiatus for the Covid19 pandemic.\u00a0 I have organised this data into a user-friendly (hopefully!) Microsoft Excel spreadsheet which allows you to see how the median hourly pay has changed between 2012 &amp; 2022 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":5359,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[64,6],"tags":[323,101,82,117,324,122,325,179,190,46],"class_list":{"0":"post-5351","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-diversity","8":"category-forecasting","9":"tag-annual-population-survey","10":"tag-confidence-intervals","11":"tag-ethnicity","12":"tag-ethnicity-pay-gap","13":"tag-intersectional","14":"tag-median","15":"tag-moving-average","16":"tag-ons","17":"tag-pay-gap-trends","18":"tag-trend-analysis","19":"entry","20":"override"},"_links":{"self":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/5351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/comments?post=5351"}],"version-history":[{"count":12,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/5351\/revisions"}],"predecessor-version":[{"id":5417,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/5351\/revisions\/5417"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/media\/5359"}],"wp:attachment":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/media?parent=5351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/categories?post=5351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/tags?post=5351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}