Ontario Public Services Wage Analysis
This is an analysis of the Ontario Public Service wage data. This is based on all public employees in the province who make over $100,000 per year.
The data is available from the Ontario provincial government. https://www.ontario.ca/page/public-sector-salary-disclosure#section-1
Account for inflation
Use the CPI to calculate the price in every year relative to a single base year. This allows us to validly compare people’s salaries across time.
Load Salary Data Across Time
Load the ‘sunshine’ lists of provincial public employees in Ontario who make over $100,000 per year
## Loading 39 lines that match Conestoga. 97## Loading 49 lines that match Conestoga. 98## Loading 75 lines that match Conestoga. 99## Loading 96 lines that match Conestoga. 00## Loading 138 lines that match Conestoga. 01## Loading 211 lines that match Conestoga. 02## Loading 285 lines that match Conestoga. 03## Loading 400 lines that match Conestoga. 04## Loading 469 lines that match Conestoga. 05## Loading 629 lines that match Conestoga. 06## Loading 788 lines that match Conestoga. 07## Loading 1105 lines that match Conestoga. 08## Loading 1981 lines that match Conestoga. 09## Loading 2201 lines that match Conestoga. 10## Loading 3559 lines that match Conestoga. 11## Loading 4016 lines that match Conestoga. 12## Loading 4196 lines that match Conestoga. 13## Loading 4631 lines that match Conestoga. 14## Loading 4910 lines that match Conestoga. 15## Loading 5375 lines that match Conestoga. 16## Loading 2350 lines that match Conestoga. 17## Loading 6584 lines that match Conestoga. 18## Loading 6906 lines that match Conestoga. 19## Loading 7569 lines that match Conestoga. 20## Loading 7864 lines that match Conestoga. 21## Loading 8369 lines that match Conestoga. 22## Loading 10332 lines that match Conestoga. 23Workers Panel
Make a panel of workers at Conestoga College. The goal is to look at how people’s salaries changed over time.
## [1] 85150 5## [1] 85150 5Which job types make the most money?
##
## Chair Dean Director Officer President Professor VP
## 2463 4676 6770 699 620 52913 2323
Highest paid to median pay in the data
Summary of Ontario colleges highest pay relative to the median
Counts of college workers making $100,000 or more
Notice the large drop in 2017. I hypothesize that this is due to college strike actions that year. Striking faculty would not make money during that period and hence may not reach the $100,000 threshold to have their information made public.
The median salary plot shows that most college workers make around $100,000. In fact, in 2017 the median salary temporarily rises slightly for many institutions. This is consistent with workers near the threshold dropping out and, thus, leaving their more highly paid colleagues to be included in the median salary calculation. From 2018 onward, there is a reduction in variation in the median salaries across all the colleges in Ontario.
Visualizations
The median salary plot shows a sharp decrease in the variation of salaries in Ontario colleges. The vast majority of workers in the Sunshine list appear to be just eligible. In fact, the charts display salaries in 2012 dollars, and by that metric, the median pay of a Sunshine list worker is just slightly below the $100,000 in terms of its buying power. (Need to have broader discussion of the chained dollar calculations and the implications.)
