Capstone Spreadsheet Project

The scenario: Mary is a student enrolled in the PHS program at Durham College. She recently attended a large social gathering but noticed many guests were not in attendance. Mary found out many of the guests were not attending because they were avoiding crowds or large gatherings due to the covid 19 pandemic. Since Mary is an enthusiastic Pre-health Math II student, she wondered if this was specific to this social gathering or was occurring in general. To Mary's delight, she discovered relevant data from Statistics Canada. From Sept. 2020 through to Dec. 2021, Statistics Canada monthly surveyed over 3 million people aged 18 to 34 years old and 35 to 49 years old in Ontario. Participants in the survey were asked, "Due to the covid 19 pandemic, have you been avoiding crowds or large gatherings as a precaution?" Statistics Canada has provided the responses as the percentage of respondents who responded 'Yes' to the survey question. You have been tasked to provide help to Mary on organizing and analyzing the data she has found from Statistics Canada. Within the excel file there is a worksheet set up for each question for this capstone spreadsheet project. Carry out the assigned calculations and fill in your answers in the text boxes provided in the excel file. completed excel Using Statistics Canada's gathered data, please answer the following questions in excel:

Question 1) grouped frequency distribution table using excel for each age group.

Question2) Determine two measures of central tendency (Mean, Median) for each age group.

2a) Within each age group, to what extent did these two measures of central tendency differ?

2b) For these sets of data, is the mean providing us with an accurate measure of central tendency (Hint: Think of outliers)?

Question 3) Determine the five number summary and construct a box plot for each age group.

Question 4) Calculate the Range, Variance and Standard Deviation for each age group. Conclusion from the study:

Question 5) Based on the data analysis you performed, what conclusions would you draw regarding avoiding crowds and large gatherings as a precaution? Make sure you back up your conclusions by drawing on the results of the analyses conducted for questions 1 to 4