Mathematics
Healthcare Statistics Excel Assigment

Question Description

I’m working on a Statistics question and need guidance to help me study.

Who can work these out for me in a timely fashion, like by this afternoon.

Healthcare statistics assignment.xlsx


Unformatted Attachment Preview

HIT 226 Course Project: Hospital Data Analysis and Reporting The data below is from General Hospital. Calculate the turnaround time for each request. Assume that the acceptable turnaround time is Release of Information Report for January 2015 # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Date Received 01/01/15 01/04/15 01/05/15 01/09/15 01/10/15 01/11/15 01/11/15 01/15/15 01/17/15 01/18/15 01/20/15 01/21/15 01/21/15 01/21/15 01/25/15 01/25/15 01/27/15 01/28/15 01/31/15 01/31/15 Client Name Jones, Johnny King, Samantha Piazza, Anthony Legend, Mary Stepnowski, Joseph Largent, Khalif Williams, Michael Teller, Aiden Hower, Layla Cartwright, Renee Perez, Stacey Santoso, Susan Williams, William Abrams, Jonah Stern, Kimberly Sran, Timothy Berger, Mark Romano, Maria Smith, Jennifer Martinez, Alonso Requestor Name PCP St. Lawrence PCP Attorney Robert Wood Johnson Mother PCP PCP Bayonne Medical Center Robert Wood Johnson PCP Attorney St. Lawrence St. Lawrence Robert Wood Johnson PCP PCP Attorney St. Lukes PCP Info Disclosed H&P D/C Summary D/C Summary D/C Summary X-rays D/C Summary H&P D/C Summary D/C Summary Lab reports X-rays X-rays D/C Summary D/C Summary H&P Lab reports X-rays D/C Summary D/C Summary D/C Summary Purpose of Disclosure Continuity of Care Continuity of Care Continuity of Care Litigation Continuity of Care Individual Continuity of Care Continuity of Care Continuity of Care Continuity of Care Continuity of Care Litigation Continuity of Care Continuity of Care Continuity of Care Continuity of Care Continuity of Care Litigation Continuity of Care Continuity of Care t the acceptable turnaround time is 21 days. Date Disclosed 01/11/15 01/24/15 02/04/15 02/18/15 01/11/15 03/02/15 01/17/15 01/20/15 02/26/15 02/01/15 03/05/15 03/01/15 01/28/15 04/05/15 01/31/15 02/05/15 02/09/15 02/01/15 03/03/15 05/04/15 5 points Records Offsite Staff ID # Turnaround Time N 14571 N 14571 N 25148 Y 25148 N 25148 N 14571 N 14571 N 25148 N 14571 Y 14571 Y 25148 N 14571 N 14571 N 25148 N 25148 N 25148 N 25148 N 14571 N 14571 Y 25148 HIT 226 Course Project: Hospital Data Analysis and Reporting The data below is from General Hospital. Calculate the turnaround time for each order. Assume that the acceptable turnaround time is 0 Physician Order Report for January 2015 Physician : Dr. Jones Client Medical Record #: 123456 Date of Admission: 1/6/15 Date of Discharge: 1/9/15 Date of Order Date Signed 01/06/15 01/06/15 01/06/15 01/06/15 01/06/15 01/07/15 01/07/15 01/08/15 01/07/15 01/07/15 01/08/15 01/08/15 2 points Turnaround Time Physicians: Dr. Huffman Client Medical Record #: 654789 Date of Admission: 1/10/15 Date of Discharge: 1/15/15 Date of Order Date Signed 01/10/15 01/10/15 01/10/15 01/10/15 01/10/15 01/11/15 01/10/15 01/11/15 01/11/15 01/11/15 01/12/15 01/12/15 01/12/15 01/14/15 01/12/15 01/14/15 01/12/15 01/14/15 3 points Turnaround Time HIT 226 Course Project - Data Analysis and Identification of Noncompliance - Due in Week 6, day 7 (Sunday midnight) The data below is from General Hospital. Assume the acceptable turnaround (TAT) for dictating the H&P is 0 day and signing is 1 day. History and physical dictation (how many days it took to dictate the H&P for each admission — subtract date of admission from the date o History and physical signature (how many days it took to sign the H&P — subtract date of admission from the date signed) History and Physical Report for January 2015 5 points # MR # Physician Date of Admission Date Dictated Date Transcribed Date Signed Dictated TAT 1 789321 Leiberman 01/04/15 01/04/15 01/04/15 01/04/15 2 456321 Huffman 01/04/15 01/05/15 01/05/15 01/06/15 3 741852 Patrikus 01/06/15 01/07/15 01/08/15 01/08/15 4 963321 Johns 01/07/15 01/08/15 01/07/15 01/09/15 5 144558 Huffman 01/10/15 01/10/15 01/11/15 01/10/15 6 695852 Leiberman 01/10/15 01/10/15 01/10/15 01/10/15 7 124536 Huffman 01/12/15 01/12/15 01/12/15 01/12/15 8 379152 Leiberman 01/15/15 01/16/15 01/16/15 01/16/15 9 685982 Jones 01/16/15 01/16/15 01/16/15 01/17/15 10 558844 Jones 01/17/15 01/17/15 01/17/15 01/18/15 11 415287 Johns 01/20/15 01/22/15 01/22/15 01/24/15 12 919125 Patrikus 01/20/15 01/20/15 01/20/15 01/22/15 13 744445 Patrikus 01/21/15 01/21/15 01/21/15 01/25/15 14 111111 Patrikus 01/21/15 01/21/15 01/21/15 01/22/15 15 145281 Huffman 01/26/15 01/26/15 01/27/15 01/27/15 16 144417 Leiberman 01/26/15 01/26/15 01/26/15 01/27/15 17 695833 Patrikus 01/27/15 01/27/15 01/27/15 01/31/15 18 335588 Johns 01/28/15 01/31/15 01/31/15 02/02/15 19 457924 Jones 01/31/15 01/31/15 01/31/15 02/01/15 20 414519 Huffman 01/31/15 01/31/15 01/31/15 02/01/15 unday midnight) &P is 0 day and signing is 1 day. t date of admission from the date of dictation) om the date signed) 5 points Signed TAT HIT 226 Course Project - Data Analysis and Identification of Noncompliance - Due in Week 6, day 7 (Sunday midnight) The data below is from General Hospital. Assume the acceptable turnaround (TAT) for dictating the discharge summary is 14 days and sign Discharge summary completion (how many days it took to dictate the DC for each admission — subtract date of discharge from the date o Discharge summary signature (how many days it took to sign the DC — subtract date of discharge from the date signed) Discharge Summary Report for January 2015 5 points # MR # Physician Date of Discharge Date Dictated Date Transcribed Date Signed Dictated TAT 1 789321 Leiberman 01/07/15 02/01/15 02/01/15 02/15/15 2 456321 Huffman 01/08/15 01/28/15 01/30/15 02/13/15 3 741852 Patrikus 01/10/15 01/25/15 01/18/15 02/12/15 4 963321 Johns 01/28/15 02/07/15 02/08/15 02/10/15 5 144558 Huffman 01/12/15 01/17/15 01/29/15 02/28/15 6 695852 Leiberman 01/11/15 01/11/15 01/31/15 02/12/15 7 124536 Huffman 01/18/15 02/15/15 02/15/15 02/21/15 8 379152 Leiberman 01/17/15 02/07/15 02/08/15 03/01/15 9 685982 Jones 01/19/15 01/19/15 01/20/15 01/21/15 10 558844 Jones 01/18/15 01/25/15 01/25/15 01/28/15 11 415287 Johns 01/21/15 01/24/15 01/25/15 01/31/15 12 919125 Patrikus 01/26/15 01/31/15 02/01/15 02/15/15 13 744445 Patrikus 01/24/15 02/04/15 02/04/15 02/06/15 14 111111 Patrikus 01/23/15 01/26/15 01/26/15 01/31/15 15 145281 Huffman 01/28/15 01/31/15 01/31/15 03/08/15 16 144417 Leiberman 01/31/15 02/28/15 02/28/15 03/04/15 17 695833 Patrikus 02/01/15 02/15/15 02/15/15 02/21/15 18 335588 Johns 02/01/15 02/15/15 02/15/15 02/19/15 19 457924 Jones 02/10/15 02/10/15 02/11/15 02/12/15 20 414519 Huffman 02/06/15 02/07/15 02/07/15 04/01/15 ge summary is 14 days and signing is 21 days. e of discharge from the date of dictation) 5 points Signed TAT HIT 226 Course Project - Data Analysis and Identification of Noncompliance - Due in Week 6, day 7 (Sunday midnight) The data below is from General Hospital. Assume the acceptable turnaround (TAT) for dictating the operative report is 0 days, transcribing Operative report completion (how many days it took to dictate the OP report for each admission — subtract date of surgery from the date Operative report signature (how many days it took to sign the OP report — subtract date of admission from the date signed) Operative Report for January 2015 5 points # MR # Physician Date of Operation Date Dictated Date Transcribed Date Signed Dictated TAT 1 789321 Leiberman 01/04/15 01/04/15 01/04/15 01/06/15 2 456321 Huffman 01/05/15 01/05/15 01/05/15 01/07/15 3 741852 Patrikus 01/06/15 01/07/15 01/07/15 01/07/15 4 963321 Johns 01/08/15 01/09/15 01/09/15 01/09/15 5 144558 Huffman 01/10/15 01/10/15 01/10/15 01/10/15 6 695852 Leiberman 01/10/15 01/10/15 01/10/15 01/10/15 7 124536 Huffman 01/13/15 01/13/15 01/13/15 01/13/15 8 379152 Leiberman 01/15/15 01/17/15 01/17/15 01/19/15 9 685982 Jones 01/16/15 01/17/15 01/17/15 01/20/15 10 558844 Jones 01/18/15 01/20/15 01/20/15 01/27/15 11 415287 Johns 01/21/15 01/22/15 01/22/15 01/22/15 12 919125 Patrikus 01/20/15 01/21/15 01/21/15 01/21/15 13 744445 Patrikus 01/22/15 01/22/15 01/22/15 01/23/15 14 111111 Patrikus 01/21/15 01/21/15 01/21/15 01/21/15 15 145281 Huffman 01/27/15 01/27/15 01/27/15 01/27/15 16 144417 Leiberman 01/26/15 01/31/15 01/31/15 02/02/15 17 695833 Patrikus 01/28/15 01/28/15 01/28/15 01/29/15 18 335588 Johns 01/28/15 01/29/15 01/29/15 01/29/15 19 457924 Jones 01/31/15 01/31/15 01/31/15 02/10/15 20 414519 Huffman 02/01/15 02/01/15 02/01/15 02/02/15 Sunday midnight) perative report is 0 days, transcribing is 1 day, and signing is 1 day. ubtract date of surgery from the date of dictation) n from the date signed) 5 points Signed TAT HIT226 Course Project: Hospital Data Analysis and Reporting The data below is from General Hospital. Populate columns I, J, and K. Evaluate each measure to determine whether it is better or worse. Core Measure Report for January 2015 - MI & CHF (Myocardial Infarction & Congestive Heart Failure) Heart Attach Care Average number of minutes before outpatients with chest pain or possible heart attack who needed specialized care were transferred to another hospital General Hospital 57 National Average 59 Average number of minutes before outpatients with chest pain or possible heart attack got an ECG 9 7 Outpatients with chest pain or possible heart attack who got drugs to break up blood clots within 30 minutes of arrival 43% 57% Outpatients with chest pain or possible heart attack who got aspirin within 24 hours of arrival 95% 96% Heart attack patients given fibrinolytic medication within 30 minutes of arrival 37% 58% Heart attack patients given PCI within 90 minutes of arrival 94% 96% Heart Failure Care Heart Failure patients given discharge instructions Heart Failure patients given an evaluation of left ventricular systolic (LVS) function Heart Failure patients given an ACE inhibitor or ARB for left ventricular systolic dysfunction (LVSD) General Hospital 94% 100% 75% National Average 94% 99% 97% sure to determine whether it is better or worse. 5 points Minimum Expected 60 5 points General Hospital's Results 10 50% 90% 50% 80% Minimum Expected 80% 80% 80% General Hospital's Results 5 points Comment on areas that need improvement Comment on areas that need improvement ...
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!