1st: Please download the data set from (Assessment 1 Data Sheet)
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).
2nd: For this assessment, create a descriptive statistics table and histogram based on the Assessment 1 Dataset. Write a narrative summary in a Word document and insert the table and histogram graphic into this document.
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.
Here is how the assignment will be graded:
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.
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.
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.
