Control chart for paitents

1. In Health Administration Programs conducting satisfaction surveys are usually covered in courses on quality improvement. This exercise shows how data from satisfaction surveys can be analyzed over time. Assume that, in different time periods, 4 randomly selected patients rated their satisfaction with our services. Are we improving?
   • Please use the following peer video as a reference for this question. You can find the solution here here – Alternative Formats .
2. In Health Administration programs accounting courses typically cover cost data. Forensic accounting examines tries to detect fraud through accounting procedures. Following data were obtained regarding the cost of taking care of patients over several time periods. Are our costs within expectation?
   • Please use the following peer video as a reference for this question. You can find the solution here here – Alternative Formats .
3. Payment reform has made hospital payments more complex. One issue in payment reform is whether the net payments to hospitals is decreasing because of numerous carve outs for never-events. In health administration programs, payment reform is covered in several courses including courses on value-based payments, finance, quality and strategic planning. In this assignment, examine if payments for AMI have declined over 4 time periods indicated in the table below. Visit the following link to download the files listed below. Keep in mind that start and end periods of data are also given inside the files and that these do not correspond to the reporting year. Also note that the name of variables and files change over the years.

In these files the denominator indicates the number of patients. Payment indicates average payment per patient. Select data for hospitals that had at least 100 patients. Submit an Excel file containing the control chart for the data.

• In HOSArchive_20150122 look for file Heart Attack Payment – Hospital.csv, using measure ID PAYM_30_AMI, for the years 7/1/2010 to 6/30/2013. If you do not have MS Access database, you can use the Excel file attached to this assignment (look at top of assignment).
• In HOSArchive_20150716 in Hospital.mdb, use file HQI_HOSP_Payment with measure ID of PAYM_30_AMI, for the years 7/1/2011 through 6/30/2014. If you do not have MS Access database, you can use the Excel file attached to this assignment (look at top of assignment).
• In HOSArchive_20170428.zip, in Hospital.mdb, look for file HQI_HOSP_PaymentAndValueOfCare, use measure ID PAYM_30_AMI, for the dates 7/1/2012 through 6/30/2015. If you do not have MS Access database, you can use the Excel file attached to this assignment (look at top of assignment).
• In HOSArchive_Revised_FlatFiles_20180126.zip, look for file Payment and Value of Care – Hospital.csv, use measure ID PAYM_30_AMI, for the years 7/1/2013 through 6/30/2016. A CSV file can be read by Excel. Please download from Hospital Compare site.
• Look in hospital compare for additional data in later years reporting on measure ID of PAYM_30_AMI. Note that all later years of Hospital Compare, report separate CSV files.

1. Download the data for the recent years from Hospital Compare. Use as many years as available. Unzip the files and select select the file for “HCAHPS – Hospital”. This is the file for satisfaction surveys. Within these file select HCAHPS measure ID of “H_COMP_6_LINEAR_SCORE “. This is the linear mean of ratings of surveyed patients. It is a value between 0% and 100%, with 100% indicating most satisfied patients. Compare the performance of “Sibley Hospital” to its competitors in DC (providers 90001 90003 90004 90005 90006 90008 90011 93300). Are satisfaction levels in Sibley better than its competitors in DC?
   • You can find the solution here here – Alternative Formats .

Instructions

In order to complete this assignment you must submit an Excel file with each question answered in a separate sheet. Copy both the question prompts and your answers to the file. All calculations should be done by formulas and not as fixed values.