Assessment 1 Instructions: 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.
Introduction
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.
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).
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.
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.
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.