1.Calculate ²for the hypothetical data shown in Table 1 below and determine whether the relationship is statistically significant. Welfare outcomes (e.g., time to find a job) are examined as a function of the education levels of welfare recipients. Use Table 2 to calculate your expected frequencies. Use the CHITEST function in Excel to calculate p-value in a Chi-Square test statistic. Please write a few sentences interpreting your result (e.g. Does a relationship exist between the education level and the degree of welfare outcome?).

Table 1: Observed Frequencies

Welfare Outcome		Education
No H.S. Degree	H.S. Degree	Some College	Total
Low	60	55	10	125
Medium	35	55	15	105
High	25	30	20	75
Total	120	140	45	305

Table 2: Expected Frequencies:

Welfare Outcome		Education
No H.S. Degree	H.S. Degree	Some College	Total
Low
Medium
High
Total