Missing DC Social Workers

	A	B	C	D	E	F	G
1	DC ASWB Eventual Pass Rates for 2011 to 2021 (from https://www.aswb.org/exam/contributing-to-the-conversation/aswb-exam-pass-rates-by-state-province/)
2
3	Bachelors Exam	Actual Data			Adjusted Data
4	Demographic	Group	# Test-Takers	Pass Rate	# Passed	# Passed (White Pass Rate)	Missing Social Workers
5	Race/Ethnicity	Asian	3
6		Black	36	33.3%	12	32	20
7		Hispanic/Latino	7
8		Multiracial	2
9		White	18	88.9%
10	Gender	Men	10	70.0%
11		Women	58	55.2%
12	Age	18-29	32	75.0%
13		30-39	20	60.0%
14		40-49	4
15		50 and older	12	16.7%
16	Language	English	57	59.6%
17		Non-English	11	45.5%
18
19	Masters Exam	Actual Data			Adjusted Data
20	Demographic	Group	# Test-Takers	Pass Rate	# Passed	# Passed (White Pass Rate)	Missing Social Workers
21	Race/Ethnicity	Asian	48	85.4%	41	48	7
22		Black	878	70.5%	619	871	252
23		Hispanic/Latino	127	81.1%	103	126	23
24		Multiracial	44	90.9%	40	44	4
25		Native American/Indigenous Peoples	1
26		White	889	99.2%
27	Gender	Men	303	77.6%
28		Women	1,754	86.0%
29	Age	18-29	1,042	90.1%
30		30-39	653	85.0%
31		40-49	209	69.9%
32		50 and older	153	67.3%
33	Language	English	1,925	85.7%
34		Non-English	132	71.2%
35
36	Clinical Exam	Actual Data			Adjusted Data
37	Demographic	Group	# Test-Takers	Pass Rate	# Passed	# Passed (White Pass Rate)	Missing Social Workers
38	Race/Ethnicity	Asian	40	90.0%	36	39	3
39		Black	747	75.4%	563	724	161
40		Hispanic/Latino	99	91.9%	91	96	5
41		Multiracial	36	94.4%	34	35	1
42		Native American/Indigenous Peoples	3
43		White	801	96.9%
44	Gender	Men	246	77.6%
45		Women	1,551	87.9%
46	Age	18-29	451	96.7%
47		30-39	868	89.4%
48		40-49	272	75.4%
49		50 and older	206	67.0%
50	Language	English	1,701	86.9%
51		Non-English	96	80.2%
52
53					Missing Bachelors Social Workers (LSWA)		20
54					Missing Masters Social Workers (LGSW)		285
55					Missing Clinical Social Workers (LICSW)		169
56
57					Total Missing Social Workers		474
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100