{"id":4113,"date":"2021-08-09T16:21:51","date_gmt":"2021-08-09T15:21:51","guid":{"rendered":"https:\/\/marriott-stats.com\/nigels-blog\/?p=4113"},"modified":"2022-12-31T12:41:49","modified_gmt":"2022-12-31T12:41:49","slug":"swap-numbers-tell-you-how-many-years-it-will-take-you-to-close-your-pay-gap","status":"publish","type":"post","link":"https:\/\/marriott-stats.com\/nigels-blog\/swap-numbers-tell-you-how-many-years-it-will-take-you-to-close-your-pay-gap\/","title":{"rendered":"Pay Gaps #23A &#8211; How long will it take to close your pay gap?"},"content":{"rendered":"<p>Five months ago, I introduced the <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/what-you-need-to-do-to-eliminate-your-gender-pay-gap\/\" target=\"_blank\" rel=\"noopener\">gender swap number as a superior statistic to the median gender pay gap<\/a>.\u00a0 Feedback from clients and others since then has confirmed my hope they would find it more intuitive to use and interpret.\u00a0 This encouraged me to call on <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/how-uk-gender-pay-gap-regulations-should-be-changed\/\" target=\"_blank\" rel=\"noopener\">Parliament to amend the UK gender pay gap legislation so that swap numbers could be published<\/a> for employers with 250 or more employees.\u00a0 I now want to build on this by showing a couple of simple calculations that can turn a swap number into an estimate of how long it will take an employer to close its pay gap.<\/p>\n<p><!--more--><\/p>\n<h5><strong><span style=\"color: #008000;\">What do these 8 employers have in common?<\/span><\/strong><\/h5>\n<p>All have published their 2020 gender pay gap data (<a href=\"https:\/\/marriott-stats.com\/nigels-blog\/latest-gender-pay-gap-data\/\" target=\"_blank\" rel=\"noopener\">which you can find here)<\/a> and all stated they had between 250 &amp; 499 employees.\u00a0 For the purposes of this article, I am going to assume each employer here has 400 employees.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4115\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40.png\" alt=\"\" width=\"1275\" height=\"601\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40.png 6206w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-300x141.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-1024x483.png 1024w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-768x362.png 768w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-1536x724.png 1536w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-2048x966.png 2048w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-450x212.png 450w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-1320x623.png 1320w\" sizes=\"auto, (max-width: 1275px) 100vw, 1275px\" \/><\/p>\n<p>The answer is that they all have a <span style=\"color: #008000;\"><strong>Gender Swap Number per 1,000 Employees (GSN1K)<\/strong> <\/span>of 40, -40 in the case of Nestle Waters and +40 for the other 7 employers.\u00a0 \u00a0Even though the median woman earn very different amounts per hour at these employers, the amount of work needed to close their pay gaps to zero is the same on average.\u00a0 I will demonstrate shortly a simple formula that you can use to estimate that on average, it will take each employer 27 years to reduce their GSN1K to below 2.5 assuming their average annual turnover of employees is 10%.<\/p>\n<p>Why does the median gender pay gap vary so much across these 8 employers even if they have the same GSN1K?\u00a0 The short answer is that they have different pay scales and the long answer can be found under recommendation 5 of <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/how-uk-gender-pay-gap-regulations-should-be-changed\/\" target=\"_blank\" rel=\"noopener\">my 7+5 recommendations for improving pay gap reporting<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #008000;\"><strong>How to calculate a Swap Number for any employer<\/strong><\/span><\/h5>\n<p>You can skip this section if you already know how to calculate swap numbers.<\/p>\n<p>I explain <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/what-you-need-to-do-to-eliminate-your-gender-pay-gap\/\" target=\"_blank\" rel=\"noopener\">the full calculation in this article<\/a> and demonstrate it <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/ryanair-gender-pay-gap-report-is-the-best\/\" target=\"_blank\" rel=\"noopener\">using Ryanair as an example<\/a> but here is a reminder of how to calculate the swap number for any pair of employee categories.\u00a0 I will use men &amp; women as the two categories here but the swap number calculation can be used for any two categories of employees e.g. you could replace men &amp; women below with able-bodied &amp; disabled.<\/p>\n<ol>\n<li><span style=\"color: #993300;\"><strong><span style=\"color: #000000;\">Count the number of men and women in each of the 4 pay quarters<\/span>.<\/strong><\/span>\n<ul>\n<li>You will have already done this calculation if you are legally obliged to submit gender pay gap data to the government.<\/li>\n<\/ul>\n<\/li>\n<li><span style=\"color: #000000;\"><strong>Count the number of men and women in each of the 2 pay halves<\/strong>\u00a0by <\/span>combining the relevant pay quarters i.e.\n<ul>\n<li><span style=\"color: #0000ff;\"><strong>M(lh)<\/strong>\u00a0= Lower Half Men = Number of men in lower pay quarter + number of men in lower middle pay quarter.<\/span><\/li>\n<li><span style=\"color: #ff0000;\"><strong>F(lh)<\/strong> = Lower Half Women = Number of women in lower pay quarter + number of women in lower middle pay quarter.<\/span><\/li>\n<li><span style=\"color: #0000ff;\"><strong>M(uh) <\/strong>= Upper Half Men = Number of men in upper pay quarter + number of men in upper middle pay quarter.<\/span><\/li>\n<li><span style=\"color: #ff0000;\"><strong>F(uh) <\/strong>= Upper Half Women = Number of women in upper pay quarter + number of women in upper middle pay quarter.<\/span><\/li>\n<li><strong>N<\/strong> = Total number of employees = <span style=\"color: #0000ff;\"><strong>M(lh)<\/strong><\/span> + <strong><span style=\"color: #0000ff;\">M(uh)<\/span><\/strong>+ <strong><span style=\"color: #ff0000;\">F(lh)<\/span> <\/strong>+ <strong><span style=\"color: #ff0000;\">F(uh)<\/span><\/strong><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"color: #000000;\"><strong>Calculate the Swap Numbers separately for each gender<\/strong><\/span>:-\n<ul>\n<li><span style=\"color: #0000ff;\"><strong>MSN<\/strong> = Male Swap Number = ( M(lh) &#8211; M(uh) )\/2 = ( number of men in lower pay half &#8211; number of men in upper pay half )\/2<\/span><\/li>\n<li><span style=\"color: #ff0000;\"><strong>FSN <\/strong>= Female Swap Number = ( F(lh) &#8211; F(uh) )\/2 = ( number of women in lower pay half &#8211; number of women in upper pay half )\/2<\/span><\/li>\n<li>By definition <span style=\"color: #0000ff;\"><strong>MSN<\/strong><\/span> &amp; <span style=\"color: #ff0000;\"><strong>FSN<\/strong><\/span> must have opposite signs unless one or both are equal to zero e.g. if <strong><span style=\"color: #ff0000;\">FSN<\/span><\/strong> is +10 then <strong><span style=\"color: #0000ff;\">MSN<\/span><\/strong> should be -10 but can be -9 or -11 if one gender has an even number of employees and the other gender has an odd number of employees.<\/li>\n<\/ul>\n<\/li>\n<li><span style=\"color: #000000;\"><strong>Calculate the Gender Swap Number (Rate per 1000 employees)<\/strong><\/span>\n<ul>\n<li><strong><span style=\"color: #008000;\">GSN<\/span> = <span style=\"color: #008000;\">Gender Swap Number <\/span><\/strong>= (<span style=\"color: #ff0000;\">FSN<\/span> &#8211; <span style=\"color: #0000ff;\">MSN<\/span>)\/2 = we subtract one from the other because <span style=\"color: #0000ff;\">MSN<\/span> &amp; <span style=\"color: #ff0000;\">FSN<\/span> have opposite signs as explained above.<\/li>\n<li><span style=\"color: #008000;\"><strong>GSN1<\/strong><\/span><span style=\"color: #008000;\"><strong>K<\/strong><\/span> = <strong><span style=\"color: #008000;\">Gender Swap Number per 1000 Employees<\/span><\/strong> = <strong><span style=\"color: #008000;\">GSN<\/span><\/strong> * 1000 \/ <strong>N =<\/strong> multiply GSN by 1,000 and divide by total number of employees.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>So if you&#8217;ve followed the calculations correctly and assumed the 8 employers above have 400 employees each, then by step 3, you should have a <span style=\"color: #008000;\"><strong>Gender Swap Number (GS<span style=\"color: #008000;\">N<\/span><\/strong>)<\/span> of +16 for the 7 employers that have a\u00a0 majority of their female employees in the lower pay half and -16 for Nestle Waters who have a majority of their female employees in the upper pay half.\u00a0 \u00a0In other words, to eliminate the median gender pay gap, 16 men in the upper pay half have to swap places with 16 women in the lower pay half for 7 employers whereas at Nestle Waters, 16 women in the upper half have to swap places with 16 men in the lower pay half.\u00a0 When you proceed to step 4, these GSNs become <span style=\"color: #008000;\"><strong>Gender Swap Number per 1000 Employees (GSN1K)<\/strong> <\/span>of +40 for 7 employers and -40 for Nestle Waters.<\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #008000;\"><strong>Why will it take 27 years to close the pay gap?<\/strong><\/span><\/h5>\n<p>I will demonstrate with Martins Craft Bakery but you can repeat everything I do here for the other 8 employers and get the same answer.<\/p>\n<p>The 27 year estimate with 10% annual employee turnover requires the following assumptions to be made.\u00a0 It is unlikely that all will hold for all 8 employers.<\/p>\n<ol>\n<li><strong>The total number of employees remains unchanged<\/strong> &#8211; I am assuming that Martins Craft Bakery has 400 employees today and that will never change.<\/li>\n<li><strong>Men &amp; women are equally likely to leave the employer each year<\/strong> &#8211; If I assume that 10% of employees leave Martins Craft Bakery every year then I also assuming that 10% of the men and 10% of the women will leave every year.<\/li>\n<li><strong>The gender ratio of new employees will be the same as the current gender ratio<\/strong> &#8211; In 2020, 80% of employees at Martins Craft Bakery were women and again I assume that 80% of new employees in every year going forward will also be women.<\/li>\n<li><strong>The gender ratio of new employees will be the same for each pay quarter<\/strong> &#8211; in addition to assuming 80% of new employees will be female going forward, I also assume this will be the case in each pay quarter.<\/li>\n<li><strong>The annual turnover of employees will be the same in every year<\/strong> &#8211; since I am assuming that Martins Craft Bakery has 400 employees, if I then assume 10% of employees are leaving and being replaced every year, I am assuming that this turnover is always 10% of 400 i.e. every year 40 employees at Martins Craft Bakery leave and are replaced.<\/li>\n<\/ol>\n<p>With these assumptions, you should be able to work out that I am assuming that 8 men and 32 women leave Martins Craft Bakery every year and are replaced by 8 men and 32 women so they always have 80 men and 320 women.\u00a0 However, what changes each year is from which pay quarters do the men and women leave from.<\/p>\n<p>If 2020 is year 0, let&#8217;s look at what will happen in year 1 in each pay quarter.\u00a0 Note I need to allow fractional employees to exist i.e. 1.5 men and 2.8 women, etc, in order to demonstrate the mathematics here.<\/p>\n<ul>\n<li><strong>Upper Pay Quarter<\/strong> &#8211; 10% of men and 10% of women will leave as per assumption 2 i.e. <strong>4.1 men and 5.9 women leave<\/strong>.\u00a0 They are replaced by 2 men and 8 women as per assumption 4.\u00a0 This means at the end of year 1, there will be 2.1 fewer men and 2.1 more women in this pay quarter i.e. there will be 38.9 men and 61.1 women.<\/li>\n<li><strong>Upper Middle Pay Quarter<\/strong> &#8211; 10% of men and 10% of women will leave as per assumption 2 i.e. <strong>1.4 men and 8.6 women leave<\/strong>.\u00a0 They are replaced by 2 men and 8 women as per assumption 4.\u00a0 This means at the end of year 1, there will be 0.6 more men and 0.6 fewer women in this pay quarter i.e. there will be 14.6 men and 85.4 women.<\/li>\n<li><strong>Lower Middle Pay Quarter<\/strong> &#8211; 10% of men and 10% of women will leave as per assumption 2 i.e. <strong>0.6 men and 9.4 women leave<\/strong>.\u00a0 They are replaced by 2 men and 8 women as per assumption 4.\u00a0 This means at the end of year 1, there will be 1.4 more men and 1.4 fewer women in this pay quarter i.e. there will be 7.4 men and 92.6 women.<\/li>\n<li><strong>Lower Pay Quarter<\/strong> &#8211; 10% of men and 10% of women will leave as per assumption 2 i.e. <strong>1.7 men and 8.3 women leave<\/strong>.\u00a0 They are replaced by 2 men and 8 women as per assumption 4.\u00a0 This means at the end of year 1, there will be 0.3 more men and 0.3 fewer women in this pay quarter i.e. there will be 17.3 men and 82.7 women.<\/li>\n<\/ul>\n<p>Note how the total number of men leaving is 8 and the total number of women leaving is 32 but the breakdown by pay quarter differs.<\/p>\n<p>Now let&#8217;s recalculate the <span style=\"color: #008000;\"><strong>GSN1k<\/strong> <\/span>for year 1.<\/p>\n<ul>\n<li><span style=\"color: #0000ff;\"><strong>M(lh)<\/strong> <\/span>= 24.7 = 17.3+7.4, <span style=\"color: #ff0000;\"><strong>F(lh)<\/strong><\/span> = 175.3 = 82.7+92.6,<\/li>\n<li><span style=\"color: #0000ff;\"><strong>M(uh)<\/strong> <\/span>= 53.5 = 14.6+38.9, <span style=\"color: #ff0000;\"><strong>F(uh)<\/strong><\/span> = 146.5 = 85.4+61.1<\/li>\n<li><span style=\"color: #0000ff;\"><strong>MSN<\/strong> <\/span>= (24.7-53.5)\/2 = -14.4, <span style=\"color: #ff0000;\"><strong>FSN<\/strong><\/span> = (175.3-146.5)\/2 = +14.4<\/li>\n<li><span style=\"color: #008000;\"><strong>GSN<\/strong><\/span> = (14.4 &#8211; (-14.4) )\/2 = +14.4<\/li>\n<li><span style=\"color: #008000;\"><strong>GSN1K<\/strong><\/span> = +14.4*1000\/400 = +36<\/li>\n<\/ul>\n<p>So the GSN1k for Martin&#8217;s Craft Bakery has narrowed from +40 to +36 i.e. a fall of 10% which happens to be annual employee turnover we assumed.\u00a0 If you now start from year 1 and calculate year 2 using the 5 assumptions, the year 2 GSN1K will be +32.4, a fall of 3.6 which is again 10% of the year 1 GSN1K of +36.\u00a0 In other words, if the 5 assumptions hold, the GSN1K falls by the same percentage as the employee turnover each year.<\/p>\n<p>That makes for a very simple mathematical formula which is &#8211;<\/p>\n<ul>\n<li><span style=\"color: #008000;\"><strong>GSN1k<\/strong><\/span>[ <strong><span style=\"color: #000080;\">y<\/span><\/strong> ] = <strong><span style=\"color: #008000;\">GSN1k<\/span><\/strong>[ <strong>0<\/strong> ] * (1 &#8211; <span style=\"color: #993300;\"><strong>t<\/strong><\/span>)^<span style=\"color: #000080;\"><strong>y<\/strong><\/span>, where<\/li>\n<li><strong><span style=\"color: #000080;\">y<\/span> <\/strong>= number of <span style=\"color: #993300;\"><strong>y<\/strong><\/span>ears since year 0 i.e. today.<\/li>\n<li><strong><span style=\"color: #993300;\">t<\/span><\/strong> = annual employer <span style=\"color: #993300;\"><strong>t<\/strong><\/span>urnover as a decimal e.g. 10% is entered as 0.1<\/li>\n<li>The formula works just as well if you want to use the actual GSN rather than GSN1k<img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4116 alignright\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-time-to-close-gap.png\" alt=\"\" width=\"205\" height=\"589\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-time-to-close-gap.png 230w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-time-to-close-gap-104x300.png 104w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-time-to-close-gap-122x350.png 122w\" sizes=\"auto, (max-width: 205px) 100vw, 205px\" \/><\/li>\n<\/ul>\n<p>You can now extrapolate this formula forward into the future for as many years as you want which I have done in the table to the right.\u00a0 Three columns are shown for annual employee turnover of 5%, 10% and 20% where the GSN1k starts at +40 in year 0.\u00a0 Notice this formula will never reduce the GSN1k to exactly zero so you need to choose a target value that more or less represents zero for your employer.\u00a0 Since I am assuming that Martins Craft Bakery has 400 employees, then 1 employee equals 2.5 employees per 1,000 employees hence why I set the target for closing the median gender pay gap for Martins to be a GSN1k of less than 2.5.\u00a0 As you can see, it will take 27 years if turnover annual employee turnover is 10% and 13 years if annual employee turnover is 20%.<\/p>\n<p>When turnover is 5%, the table doesn&#8217;t tell us how many years it takes for GSN1k to fall below 2.5 since it is greater than 30 years.\u00a0 I could have easily extrapolated it further into the future but there is a direct formula that tells you how many years it will take GSN1k to reach a target value if the 5 assumptions hold.\u00a0 This is &#8211;<\/p>\n<ul>\n<li><strong><span style=\"color: #008000;\">G<\/span><\/strong> = target value for <span style=\"color: #008000;\"><strong>GSN1k<\/strong><\/span>.<\/li>\n<li><strong><span style=\"color: #993300;\">t<\/span><\/strong> = annual employer <span style=\"color: #993300;\"><strong>t<\/strong><\/span>urnover as a decimal e.g. 10% is entered as 0.1<\/li>\n<li><strong>Y<\/strong> = number of years for GSN1k to fall below G.<\/li>\n<li><strong>Y<\/strong> = [ LN( <span style=\"color: #008000;\"><strong>G<\/strong> <\/span>) &#8211; LN( <span style=\"color: #008000;\"><strong>GSN1k<\/strong><\/span>[ <strong>0<\/strong> ] ) ] \/ LN( 1 &#8211; <span style=\"color: #993300;\"><strong>t<\/strong><\/span> )<\/li>\n<li>where <strong>LN()<\/strong> is the natural logarithm formula in Microsoft Excel.<\/li>\n<li>Again you can use GSN rather than GSN1k if you prefer.<\/li>\n<\/ul>\n<p>So if <span style=\"color: #993300;\"><strong>t<\/strong><\/span>=0.05, <strong><span style=\"color: #008000;\">G<\/span><\/strong>=+2.5, <strong><span style=\"color: #008000;\">GSN1k[0]<\/span><\/strong>=+40 then <strong>Y<\/strong> = (LN(2.5)-LN(40))\/LN(1-0.05) = 54 years.<\/p>\n<p>Of course, the 5 assumptions are not going to hold for every year even if on average they happen to be true.\u00a0 To see how such variation can affect Y, please read my article &#8220;<a href=\"https:\/\/marriott-stats.com\/nigels-blog\/closing-gender-pay-gap-will-take-a-generation\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #993300;\"><em>Eliminate your pay gap by playing Blackjack<\/em><\/span><\/a>&#8221; which uses computer simulation to explore this.\u00a0 That article includes a spreadsheet you can download to carry out your own simulation.\u00a0 My simulations result in the same conclusion that should be obvious from the table above, namely that in years when you have high employee turnover, that is the time to go all out on efforts to significantly reduce the underrepresentation of the relevant employee category in the relevant pay quarter.\u00a0 In years of low employee turnover, you won&#8217;t be able to do much.<\/p>\n<p>The simulations address another issue with the formulas I&#8217;ve given above which is that it is not possible with the 5 assumptions for a GSN to change from positive to negative and vice versa.\u00a0 In reality this will happen due to random chance when the GSN is close to zero.<\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #008000;\"><strong>Will every employer with GSN1k of 40 take 27 years to reduce that to 2.5?<\/strong><\/span><\/h5>\n<p>As I said before, the formula for estimating the number of years to close a pay gap for a certain level of employee turnover is only true if 5 assumptions are made.\u00a0 Thus the estimate is simply an average and it is up to the employer to work out by how much they are likely to vary from those assumptions.\u00a0 As <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/closing-gender-pay-gap-will-take-a-generation\/\" target=\"_blank\" rel=\"noopener\">my Blackjack article noted<\/a>, growth provides the best opportunity to change a pay gap since you are increasing the total number of employees rather than keeping it constant and thus the new employees where you hope to address historical under-representations will make up a bigger part of your workforce.<\/p>\n<p>What about the 8 employers we started out with?\u00a0 Even though on average, they will take 27 years to close the pay gap with 10% annual employee turnover, are there other factors that might lead us to say this employer will be faster and that employer will be slower?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4115\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40.png\" alt=\"\" width=\"1141\" height=\"538\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40.png 6206w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-300x141.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-1024x483.png 1024w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-768x362.png 768w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-1536x724.png 1536w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-2048x966.png 2048w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-450x212.png 450w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-with-GSN1K-of-40-1320x623.png 1320w\" sizes=\"auto, (max-width: 1141px) 100vw, 1141px\" \/><\/p>\n<p>Here are my thoughts.\u00a0 Feel free to take a different view since I am not an expert in these industries!<\/p>\n<ol>\n<li><strong>Rayleigh Schools Trust<\/strong> &#8211; the upper pay quarter which presumably includes the senior teachers and heads is more male than the other 3 quarters but even then it is still 3\/4 female.\u00a0 The real issue is increasing the number of men in the lower pay quarters.\u00a0 If this is a primary school trust, I cannot see many men wanting to work in these roles.\u00a0 I think this will take longer than 27 years due to social expectations of men and women beyond the capacity of this employer to resolve alone.<\/li>\n<li><strong>HSBC Global Asset Management<\/strong> &#8211; HSBC is a massive global organisation and this is only a small branch.\u00a0 So the pay gap could disappear tomorrow through restructuring of subsidiaries alone, something I highlighted in my article &#8220;<a href=\"https:\/\/marriott-stats.com\/nigels-blog\/gpg-yoy-trends-unilever-2\/\" target=\"_blank\" rel=\"noopener\"><em><span style=\"color: #993300;\">the good, the bad and the Unilever<\/span><\/em><\/a>&#8220;.\u00a0 Of course, the finance industry is known for very high salaries being predominantly earned by men so progress is not going to be quick but I do think they can make quicker progress than a primary school.<\/li>\n<li><strong>Nestle Waters UK<\/strong> &#8211; Like HSBC, this is again a subsidiary of a much larger organisation and restructuring can close it overnight.\u00a0 I do hope Nestle are not falling into the trap of thinking a pay gap that favours women is a good thing which <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/does-novartis-have-a-gender-pay-gap-or-not\/\" target=\"_blank\" rel=\"noopener\">I have seen some organisations do like Novartis UK<\/a>.\u00a0 They have a large pay gap and it should be addressed with the same vigour as one that favours men.\u00a0 Unlike HSBC and the finance industry, Nestle and indeed the food industry at large (<a href=\"https:\/\/marriott-stats.com\/nigels-blog\/gender-pay-gap-and-life-on-mars\/\" target=\"_blank\" rel=\"noopener\">which I used to work in)<\/a> has no shortage of women in high paid roles and I think they will be one of the quicker employers to close their pay gap.<\/li>\n<li><strong>Warner Bros Entertainment<\/strong> &#8211; Another small subsidiary of a much larger company.\u00a0 Again I think this gap can be closed quicker than 27 years.\u00a0 At the moment, conglomerates are not required to report for the whole group and I explained in my article &#8220;<a href=\"https:\/\/marriott-stats.com\/nigels-blog\/close-your-gender-pay-gap-the-quick-and-easy-way\/\" target=\"_blank\" rel=\"noopener\"><em>10 quick and easy ways to close your pay gap<\/em><\/a>&#8221; why this is not desirable.\u00a0 Recommendation E of my <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/how-uk-gender-pay-gap-regulations-should-be-changed\/\" target=\"_blank\" rel=\"noopener\">7+5 recommendations for amending UK pay gap legislation<\/a> calls for this to be changed.<\/li>\n<li><strong>Martins Craft Bakery<\/strong> &#8211; I do not think they are part of a conglomerate so restructuring is out here.\u00a0 What is notable from the pay quarters (or <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/pay-gaps-14-why-use-gender-pay-fingerprint\/\" target=\"_blank\" rel=\"noopener\">fingerprints as I like to call them<\/a>) is that men are skewed towards the top pay quarter in what is a female dominant employer.\u00a0 Given my earlier comments about the food industry generally being a good place for women to progress their careers, I think looks like an issue specific to this employer which needs addressing.\u00a0 I suspect rapid progress could be made here if they choose to put their mind to it.<\/li>\n<li><strong>NE Derbyshire Council<\/strong> &#8211; This is a 50:50 M:F employer with women making up the majority of the lower pay half and men making up the majority of the upper pay half.\u00a0 There is no opportunity to restructure as part of a conglomerate, they are likely to be on public sector union negotiated pay scales which are unlikely to change so any change has to come from more women applying for higher paid roles and more men for lower paid roles.\u00a0 The latter may be the harder bit and so I can easily see them taking 27 years to close this pay gap.<\/li>\n<li><strong>Wateraid<\/strong> &#8211; As a charity, they are unlikely to be paying high salaries.\u00a0 I would not be surprised if a large number of employees are earning the same.\u00a0 However, I can see this employer being the fastest to close their pay gap and that is because of the lower middle pay quarter today.\u00a0 This is 75% women compared to 55% women in the upper pay half.\u00a0 That suggests that if a promotion drive aimed at women in this pay quarter was launched which moves them up to the upper middle pay quarter, they could make rapid progress.\u00a0 They still need to address the lower pay quarter which is predominantly women but the quarter above offers an opportunity to take a big step at the beginning.<\/li>\n<li><strong>Europa Warehouse<\/strong> &#8211; Despite having one of the smallest actual pay gaps (median women earns 98p for every \u00a31 earned by the median man), I can see this employer struggling to close the last mile.\u00a0 First it must said that the reason why the pay gap is so small is that the majority of employees are probably on the same pay scale with only a few managers earning a lot more.\u00a0 But this employer is 75% female in the lower pay quarter whilst nearly 50:50 elsewhere.\u00a0 That suggests a set of roles, maybe admin, that are overwhelmingly female and paid slightly less than other roles.\u00a0 If so, making those roles less female may take a long long time.<\/li>\n<\/ol>\n<p>Of course this where the employer can own their narrative when they submit their gender pay gap data.\u00a0 Rather than letting me try to explain why it will take 27 years, they can instead say why that is a load of rubbish because of what they are planning to do.\u00a0 That is why I would like to add to recommendation 5 of my <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/how-uk-gender-pay-gap-regulations-should-be-changed\/\" target=\"_blank\" rel=\"noopener\">7+5 recommendations for amending UK pay gap legislation<\/a> a call for the GEO to publish the estimated number of years it will take the employer to close the pay gap.\u00a0 That could prompt employers to say &#8220;<span style=\"color: #993300;\"><em>hang on, that&#8217;s not right and here&#8217;s why<\/em><\/span>&#8220;.\u00a0 I see too many employers just submitting numbers when in fact they should owning their pay gap report and swap numbers &amp; the associated estimate of Y could be the stick that get them moving.<\/p>\n<p>&nbsp;<\/p>\n<h5><span style=\"color: #008000;\"><strong>Is the Maximum GSN1K useful?<\/strong><\/span><\/h5>\n<p>I&#8217;d like to finish on a related point which is an optional extra but some people may find it useful.<\/p>\n<p>The 8 employers I&#8217;ve used here all have the same gender swap number but they have different maximum GSN1k&#8217;s.\u00a0 By maximum, I mean given the gender ratio the employer has today, what is the worse possible swap number they could have?\u00a0 For example, NE Derbyshire is 50:50 M:F and the worst possible outcome for the swap number would be if men made up 100% of the upper pay half and women 100% of the lower pay half.\u00a0 Then the GSN1k would be +250 so placed against that, NE Derbys current +40 looks a long way from worst case scenario.\u00a0 That differs from Rayleigh Schools Trust where its worse case scenario is +87 so the current +40 is almost half way to worst case.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4118\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-summary.png\" alt=\"\" width=\"591\" height=\"213\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-summary.png 591w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-summary-300x108.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2021\/08\/Gender-Swap-Number-8-employers-summary-450x162.png 450w\" sizes=\"auto, (max-width: 591px) 100vw, 591px\" \/><\/p>\n<p>The calculation of the maximum GSN1k for an employer is simple to do.\u00a0 All you need is the swap number calculation for the smaller category of employees and then imagine all of that category being put in the either the upper or lower pay half.\u00a0 So in the case of Nestle &amp; HSBC, women are the minority category so we use the FSN calculation.\u00a0 The same goes for NE Derbys since it doesn&#8217;t matter which one we use since it&#8217;s 50:50 there.\u00a0 For the other 5 employers, men are the minority and so we use the MSN calculation.\u00a0 It turns out a simple formula is the following &#8211;<\/p>\n<ul>\n<li><strong>M<\/strong> = number of employees in the minor category<\/li>\n<li><strong>T<\/strong> = total number of employees<\/li>\n<li><strong>Max GSN1k<\/strong> = <strong>M<\/strong>\/2*1000\/<strong>T<\/strong><\/li>\n<\/ul>\n<p>Note employers submit pay quarter data to 1 decimal place hence why rounding error means NE Derbys actual maximum GSN1k is +248 not +250.<\/p>\n<p>As I said, I see the Max GSN1k as an optional extra but it is another way of picking up employers who appear to have a relatively low swap number but when you calculate it as a percentage of a maximum, you realise they are close to a worse case scenario.\u00a0 It is the gender dominant (male or female) employers like the bottom two above that will get picked up by this metric but note they are still facing the same amount of time as other employers on average when it comes to closing their pay gap.<\/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:\/\/twitter.com\/MarriottNigel\/status\/1425074586442473472\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #008000;\"><strong>Twitter <\/strong><\/span><\/a>or <a href=\"https:\/\/www.linkedin.com\/feed\/update\/urn:li:activity:6830530129622556672\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #008000;\"><strong>LinkedIn<\/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; Need help with understanding your pay gap? &#8212;<\/strong><\/span><\/h5>\n<p>I offer the following services.\u00a0 Please click on the headings for more details.<\/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>Five months ago, I introduced the gender swap number as a superior statistic to the median gender pay gap.\u00a0 Feedback from clients and others since then has confirmed my hope they would find it more intuitive to use and interpret.\u00a0 This encouraged me to call on Parliament to amend the UK gender pay gap legislation [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":4115,"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],"tags":[105,216,148,244],"class_list":{"0":"post-4113","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-diversity","8":"tag-closing-gaps","9":"tag-pay-fingerprint","10":"tag-pay-gaps","11":"tag-swap-number","12":"entry","13":"override"},"_links":{"self":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/4113","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=4113"}],"version-history":[{"count":14,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/4113\/revisions"}],"predecessor-version":[{"id":4803,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/4113\/revisions\/4803"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/media\/4115"}],"wp:attachment":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/media?parent=4113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/categories?post=4113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/tags?post=4113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}