Capella University Hospital Nurses and Staff Retention Study Summary

integrate your findings from Assessments 1–4 and describe how the survey was conducted. You will also reflect on the limitations of the survey and think about potential improvements for a future study.?

Demonstration of Proficiency

By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies through the following assessment scoring guide criteria.

Competency 1: Interpret a data set’s central tendency and variability using descriptive statistical procedures.

Interpret summary statistics for all survey questions.

Competency 2:? Evaluate the adequacy of data collection methods.

Evaluate constraints or limitations of conclusions based on survey results.

Competency 3:

Derive logical conclusions for inferential statistical calculations.

Derive logical conclusions for inferential statistical calculations.

Competency 4: Solve problems in your personal and professional life by applying statistical procedures.

Interpret statistical analysis of data to explain the meaning of the survey results.

Explain the significance of survey results to research goals addressing an issue in one’s personal or professional life.

Competency 5: Evaluate statistical arguments.

Recommend future study to further examine an issue in one’s personal or professional life.

In Assessments 1–4, you have gone through all steps from proposing a survey to producing and evaluating the survey data. For this assessment, you will analyze and integrate your findings from the previous components in Assessments 1–4. Write your paper from the viewpoint that you are presenting the information to an audience that is interested in your results. Include graphical representations as well as an explanation of descriptive and inferential measures, relating these components to the context of your survey. Only make claims that the data you collected can support.

The goal of your analysis and interpretation is to take the data that was collected and turn it into useful and usable information. Look for lessons that you learned from your data collection and results. What did you learn about the participants?

What surprised you?

Did you expect any of the results?

Are there issues that arose that you did not understand?

These may require further, more in-depth research. Discuss any limitations of the study.

In your paper:

Interpret and communicate your results to your target audience.

Include a brief summary of your population, sampling techniques, and survey.

Communicate results, interpretation, and analysis of all assessments, including graphs (circle, bar, histogram), measures of central tendency, measures of variation, confidence intervals, and hypothesis tests.

Your paper should contain both a summary of results and an interpretation and analysis of the results. Every survey question should be addressed in your interpretation. You will not be able to comment on every little finding, so you will have to make some judgments about what might be the most interesting or revealing results.

Formatting Instructions

Submit a 5–7 page, double-spaced paper that includes the following sections:

Title Page.

Brief Overview of Survey. Briefly describe the overall goal of the study, population, sampling techniques, and survey.

Findings and Results. Summarize the results of the survey.

State each question asked and the proportions and sample sizes for the binary questions; and the means, standard deviations, and sample sizes for the quantitative questions.

State the confidence interval for each question and/or the results of the significance tests for each question.

Analysis of Results. Interpret and analyze survey results.

What did you learn from your survey?

What conclusions could you reach based on the survey results?

What surprised you?Did you expect any of the results?Are there issues that arose that you did not understand?

How did the study relate to the issue in your personal or professional life that you wanted to examine?

Limitations and Constraints of the Study. Consider to what extent the survey gave you reliable information about the population.

Review whether your questions were clearly stated and unambiguous.

Explain whether the sample method was appropriate for the type of survey.

Discuss to what extent the information the data generator produced is realistic.

Recommendations for Future Study. What further study would help you examine the issue of interest in this study?

