In this blog post, I will be discussing data provided by the University of Regina (U of R) of employees with a total salary of $100,000.00 or greater in 2018 and 2019. The U of R publishes salaries of employees on an annual basis to have greater accountability to staff, students, donors, governments and the general public. You can find this PDF of salaries that the U of R posts here (U of R Salaries). In my blog post I will also be analyzing this data provided by the U of R for errors as well as calculating basic arithmetic/counting calculations to find out what this information can provide us. I have provided a copy of the Spreadsheet that I used in my analysis to give the reader a closer look at this data and why this data is important for the general public.
The spreadsheet that I provided in
the link above has two separate worksheets within in to analyze the data. The
first worksheet is the original data provided from the U of R (titled – 2018-19
data) for 2018 and 2019. It also includes various new columns in the spreadsheet
that were used to analyze the data as well as columns that would be of interest
if the University included. The second worksheet (titled – Arithmetic & Counting
Calculations) is basic arithmetic and counting calculations based on the first
worksheet to get a better understanding of this data. I will discuss each worksheet
in the spreadsheet in detail below.
2018-19 Data Worksheet
The first worksheet originally included
10 columns and 541 rows. After working in
the worksheet, it now includes 18 columns as I have added several columns that
I believe are needed to get a better understanding about the salaries at the U
of R.
- Columns A and B includes the last name and first
name of the employee that works for the U of R.
- Columns C and D includes the salary information
for 2018 and 2019. In the Collective
Agreement (2017-2021), the salary is a base salary that is dependent on the employees’
position. Furthermore, the base salaries have minimum and maximum ranges that
include increments that an employee is awarded in July of each year up to a maximum
range (i.e. July 2017, July 2018, July 2019, July 2020). If a new collective agreement is not signed
by June 30, 2021, the increments stipulated shall be awarded to eligible staff members
until a new contract is signed. The salary ranges also may include merit
payments that go beyond the maximum ceiling of the salary ranges. These merit
increments can be applied by employees and are based on exceptional performance. There is a review committee in place to
review these applications and decide whether merit payments are awarded to a
given employee that has applied.
- Columns E and F includes administrative payments
to employees in 2018 and 2019. These
payments are stipends, meaning they are fixed payments for roles that an
employee make take out that is outside their normal job description. These
include acting opportunities such as department heads or for additional
research for their department.
- Columns G and H includes market supplements in
2018 and 2019. Market supplements are
used to assist in recruiting academic staff members or retaining members in
positions at the U of R. These market
supplements may be paid when it can be demonstrated that competitive pressures
exist in the academic market. Furthermore, market supplements paid to employees
shall not exceed 2.5% of the total salary budget. These market supplements must
be a written proposal by a department head, a group of academic staff members
or the Dean and are reviewed by a committee each year in July.
- Columns I and J includes the total salaries for 2018
and 2019. These total columns are the sum of the columns “Salary”, “Administrative”,
and “Market Supplement” and are entered manually in the original spreadsheet
with no formulas in place.
- Columns K and L includes total salaries (sum of
the columns “Salary”, “Administrative”, and “Market Supplement”) with the use
of formulas for 2018 and 2019.
- Columns M and N includes the differences between
the total salary with use of formulas and the total salary that were entered manually.
There was one error that I came
across in the original data that was provided for me. If you look at the spreadsheet on row 201, I
have highlighted the difference in the 2019 total reported for Mark Haidl. The total
salary reported with the formula that I have added into the spreadsheet (=SUM
(Salary, Administrative, Market Supplement)) shows that there is a difference
of $3,558. After looking at the data, the
error is an input/clerical error as Mark Haidl did not receive any extra
administrative or market supplements on top of his salary and the salary was
simply recorded wrong in the spreadsheet for 2019. Having found only one minor error, I would
not question the accuracy of the spreadsheet provided.
In 2018, there were 467 employees
that made over the $100,000 threshold whereas in 2019, there were 504 employees
that made over the $100,000 threshold.
This is a difference of 37 more employees in the 2019 year than the previous
year. Also, there were 73 employees that
made above $100,000 in 2019 who either weren’t employed at the U of R in 2018 or
did not meet the threshold of the $100,000 in the previous year. This means that the university has likely
increased wages to meet the costs of living increases or simply the University
has hired more employees in the 2019 year.
Arithmetic & Counting Calculations
Worksheet
The second worksheet in the spreadsheet
includes some basic arithmetic and counting calculations based on the total salary
formula that I have included in the first worksheet of data. These statistical
measures include number of employees, total salary, mean, median, mode,
maximum, minimum, range, skewness and the differences between the 2018 and 2019
years. I have also included the growth rate for some of the statistical
measures where it made sense.
In the worksheet I first calculated
the total salaries for 2018 versus 2019.
In 2019, the sum of the total salaries was $69,203,654 and in 2018, the
sum of the total salaries was $63,265,758. This is a difference of $5,937,896
and a growth rate of 9.4%. While this growth rate is high, it includes 37 more
employees in 2019 than in 2018 which means it is not that accurate of a number.
The mean, median and mode were very similar when comparing 2018 and 2019
salaries, with the mean and median being around the $130,000 mark and the mode
being around the $105,000 mark. Although, these numbers are highly skewed as in
both years, the skew is above 2. This mean that there were some outliers in the
dataset with high salaries such as the University President (Dr. Vianne
Timmons).
When examining the growth rate to
determine the increase of salaries between 2018 and 2019, I found the growth
rate to be 9.4%. This number represents the total sum of all salaries from that
given year and then calculating the percentage of growth in that year. The
second measure of the growth rate can be calculated when you only include those
employees who made over $100,00 in both 2018 and 2019. This number is 4.9% and is
a more accurate measure of growth rate for the University and its employees. This number only includes employees employed
in both 2018 and 2019 and is more accurate as it measures the increase of an employee’s
salary from year to year instead of each year.
When you take the growth rate from employees that were only making over
$100,000 each year, it is not a fair representation of the dataset. It is also not
possible to say that the average salary at the U of R decreased between 2018
and 2019 because if you look at my numbers there was an increase in the total salary
and as indicated above, the mean increased by over $1,836 between 2018 and
2019.
Additional Column Headings
Needed
In the spreadsheet, I believe
there are some additional columns needed to have a better understanding of
salaries at the U of R. In my analysis, I have added the following columns in
the worksheet: Department, Level of Pay Increment, Position Type, Starting Salary
and Age/Close to Retirement.
I believe these columns are needed
as I would like more information about the employee and the position that they currently
hold. By having the department listed,
it allows the public to know whether the U of R has more administrative costs
or market supplement costs for a given department as well as it indicates the
total salary for each department within the university. This may be helpful to
tell if the University needs help recruiting or retaining employees. The current level of pay increment is also interesting,
as this allows citizens to see if the employee is new. It is evident that the
longer an individual has been employed with an organization the more the person
generally earns within the organization. I also feel like having the starting
salary and position type would be interesting as it would let students, donors
and the general public know where most of the money is being put into in terms
of employees. Lastly, I would like to include the column of age/close to
retirement to be able to see the demographics of employees of the University and
whether the closer an employee is to retire the more the person earns.
While having some of these extra
columns would be interesting, it may include too much information on employees
and could breach individual’s privacy.
While I believe the university does a good job by posting their employees
by name and a breakdown of their information, having these additional columns
may breach some of the privacy of employee’s.
Privacy and Open Government
The U of R is very open by
publishing its employees’ salaries online, by doing this it does raise some
questions regarding the protection of personal privacy versus the publics’
right to know. I believe in this
situation that the public does have the right to know as it includes their tax
dollars and the amount of privacy that is “breached” is very minimal. I believe
the public interest is being served as having this data online in an open and transparent
way allows students, parents, donors, governments and the general public to see
where their money is going in terms of salaries. It allows for accountability
to the public that an institution such as the U of R is operating in a fair and
consistent manner.
My opinion does not change whether
the information was published online, as opposed to previously being only available
at the library as a paper copy. I would
like to commend the University by posting this information online where it is
easier to access for the general public and a quicker way to be able to draw
information from.
Lastly, the U of R website includes a small disclosure with this data. It states that the University is able to exclude certain salaries of $100,000 or greater where such disclosure could threaten the safety of an individual. I believe this is a reasonable exception to being open and transparent with the general public. While I did not investigate the specific policy that would warrant this disclosure, I believe that if someone’s privacy could be threatened by releasing this information it is better to exclude the individual from the data. There are some drawbacks of a policy that individuals can ask to have their salary protected as it may allow the data set to become more skewed. In closing, I believe that we should try to protect employees and keep them safe from threats if necessary, whether this non-disclosure may negatively affect the data set.