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

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)

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.

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 moreEach 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 moreThanks 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 moreYour 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 moreBy 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