Students will complete an individual assignment in data management and summarization using Microsoft Excel.
statistics
Description
Students will complete an individual assignment in data management and summarization using Microsoft Excel. You will be given access to an unorganized dataset and will need to organize and summarize the data in Excel using various formulas, functions, tables, and charts.
Format of submission: One Excel spreadsheet file (.xls or .xlsx format). Once submitted you will not be
able to upload a new file, therefore please ensure your file is reviewed for completeness prior to
submitting online.
Health care institutions are required under the Ontario Health Protection and Promotion Act (HPPA) to
monitor staff and parents for symptoms of gastroenteric and respiratory infections (City of Toronto,
2019). Institutions are required to detect, and report suspected and confirmed infections to their public
health unit. An outbreak of such infections is an increase in the rate of infections above what is
expected. Using open-source data from the City of Toronto (please see link below), you will be required
to download and analyze institutional outbreak data following the instructions provided.
