Descriptive Statistics and Data Visualizations

Descriptive Statistics and Data Visualizations

ORDER CUSTOM, PLAGIARISM-FREE PAPERS ON Descriptive Statistics and Data Visualizations

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

Preparation

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

The dataset contains the following variables:

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.

Additional Requirements

Your assessment should meet the following requirements:

 

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 …