Nursing Home Performance Descriptive Statistics Paper

Nursing Home Performance Descriptive Statistics Paper

ORDER CUSTOM, PLAGIARISM-FREE PAPERS ON  Nursing Home Performance Descriptive Statistics Paper

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.Nursing Home Performance Descriptive Statistics Paper
  • 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.

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.Nursing Home Performance Descriptive Statistics Paper

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.Nursing Home Performance Descriptive Statistics Paper

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 …Nursing Home Performance Descriptive Statistics Paper