**NR3003: Quantitative Analysis- ****Summary Data Analysis Form**

NR3003: Quantitative Analysis- Summary Data Analysis Form

This is the form you need to use to describe the findings (or results) of your quantitative analyses of the patient safety data set. For each finding, you are given specific instructions on how to use the Excel program to analyze the data that will give you the results you need for this Assessment. When you have completed the analyses and described your findings on this form, submit this form along and the Qualitative Code Sheet to complete this Assessment.

**ORDER NOW FOR CUSTOMIZED SOLUTION PAPERS**

**ORDER NOW FOR CUSTOMIZED SOLUTION PAPERS**

**Analysis 1:**

What is the mean age of patients in the patient safety data set?

_____ years

**Instructions:**

- Open the patient safety data set using the Microsoft Excel program.
- At the top of the screen, click on Formulas.
- Highlight Column B, starting at line 2 and ending at line 52.
- Click on “Autosum,” and then click on “Average.”
- You will find the mean age of patients in the data set on line 52 for Column B.

__ __

**Analysis 2:**

What percentage of patients experienced a fall during their hospitalization?

_____ %

**Instructions:**

- Open the patient safety data set using the Microsoft Excel program.
- At the top of the screen, click on “Formulas.”
- Highlight Column G, starting at line 2 and ending at line 52.
- Click on “Sum.”
- The number of patients in the data set who had reported falls during their hospitalization is now given on line 52 of Column G.
- To calculate the percentage of patients who fell during their hospitalization, divide the number of falls by the total number of patients in the data set (n = 50).

__ __

**Analysis 3:**

What percentage of patients experienced catheter-associated urinary tract infections (CAUTIs) during their hospitalization?

_____ %

**Instructions:**

- Open the patient safety data set using the Microsoft Excel program.
- At the top of the screen, click on “Formulas.”
- Highlight Column H, starting at line 2 and ending at line 52.
- Click on “Sum.”
- The number of patients in the data set who reported CAUTIs during their hospitalization is now given on line 52 of Column H.
- To calculate the percentage of patients with CAUTIs during their hospitalization, divide the number of CAUTIs by the total number of patients in the data set (n = 50).

**Analysis 4:**

What percentage of patients experienced medication errors during their hospitalization?

_____ %

**Instructions:**

- Open the patient safety data set using the Microsoft Excel program.
- At the top of the screen, click on “Formulas.”
- Highlight Column I, starting at line 2 and ending at line 52.
- Click on “Sum.”
- The number of patients in the data set who reported medication errors during their hospitalization is now given on line 52 of Column I.
- To calculate the percentage of patients with reported medication errors during their hospitalization, divide the number of errors by the total number of patients in the data set (n = 50).

**Analysis 5:**

What percentage of patients experienced central line-associated bloodstream infection (CLABSI) within 48hours of central line placement during their hospitalization?

_____ %

**Instructions:**

- Open the patient safety data set using the Microsoft Excel program.
- At the top of the screen, click on “Formulas.”
- Highlight Column J, starting at line 2 and ending at line 52.
- Click on “Sum.”
- The number of patients in the data set with CLABSI within 48hours of their hospitalization is now given on line 52 of Column J.
- To calculate the percentage of patients with CLABSI, divide the number of patients with CLABSI by the total number of patients in the data set (n = 50).

**Analysis 6:**

What percentage of patients experienced *Clostridium difficile* Infection (CDI) within 48hours of central line placement?

_____ %

**Instructions:**

- Open the patient safety data set using the Microsoft Excel program.
- At the top of the screen, click on “Formulas.”
- Highlight Column K, starting at line 2 and ending at line 52.
- Click on “Sum.”
- The number of patients in the data set with CDI during their hospitalization is now given on line 52 of Column K.
- To calculate the percentage of patients with CDI, divide the number of patients with CDI by the total number of patients in the data set (n = 50).

Summarize the findings from your analyses about these patient safety events that occurred over the course of 1 month on the two medical units at this major urban hospital. Identify at least two pieces of additional information that is needed to decrease the occurrence of these events.

__ __