​​Data Analysis Tools


Census Availability Guidance.
This guide allows users to access labor market availability data publically available from the U.S. Census. The data estimates the proportion of persons meeting minimum qualifications to perform a wide variety of employment classifications within a defined geographic region by race, ethnicity, and sex.


Availability Analysis Tool. This worksheet allows users to estimate the percentage availability of individual race/ethnicity groups within one or more geographic areas for one or more job classifications. The worksheet also provides a comparison of calculated availability to the user’s current workforce to identify potential underutilization, evaluate past recruitment strategies, and explore the viability of proposed recruitment strategies in addressing workforce diversity objectives.

Availability Analysis Tool - Individual Race V1.0 07242018.xlsx


Longitudinal Analysis – Applicant Pool Composition. This worksheet allows users to analyze the composition of their applicant pools for one or more positions by race, ethnicity, and sex over a five year period. The analysis provides results for individual years as well as the cumulative five year period, highlighting differences in hiring rates by race, ethnicity, and sex during the analysis periods.

Longitudinal Analysis - Applicant Pool Composition V.3 06192018.xlsx


​Longitudinal Analysis – Hiring Process Phase Analysis. This worksheet allows users to analyze the progress of applicants through each phase of a hiring process by race, ethnicity, and sex. The analysis highlights differences in success rates for applicants as they advance through each phase by race, sex, and ethnicity during the analysis periods.

Longitudinal Analysis - Hiring Process Phase Analysis V.3.1 10042018.xlsx


By Greggory Smith
July 2018


 

​​​​​