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.
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.
Booking a course.
To book a training course, call 01225 489033 or email firstname.lastname@example.org.
On occasion, we will run 1 or more of our standard courses as a public course available to all. These take place throughout the year in the beautiful city of Bath. Discounts are available for people booking more than 1 day. See our list of scheduled training courses available to book online now.