(Use Excel) According to a 2008 survey by the Pew Research Center, people in China are highly satisfied with their roaring economy and the direction of their nation (USA Today, July 22, 2008). Eighty-six percent of those who were surveyed expressed positive views of the way China is progressing and described the economic situation as good. A political analyst wants to know if this optimism among the Chinese depends on age. In an independent survey of 280 Chinese residents, the respondents are asked how happy they are with the direction that their country is taking. Their responses are tabulated in the following table.

a. Set up the appropriate hypotheses to test the claim that optimism regarding China's direction depends on the age of the respondent.
b. Calculate the value of the test statistic.
c. Use Excel's CHISQ.DIST.RT function to calculate the p-value.
d. At a 1% level of significance, can we infer that optimism among the Chinese is dependent on age?

Age 20 up to 40 40 up to 60 60 and above Very Somewhat Not Happy Happy Happy 50 38 45 23 51 19 18 16 20