0% found this document useful (0 votes)
27 views5 pages

Gender Pay Gap Analysis at Winner Plc

This document describes an analysis conducted to determine if there is gender discrimination in salaries at Winner Plc. The analysis of a sample of 50 employees found the average salary for men was £8,400 higher than for women. Additional analyses were conducted to examine the relationships between salary and gender, experience and gender, and salary, gender and experience. The results indicate there is a significant difference in salaries and experience based on gender, but experience accounts for some of the salary difference. Further analysis is needed to better model the relationship between salary and experience and determine if gender discrimination exists.

Uploaded by

Larry ZHENG
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
27 views5 pages

Gender Pay Gap Analysis at Winner Plc

This document describes an analysis conducted to determine if there is gender discrimination in salaries at Winner Plc. The analysis of a sample of 50 employees found the average salary for men was £8,400 higher than for women. Additional analyses were conducted to examine the relationships between salary and gender, experience and gender, and salary, gender and experience. The results indicate there is a significant difference in salaries and experience based on gender, but experience accounts for some of the salary difference. Further analysis is needed to better model the relationship between salary and experience and determine if gender discrimination exists.

Uploaded by

Larry ZHENG
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Winner Plc

Salary Discrimination?

“The gender pay gaps detailed by British companies in recent months surprised
almost no one — men are paid more than women, often by a wide margin, at the vast
majority of businesses.

But by making companies publicly air their salary information, Britain intends to
force a reckoning. Officials in London hope the embarrassing revelations in the
reports, which had to be submitted by Wednesday, will shame companies into doing
more to close the divide. ”, New York Times, April 2018

At the last board meeting of Winner Plc., the headquarters of a large multinational company,
the issue was raised; that women were being discriminated in the company, in the sense
that the salaries were not the same for male and female executives. A quick analysis of a
sample of 50 employees (of which 24 men and 26 women) revealed that the average salary
for men was about £8,400 higher than for women. This seemed like a considerable
difference, so it was decided that a further analysis of the company salaries was warranted.
In the table on the next page, the salaries of the 50 executives in the sample are given.

Assignment

You are asked to carry out the analysis. The ultimate objective is to find out whether there is
indeed a significant difference between the salaries of men and women, and whether the
difference is due to discrimination or whether it is based on another, possibly valid,
determining factor.

2
1. Relationship Salary – Gender ?

Download the Excel file “Winner [Link]” from Blackboard to your personal drive. The Excel file
contains the salaries for the sample of 50 executives in the company. Can you conclude that
there is a significant difference between the salaries of the male and female executives?

Perform all different types of analyses, and check whether they all lead to the same
conclusion:

 Confidence intervals
 Hypothesis testing
 Correlation analysis
 Regression (gender can be formulated as a “dummy” independent variable: gender =
0 if male, gender = 1 if female)

Male employee Salary Female employee Salary


1 £79,400 1 £57,000
2 £67,400 2 £61,300
3 £66,500 3 £62,000
4 £72,600 4 £70,100
5 £63,600 5 £45,600
6 £74,500 6 £71,200
7 £76,400 7 £64,700
8 £67,900 8 £53,800
9 £61,600 9 £60,900
10 £75,500 10 £62,700
11 £64,500 11 £76,400
12 £73,400 12 £57,900
13 £76,100 13 £68,200
14 £72,200 14 £65,800
15 £69,600 15 £60,300
16 £53,100 16 £62,600
17 £65,500 17 £67,000
18 £78,400 18 £62,700
19 £77,600 19 £54,700
20 £82,000 20 £71,400
21 £59,800 21 £50,400
22 £80,800 22 £71,800
23 £74,800 23 £64,100
24 £71,000 24 £70,400
25 £53,100
26 £60,900

Average £71,008 Average £62,577

3
2. Relationship Experience – Gender?

At the board meeting, someone raised the issue that there was indeed a substantial
difference between male and female salaries, but that this was attributable to other reasons
such as differences in experience. A questionnaire send out to the 50 executives in the
sample reveals that the average experience of the men is approximately 21 years, whereas
the women only have about 7 years experience on average (see table below).

