I need some assistance with this problem while using excel ## Age-Sports Relation Analysis in a Sports ClubA Sports Club is a haven For fitness lovers of all ages Offering a range of sports To cater to all stages. The manager got curious one day Does age affect the choice of sport they play? He collected the data on all the 800 members To create a chart by age, And to conduct a test of independence It can take many a page! With a 95% confidence level, provide him with a solution To his quandary about the age-sports relation!### Observed Frequencies| Sport | 18-25 | 26-30 | 31-40 | 41+ ||------------|-------|-------|-------|------|| Racquetball| 52 | 55 | 36 | 27 || Tennis | 65 | 63 | 38 | 45 || Swimming | 70 | 60 | 54 | 47 || Badminton | 44 | 52 | 52 | 40 |**Hint:** This is a Chi-squared test of independence.#### Fill in the following blanks:1. a. The value of the test-statistic is: **[Text Box]**1. b. The critical value of the Chi-squared is: **[Text Box]**1. c. We can reject the Ho at alpha = 0.05. Answer "True" or "False": **[Text Box]**

Name: I need some assistance with this problem while using excel ## Age-Spor
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: I need some assistance with this problem while using excel ## Age-Sports Relation Analysis in a Sports ClubA Sports Club is a haven For fitness lovers of all ages Offering a range of sports To cater to all stages. The manager got curious one day