1
Descriptive Statistics and Data Visualizations
Student’s Name
Tutor
Institution
Course
Date
2
Descriptive Statistics and Data Visualizations
Cambridge Nursing Home Data Analysis
The healthcare facility has the goal of achieving higher utilization rates, higher rates of
patient satisfaction, and lower readmission rates. The organization's management has been
thinking about whether to retain the current department manager based on the facility's average
performance over the past 70 months. However, to achieve and bring such a decision to actuality,
it is essential to conduct descriptive statistics analysis using the data obtained from the provided
information collected in the healthcare facility over the past 70 months.
Frey (2018) contends that the primary goal of carrying out descriptive statistics is to
ensure the maximization of information and effectiveness of communication while reducing the
loss of data. Therefore, descriptive statistics were conducted using the provided dataset from the
healthcare facility on readmission, utilization, and satisfaction rates over the given period. The
three standard measures of central tendency are the mode, mean and median. For the provided
dataset for satisfaction rate, readmission rate, and utilization rate, the three measures of central
tendency and a measure of dispersion, such as interquartile, standard deviation, and range, were
analyzed. The most common measure of dispersion is the standard deviation (SD) which shows
how the data is spread about the mean, according to Manikandan (2011).
Utilization
Utilization
20 120.00%
10 60.00%
Frequency
0 0.00% Frequency
03 35 38 57 75 67 e 73 06 Cumulative %
or
83 80 88 28 06 77 M 993 091
2 23 284 101 416 .44 345 97 04
.4 1.4 5.4 57. 105 3.4 .3 3.4
69 8 4 9 2 1 3
Bin
3
The utilization rate's central tendency measurements showed a mean value of 69.82, a
median value of 67.79, and no value for the mode. The utilization rate's measure of dispersion
showed a range of 96.05, a sample variance of 468.25, and a standard deviation of 21.64. The
average, median, and mode values for the central tendency for the satisfaction rate are 49.36,
51.50, and 96.0, respectively.
Patient Satisfaction
Satisfaction
120.00%
12
80.00%
8
Frequency
Frequency
4 40.00%
Cumulative %
0 0.00%
5 re 25 .25 75 75 75 1.5 3
.12 Mo .6 27 .3 7.8 75. 5
1 5 6 3 3 9 8
Bin
The range of the satisfaction rate's measure of dispersion is 97.0, the sample variance is
955.57, and the standard deviation is 30.91.
Readmission
Readmissions
16 120.00%
12 80.00%
8
40.00%
Frequency
4 Frequency
0 0.00% Cumulative %
8 1 6 6 3 4 1 re 9
7 67 853 682 023 938 597 512 Mo 426
3 5 1 0 7 9 7 5
0 72 322 822 823 572 571 321 0 71
1 1 0 1 1 0 0 0
0. 0. 0. 0. 0. 0. 0. 0.
Bin
4
Measures of the readmission rate's central tendency showed a mean value of 0.11, a
median value of 0.10, and no value for the mode. The readmission rate's measure of dispersion
showed a range of 0.20, a sample variance of 0.00, and a standard deviation of 0.05.
Descriptive Statistic Summary
Utilization Satisfaction Readmissions
Mean 69.8219826 Mean 49.35714286 Mean 0.105987074
Standard Error 2.58636947 Standard Error 3.694718726 Standard Error 0.005776462
Median 67.79299514 Median 51.5 Median 0.104060962
Mode #N/A Mode 96 Mode #N/A
Standard Deviation 21.63911949 Standard Deviation 30.91223467 Standard Deviation 0.048329353
Sample Variance 468.2514923 Sample Variance 955.5662526 Sample Variance 0.002335726
Kurtosis -0.369564621 Kurtosis -1.362485489 Kurtosis -0.603746401
Skewness 0.239965528 Skewness 0.119793849 Skewness -0.010495708
Range 96.04877859 Range 97 Range 0.200166819
Minimum 21.39799373 Minimum 3 Minimum 0.007154269
Maximum 117.4467723 Maximum 100 Maximum 0.207321088
Sum 4887.538782 Sum 3455 Sum 7.419095158
Count 70 Count 70 Count 70
The information revealed that the patient utilization rate first increased gradually. The use
rate eventually peaked and began to decline as the perk was used up. This could imply that there
was a slow initial admission rate into the nursing home, an increase in utilization rate when
admissions reached the facility's maximum capacity, but a decrease in use rate after readmission
rates started to decline. Because the investigation revealed a 49% patient satisfaction rate, which
is below average, there was some fluctuation in the patient satisfaction rate. The foundation of
good healthcare is patient pleasure. Shinde and Kapurkar (2014) contend that patient satisfaction
is a concrete criterion for evaluating health care and, consequently, the quality of nursing care."
Furthermore, the rate of readmission was rising but then began to fall. This can be a result of
staffing levels being cut back and care no longer being up to par. Low pay, physically demanding
5
labor, and other sources of job unhappiness make it challenging to maintain appropriate staffing
to ensure high-quality long-term care, according to Zhang et al. (2014).
Interpretation of statistical analysis
The data analysis for utilization rate revealed a utilization rate of 69%, indicating that
patients were able to access and uses the nursing home's services to improve patient outcomes.
49% was the satisfaction rate, which is below average. This could imply that there is still much
to be done in terms of nursing home patient care, patient safety, and care quality. The 11%
readmission rate is comparatively low. This can be due to inadequate care or outdated equipment
at the nursing home. PPE shortages have been recorded in many nursing homes, which have
resulted in the use of subpar equipment or the sharing of equipment amongst patients with and
without COVID-19 (Whoriskey et al., 2020).
It is worth noting that based on the study that was done, the organization's management
objectives of a better utilization rate were a net success. Because the average patient satisfaction
studied was below average, higher patient satisfaction could not be achieved. The healthcare
facility's administration had anticipated a low readmission rate. The organization's management
may decide not to keep the department manager based on the analysis supplied and the manager's
performance.
6
References
Frey, B. B. (Ed.). (2018). Descriptive statistics. In The SAGE encyclopedia of educational
research, measurement, and evaluation (Vols. 1–4). Thousand Oaks, CA: Sage.
Manikandan, S. (2011). Measures of central tendency: Median and mode. Journal of
Pharmacology and Pharmacotherapeutics, 2(3), 214. https://doi.org/10.4103/0976-
500x.83300
Shinde, M., & Kapurkar, K. (2014). Patient’s satisfaction with nursing care provided in selected
areas of tertiary care hospital. International Journal of Science and Research, 3(2), 150–
160.
Whoriskey, P., Cenziper, D., Englund, W., Jacobs, J. (2020). Hundreds of nursing homes ran
short on staff, protective gear as more than 30,000 residents died during pandemic
https://www.washingtonpost.com/business/2020/06/04/nursing-homescoronavirus-
deaths/
Zhang Y., Punnett L., Gore R. (2014). CPH-NEW Research Team Relationships among
employees' working conditions, mental health, and intention to leave in nursing homes. J
Appl Gerontol Off J South Gerontol Soc; 33(1):6–23.
