The General Social Survey is an annual survey given to about 1,500U.S. adults selected at random. Each year, the survey contains several questions meant to probe respondents' views of employment. A recent survey contained the question "How important to your life is having a fulfilling job?" Of the258college graduates surveyed,122chose the response "Very important." Of the121people surveyed whose highest level of education was high school or less, 67chose the response "Very important." Based on these data, can we conclude, at the.05level of significance, that there is a difference between theproportion p1of all U.S. college graduates who would answer "Very important" and the proportionp2of all U.S. adults whose highest level of education was high school or less who would answer "Very important"?

Perform a two-tailed test. Then fill in the table below.

Carry your intermediate computations to at least three decimal places and round your answers as specified in the table.

Answer the following questions

1. What is the null hypothesis

2. What is the alternative hypothesis

3. The type of test statistic (Z,t, Chi Square, or F) and the degree of Freedom

4. The value of the test statistics (Rounded to at least three decimal places)

5. The two critical values at the .05 level of significance (Rounded to at least three decimal places)

6. Finally, Can we conclude that there is a difference between the two populations in the proportions who would answer very important.(Yes or No)

While it is not necessary, I would like to see if this could be answered in excel so I could see the process and be able to answer simular questions in the future. Thank you for your help :)