## 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).
- readmissions (readmission rate per month).

#### 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.#### Grading Criteria

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.- Perform the appropriate descriptive statistics for selected variables in a dataset.
- Report descriptive statistics table with measures of central tendency and dispersion.

- Create a histogram that visually depicts the distribution of selected variables in a dataset.
- Interpret statistical results used in the data analysis.
- Write a narrative summary of the results that includes practical, administration-related implications of the descriptive statistics.
- Write a separate summary for the histogram.

- Write clearly and concisely, using correct grammar, mechanics, and APA formatting.

#### Additional Requirements

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

## 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

readmissions

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.

Readmission Histogram

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).

...