Create a descriptive statistics table and histogram for selected variables in a dataset. Write a 2â€

  

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. 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. 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.Competency 3: Interpret results of data analysis for value-based health care decisions, policy, or practice.Competency 4: Present results of data analysis to support a decision or recommendation.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. Perform the appropriate descriptive statistics for selected variables in a dataset. Interpret statistical results used in the data analysis. 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. Write clearly and concisely, using correct grammar, mechanics, and APA formatting.
assignment_instructions.docx

descriptive_statistics_and_data_visualizations_scoring_guide.pdf

Don't use plagiarized sources. Get Your Custom Essay on
Create a descriptive statistics table and histogram for selected variables in a dataset. Write a 2â€
Just from $13/Page
Order Essay

cf_assessment_1_dataset.xlsx

Unformatted Attachment Preview

Overview
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.
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.
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.
Assignment Instruction
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.

Use the Analysis ToolPak to Perform Complex Data Analysis.
Preparation
Download the Assessment 1 Dataset [XLSX]. This is attached
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.
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, administrationrelated implications of the descriptive statistics.
• Write a separate summary for the histogram.
5. 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.
8/7/2019
Descriptive Statistics and Data Visualizations Scoring Guide
Descriptive Statistics and Data Visualizations Scoring Guide
CRITERIA
NONPERFORMANCE
BASIC
PROFICIENT
DISTINGUISHED
Perform the
appropriate
descriptive statistics
for selected
variables in a
dataset.
Does not
perform the
appropriate
descriptive
statistics for
selected
variables in a
dataset.
Incorrectly performs the
appropriate descriptive
statistics for selected
variables in a dataset.
Performs the
appropriate
descriptive
statistics for
selected
variables in a
dataset.
Performs the appropriate
descriptive statistics for
selected variables in a
dataset. Ensures the table is
complete, follows the correct
format, is well constructed,
and is easy to read.
Create a histogram
that visually depicts
the distribution of
selected variables in
a dataset.
Does not create
a histogram that
visually depicts
the distribution of
selected
variables in a
dataset.
Creates a histogram that
visually depicts the
distribution of selected
variables in a dataset but it
is incomplete or contains
errors.
Creates a
histogram that
visually depicts
the distribution
of selected
variables in a
dataset.
Creates a histogram that
visually depicts the
distribution of selected
variables in a dataset.
Ensures the histogram is
accurate, well constructed,
and easy to interpret.
Interpret statistical
results used in the
data analysis.
Does not
interpret
statistical results
used in a data
analysis.
Interprets statistical results
of an analysis but the
interpretation is incomplete,
inaccurate, or logically
inconsistent with the data.
Interprets
statistical
results used in
the data
analysis.
Interprets statistical results
used in the data analysis.
Ensures the interpretation is
complete, provides a
perceptive and clearly
articulated conclusion, and
includes an assessment of
caveats and limitations.
Write a narrative
summary of the
results that includes
practical,
administrationrelated implications
of the descriptive
statistics.
Does not write a
narrative
summary of the
results that
includes
practical,
administrationrelated
implications of
the descriptive
statistics.
Writes a narrative summary
of the results that contains
incorrect or insufficient
administration-related
implications of the
descriptive statistics.
Writes a
narrative
summary of the
results that
includes
practical,
administrationrelated
implications of
the descriptive
statistics.
Writes a scholarly narrative
summary of the results that
includes practical,
administration-related
implications of the
descriptive statistics. Draws
valid, fully justified
conclusions well supported
by scholarly literature.
Write clearly and
concisely, using
correct grammar,
mechanics, and APA
formatting.
Does not write
clearly and
concisely, using
correct grammar,
mechanics, and
APA formatting.
Writes in a manner that is
unclear and disorganized,
includes errors in grammar
and mechanics that inhibit
effective communication, or
contains incorrect or
improperly formatted
source citations and
references.
Writes clearly
and concisely,
using correct
grammar,
mechanics, and
APA formatting.
Writes clearly and concisely.
Ensures grammar,
mechanics, and APA
formatting are error free.
https://courserooma.capella.edu/bbcswebdav/institution/MHA-FP/MHA-FP5017/190700/Scoring_Guides/a01_scoring_guide.html
1/1
utilization satisfactionreadmissions
74.27057
100 0.084485
63.99188
16 0.177423
98.59192
31 0.164667
83.83318
3 0.178409
102.6872
89 0.007154
67.99378
22 0.150899
46.14154
19 0.044172
43.72361
29 0.048756
57.88714
79 0.165101
67.59221
59 0.142432
86.79082
70 0.020972
97.85154
26 0.064269
65.94915
22 0.126403
68.7699
51 0.160362
73.48808
10 0.143454
44.06588
52 0.117126
21.39799
8 0.096196
63.73128
6 0.058184
60.3591
21 0.122917
104.9315
35 0.124026
44.06642
19 0.068038
74.79688
19 0.094528
73.80654
12 0.147442
74.13603
7 0.098442
53.15719
45 0.207075
37.7386
71 0.036068
56.67985
6 0.104524
34.09113
62 0.118022
82.18294
57 0.207321
117.4468
55 0.145666
72.63796
69 0.089209
66.48575
99 0.101125
60.31853
78 0.075609
97.4345
60 0.150218
55.71568
74 0.124018
78.65189
37 0.124208
101.5713
15 0.187252
65.80222
11 0.026605
76.79661
11 0.10254
73.13039
96 0.075294
44.72086
29 0.056506
98.73114
96 0.048891
33.8434
83 0.174334
84.88798
78 0.131844
52.40842
96 0.167126
57.31398
81 0.112467
52.43385
65.57764
83.33311
43.04142
37.8057
74.8687
69.84653
65.56504
60.51123
71.25343
54.01618
51.56944
66.47474
110.626
35.71084
107.777
73.49521
96.69419
105.5554
64.83288
61.43368
69.81598
114.9896
87.70982
70
99
96
91
58
38
59
79
88
38
13
54
35
63
56
22
90
28
8
94
78
7
27
50
0.061826
0.131735
0.081496
0.099062
0.073216
0.144065
0.042271
0.030994
0.119027
0.180316
0.08865
0.106493
0.022939
0.162756
0.098004
0.078145
0.065701
0.119516
0.103598
0.015921
0.123979
0.114584
0.081302
0.10172

Purchase answer to see full
attachment

  
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more