# Capella University Descriptive Statistics and Data Visualizations Summary

User Generated

Ybirqbirl305

Mathematics

Capella University

## Description

• Create a descriptive statistics table and histogram for selected variables in a dataset. Write a 2-3 page narrative summary in a Word document and insert the table and histogram graphic into this document.

#### Introduction

Note: You are strongly encouraged to complete the assessments in this course in the order they are presented.Descriptive statistics play an important role in analyzing data. It numerically summarizes key characteristics of variables. Measures of central tendency (mean, median, and mode) and dispersion (variance, standard deviation, and range) characterize the probability distribution. A histogram visualizes the distribution of numerical data indicating the number of data points that lie within a range of values. For this assessment, you will perform descriptive statistics and create a histogram for selected variables in a dataset.

#### Overview

Note: Complete the assessments in this course in the order in which they are presented.

#### Data Analysis Software

To complete the assessments in this course, you will need to use data analysis software to complete statistical calculations, create graphs, and tabular summaries, and share your results in a Microsoft Word document. You will use Microsoft Excel and Microsoft Excel Analysis ToolPak add-in. Be aware that not all statistical calculations, graphs, and tabular summaries can be completed in this software, so you may need to do some work outside of the software.
##### Microsoft Excel Data Analysis ToolPak Add-In for PC and Mac
Microsoft Excel Analysis ToolPak Activation for PC Users: The Microsoft Excel Analysis ToolPak is a specialized Excel add-in included in the standard Microsoft Office suite. If your Excel software meets the standard Capella University Computer Requirements, you will not need to purchase this software. However, you may need to activate the application before you can use it. If you do not own Microsoft Excel, Capella arranges for a significant discount for Microsoft Office for Capella learners. The following provides an overview of the Analysis ToolPak, instructions for loading and activation and instructions on using the ToolPak to perform data analysis. Note that these instructions are for 2016 and older versions of Microsoft Excel for PC and for the 2016 version only for Mac. If you are using a different version, you may need to search Microsoft's website for the appropriate instructions.

#### Preparation

Download the Assessment 1 Dataset [XLSX]. The dataset contains the following variables:
• utilization﻿ (average number of patient days per month)﻿.
• satisfaction (patient satisfaction scores percentile rank).

#### Instructions

Nursing home administration has the objectives of higher utilization, higher patient satisfaction, and lower readmissions, and they need to make a decision on whether to retain the department manager based on average performance over the past 70 months. For this assessment, create a descriptive statistics table and histogram based on the Assessment 1 Dataset. Write a narrative summary in a Word and insert the table and histogram graphic into this document. See Copy From Excel to Another Office Program for instructions. Submit both the Word document and the Excel file that shows the descriptive statistics output.

The numbered assessment instructions outlined below correspond to the grading criteria in the Descriptive Statistics and Data Visualizations Scoring Guide, so be sure to address each point. You may also want to review the performance-level descriptions for each criterion to see how your work will be assessed.
1. Perform the appropriate descriptive statistics for selected variables in a dataset.
• Report descriptive statistics table with measures of central tendency and dispersion.
2. Create a histogram that visually depicts the distribution of selected variables in a dataset.
3. Interpret statistical results used in the data analysis.
4. Write a narrative summary of the results that includes practical, administration-related implications of the descriptive statistics.
• Write a separate summary for the histogram.
5. Write clearly and concisely, using correct grammar, mechanics, and APA formatting.

Your assessment should meet the following requirements:
• Written communication: Write clearly, accurately, and professionally, incorporating sources appropriately.
• Length: 2–3 pages
• Resources: Not applicable.
• APA format: Cite your sources using current APA format.
• Font and font size: Times Roman, 12 point.

#### Competencies Measured

By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:
• Competency 2: Analyze data using computer-based programming and software.
• Perform the appropriate descriptive statistics for selected variables in a dataset.
• Competency 3: Interpret results of data analysis for value-based health care decisions, policy, or practice.
• Interpret statistical results used in the data analysis.
• Competency 4: Present results of data analysis to support a decision or recommendation.
• Create a histogram that visually depicts the distribution of selected variables in a dataset.
• Write a narrative summary of the results that includes practical, administration-related implications of the descriptive statistics.
• Competency 5: Communicate audience-appropriate health management content in a logically structured and concise manner, writing clearly with correct use of grammar, punctuation, spelling, and APA style.
• Write clearly and concisely, using correct grammar, mechanics, and APA formatting.
• SCORING GUIDE
• Use the scoring guide to understand how your assessment will be evaluated.

### Unformatted Attachment Preview

Purchase answer to see full attachment
3 pages
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

## Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.Hey there,I have completed this assignment 100% with accuracy and perfection. The analysis has been performed in excel and a detailed report has been written for you. I have uploaded both the files as a draft for now so that you can review them. If you want me to reduce the length of the report or many any changes/additions just send me a message and I will fix that for you :)If all is perfect, then mark this question as completed with a good tip :)I am now waiting for your feedback :)

Running head: STATISTICS REPORT

1

Descriptive Statistics and Data Visualizations
Student’s Name
Institutional Affiliation

STATISTICS REPORT

2
Descriptive Statistics and Data Visualizations
Introduction

The ultimate objective of the administration in a nursing home is higher patient
satisfaction, higher utilization, and lower readmission. The purpose of this report is to analyze
the performance of the departmental manager based on these three key measures and make a
final decision regarding whether the administration should retain the department manager or not.
Descriptive statistics and histograms will be generated for each of the three variables to analyze
the performance of the nursing home. The final decision would be made by comparing the data
analysis with the set benchmarks of the industry.
Statistics and Interpretation of the Statistical Results
Descriptive Statistics
The descriptive statistics have been generated for each variable in an excel spreadsheet
using the Data Analysis ToolPak (Black & Masten, 2020). These are shown in table 1 below:
Variables
Particulars
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count

utilization

satisfaction

69.8219826
49.35714286
2.58636947
3.694718726
67.79299514
51.5
#N/A
96
21.63911949
30.91223467
468.2514923
955.5662526
-0.369564621
-1.362485489
0.239965528
0.119793849
96.04877859
97
21.39799373
3
117.4467723
100
4887.538782
3455
70
70
Table 1: Descriptive Statistics

0.105987074
0.005776462
0.104060962
#N/A
0.048329353
0.002335726
-0.603746401
-0.010495708
0.200166819
0.007154269
0.207321088
7.419095158
70

STATISTICS REPORT

3

Table 1 above shows the summary of the entire dataset for each of the three variables.
The average utilization rate for the past 70 months is 69.82, with a standard deviation of 21.64
and a median value of 67.79. The goal of the nursing home is to maximize the utilization rate
equal to its standard deviation of 21.64, but it is far from close to this. Therefore, the nursing
home has a lot of room for improving its utilization rate to achieve 91.46 (69.82+21.64). The
range of 96.04 is too high for the current values.
The average satisfaction score for the past 70 months is 49.836, with a standard deviation
of 30.631 and a median value of 51.5. The goal of the nursing home is to maximize the
satisfaction scores and bring them close to the mode value of 96. Therefore, the nursing home
has a lot of room for improving its satisfaction score to achieve an average score of 96. The
range value for this measure is also too high.
The average readmission rate for the past 70 months is 0.11, with a standard deviation of
0.04 and a median value of 0.10. The goal of the nursing home is to reduce the readmission rate
by at least 0.04, which can mean a significant improvement. High quality healthcare and
healthcare improvements can help to reduce the readmission rates for the nursing home.
Histograms
The histograms have been generated for each of the three variables using an excel
spreadsheet, and these are shown below:

STATISTICS REPORT

4

Utilization Histogram
30

15
11
0
20

8

6
40

0
60

80

100

120

MORE

Figure 1: Utilization Histogram
Figure 1 shows the histogram for the utilization variable, and it is a bell-shaped curve
which means that the data for this variable is normally distributed. In other words, the
fluctuations in the utilization rates might be huge, but they are consistent, and thus the above
histogram is symmetrical in shape. The skewness value is close to 0, which means the data is not
skewed. Kurtosis, on the other hand, is -0.36, which means tails are thin, and distribution is flat,
as depicted in the above figure.

Satisfaction Histogram
17
15

14
12

12

0
0

0
20

40

60

80

100

MORE

STATISTICS REPORT

5
Figure 2: Satisfaction Histogram

The histogram for satisfaction scores in figure 2 is not normally distributed, and the shape
of the distribution is not symmetric. The skewness value is close to 0 because the data is not
skewed, but it is also not normally distributed with a bell-shaped curve. The kurtosis is also
negative for this variable as tails are thin and distribution is flat.

31
25

12

0
0

0.1

0.15

0.2

2

0

0

0.25

0.3

MORE

Figure 3: Readmission Histogram
The histogram in figure 3 for the readmission variable shows that the data is not normally
distributed, and it is rightward skewed. This means that the right tail is long as compared to the
left tail. The kurtosis for readmission rates is -0.6, indicating that tails are thin and distribution is
flat.
Narrative Summary with a Supported Management Decision
The performance of the nursing home based on all three measures is poor to average. The
utilization rate is low, and so the readmission rates are also low, and the overall results of the
statistical analysis are mixed. If the average statistics of the nursing home are compared with

STATISTICS REPORT

6

industry benchmarks, then the performance of the nursing home can be accurately analyzed.
Medicare's average length of stay is 30 days, with an occupancy rate of 87% (Smith et al., 2019).
...

### Review

Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4