• Blog home
  • Elections
  • Polling
  • Sport
  • Weather
  • Forecasting
  • Diversity
  • Stats Training
  • Misc
  • Archive
  • Twitter
  • Back to Marriott Statistical Consulting

Nigel Marriott's Blog

An independent statistician using data to understand our world and to predict the future

You are here: Home / Archive / Pay Gap Tools #1 – Where can I find a gender pay gap calculator?

Pay Gap Tools #1 – Where can I find a gender pay gap calculator?

June 1, 2020 By Nigel

** Update 22nd August 2020 ***

I am no longer offering a free spreadsheet tool. 

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.  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.  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.

My advanced pay gap spreadsheet is also included if you purchase either a 3 Hour 1-on-1 Coaching session 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“.  Both options cost £395+VAT.

 

Notes on previous iterations of this post

Update 22nd August 2020 – If you have already downloaded a copy of my free spreadsheet, please remember that I did make this explicit statement at the time.

“As this spreadsheet is free, I offer no guarantees as to its accuracy and cannot be held responsible should an error arise.”

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

Update 24th June 2020 – Version 3 of my calculator was released.  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.  Employers are required to report their hourly pay including bonuses not excluding them.  This version corrects that and adds a few extra features.

Update 4th March 2020 – Version 2 of my calculator was released.  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.  There should have been no material error if you pay only a few employees bonuses or the size of the bonus is small.

 

– Need help with interpreting your pay gaps? –

I offer the following services.

  1. Analytics – I can dig deep into your data to identify the key drivers of your pay gaps.  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.
  2. Training – I run training courses in basic statistics which are designed for non-statisticians such as people working in HR.  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.
  3. Expert Witness – Has your gender pay gap data uncovered an issue resulting in legal action?  Need an expert independent statistician who can testify whether the data supports or contradicts a claim of discrimination?  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.

If you would like to have a no-obligation discussion about how I can help you, please do contact me.

– Want to know more about pay gaps?  –

I have written a number of articles about pay gaps covering many topics.  Click here to see an organised list of these articles.

Alternatively, visit my Twitter thread to see my comments on gender pay gaps in the media.  Some notable ones are here.

  1. My complaint about comments made by the head of the TUC on the 2018 pay gap.
  2. Some observations on the government’s guidance to producing gender pay gap statistics and the numerous deficiencies in these.
  3. My comments on why incorrect gender pay gap data is being submitted.

Filed Under: Archive Tagged With: Calculator, Gender Pay Gap

Search this site

More blogs

Trophy Winners #2 – England Women’s Club Football 1992 to 2023

The 2022/23 Women's Super League (WSL) ended with both Chelsea & Man Utd achieving the double, … [Read More...] about Trophy Winners #2 – England Women’s Club Football 1992 to 2023

Pay Gap Trends #6 – Are we there yet?

Has 6 years of mandatory gender pay gap reporting (GPGR) made a dent in the UK's gender pay gap?  … [Read More...] about Pay Gap Trends #6 – Are we there yet?

Pay Gap Data #6 – Where can I find gender pay gap data for 2022?

This post was updated on 8th May 2023 with the latest data The government requires all … [Read More...] about Pay Gap Data #6 – Where can I find gender pay gap data for 2022?

UK Weather Tracker #75 – April 2023

The weather in the UK in April was average, very very average!  All 7 weather variables that I track … [Read More...] about UK Weather Tracker #75 – April 2023

UK Weather Tracker #74 – March 2023

As we move from February to March, it normally gets warmer and brighter in the UK.  Unusually, March … [Read More...] about UK Weather Tracker #74 – March 2023

Subscribe to Our Newsletter

Join our newsletter mailing list

Receive latest news, articles and offers

Select the categories of interest:

We are GDPR compliant. Read our privacy and Cookie policy for more info.

Check your inbox or spam folder to confirm your subscription.

Copyright © 2023 ·Registered in England, Company No. 5577275, VAT No. 883304029. Registered Office – 65 Bristol Road, Keynsham, Bristol, BS31 1EG