The dataset was obtain from 16-page document detailing the salaries of Trump Administration in it’s annual report to congress on White Huse personnel as of Friday, June 30, 2017. You can find a copy of the report here. You can read more about the dataset here
The aim of this data analysis is to understand the salary distribution of male and female employees, and further explore any gaps between the two genders in the dataset. You can find a copy of the data and code used to produce this analysis on my GitHub account here
In 2017, the White House spent a total of $ 35766744 on the salaries of 377 employees.
Below is a table showing the top earner in the White House for 2017
| NAME | STATUS | SALARY | PAY BASIS | TITLE | GENDER |
|---|---|---|---|---|---|
| House, Mark S. | Detailee | 187100 | Per Annum | SENIOR POLICY ADVISOR | M |
Let’s start by looking at the mean and median salaries for male and female employees
| GENDER | NUMBER | MEAN SALARY | MEDIAN SALARY |
|---|---|---|---|
| F | 166 | 84885.53 | 77000 |
| M | 211 | 102728.65 | 95000 |
There are 153 staff earning $100,000 or more
Of the 153, only 51 of them are female.
| GENDER | NUMBER |
|---|---|
| F | 115 |
| M | 109 |
Of the remaining 224 that earn less than $100,000, 115 of them are female. This include Ivanka Trump and her husband, Jared Kusner, and Reed Cordish all of whom have a salary of 0. Gary Cohn, millionare former CEO of Goldman Sachs has a salary of 30,000.
The density distribution shows more female employees at the lower tail of the salary distribution and more male employees at the upper tail of the distribution.
There are 68 distinct titles. Of the 68, there are 30 titles/positions for which there are both males and females. The graph attempts to see if there are positions where males and females earn different salaries using the median salary.