$1-$10	$11-$50	$51-$100	$101-$200	Total
High School	207	282	241	103	833
College grad	234	242	232	150	858
Totals	=B3+B4	=C3+C4	=D3+D4	=E3+E4	=F3+F4
					
HO There is no relation between variables					
Alt There is a ignificant relation between the two variables					
					
					
					
Expected values	 Row total * column total/grand total				
Edu Level	$1-$10	$11-$50	$51-$100	$101-$200	Total
High School	=(F3*B5)/F5	=(F3*C5)/F5	=(F3*D5)/F5	=(F3*E5)/F5	=SUM(B14:E14)
College grad	=(F4*B5)/F5	=(F4*C5)/F5	=(F4*D5)/F5	=(F4*E5)/F5	=SUM(B15:E15)
Total	=B14+B15	=C14+C15	=D14+D15	=E14+E15	=F14+F15
					
observed	calculated	(o-c)^2/c			
=B3	=B14	=(A19-B19)^2/B19			
=C3	=C14	=(A20-B20)^2/B20			
=D3	=D14	=(A21-B21)^2/B21			
=E3	=E14	=(A22-B22)^2/B22			
=B4	=B15	=(A23-B23)^2/B23			
=C4	=C15	=(A24-B24)^2/B24			
=D4	=D15	=(A25-B25)^2/B25			
=E4	=E15	=(A26-B26)^2/B26			
Chi-Squared		=SUM(C19:C26)			
					
degrees of freedom = (no. of rows-1) * (no. of columns-1)					
	(2-1) * (4-1) = 3				
					
look up 3 degrees of freedom  and 0.05 p value = 7.815					
					
Since Chi-Square is greater than the p value so reject the null hypothesis.  The difference between observed and expected is statistically significant					
accept the alternative hypothesis					
accept the alternative hypothesis