Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!


MHA-FP5017 Capella Assessment 1 Descriptive Statistics and Data Visualizations

MHA-FP5017 Capella Assessment 1 Descriptive Statistics and Data Visualizations

Question 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.
  • Data Analysis Software
    • Use the Analysis ToolPak to Perform Complex Data Analysis.
    • utilization (average number of patient days per month) .
    • satisfaction (patient satisfaction scores percentile rank).
    • readmissions (readmission rate per month).
    • 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.
    • 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.

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.


Download the Assessment 1 Dataset [XLSX]. Attached as excel document

The dataset contains the following variables:


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.

Additional Requirements

Your assessment should meet the following requirements:

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Course Elite only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Course Elite are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Course Elite is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Course Elite, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.