1. The "library use data" tab in the Excel workbook contains a table that was created based on a survey given to 153 randomly sampled adult Old Port library users. Respondents were asked their age and their primary purpose for using the Old Port Public Library. This information was used to create a table displaying the counts of public library use purposes (recreation, research/education, or other), for individuals falling into two different age groups (age 18-39 and age 40+). (a) In Excel, make a table displaying the column percentages for primary library use purpose for each age group. (b) Are there differences in the proportion of individuals that fall into each library use category, by age group? Explain. (c) State the null and alternative hypotheses for a significance test of library use purpose and age group. (d) In Excel, show a table of expected values. (e) In Excel, show a table to calculate the chi-squared test statistic. (f) What is the p-value? How did you find this value? (g) Do you have evidence to reject the null hypothesis? If so, at what level? State the conclusion of your hypothesis test. (h) What might be some lurking variables that could impact the association between library use purpose and age group?

Survey of library users in Old Port The survey was given to a random sample of 153 adult library users Variables represented in the table below are the age group of the survey participant, and their m Observed values Age Library use purpose 18-39 yea rs 40+ yea rs Recreation Research/education Total