Adverse Impact

RA1Worksheet1.xlsx

Home >Human Resource Management homework help >Adverse Impact

Sheet1

1	ACTIVE WORKFORCE	SEX		MINORITY			AGE
	TOTAL	MALES	FEMALES					40 +
				Non-Minority	MINORITY	N/A	U 40

	TOTALS
	Calculations:	M/TAW	F/TAW	N-MIN/TAW	MIN/TAW	NA/TAW	U 40/TAW	40+/TAW
	PERCENTAGES

2	TERMINATIONS	SEX		MINORITY			AGE
		MALES	FEMALES		MINORITY			40 +
				Non-Minority		N/A	U 40

	Totals
	Terminations
	Calculations:	termed males / total males	termed females / total females	termed N-M / total N-Ms	termed Min / total Min	termed NA / total NA	termed U40 / total U40	termed 40+ / total 40+
		= .xxx (x%)	= .xxx (x%)	= .xxx (x%)	= .xxx (x%)	= .xxx (x%)	= .xxx (x%)	= .xxx (x%)
	For terminations (negative employment action): If calculations are > 80%, then adverse impact is indicated.
		Focal frequency ratio (.xxx)		Focal frequency ratio			Focal frequency ratio
		Reference frequency ratio (.xxx)		Reference frequency ratio			Reference frequency ratio
		Ratio = .xxx (x%)		Ratio = .xxx (x%)			Ratio = .xxx (x%)
		Adverse impact ?		Adverse impact?			Adverse impact?
3	PROMOTIONS	SEX		MINORITY		N/A	AGE
		MALES	FEMALES	NON-	MINORITY		UNDER	40 AND OVER
				MINORITY			40
	Totals
	Promotions
	Calculations:	promoted males / total males	promoted females / total females	promoted N-M / total N-Ms	promoted Min / total Min	promoted NA / total NA	promoted U40 / total U40	promoted 40+ / total 40+
		= .xxx (x%)	= .xxx (x%)	= .xxx (x%)	= .xxx (x%)	= .xxx (x%)	= .xxx (x%)	= .xxx (x%)
	For promotions (positive employment action): If calculations are < 80%, then adverse impact is indicated.
		Focal frequency ratio (.xxx)		Focal frequency ratio			Focal frequency ratio
		Reference frequency ratio (.xxx)		Reference frequency ratio			Reference frequency ratio
		Ratio = .xxx (x%)		Ratio = .xxx (x%)			Ratio = .xxx (x%)
		Adverse impact ?		Adverse impact?			Adverse impact?

RA1 Worksheet NAME:

Adverse Impact

Sheet1

Sheet2

Sheet3