MHA FPX5107 Assessment 1 Descriptive Statistics and Data Visualization

 

 

Views: 771

MHA FPX5107 Assessment 1 Descriptive Statistics and Data Visualization: Analyzing negative aspects within a healthcare system is a crucial process. This assessment involves the evaluation of a healthcare institution’s overall performance through the use of statistical analysis and visual representations (Hariri & Bowers, 2019). The collected data includes information on monthly healthcare service utilization, patient satisfaction, and monthly readmission rates. The assessment employs the Microsoft Office Excel Analysis Tool Pack to conduct the statistical analysis, and the findings are then interpreted. Furthermore, the assessment discusses the implications of these interpretations in the context of existing literature.

The healthcare data analysis incorporates descriptive statistical tests to assess two key aspects: central tendency and data dispersion. To evaluate central tendency, the mean, median, and mode have been chosen for all three variables (utilization, satisfaction, and readmissions). Conversely, variance and standard deviation have been employed to gauge the extent of data dispersion (Feroze & Kulkarni, 2019).

Table Descriptive Statistics

Utilization		Satisfaction		Readmissions
Mean	69.822	Mean	49.357	Mean	0.106
Median	67.793	Median	51.5	Median	0.104
Mode	–	Mode	96	Mode	–
Standard deviation	21.639	Standard deviation	30.912	Standard deviation	0.048
Sample variance	468.25	Sample variance	955.566	Sample variance	0.002
Range	96.049	Range	97	Range	0.200
Sum	4887.5	Sum	3455	Sum	7.419
Count	70	Count	70	Count	70

Histogram for Data Visualization

Creating distinct categories and subdivisions within a sizable dataset is essential for efficient analysis. Histograms serve as valuable tools for visually representing these categories and divisions within the dataset (like MHA FPX5107 Assessment 1 Descriptive Statistics and Data Visualization). In this context, three histograms have been generated to delineate specific categories and enhance our comprehension of the prevailing conditions related to healthcare service utilization, patient satisfaction, and readmission rates. As an example, the histogram illustrating the utilization of healthcare services over the past 70 months is presented below:

MHA FPX5107 Assessment 1 Descriptive Statistics and Data Visualization

The analysis reveals that hospital utilization was notably low for six out of 70 months. On the other hand, there were 29 months with consistently high utilization, where the patient count ranged between 57 and 75. Additionally, there were 21 months marked by exceptionally high activity, with patient counts and healthcare service utilization exceeding 75. The patients treated during these busy months have been assessed for their satisfaction levels as follows:

Descriptive Statistics and Data Visualization

During the months when healthcare utilization was predominantly low, the patient satisfaction rate was notably high. The histogram clearly illustrates that patient satisfaction ratings exceeded 55 in approximately 32 months, while in 38 months, patients reported moderate satisfaction levels, which were less than 55. The correlation between patient satisfaction and readmission rates can be comprehensively examined across all months, as demonstrated in the histogram below:

MHA FPX5107 Assessment 1

At the end readmissions were minimal in approximately 25 mo

Order Now