Link to University of Wisconsin-Madison home page

RADAR

Repository for Administrative Data and Reports

Faculty Salary Scatterplots

Last Updated
04/27/2024
Description

This Tableau workbook provides faculty salary data by department (including gender, faculty rank and years since degree) to assist in determining whether faculty members are appropriately and equitably paid in comparison to peers at UW-Madison.

Report URL
https://data.wisc.edu/scatterplots/
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/27258/versions/72313
Data Domain(s)
Employee Record
Access Restrictions
Specific / Limited Audience
Data Source Information
HRS/EPM
Update Schedule
Annually, 1st quarter of calendar year.
Responsible Office
Data, Academic Planning & Institutional Research
Important Notes

Data shown is from the Human Resource System (HRS) and is complete through January. Any additions, subtractions, or changes to the faculty data in HRS since then will not be reflected in these tables or graphs.

Certain elements of these data are collected from employees on the condition that the data will be used only for limited affirmative action and related University purposes. Therefore, your access to the data is with the understanding and agreement that you will not disclose them to others who do not themselves have access.

These data are prepared for each tenure-granting department. Faculty members are shown in each department where they hold a tenure or tenure-track appointment. The percent commitment for the department is shown in the table under '% Appt this Dept.' Salaries on a 12-month bases for 'A' appointment are converted to a 9-month basis. Salaries on a 9-month basis for 'C' appointments are not modified. The table and chart shows all salaries on a 9-month basis. Faculty with zero-dollar appointments and those paid 100% through an administrative appointment (such as chancellor or dean) are excluded from the chart. However, these faculty members are listed in the table with $0 faculty salary. Faculty with missing degree information are also excluded from the chart but listed in the table.

The scatterplot for each department displays a linear trend line, which is the line that most closely approximates the data in the scatterplot. The tooltip that appears when hovering over the trend line has three lines: 1) the equation used to produce the trend line; 2) the R-Squared value, which shows the ratio of variance in the data, as explained by the model, to the total variance in the data; and 3) the P-value, which reports the probability that the equation in the first line was a result of random chance.

Definitions

Name Functional Definition Data Domains
A-Basis Appointment

An appointment for the fiscal year paid as determined by the calendar month.

Employee Record
Academic Year (Su,Fa,Sp)

An academic year consists of sequential summer, fall, and spring terms. For example, the 2021-22 academic years includes summer 2021, fall 2021, and spring 2022.

Academic Planning
C-Basis Appointment

An appointment directly tied to the academic year calendar (273 days or 39 weeks).

Employee Record
Department (Academic Structure)

An entity approved by academic governance to serve at least one of three academic purposes: serve as the academic home for a plan, serve as the academic home of a subject, or serve as a faculty tenure home. The status of an academic organization as academic owner is established through faculty/shared governance approval process; each plan and subject has one academic organization designated as an academic owner. Academic organizations are tied to the budgetary UDD (A####).

Academic Planning, Employee Record
Employee Name (HRS)

The English format name for an employee entered in HRS. The name consists of Last Name, First Name and an optional Middle Initial.

Employee Record
Gender

Gender includes the social, psychological, cultural and behavioral aspects of being a specific gender identity (e.g. being a man, woman, trans man, trans woman, nonbinary, or another gender). A person’s gender may be different from their legal sex.

At UW Madison we prefer to use the term Gender to be more inclusive rather than 'Gender Identity' which has historically only been used for non-cisgender individuals. For example, data collection forms should ask “What is your gender?” rather than “What gender do you identify as?”.

Definition provided by the Data Guidelines for Legal Sex and Gender, endorsed by the Data Governance Council Feb 20, 2024 and published at https://uwmadison.box.com/s/8m8ibkv81kxbmkl5ijafbpkm2onicnms

Core Person