Patient Outcomes Project Part I: Aggregating and Displaying Data

Introduction
In this two-part assignment, you will be boiling down large amounts of data: to information and to usable knowledge. You will be analyzing data in two ways: First by creating a chart, then by performing aggregate analyses (average, sum, and min/max) on the data. Finally, you will use this information to inform a decision.
Scenario
Your institution has taken an interest in nurse staffing and patient outcomes. On reflection, you believe that your patients seem to have better care when there is a higher percentage of BSN nurses staffed on the skilled nursing unit. You decide to investigate this quality matter by looking at the data.
Assignment Guidelines
You begin your investigation by gathering data from electronic medical records for each month from the last calendar year. You have organized and saved the data in Sheet #1 “Pt Outcomes | BSN” of your Patient Outcomes Project (Excel) (Links to an external site.) file.
Displaying Data

Download the Patient Outcomes Project (Excel) (Links to an external site.) file and save it to your computer with your last name in the filename.
Use the data in Sheet #1 “Pt Outcomes | BSN” to develop a run chart. Use a style 2 line graph with the numbers of the vertical axis in the bubbles. (See Example Chart and Bullets (Word) (Links to an external site.).)
Create a new sheet in the file and move the embedded chart to its own tab titled “Monthly Chart.” This will be Sheet 2.

Aggregating Data

Use the appropriate aggregate functions in Excel to determine the average, sum, min/max for the number of falls, and the number of pressure ulcers, as well as the average of the % BSN.
Document this data on a fourth tab titled “Descriptive Stats” in the Excel file. Order it so that this sheet is the third sheet of the four.

Formatting and Mechanics
Submit one Excel file with four sheets:

Sheet 1: Pt Outcomes | BSN
Sheet 2: Monthly Chart
Sheet 3: Descriptive Stats
Sheet 4: Scores | # BSN (this sheet will be used in the next assignment)