This project discussed the Gender pay gap challenge, and it focused onturning invisible inequality into visible data.
The goal of it is to:
Prove the existence of the gender pay gap using real data.
Focus on the different aspects that affect this gap.
Present findings in clear visual charts accessible to non-technical people.
The target audience for this project is Employees, HR managers, and
policy makers.
I have chosen a Panel Study of Income Dynamics dataset (33,398
people)
I have used Google Sheets for data cleaning, pivot tables, AVERAGEIFS
formulas, and Linear Regression, a trend line analysis method.