a "most-favored-group" utility that automatically calculates and compares the selection rate for the most favored race/ethnicity group to the selection rates for all other groups, both individually and in the aggregate;
user-activated visual alert settings to flag common data-entry errors, such as entering more hires than applicants;
user-activated visual alert settings to flag statistically significant selection rate disparities;
user-activated view and print settings to display (or hide) analytical test results, which can be useful for printing aggregate data reports without the accompanying statistical analysis; and
significant format improvements that allow users to analyze up to 25 transactions per page, and to annotate and print pre-formatted, professionally-designed reports for internal or external (OFCCP) dissemination.
The final two spreadsheets have been pre-formatted to analyze positive and negative transactions data for a single transaction and a single analytical unit by individual race/ethnicity group. These two sheets simply require users to enter the total numbers of eligible and selected persons in each race/ethnicity category in the top right corner of the sheet. The spreadsheets then automatically determine which single race/ethnicity category is the "most favored" group, and compare the selection rate for the most favored group to those for all other groups, both individually and collectively.