Create a descriptive statistics table and histogram for one of the three variables in a data set. Write a 2-3 page recommendation and plan of action in a Word document and insert the table and histogram graphic into this document. Submit both the Word document and the Excel file that shows the descriptive statistics output.
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 data set 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. Select one of the three variables to analyze to create a plan of action for improvement. Provide a rationale for your selection. Base your analysis on average performance over the past 70 months.