Top Tutors
The team is composed solely of exceptionally skilled graduate writers, each possessing specialized knowledge in specific subject areas and extensive expertise in academic writing.
Click to fill the order details form in a few minute.
Posted: May 15th, 2022
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
We prioritize delivering top quality work sought by students.
The team is composed solely of exceptionally skilled graduate writers, each possessing specialized knowledge in specific subject areas and extensive expertise in academic writing.
Our writing services uphold the utmost quality standards while remaining budget-friendly for students. Our pricing is not only equitable but also competitive in comparison to other writing services available.
Guaranteed Plagiarism-Free Content: We assure you that every product you receive is entirely free from plagiarism. Prior to delivery, we meticulously scan each final draft to ensure its originality and authenticity for our valued customers.
When you decide to place an order with Dissertation Help, here is what happens:
Place an order in 3 easy steps. Takes less than 5 mins.