{"id":1216,"date":"2020-06-01T11:03:07","date_gmt":"2020-06-01T10:03:07","guid":{"rendered":"https:\/\/marriott-stats.com\/nigels-blog\/?p=1216"},"modified":"2020-08-22T11:48:41","modified_gmt":"2020-08-22T10:48:41","slug":"gender-pay-gap-calculator","status":"publish","type":"post","link":"https:\/\/marriott-stats.com\/nigels-blog\/gender-pay-gap-calculator\/","title":{"rendered":"Pay Gap Tools #1 – Where can I find a gender pay gap calculator?"},"content":{"rendered":"

** Update 22nd August 2020 ***<\/em><\/p>\n

I am no longer offering a free spreadsheet tool.\u00a0<\/strong><\/span><\/p>\n

<\/p>\n

Whilst all the calculations for gender pay gap submission can indeed be done in a spreadsheet using simple functions, you have to make sure that the raw data you enter in the spreadsheet is correct.\u00a0 I have realised the government’s gender pay gap regulations are much more complex than first thought and my spreadsheet is not capable of verifying that you have entered the correct data.\u00a0 I can advise you on how to enter the correct data but this is a service I charge for but you will receive an advanced version of my pay gap calculator spreadsheet which offers more functionality including diagnostics of why you have a pay gap.<\/p>\n

My advanced pay gap spreadsheet is also included if you purchase either a 3 Hour 1-on-1 Coaching session<\/a><\/strong> which can be run at a time convenient for you or book a place on my 1-day training course “Turn your Pay Gap Data into Insights & Actions<\/em><\/strong>“<\/a>.\u00a0 Both options cost \u00a3395+VAT.<\/p>\n

 <\/p>\n

Notes on previous iterations of this post<\/strong><\/span><\/h4>\n

Update 22nd August 2020 <\/em><\/span>– If you have already downloaded a copy of my free spreadsheet, please remember that I did make this explicit statement at the time.<\/p>\n

“As this spreadsheet is free, I offer no guarantees as to its accuracy and cannot be held responsible should an error arise.”<\/strong><\/span><\/p>\n

As I say, the formulas in the spreadsheet are correct provided you have entered the data correctly.\u00a0 Errors in entering the raw data are more likely if you pay your employees bonuses.\u00a0 If you do not pay bonuses, then it is much easier to enter the correct data.<\/p>\n

Update 24th June 2020 – Version 3 of my calculator was released.\u00a0 After reading the fine detail of the Equality Act 2010 and the government guidance (and I mean the fine detail!) I realised that version 1 was correct after and version 2 is incorrect.\u00a0 Employers are required to report their hourly pay including bonuses not excluding them.\u00a0 This version corrects that and adds a few extra features.<\/em><\/span><\/p>\n

Update 4th March 2020 – Version 2 of my calculator was released.\u00a0 I discovered an error in version 1 which could lead to incorrect figures being calculated for employers who pay large amounts of bonuses to a large number of employees.\u00a0 There should have been no material error if you pay only a few employees bonuses or the size of the bonus is small.<\/em><\/span><\/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 many topics.\u00a0 Click here to see an organised list of these articles<\/a>.<\/p>\n

    Alternatively, 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<\/ol>\n","protected":false},"excerpt":{"rendered":"

      ** Update 22nd August 2020 *** I am no longer offering a free spreadsheet tool.\u00a0<\/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":[76,63],"class_list":{"0":"post-1216","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-archive","7":"tag-calculator","8":"tag-gender-pay-gap","9":"entry","10":"override"},"_links":{"self":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/1216","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=1216"}],"version-history":[{"count":14,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/1216\/revisions"}],"predecessor-version":[{"id":3195,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/1216\/revisions\/3195"}],"wp:attachment":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/media?parent=1216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/categories?post=1216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/tags?post=1216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}