This Course has passed
To close a gender pay gap you have to do three things:
- Measure where you are today.
- Specify where you want to be in the future.
- Identify the most effective way of getting there.
All 3 steps require the use of statistical thinking and statistical methods. Of course, other skills and processes are also needed but they cannot succeed on their own without the help of statistics.
The aim of the course is to provide an introduction to HR data analytics. It will help participants interpret gender pay gap data and identify how to close a gap using statistical thinking and the basic functions of Microsoft Excel.
This course is tailored to HR & other professionals with little or no statistical skills and will teach the basics required to get started.
Who should attend this course?
Anyone who has to produce, present and report on gender pay gap data and develop and track actions to close pay gaps. It does not matter which department you work in, if you are any way involved in your organisations gender pay gap reporting process and are struggling with how to calculate the figures in the first place and/or to understand what they mean for your organisation, then this is the course for you.
The course will held at the Chequers Inn, 50 Rivers St, Bath BA1 2QA, UK and will start at 9.15am and finish at 5pm. Lunch will be provided.
In order to get the most out of this course, participants will require:
- Completion of a pre-course questionnaire before attending the course.
- An awareness of the basic requirements of gender pay gap reporting.
- Some familiarity with employment practices that could help close pay gaps.
- A laptop with Microsoft Excel installed. A spreadsheet with the data to be analysed during the course will be emailed to you before the course.
- Be comfortable with the basic operations of Microsoft Excel such as entering data, undertaking simple calculations such as the average and producing simple charts.
It is important to note that this course is not a training course in Microsoft Excel or the details of the legislation about gender pay gap reporting hence why some familiarity with these is needed. However, you will learn additional details about both of these topics during the course.
What you will learn?
The course begins with the calculation of the mandatory statistics that you have to submit in your statutory gender pay gap report and we will explore what they do and do not tell you i.e.
- Mean and median gender pay gap & bonus gap
- The four income quartiles and the gender breakdown within each
The course then introduces you to additional ways to make your figures more meaningful and easier to interpret. These methods can also be used to identify the most effective way to close a gender pay gap once you have specified where you want to be. Specifically:
- How to plot your results in a variety of chart formats.
- How to interpret your results especially your income quartile data.
- How to prepare and interpret a year on year comparison.
- How to identify where more in-depth analysis may be worthwhile.
Having worked out where your organisation is today and why you have a gender pay gap, the course will then help you to figure out what “success” looks like for your organisation in the future, including:
- How to work out what no gender pay gap would look like in your organisation.
- How to identify if that goal is achievable in the next few years by analysing the pay gaps of other employers.
- Using the above two steps to specify what your goal looks like in terms of the mandatory statistics and any additional statistics.
Finally, using the tools we covered earlier for understanding our pay gaps in more depth, we can work out the most effective way to achieve our goals, specifically:
- How to identify the key drivers of your pay gaps
- How to separate the internal drivers from external drivers
- How to work out which statistics will need to be tracked over time and thus should be included in your action plan.
The course will have ample opportunities for you to practice the calculations in Microsoft Excel and will introduce you to a spreadsheet template which you can use for your own data both during and after the course.
Your course instructor
Nigel Marriott is an Independent Statistician and fellow of the Royal Statistical Society. He has been running basic statistics courses aimed at non-statisticians for 17 years. Feedback has consistently noted that Nigel has a rare ability to explain what looks like complicated statistics in a simple manner that makes it easy for you to understand and apply what you are learning.
Find out what previous course attendees think of Nigel.
Nigel also blogs extensively on issues of diversity and pay gaps and you can find all his blogs here.
The course fee is £395 +VAT per person.
Other Training Courses in Statistics
We offer a wide range of statistical training courses covering numerous topics. We provide in-house training as well as public courses like this one. You can find out more details here.