Q1
Q2
1
1
1
0
0
1
0
0
1
1
0
1
1
1
0
1
0
0
1
1
0
1
0
0
0
0
1
0
1
1
1
0
0
1
1
1
1
1
1
1
0
1
0
0
1
0
Q3
1
1
0
1
0
0
1
0
0
0
1
1
0
1
1
1
0
1
1
0
1
1
0
1
1
1
0
1
1
1
0
1
1
0
1
1
1
1
1
1
1
1
1
1
1
0
Q4
1
1
1
1
1
0
0
0
0
1
0
1
0
1
1
1
1
0
1
1
1
1
0
0
0
1
0
0
1
1
1
0
0
0
0
1
1
0
1
0
0
1
0
0
1
1
Q5
1
1
1
0
0
1
0
0
0
0
0
1
1
0
1
1
1
0
1
0
0
0
1
0
0
1
1
1
0
0
1
0
1
0
0
1
0
1
1
1
0
1
0
1
1
0
Q6
7
8
4
6
6
2
2
3
4
5
2
6
6
6
4
10
3
2
7
3
6
8
4
2
10
5
3
10
4
8
3
9
5
5
8
5
8
7
10
9
7
5
4
5
8
0
6
7
6
3
7
4
2
1
5
5
4
3
7
4
7
7
3
4
7
5
5
6
3
7
4
5
4
5
6
5
6
4
3
2
5
5
5
4
4
3
4
5
4
5
5
0
1
28
48
0,583333
0
0
1
1
1
1
33
26
26
48
48
48
0,6875 0,541667 0,541667
2
7
5,520833
5
5
2,566553
10
0
10
2,551508
5
5,479167
Pie Charts for questions 1-4
Question One
No
Yes
20
28
7
5
Sum of all 1s for questions 1-4
Number of answers for 1-4
Sample proportion for 1-4
4,895833 Sample means for questions 5 and 6
5 Sample median for questions 5 and 6
5 Sample mode for questions 5 and 6
1,402504 Sample standard deviation for 5&6
10 Max for 5&6
0 Min for 5&6
6 Range for 5&6
2,551508 standard deviation
5 Mode
5,479167 Average
Question Two
No
Yes
15
33
Question Two
Question One
No
No
Yes
Yes
Histogram for 5 & 6
Histogram for 5
This chart isn’t available in your version of Excel.
This chart isn’t available
Editing this shape or saving this workbook into a different file format will
permanently break the chart.
Editing this shape or savi
permanently break the c
Part 3
The two interesting findings from the data is that most participants were satisfied with the satffing of the units on any given s
Question Two
No
15
Yes
33
Question Two
35
30
30
25
20
15
10
5
0
No
Yes
Question Three
No
Yes
22
26
Question Four
No
Yes
Question Three
No
Yes
Histogram for 6
This chart isn’t available in your version of Excel.
Editing this shape or saving this workbook into a different file format will
permanently break the chart.
satffing of the units on any given shift and 33 participants agreed..
Question Four
No
Question Four
22
26
Question Four
No
Yes
Your assessment must be submitted using this template. Feel free to add additional work at the bottom, but the top must rem
There are five tables in this worksheet: two for statistical summary, two for confidence intervals, and one for hypothesis tests
To find a table quickly, press Ctrl+G. Press the Tab key to move to input areas of the table.
Note: See the worksheet named “Example” (in the bottom tab) for examples of how to fill in the yellow boxes.
Blank row, Table 1 begins in A8.
Blank row, Table 1 begins in A8.
Statistical Summary: Questions 1–4
Confidence Intervals: Questions 1–4
Sample
Question
Proportion Sample Size
#1
0.58333
48
#2
0.6875
48
#3
0.541667
48
#4
0.541667
48
End of Table 1, blank row. Table 2 begins in F8.
Question
Error
Lower Limit
#1
0.142318923 0.441011077
#2
0.133804506 0.553695494
#3
0.143835514 0.397831486
#4
0.143835514 0.397831486
End of Table 2, blank row. Table 3 begins in A15.
Statistical Summary: Questions 5–6
Confidence Intervals: Questions 5–6
Sample Std Sample
Question
Sample Mean
Dev
Size
#5
5.520833
2.566553
48
#6
4.895833
1.402504
48
End of Table 3, blank row. Table 4 begins in F15.
Blank row. Table 4 begins in F15.
Table 5 begins in F21.
Question
Error
Lower Limit
#5
0.740900033 4.779932967
#6
0.404868031 4.490964969
End of table, blank row. Table 5 begins in F21.
End of table, blank row. Table 5 begins in F21.
Hypothesis Tests: Questions 1–6
Question
Ho
#1
p≥ 0.55
#2
p≥ 0.60
#3
p≤ 0.65
#4
p=0.75
#5
μ=48
#6
μ≤ 48
End of table, blank row.
Ha
p≤ 0.55
p≤ 0.60
p≥ 0.55
p≠ 0.60
μ≠48
μ≥ 48
Rejection criteria:
Left-tailed test, reject Ho when z < -1.645. Right-tailed test, reject Ho when z > 1.645.
Two-tailed test, reject Ho when z < -1.96 or z > 1.96.
End of worksheet.
tom, but the top must remain.
d one for hypothesis tests.
yellow boxes.
ns 1–4
Upper Limit
0.725648923
0.821304506
0.685502514
0.685502514
3 begins in A15.
Conclusion
We are 95% confident the true population proportion is between 0.441 and 0.726.
We are 95% confident the true population proportion is between 0.554 and 0.821.
We are 95% confident the true population proportion is between 0.398 and 0.686.
We are 95% confident the true population proportion is between 0.398 and 0.686.
ns 5–6
Upper Limit
6.261733033
5.300701031
Conclusion
We are 95% confident the true population proportion is between 4.78 and 6.262.
We are 95% confident the true population proportion is between 4.491 and 5.301.
begins in F21.
begins in F21.
1–6
Reject Ho When
z < -1.645 z > 1.645
z < -1.96 or z > 1.96
z < -1.645 z < -1.96 or z > 1.96
z > 1.645
z < -1.96 or z > 1.96.
Test Statistic
Decision
0.464160662 Do not reject Ho
2.598076211 Do not reject Ho
-0.824953197 Do not reject Ho
-3.333328 Reject Ho
-30.98708731 Reject Ho
-563.6610365 Reject Ho
Summary
There is not sufficient statistical evidence to show the pop
There is not sufficient statistical evidence to show the pop
There is not sufficient statistical evidence to show the pop
There is sufficient statistical evidence to show the populat
There is sufficient statistical evidence to show the populat
There is sufficient statistical evidence to show the populat
IMPORTANT:
Be sure you change the population statistic in the
Test Statistic formula to reflect what you put in Ho
and Ha.