Waar gaat deze meeting over?
Lennert will share his thoughts on how to apply regression in a robust way, still based on excel, for analyzing the sources of wage disparities in anticipation of EU PTD.
In the first part of the meeting, Lennert will delve into specifics of a preferred way of doing regression analyses, multiple regression based on the so called "Blinder-Oaxaca Decomposition" method. The second part will be a pragmatic and hands-on display on how to start a Multiple Regression in Excel and decompose it.
Stream:
Key take-aways:
In this session, participants explored how multiple regression and the Blinder-Oaxaca decomposition method can be used to analyze wage gaps and support the implementation of the EU Pay Transparency Directive. The discussion emphasized the importance of using pay grades over levels, maintaining data hygiene, and aligning regression factors with organizational pay philosophies. The session also encouraged collaborative learning through shared databases and tools like Excel and R.
- Use pay grades over levels to improve explanatory power and reduce unexplained wage gaps.
- Excel is a good starting point, but tools like R offer better scalability for complex datasets.
- Align regression variables with pay setting principles to ensure transparency and consistency.
- Include historical performance data to uncover long-term patterns and potential bias.
- Collaborate via the Rumbold calculation engine to test models and share insights.
(This message is AI generated by Copilot and based on information relevant to this meeting)
