Discriptive stat

pleaae follow all directions using the provided data set 

Assessment 1 Instructions: Descriptive Statistics and Data

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

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.


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

Data Analysis SoftwareData 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,

Course Navigation 

Tyler Zerwekh

Kacie Goblirsch

3/30/23, 5:13 AM
Page 1 of 4

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


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 CriteriaGrading 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, administration-related implications of
the descriptive statistics.

3/30/23, 5:13 AM
Page 2 of 4

Write a separate summary for the histogram.


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

Additional RequirementsAdditional Requirements

Your assessment should meet the following requirements:

Written communication: Write clearly, accurately, and professionally, incorporating sources
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 MeasuredCompetencies 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

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.


Use the scoring guide to understand how your assessment will be evaluated.


3/30/23, 5:13 AM
Page 3 of 4

3/30/23, 5:13 AM
Page 4 of 4

utilization satisfaction readmissions
74.27057 100 0.0844848
63.991883 16 0.177423
98.591923 31 0.164667
83.833182 3 0.1784092
102.68718 89 0.0071543
67.993777 22 0.150899
46.14154 19 0.0441722
43.723615 29 0.0487564
57.887137 79 0.1651007
67.592213 59 0.1424319
86.790817 70 0.0209721
97.851545 26 0.0642694
65.949151 22 0.1264027
68.769903 51 0.1603615
73.488084 10 0.1434542
44.065877 52 0.1171261
21.397994 8 0.0961963
63.731283 6 0.0581837
60.359104 21 0.1229174
104.93151 35 0.1240264
44.066422 19 0.0680375
74.796883 19 0.0945278
73.806544 12 0.1474421
74.136029 7 0.0984423
53.157187 45 0.2070749
37.738602 71 0.0360682
56.679846 6 0.1045236
34.091127 62 0.1180218
82.182937 57 0.2073211
117.44677 55 0.1456658
72.63796 69 0.0892093
66.485747 99 0.1011252
60.318526 78 0.0756086
97.434502 60 0.1502176
55.715678 74 0.124018
78.651887 37 0.1242077
101.57127 15 0.1872522
65.802222 11 0.0266054
76.796606 11 0.1025398
73.130389 96 0.0752936
44.720859 29 0.0565061
98.731136 96 0.0488906
33.843399 83 0.1743344
84.887983 78 0.1318436
52.408418 96 0.1671262
57.313983 81 0.1124667
52.43385 70 0.0618262
65.577641 99 0.131735
83.333109 96 0.0814958
43.041424 91 0.0990624
37.805703 58 0.0732161
74.868698 38 0.1440654
69.846533 59 0.042271
65.56504 79 0.0309939
60.511232 88 0.1190274
71.253427 38 0.1803164
54.016184 13 0.08865
51.569441 54 0.1064931

3/30/23, 5:12 AM
Page 1 of 2

66.474741 35 0.0229385
110.62601 63 0.1627558
35.710838 56 0.0980043
107.77696 22 0.078145
73.49521 90 0.0657013
96.69419 28 0.1195158
105.55537 8 0.1035983
64.832881 94 0.0159208
61.433683 78 0.1239787
69.815978 7 0.1145837
114.98962 27 0.0813021
87.709819 50 0.1017198

3/30/23, 5:12 AM
Page 2 of 2

Calculate the price of your order

Select your paper details and see how much our professional writing services will cost.

We`ll send you the first draft for approval by at
Price: $36
  • Freebies
  • Format
  • Formatting (MLA, APA, Chicago, custom, etc.)
  • Title page & bibliography
  • 24/7 customer support
  • Amendments to your paper when they are needed
  • Chat with your writer
  • 275 word/double-spaced page
  • 12 point Arial/Times New Roman
  • Double, single, and custom spacing
  • We care about originality

    Our custom human-written papers from top essay writers are always free from plagiarism.

  • We protect your privacy

    Your data and payment info stay secured every time you get our help from an essay writer.

  • You control your money

    Your money is safe with us. If your plans change, you can get it sent back to your card.

How it works

  1. 1
    You give us the details
    Complete a brief order form to tell us what kind of paper you need.
  2. 2
    We find you a top writer
    One of the best experts in your discipline starts working on your essay.
  3. 3
    You get the paper done
    Enjoy writing that meets your demands and high academic standards!

Samples from our advanced writers

Check out some essay pieces from our best essay writers before your place an order. They will help you better understand what our service can do for you.

  • Analysis (any type)
    Advantages and Disadvantages of Lowering the Voting Age to Thirteen
    Undergrad. (yrs 1-2)
    Political science
  • Coursework
    Undergrad. (yrs 1-2)
    Business Studies
  • Essay (any type)
    Is Pardoning Criminals Acceptable?
    Undergrad. (yrs 1-2)
    Criminal Justice

Get your own paper from top experts

Order now

Perks of our essay writing service

We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.

  • Swift delivery
    Our writing service can deliver your short and urgent papers in just 4 hours!
  • Professional touch
    We find you a pro writer who knows all the ins and outs of your subject.
  • Easy order placing/tracking
    Create a new order and check on its progress at any time in your dashboard.
  • Help with any kind of paper
    Need a PhD thesis, research project, or a two-page essay? For you, we can do it all.
  • Experts in 80+ subjects
    Our pro writers can help you with anything, from nursing to business studies.
  • Calculations and code
    We also do math, write code, and solve problems in 30+ STEM disciplines.

Frequently asked questions

Get instant answers to the questions that students ask most often.

See full FAQ
  • Is there a possibility of plagiarism in my completed order?

    We complete each paper from scratch, and in order to make you feel safe regarding its authenticity, we check our content for plagiarism before its delivery. To do that, we use our in-house software, which can find not only copy-pasted fragments, but even paraphrased pieces of text. Unlike popular plagiarism-detection systems, which are used by most universities (e.g. Turnitin.com), we do not report to any public databases—therefore, such checking is safe.

    We provide a plagiarism-free guarantee that ensures your paper is always checked for its uniqueness. Please note that it is possible for a writing company to guarantee an absence of plagiarism against open Internet sources and a number of certain databases, but there is no technology (except for turnitin.com itself) that could guarantee no plagiarism against all sources that are indexed by turnitin. If you want to be 100% sure of your paper’s originality, we suggest you check it using the WriteCheck service from turnitin.com and send us the report.

  • I received some comments from my teacher. Can you help me with them?

    Yes. You can have a free revision during 7 days after you’ve approved the paper. To apply for a free revision, please press the revision request button on your personal order page. You can also apply for another writer to make a revision of your paper, but in such a case, we can ask you for an additional 12 hours, as we might need some time to find another writer to work on your order.

    After the 7-day period, free revisions become unavailable, and we will be able to propose only the paid option of a minor or major revision of your paper. These options are mentioned on your personal order page.

  • How will I receive a completed paper?

    You will get the first version of your paper in a non-editable PDF format within the deadline. You are welcome to check it and inform us if any changes are needed. If everything is okay, and no amendments are necessary, you can approve the order and download the .doc file. If there are any issues you want to change, you can apply for a free revision and the writer will amend the paper according to your instructions. If there happen to be any problems with downloading your paper, please contact our support team.
  • Where do I upload files?

    When you submit your first order, you get a personal account where you can track all your orders, their statuses, your payments, and discounts. Among other options, you will have a possibility to communicate with your writer via a special messenger. You will be able to upload all information and additional materials on your paper using the “Files” tab on your personal page. Please consider uploading everything you find necessary for our writer to perform at the highest standard.
See full FAQ

Take your studies to the next level with our experienced specialists

Live Chat+1 (857) 777-1210 EmailWhatsApp