Health Information Management
312 Healthcare Statistics
Assignment #1
Total: 45 Marks
Value: 15%
Instructions:
Complete all exercises below. You must show all your work/formulas where applicable to get full
marks.
1. Fictitious wait times for the cardiac clinic are as follows:
79, 81, 88, 58, 66, 68, 72, 74, 81, 75, 85, 96, 74, 65, 66, 98, 78, 45, 85, 56, 88, 75, 84, 95, 44, 51,
53, 82, 71, 76, 75, 82, 66, 61, 74, 69, 78, 91, 96, 80, 79, 65, 55, 52, 78, 83, 90, 59, 48, 85, 83, 79,
77, 66, 58, 62, 69, 91, 74, 78, 85, 82, 98, 73, 66, 88, 74, 79, 81, 68, 57, 65, 86, 79, 80, 79, 70, 58,
72, 92, 65, 68, 82, 84, 77, 76, 82, 81, 79, 85
a) Create a frequency distribution for the wait times above. (5 marks)
b) Explain in detail the steps you used to create your distribution. (5 marks)
~ arning
,. I ~ONQU!~~
..r””L:11 11 COLLEGE
2 © HealthCareCAN All rights reserved
2. A sample of thirty-four deaths (16 males and 18 females) were reported during the past six
months. The ages of the patients at the time of death were as follows:
Males: 51, 2, 68, 82, 23, 64, 63, 59, 62, 47, 46, 48, 70, 80, 37, 59
Females: 45, 82, 52, 68, 76, 59, 59, 35, 36, 65, 66, 52, 84, 63, 46, 24, 80, NB
a) Calculate the mean age for each of the following. Please show how you arrived at the
answer. Remember the rounding rule for the mean, as marks will be lost if it is not
adhered to (10 marks)
i. All 34 patients
ii. All male patients
iii. All female patients
iv. All female patients, excluding newborns
v. All patients, excluding newborns
b) Calculate the median age of all 34 patients at the time of death. (2 marks)
c) Calculate the mode of the entire distribution. (2 marks)
d) Calculate the variance for the ungrouped distribution. Show all steps in a clearly labelled table. (5 marks)
e) Calculate the standard deviation of the ungrouped distribution and explain what this
means. (5 marks)
” rearning
a division of “t,. ‘!. HealthCareCAN
ALGONQU!~~
COLLEGE
3 © HealthCareCAN All rights reserved
3. You have been asked to provide a report to the Chief of Medicine in your hospital. He would
like to know how many people have been discharged from the unit with a most responsible
diagnosis of Type 2 Diabetes in each month in 2018 and 2019. He is using the information
to determine if there is any need to implement a special program targeting this population.
The summary figures you extract from abstracted data are as follows:
2018
January- 9
February- 8
March- 7
April – 10
May- 10
June- 11
July- 11
August- 11
September- 13
October- 18
November- 16
December- 15
2019
January- 18
February- 17
March- 18
April – 15
May- 17
June- 19
July- 21
August- 21
September- 22
October- 21
November- 23
December- 22
a) Create a file in Microsoft Excel and summarize the data above in chart format. This chart
will form part of the report you provide to the Chief of Medicine, so it should display a clear
comparison and show any trend over this time period. (5 marks)
b) Provide an explanation of why you chose to present your data using this chart type. (1 mark)
c) Provide a brief, written analysis (approximately 100 words) of what you have observed in
reviewing the data. Provide information to help the Chief of Medicine make a decision about
whether or not to introduce additional programs for diabetics. (5 marks)
” rearning
a division of “t,. ‘!. HealthCareCAN
ALGONQU!~~
COLLEGE
4 © HealthCareCAN All rights reserved
Requirements:
• The Excel file required for Part 3 should be handed in with your Word file. Therefore,
you will upload 2 files to the Gateway for this assignment. Please ensure you have
included your name on each file and that the content of your file is well-labelled for
clarity.
• Ensure any written answers are in full sentences with attention to grammar and
spelling. Marks will be deducted for a poorly presented report. Remember: this report
should be formatted as though you were really going to present it to the Chief of
Medicine in your facility!
” rearning
a division of “t,. ‘!. HealthCareCAN
ALGONQU!~~
COLLEGE
