home work

Competencies

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.