Analyze the following data

1. Several years ago, the proportion of Filipinos aged 18 - 24 who invested in the stock market was 0.20. A random sample of 20 Filipinos in this age group was recently taken. They were asked whether or not they invested in the stock market. The results follow: At a 0.05 level of significance, use Excel to determine whether or not the proportion of Filipinos 18 - 24 years old that invest in the stock market has changed. A B C D Invest Sample Size 20 yes Response of Interest 5 no Count of Response 20 no Sample Proportion 0.25 no no Hypothesized Value 0.2 no yes Standard Error 0.096825 no Test Statistic 0.516398 no no p-value (Lower Tail) 0.302712 no p-value (Upper Tail) 0.697212 no p-value (Two Tail) 0.605577 no no yes yes no