AutoSave on. ( 7 5- - variance assignment . Saved Jocelyn dela Cruz JD X File Home Insert Page Layout Formulas Data Review View Help Acrobat PDF Suite 2020 Shape Format Comments TextBox 1 X V A B C D E F G H K L M N O P Q R S T U V W X Y Z AAJ 1 Data Quality Review of NACRS and MIS Functional Centres 2 1) Complete the Variance column (note the definition of variance for the W 7*31020 *31025 7*31076 Total purposes of this assignment on the READ ME FIRST tab). Ambulatory Care Ambulatory Care Ambulatory Care What was the calculation you used? Emergency- General - Emergency- Hospital Emergency- Facility # of visits Urgent Care - # of Psychiatric # of ED visits Name visits Services/Crisis Intervention - # of 2) What conclusions can you draw from the Variance column when visits comparing hospitals ? MIS NACRS - CIH MIS NACRS - CI MIS NACRS - MIS NACRS - CIHI Variance (Hint: is the data much different at each hospital? Is one hospital submitting Hospital A 51,500 52,202 51,500 52,202 more to MIS than to NACRS or vice versa? Which hospitals are doing better Hospital B 62,100 51,000 2,100 2,500 917 120 65,117 53,620 than others? Which are doing worse?) Hospital C 67,00 67,000 2,200 2,200 1,070 1,065 70,270 70,265 9 Hospital D 55,231 55,230 2,100 20,999 2,410 59,741 76,229 3) Which of the hospitals is doing a better job of capturing the Emergency 10 Hospital E 54,123 54,125 54,123 54,125 visits? 11 Hospital F 65,789 65,789 2,250 2,300 68,03 68,089 12 Hospital G 45,612 46,321 45,612 46,321 13 TOTAL 401,355 391,667 8,650 25,699 4,397 3,485 414,402 420,851 14 15 4) What Data Quality issues can you identify in the above? Include an example 16 for each DQ issue you found. (Hint: look at the other tables - is any 17 information missing? Do the numbers look correct? Are the Total ED visits 18 19 equal? Should they be?) 20 21 READ ME FIRST Data and Questions + + Ready Accessibility: Investigate 80%