Answer Happy

he "library use data" tab in the Excel workbook contains a tablethat was created based on a survey given to 153 randomly sampledadult Old Port library users. Respondents were asked their age andtheir primary purpose for using the Old Port Public Library. Thisinformation was used to create a table displaying the counts ofpublic library use purposes (recreation, research/education, orother), for individuals falling into two different age groups (age18-39 and age 40+).
(a) In Excel, make a table displaying the column percentages forprimary library use purpose for each age group.
(b) Are there differences in the proportion of individuals thatfall into each library use category, by age group? Explain.
(c) State the null and alternative hypotheses for a significancetest 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 teststatistic.
(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 theassociation 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 Library use purpose Recreation Research/education Other Total 18-39 years 28 30 12 70 Age 40+ years 55 14 14 83 Total 83 44 26 153