1
Running Head: QUANTITATIVE ANALYSIS
NURS 3150, Foundations of Nursing Research
Week 5 Assignment: Quantitative Analysis
Walden University
, 2
QUANTITATIVE ANALYSIS
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.
Analysis 1:
What is the mean age of patients in the patient safety data set?
The mean age of the patients is 54.8 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?
There were 38 % of patients that were reported to have a fall during their stay, nineteen
patients fell during their stay.
Instructions:
a) Open up your patient safety data set using the Microsoft Excel program.
b) At the top of your screen, click on “Formulas.”
Running Head: QUANTITATIVE ANALYSIS
NURS 3150, Foundations of Nursing Research
Week 5 Assignment: Quantitative Analysis
Walden University
, 2
QUANTITATIVE ANALYSIS
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.
Analysis 1:
What is the mean age of patients in the patient safety data set?
The mean age of the patients is 54.8 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?
There were 38 % of patients that were reported to have a fall during their stay, nineteen
patients fell during their stay.
Instructions:
a) Open up your patient safety data set using the Microsoft Excel program.
b) At the top of your screen, click on “Formulas.”