Download the Excel file “Winner [Link]” from Blackboard to your personal drive. The Excel file
contains the years of experience for the sample of 50 executives in the company.

Based on this evidence, can you conclude that there is a significant difference between the
experience of the male and female executives? Perform similar analyses as in Section 1. Does
your conclusion validate or endanger your conclusion about the difference in male and
female salaries?

Male employee Experience Female employee Experience


1 16 1 2
2 25 2 2
3 15 3 3
4 33 4 16
5 16 5 0
6 19 6 29
7 32 7 3
8 34 8 0
9 1 9 1
10 44 10 2
11 7 11 21
12 14 12 0
13 33 13 8
14 19 14 11
15 24 15 5
16 3 16 11
17 17 17 18
18 19 18 2
19 21 19 0
20 31 20 19
21 6 21 0
22 35 22 15
23 20 23 4
24 23 24 20
25 0
26 0

Average 21.1 Average 7.4

4
3. Relationship Salary – Experience ?

Someone at the meeting argues that clearly, a more thorough analysis of the relationship
between salary and experience is required before any conclusion can be drawn about
whether there is any gender‐based salary discrimination in the company.

Download the Excel file “Winner [Link]” from Blackboard to your personal drive. The Excel file
contains the salary and experience for the sample of 50 executives in the company. Analyse
the relationship between salary and experience. What can you conclude for the relationship
of salary and experience? Choose the type of analysis you think is suitable.

4. Relationship Salary – Gender ‐ Experience ?

Download the Excel file “Winner [Link]” from Blackboard to your personal drive. The Excel file
contains the gender, salary and experience for the sample of 50 executives in the company.

Extend your analysis of Section 3 to investigate whether there is salary discrimination based
on gender or not.

5. Improving the Model

Again at the meeting, someone was looking at the results of the analysis of salary versus
experience, and said that it was to be expected that an employee with more experience than
another employee would have a higher salary. However, he argued that the difference in
salary between two people with 2 and 4 years experience would be higher than the
difference in salary between two people with 26 and 28 years experience!

Can you find any indication in the results reported in section 4 that this is the case? If yes,
how can you modify your analysis to take this into account?

6. Additional Thoughts

Do you have any additional thoughts on whether there might be a gender disadvantage in
the firm or not?

5
Regression Checklist
1. Visually inspect the data
You can draw a scatter plot using Insert\Scatter.

2. Check correlations between the data


Data\Data Analysis\Correlation computes the correlation between two or more data
series. In Input Range, specify the range with the 2 or more columns of data. In Labels in
First Row, indicate whether you have included labels in the input range or not. In Output
Range, specify a cell where the output can be written.

3. Develop a sensible model


Data\Data Analysis\Regression allows for a regression analysis. In Input Y Range, specify
the dependent variable. In Input X Range, specify the range with the independent
(explanatory) variable(s)  all the independent variables should be in columns next to
each other. In Labels, indicate whether you have included labels in the input range or
not. In Output Range, specify a cell where the output can be written. Also highlight all
the options in Residuals. When you carry out a regression analysis, write down the
obtained equation, interpret it (“What does it mean?”) and see whether it makes sense.

4. Check the goodness‐of‐fit


Evaluate adjusted R2

5. Examine significance of variables


Evaluate t‐values or p‐values, and remove insignificant variables

6. Examine whether the model is well‐specified


Inspect the Line Fit and Residual plots.

7. Multiple Regression:
Check for multicollinearity (i.e. correlated independent variables), and remove correlated
independent variables from the model.

8. Competing Models:
Assess and compare different models to see which one is most sensible and fits the data
best.

Common questions

Powered by AI

Measures to ensure fairness include conducting regular pay audits, adjusting salaries based on equitable factors such as role, experience, and performance, and promoting transparency through public salary reports. Implementing structured criteria for salary increments and ensuring diverse representation in leadership can further mitigate bias. Training programs to raise awareness about implicit biases and establishing mentorship and sponsorship programs to support women's career advancement can foster an equitable work environment and mitigate gender-based salary discrepancies .

