Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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?

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Simulation

Authors: Sheldon M Ross

6th Edition

0323899617, 9780323899611

More Books

Students also viewed these Mathematics questions