*Create a descriiptive 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.
*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.
*The dataset contains the following variables:
1. utilization (average number of patient days per month).
2. satisfaction (patient satisfaction scores percentile rank).
3. 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 descriiptive 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
Submit both the Word document and the Excel file that shows the descriiptive statistics output.
Grading Criteria
The numbered assessment instructions outlined below correspond to the grading criteria in the Descriiptive Statistics and Data Visualizations Scoring Guide, so be sure to address each point. You may also want to review the performance-level descriiptions for each criterion to see how your work will be assessed.
Perform the appropriate descriiptive statistics for selected variables in a dataset.
Report descriiptive 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 descriiptive statistics.
Write a separate summary for the histogram.
Write clearly and concisely, using correct grammar, mechanics, and APA formatting