The pronounced average salary differences (£71,008 for men vs. £62,577 for women) and the disparate average years of experience (21 years for men vs. 7 years for women) highlight a critical need for policy adjustments at Winner Plc. Strategies might include instituting mentorship programs to enhance women's career advancement and addressing structural barriers that inhibit women's accumulation of experience. Additionally, policies promoting equal representation in higher roles, guaranteeing equal pay for equal work, and regularly reviewing pay structures could reduce income disparities and foster a more inclusive work environment .

Correlation analysis and regression analysis are appropriate statistical methods for evaluating the relationship between salary and experience. A correlation analysis quantifies the strength and direction of the linear relationship between the two variables, while regression analysis can predict salary based on experience and quantify how salary changes with each additional year of experience. A strong positive correlation would suggest that experience significantly impacts salary progression. However, if experience does not account for all variations in salary, other factors might also play crucial roles, indicating non-linearity or multicollinearity issues .

A regression model incorporating both gender (as a dummy variable) and experience will help disentangle the effects of gender on salary from those of experience. If the gender coefficient is significant and negative, it implies potential gender-based salary discrimination even after controlling for experience. Model diagnostics such as adjusted R², t-values, or p-values confirm the model's fit and the significance of individual predictors. Checking for multicollinearity and plotting residuals are crucial to ensure the model is correctly specified and reliable in identifying discriminatory salary practices .

Using dummy variables, such as coding gender as 0 for male and 1 for female, allows for the inclusion of gender as a categorical independent variable in regression analysis. This facilitates the quantification of the salary impact attributed directly to gender, controlling for other factors such as experience. It enables a comparison of the average salary difference between genders while taking into account other variables, offering clear insight into whether gender independently contributes to salary variance, thereby potentially exposing discriminatory practices .

Confidence intervals can be used to estimate the range in which the true mean salary difference between male and female executives lies. If the confidence interval for the difference in means does not include zero, it suggests a significant difference. Hypothesis testing involves setting up null (no difference) and alternative (significant difference) hypotheses and using statistical tests (like t-tests) to determine if observed differences in salaries are statistically significant. A p-value less than a significance level (usually 0.05) leads to rejecting the null hypothesis, indicating a significant salary difference. Both methods are critical in determining whether any observed salary differences are due to chance or represent real disparities .

To adjust for varying impacts of experience on salary at different tenure levels, a non-linear model, such as a piecewise regression or polynomial regression, may be more suitable. These models can capture non-constant slopes, reflecting changes in salary growth rates as experience increases. Additionally, using interaction terms in a multiple regression model can help identify if and how the relationship between experience and salary changes over time. Such models enable distinguishing between initial rapid salary increases and plateau effects seen at higher experience levels .

Experience substantially influences salary and may contribute to explaining some of the gender pay gap. The data reveals men have on average 21 years of experience compared to 7 years for women. This suggests that some salary differences could be legitimately attributed to differences in experience levels. However, interpreting salary differences solely based on experience may overlook other factors such as potential discrimination, career interruptions, and role allocations within the company. Thus, a thorough regression analysis factoring in both gender and experience is required to parse out these contributions and ensure a fair evaluation .

Beyond regression and correlation analyses, conducting a cohort analysis could track gender-based salary progression over time. A break-even analysis might assess the point at which salary disparities emerge. Furthermore, qualitative analyses, such as surveys gauging perceptions of fairness or organizational culture assessments, could uncover underlying biases not evident in quantitative data. Structuring these analyses around role-specific comparisons and including diverse data points like education level, role responsibilities, and departmental differences could yield deeper insights into salary inequities and guide targeted remedial actions .

Multicollinearity occurs when independent variables in a regression model are highly correlated, which can distort the estimated coefficients and their statistical significance, leading to unreliable conclusions about the relationship between variables. In this context, if gender and experience are correlated, it can inflate the variance of coefficient estimates, making it difficult to ascertain the distinct impact of each on salary. Addressing multicollinearity involves examining Variance Inflation Factors (VIFs) and possibly removing or combining variables, or using Principal Component Analysis (PCA) to reduce dimensionality .

You might also like