NURS 3150 Week 5: Quantitative Analysis Essay

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. 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. NURS 3150 Week 5: Quantitative Analysis Essay

KINDLY ORDER NOW FOR A CUSTOM-WRITTEN, PLAGIARISM-FREE PAPER

Analysis 1:

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

_____ years

Instructions:

1. Open up your patient safety data set using the Microsoft Excel program.
2. At the top of your screen, click on “Formulas.”
3. Highlight Column B, starting at line 2 and ending at line 52.
4. Click on “Autosum,” and then click on “Average.”
5. 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? NURS 3150 Week 5: Quantitative Analysis Essay

_____ %

Instructions:

1. Open up your patient safety data set using the Microsoft Excel program.
2. At the top of your screen, click on “Formulas.”
3. Highlight Column G, starting at line 2 and ending at line 52.
4. Click on “Sum.”
5. The number of patients in the data set who had reported falls during their hospitalization is now given on line 52 for Column G.
6. 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:

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

Analysis 4:

What percentage of patients reported medication errors during their hospitalization?

_____ %

Instructions:

1. Open up your patient safety data set using the Microsoft Excel program.
2. At the top of your screen, click on “Formulas.”
3. Highlight Column I, starting at line 2 and ending at line 52.
4. Click on “Sum.”
5. The number of patients in the data set who reported medication errors during their hospitalization is now given on line 52 for Column I.
6. 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 reportedmethicillin-resistant Staphylococcus aureus (MRSA) infections when first admitted to the medical unit? NURS 3150 Week 5: Quantitative Analysis Essay

_____ %

Instructions:

1. Open up your patient safety data set using the Microsoft Excel program.
2. At the top of your screen, click on “Formulas.”
3. Highlight Column J, starting at line 2 and ending at line 52.
4. Click on “Sum.”
5. 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.
6. 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 1 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.

Reference

Gray, J. R, Grove, S. K., & Sutherland, S. (2017). The practice of nursing research: Appraisal,

synthesis, and generation ofevidence (8th ed.). St. Louis, MO: Elsevier.