QUANTITATIVE DATA

2

Title of the Paper in Full Goes Here

Student Name Here

Program Name or Degree Name, Walden University

Course Number, Section, and Title

(Example: NURS 0000 Section 01, Title of Course)

Instructor Name

Month, Day, Year

(enter the date submitted to instructor)

Week 5: Quantitative Analysis Assignment

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. The data set is found in the Week 5 Learning Resources. 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 Assignment. When you have completed the analyses and described your findings on this form, you then need to submit it using the Week 5 platform for assignments.

Analysis 1:

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

_____ years

Instructions:

a) Open up your patient safety data set using the Microsoft Excel program.

b) At the top of your screen, click on “Formulas.”

c) Highlight Column B, starting at line 2 and ending at line 52.

d) Click on “Autosum,” and then click on “Average.”

e) You will find the mean age of patients in the data set on line 52 for Column B.

Analysis 2:

What percentage of patients were reported to have fallen during their hospitalization?

_____ %

Instructions:

a) Open up your patient safety data set using the Microsoft Excel program.

b) At the top of your screen, click on “Formulas.”

c) Highlight Column G, starting at line 2 and ending at line 52.

d) Click on “Sum.”

e) The number of patients in the data set who had reported falls during their hospitalization is now given on line 52 for Column G.

f) 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 reported catheter-associated urinary tract infections (CAUTIs) during their hospitalization?

_____ %

Instructions:

a) Open up your patient safety data set using the Microsoft Excel program.

b) At the top of your screen, click on “Formulas.”

c) Highlight Column H, starting at line 2 and ending at line 52.

d) Click on “Sum.”

e) The number of patients in the data set who reported CAUTIs during their hospitalization is now given on line 52 for Column H.

f) 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 reported medication errors during their hospitalization?

_____ %

Instructions:

a) Open up your patient safety data set using the Microsoft Excel program.

b) At the top of your screen, click on “Formulas.”

c) Highlight Column I, starting at line 2 and ending at line 52.

d) Click on “Sum.”

e) The number of patients in the data set who reported medication errors during their hospitalization is now given on line 52 for Column I.

f) 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 reported methicillin-resistant Staphylococcus aureus (MRSA) infections when first admitted to the medical unit?

_____ %

Instructions:

a) Open up your patient safety data set using the Microsoft Excel program.

b) At the top of your screen, click on “Formulas.”

c) Highlight Column J, starting at line 2 and ending at line 52.

d) Click on “Sum.”

e) The number of patients in the data set who reported MRSA infections at the beginning of their hospitalization is now given on line 52 for Column J.

f) To calculate the percentage of patients with MRSA, divide the number of errors by the total number of patients in the data set (n = 50).

Data Analysis

Summarize the findings from your analyses about these patient safety events that occurred in one month on the two medical units at this major urban hospital. What additional information would you need to help develop a plan to decrease the occurrence of these events? The summary should consist of a minimum of 350 words and should be two to three paragraphs. Citations should be used to support statements. After the summary, a reference section should be included.

References

List your own references in alphabetical order and in APA format. References should be published within the last five years. In your paper, be sure every reference entry matches a citation, and every citation refers to an item in the reference list.