Competencies
1. Describe the data using the measures of central tendency and measures of variability.
2. Apply the normal distribution, standard normal distribution, and central limit theorem.
3. Develop a confidence interval for a population parameter.
4. Evaluate hypothesis tests for population parameters from one population.
5. Evaluate hypothesis tests for population parameters from two populations.
6. Determine the linear correlation and regression equation between two variables to make predictions for the dependent variable.
Project Deliverable tie to Competency
In the final assignment, you will demonstrate your understanding of all the competencies from the course, from using descriptive statistics to provide an overview of a data set, analyzing a distribution, making estimates using a confidence interval, conducting hypothesis test using one or more samples, and using regression analysis to make predictions.
Scenario
Your success in your prior position has opened new opportunities for you and you have accepted a new position at a local hospital where you will be able to apply your statistical knowledge and skills to help make evidence-based decisions to improve the care and well-being of patients.
As you settle into your new role, you are tasked to do a comprehensive analysis of patient data that will help all practitioners better understand the population they work with. The data set includes the following variables (including units of measurement, where applicable):
>Patient ID Number
>Age (in years)
>Intake Temperature (Degrees Fahrenheit)
>Length of Stay (Days)
>Pain Score (On a scale of 1 to 10)
>Department
Download the Excel Workbook provided below. Ensure that you use the data provided in the Workbook to make all calculations.
Instructions
The Excel Workbook contains eight tabs. The first tab contains the instructions. The second tab, labeled “data”, contains the raw data that will be used for your calculations. The next six tabs contain questions for you to answer. Ensure that you are completely answering all questions with explanations, and your work is shown in Excel when needed.
Submission Requirements
- You must submit the Workbook with the completed calculations, answers, and analysis.