Question

Results from a civil corvant excam are shown in the table to the right is there sufficient evidence to support the claim that the results from the best we discriminatory? Us 2005 significance level Whi candidates Minority candidates Pased 15 10 Determine the null and alternative hypotheses OA. Ho White and minority candidates have the same chance of passing the test H, White and minority candidates do not have the same chance of passing the best OB. Ho: A white candidate is more ly to pass the test than a minority candidate HA white candidate is for more likely to pass the test than a minority candidate OC. Ho White and minority candidates do not have the same chance of passing the tem H, White and minority candidates have the same chance of passing the test OD. Ho Awe candies no more to pass the best than a minonly candidate H, Awhite candidate is more to pass the best than a minority candidate Determine the test x-Round to three decimal places as needed) Determine the value of the best P.value (Pound to four decimales as needed) Is there sutientvidence to them that there on the tout are demanatory O A There is not sure widence toport the claim that the results we diminator OB There is no widence to the white candidate is more they to pass the best than any candida OC. There went on to them that there are story OD. There is the one to the that we candidates more to the test they candidate

Answer 1

Solve using Excel:

A B C D E TI 1 ACTUAL Failed Passed Total 15 19 34 10 26 36 25 45 70 EXPECTED Failed Passed 12.143 21.857 2 3 White 4 Minority 5 Total 6 7 8 9 White 10 Minority 11 12 13 14 White 15 Minority 16 17 Test statistic 18 p-value FORMULA FOR EXPECTED VALUE =(B$5*$D3)/$D$5 =(C$5*$D3)/$D$5 =(B$5*$D4)/$D$5 =(C$5*$D4)/$D$5 12.857 23.143 CHI-SQUARE Passed Failed 0.672 0.373 0.635 0.353 FORMULA FOR CHI-SQUARE =(B3-B9)^2/89 =(C3-C9)^2/09 =(B4-B10)^2/B10 =(C4-C10)^2/C10 2.033 =SUM(B14:C15) 0.1539 ECHISQ.DIST.RT(2.033,1)

	ACTUAL
	Passed	Failed	Total
White	15	19	34
Minority	10	26	36
Total	25	45	70
	EXPECTED
	Passed	Failed		FORMULA FOR EXPECTED VALUE
White	12.143	21.857		=(B$5*$D3)/$D$5	=(C$5*$D3)/$D$5
Minority	12.857	23.143		=(B$5*$D4)/$D$5	=(C$5*$D4)/$D$5
	CHI-SQUARE
	Passed	Failed		FORMULA FOR CHI-SQUARE
White	0.672	0.373		=(B3-B9)^2/B9	=(C3-C9)^2/C9
Minority	0.635	0.353		=(B4-B10)^2/B10	=(C4-C10)^2/C10
Test statistic	2.033	=SUM(B14:C15)
p-value	0.1539	=CHISQ.DIST.RT(2.033,1)

H₀: White and minority candidates have the same chance of passing the test

H₁: White and minority candidates have the same chance of passing the test (Option 1)

Test statistic = 2.033

Degrees of freedom: df = (rows-1)*(columns-1) = (2-1)*(2-1) = 1, Level of significance = 0.05

p-value (Using Excel function CHISQ.DIST.RT(test statistic, df)) = CHISQ.INV.RT(2.033,1) = 0.1539

Since p-value is more than 0.05, we do not reject the null hypothesis.

There is not sufficient evidence to support the claim that results are discriminatory (Option A)