Health Information Management
\n312 Healthcare Statistics
\nAssignment #1
\nTotal: 45 Marks
\nValue: 15%
\nInstructions:
\nComplete all exercises below. You must show all your work\/formulas where applicable to get full
\nmarks.
\n1. Fictitious wait times for the cardiac clinic are as follows:
\n79, 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,
\n53, 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,
\n77, 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,
\n72, 92, 65, 68, 82, 84, 77, 76, 82, 81, 79, 85
\na) Create a frequency distribution for the wait times above. (5 marks)
\nb) Explain in detail the steps you used to create your distribution. (5 marks)
\n~ arning
\n,. I ~ONQU!~~
\n..r””L:11 11 COLLEGE
\n2 \u00a9 HealthCareCAN All rights reserved
\n2. A sample of thirty-four deaths (16 males and 18 females) were reported during the past six
\nmonths. The ages of the patients at the time of death were as follows:
\nMales: 51, 2, 68, 82, 23, 64, 63, 59, 62, 47, 46, 48, 70, 80, 37, 59
\nFemales: 45, 82, 52, 68, 76, 59, 59, 35, 36, 65, 66, 52, 84, 63, 46, 24, 80, NB
\na) Calculate the mean age for each of the following. Please show how you arrived at the
\nanswer. Remember the rounding rule for the mean, as marks will be lost if it is not
\nadhered to (10 marks)
\ni. All 34 patients
\nii. All male patients
\niii. All female patients
\niv. All female patients, excluding newborns
\nv. All patients, excluding newborns
\nb) Calculate the median age of all 34 patients at the time of death. (2 marks)
\nc) Calculate the mode of the entire distribution. (2 marks)
\nd) Calculate the variance for the ungrouped distribution. Show all steps in a clearly labelled table. (5 marks)
\ne) Calculate the standard deviation of the ungrouped distribution and explain what this
\nmeans. (5 marks)
\n” rearning
\na division of “t,. ‘!. HealthCareCAN
\nALGONQU!~~
\nCOLLEGE
\n3 \u00a9 HealthCareCAN All rights reserved
\n3. You have been asked to provide a report to the Chief of Medicine in your hospital. He would
\nlike to know how many people have been discharged from the unit with a most responsible
\ndiagnosis of Type 2 Diabetes in each month in 2018 and 2019. He is using the information
\nto determine if there is any need to implement a special program targeting this population.
\nThe summary figures you extract from abstracted data are as follows:<\/p>\n
2018
\nJanuary- 9
\nFebruary- 8
\nMarch- 7
\nApril \u2013 10
\nMay- 10
\nJune- 11
\nJuly- 11
\nAugust- 11
\nSeptember- 13
\nOctober- 18
\nNovember- 16
\nDecember- 15
\n2019
\nJanuary- 18
\nFebruary- 17
\nMarch- 18
\nApril – 15
\nMay- 17
\nJune- 19
\nJuly- 21
\nAugust- 21
\nSeptember- 22
\nOctober- 21
\nNovember- 23
\nDecember- 22
\na) Create a file in Microsoft Excel and summarize the data above in chart format. This chart
\nwill form part of the report you provide to the Chief of Medicine, so it should display a clear
\ncomparison and show any trend over this time period. (5 marks)
\nb) Provide an explanation of why you chose to present your data using this chart type. (1 mark)
\nc) Provide a brief, written analysis (approximately 100 words) of what you have observed in
\nreviewing the data. Provide information to help the Chief of Medicine make a decision about
\nwhether or not to introduce additional programs for diabetics. (5 marks)<\/p>\n
” rearning
\na division of “t,. ‘!. HealthCareCAN
\nALGONQU!~~
\nCOLLEGE
\n4 \u00a9 HealthCareCAN All rights reserved
\nRequirements:
\n\u2022 The Excel file required for Part 3 should be handed in with your Word file. Therefore,
\nyou will upload 2 files to the Gateway for this assignment. Please ensure you have
\nincluded your name on each file and that the content of your file is well-labelled for
\nclarity.
\n\u2022 Ensure any written answers are in full sentences with attention to grammar and
\nspelling. Marks will be deducted for a poorly presented report. Remember: this report
\nshould be formatted as though you were really going to present it to the Chief of
\nMedicine in your facility!
\n” rearning
\na division of “t,. ‘!. HealthCareCAN
\nALGONQU!~~
\nCOLLEGE<\/p>\n","protected":false},"excerpt":{"rendered":"
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\u2026<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1463,7667,7669,7657,7663,7662,2751,7665,7664,1468,7666,7659,7660,7661,7658,1465],"tags":[687,116,117,121,125,8905,114,8902,8906,118,8908,8,115,62,8903,71,33,36,119,4,124,122,8904,7,77,50,105,123,8907],"class_list":["post-96248","post","type-post","status-publish","format-standard","hentry","category-best-nursing-paper-writing-service","category-buy-bsn-nursing-papers-online","category-buy-dnp-nursing-papers-online","category-healthcare-management-assignment-help-from-experts","category-help-my-assignment","category-ireland-assignment-help","category-online-healthcare-assignment-help","category-online-nursing-essay","category-online-nursing-paper-writers","category-online-nursing-papers","category-online-public-healthcare-assignment-help","category-online-tutors-helps","category-sample-assignment","category-top-essay-writing","category-urgent-assignment-helper","category-write-my-nursing-paper","tag-assignment-help-website","tag-best-essay-writing-service","tag-best-nursing-essay-writing-service","tag-best-nursing-essay-writing-services","tag-biology-essay-writing-service","tag-book-essay-title-generator","tag-healthcare-essay-writing-service","tag-help-me-write-my-essay","tag-help-write-my-essay","tag-medical-assignment-writing-services","tag-medical-essay-assignment-writi","tag-medical-essay-writing-service","tag-medical-essay-writing-service-online","tag-medical-paper-writing-service","tag-need-help-writing-an-essay","tag-nursing-answers","tag-nursing-essay-help","tag-nursing-essay-writing-examples","tag-nursing-essay-writing-services","tag-nursing-paper-writing-services-reviews","tag-nursing-writing-acers","tag-nursing-writing-helps","tag-online-essay-help-chat","tag-online-nursing-essay-writing-service","tag-pay-for-nursing-essay","tag-please-write-my-essay","tag-professional-medical-writing-services","tag-reliable-online-nursing-assignment-help","tag-write-my-essay-for-me"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/96248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=96248"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/96248\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=96248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=96248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=96248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}