{"id":2376,"date":"2020-06-02T21:21:51","date_gmt":"2020-06-02T20:21:51","guid":{"rendered":"https:\/\/marriott-stats.com\/nigels-blog\/?p=2376"},"modified":"2021-03-08T17:26:28","modified_gmt":"2021-03-08T17:26:28","slug":"gender-pay-gap-data-2019","status":"publish","type":"post","link":"https:\/\/marriott-stats.com\/nigels-blog\/gender-pay-gap-data-2019\/","title":{"rendered":"Pay Gap Data #3 – Where can I find gender pay gap data for 2019?"},"content":{"rendered":"

This post was updated on 3rd June 2020 with the latest data<\/em><\/p>\n

Update 5\/4\/20 –\u00a0 On 24th March, the government suspended enforcement of the deadline for reporting 2019 gender pay gaps<\/a> due to the coronavirus outbreak<\/a>.\u00a0 As of now, Only 40% of employers have reported their 2019 data.\u00a0 Employers are still required to report 2019 data but will not be punished for being late in doing so.<\/em><\/p>\n

The government requires all organisations employing 250 or more employees to submit gender pay gap data.\u00a0 All data is available to the public and can be found on the government’s gender pay gap website<\/a>.\u00a0 I have downloaded this data and created a spreadsheet tool to present the data in a more user-friendly and visual format.<\/p>\n

<\/p>\n

The latest set of submissions are supposed to be uploaded by 5th April 2020 but these figures refer to pay made in April 2019 i.e. a year ago.\u00a0 From the end of April 202o, organisations can submit their 2020 data and not wait for the deadline of April 2021.\u00a0 So far only 14 have done so but I have not yet added this data to the spreadsheet.<\/p>\n

You are very welcome to download this spreadsheet and make use of the charts and tables within.\u00a0 I would appreciate it if you could credit me with the creation of the charts.<\/p>\n

Download my spreadsheet here >>> Gender Pay Gap Data & Chart Tool v4.3<\/a><\/strong><\/span><\/span><\/span><\/span><\/h4>\n

IMPORTANT!<\/strong> – you may get an error message when you click on some of the menu dropdowns and tick boxes in this spreadsheet.\u00a0 This message is misleading and can be ignored by clicking OK.\u00a0 If you save the download as a Macro-Enabled workbook then the error message should disappear.\u00a0 Also please note the workbook is currently optimised for Excel in Windows.\u00a0 It does work in Excel for a Mac but I am aware of some features not working as intended on a Mac.\u00a0 I am in the process of trying to correct the Mac issues.<\/p>\n

The EMPLOYERSUMMARY<\/strong> sheet summarises an employer’s gender pay gap data for a particular year and you can change the year that is displayed if you wish.\u00a0 On opening it, select the organisation you want to view from the dropdown box (please note there can be over 10,000 organisations!).\u00a0\u00a0There are also some calculations of year on year trends and these provide clues as to whether the organisation has entered its data correctly.\u00a0 You can find out more about these in my article “Year on Year Trends, the Good, Bad & Unilever<\/em><\/a>“.<\/p>\n

The COMPAREEMPLOYERS<\/strong> sheet is a new feature that allows you to choose 20 employers and compare them side by side.\u00a0 It is currently preloaded with the 20 teams from the English Premier League for the 2018\/19 season but you can overwrite with your chosen employers.\u00a0 A full list of employers in given in column R of this sheet.\u00a0 In addition, it is now possible on the EMPLOYERSUMMARY<\/strong> sheet to restrict the list of employers in the menu box to just your chosen list of 20 employers.\u00a0 Instructions are given in the HELP and COMPAREEMPLOYERS sheet but please note you may get an error message.\u00a0 The error message is misleading and can be ignored by clicking OK and continuing to use the spreadsheet.<\/p>\n

There is an ISSUES<\/strong> sheet which highlights some organisations that appear to have made errors.<\/p>\n

There is a HELP<\/strong> sheet which youth\u00a0 can read for more information.\u00a0 The spreadsheet contains links which provide more explanation of what is being presented but you will find most of this information in my article “7 ways to misuse gender pay gap data<\/em><\/a>“.<\/p>\n

I will make a point of keeping this spreadsheet up to date as organisations upload new data so please bookmark this page and come back to see if the version number has changed.\u00a0 I will also let you know via my twitter feed<\/a> if changes have been made.<\/p>\n

If you have any comments or questions about my spreadsheet, please do contact me<\/a>.<\/p>\n

 <\/p>\n

– Need help with interpreting your pay gaps? –<\/strong><\/span><\/h4>\n

I offer the following services.<\/p>\n

    \n
  1. Analytics<\/span><\/strong><\/span><\/a>\u00a0– 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
  2. Training<\/span><\/strong><\/span><\/a> – 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
  3. Expert Witness<\/span><\/strong><\/span><\/a> – 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 as can be seen from my testimony to the Treasury Select Committee<\/a>.<\/li>\n<\/ol>\n

    If you would like to have a no-obligation discussion about how I can help you, please do contact me<\/a>.<\/p>\n

    – Want to know more about pay gaps?\u00a0 –<\/strong><\/span><\/h4>\n

    I have written a number of articles about pay gaps covering these topics:-<\/p>\n

      \n
    1. What gender pay gap data tells us, what it doesn’t tell us and how it can be misused<\/a><\/li>\n
    2. Why the gender pay gap is not the same as unequal pay<\/a><\/li>\n
    3. Three distinct errors that have been made by at least 10% of all organisations when submitting their gender pay gap data<\/a><\/li>\n
    4. How to distinguish between a true pay gap and a pay gap that arises naturally due to the laws of chance<\/a><\/li>\n
    5. Why Gender Pay Fingerprints are superior to Gender Pay Gaps<\/a><\/li>\n
    6. Why winning an equal pay tribunal can widen a gender pay gap<\/a><\/li>\n
    7. My 12 steps to improve public confidence in gender pay gap data<\/a><\/li>\n
    8. My evidence to the Treasury Select Committee on how gender pay gap reporting could be improved<\/a><\/li>\n
    9. Calculate your gender pay gap by downloading my free spreadsheet calculator!<\/a><\/li>\n
    10. Did the gender pay gap narrow in 2018?<\/a><\/li>\n
    11. How to identify unusual year on year changes in gender pay gaps<\/a><\/li>\n
    12. How to close your pay gap with DMAIC<\/a><\/li>\n
    13. Should the UK introduce Ethnicity Pay Gap reporting?<\/a><\/li>\n
    14. What is best way to do Ethnicity Pay Gap reporting?<\/a><\/li>\n
    15. Frequently Asked Questions about gender pay gaps.<\/a><\/li>\n<\/ol>\n

      Finally visit my Twitter thread<\/a> to see my comments on gender pay gaps in the media.\u00a0 Some notable ones are here.<\/p>\n

        \n
      1. My complaint about comments made by the head of the TUC on the 2018 pay gap.<\/a><\/li>\n
      2. Some observations on the government’s guidance to producing gender pay gap statistics and the numerous deficiencies in these<\/a>.<\/li>\n
      3. My comments on why incorrect gender pay gap data is being submitted<\/a>.<\/li>\n
      4. At last, the BBC publishes a good article on gender pay gaps!<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

        This post was updated on 3rd June 2020 with the latest data Update 5\/4\/20 –\u00a0 On 24th March, the government suspended enforcement of the deadline for reporting 2019 gender pay gaps due to the coronavirus outbreak.\u00a0 As of now, Only 40% of employers have reported their 2019 data.\u00a0 Employers are still required to report 2019 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"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":[90],"tags":[161,70,63,40],"class_list":{"0":"post-2376","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-archive","7":"tag-161","8":"tag-data-quality","9":"tag-gender-pay-gap","10":"tag-presenting-data","11":"entry","12":"override"},"_links":{"self":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/2376","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=2376"}],"version-history":[{"count":10,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/2376\/revisions"}],"predecessor-version":[{"id":3639,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/2376\/revisions\/3639"}],"wp:attachment":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/media?parent=2376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/categories?post=2376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/tags?post=2376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}