due in 8 hours (Research assignment)

1

Assignment #3: Quantitative Analysis

Part 2: Analysis of the data(quantitative result in graphical form is attached separately)

Analysis of data from the MN Hospital Report Data by Care Unit FY2013 was conducted. For purposes of this paper, sampling was limited to ten hospitals for their Medical Surgical unit with similar number of available bed and there med-surge data set. The table above demonstrated statistics consisting of the mean and median rate of available bed, the number of admissions, Med/Surg Patient Days and the charges.Average number of available beds of the ten facilities is calculated to 206 with the mean average of 20.6, the total admission was 1721 with the mean average of 172. For patient day, each day represents a unit of time during which the services of the institution or facility are used by a patient; for example, 50 patients in a hospital for 1 day would represent 50 patient days.The average median patient day for the 10 hospitals is calculated to 447 and a mean average of 614. The total mean average charges for all of the facilities are calculated to $731,991.20.

The dataset calculation shows that there are positive relationship between the number of available beds in each hospital and the number of beds in each surgical unit admissions. As the number of available beds effects the surgical unit admissions if the numbers of beds are increased, the number of surgical unit admissions will also be increased by different ratio.It also shows positive relation between the number of surgical unit admissions and the number of medical surgical unit patient days as the number of surgical admissions effects the number of beds for patients. Thus, if the number of admissions increases the number of beds will increase by about from 2% to 4 %.All the factors (number of admissions, number of beds,& number of patient’s days) will affect the surgical charges. If these factors increase it will effect increasing in the surgical charges.

Quantitative correlation analysis of patient satisfaction and the relationship with variables is indicated. These variables are wait time, length of direct provider interaction, andreadmission. Additional data was collected to meet this need. PubMedWeb.gov, and study results calculated from data collected university hospital setting (Court, 2002). Based on the questionnaire of waiting time that was completed for 812 patients, the median time spent in the emergency surgical unit was 100 minutes, 47% of patients saw a physician less than 15 minutes after their arrival. Forty percent of patients considered that they had to wait too long (Court, 2002). The hypothesis of this study claims a correlation exists between patient satisfaction and admission rate. The above listed hospitals on our database will have lower admission rate if patient satisfaction is low and if the waiting time is longer. If the number of available bed increased throughout the hospitals, patient wait time will decrease which then leads to more patient satisfaction.

Reference:

Court, Frank-Soltysiak (Nov 9, 2002). Waiting time and satisfaction of patients attending theemergency surgery unit of a university hospital center. PubMed US National Library of Medicine: Retrieved from http://www.ncbi.nlm.nih.gov/pubmed/12467148

The following statement about the graph can be inserted with part one.

This paper uses excel as it’s the cheapest method of analyzing the data and it’s easier to create graph/chart. We mentioned on our last assignment that SPSS can also be used. Although, this method can create a better graph, the software is not easily accessible as it needs to be downloaded and there is a fee involved.

The graph analysis was done using excel software by inserting the Scatter chart, also known as XY chart to compare pairs of values. Within this method, it’s then selected scatter with smooth line and markers to complete the chart. This is done by highlighting the data set to be analyzed then inserting the scatter method to create the graph. This is usually used when a few data points on the X-axis order and the data represents a function.