quetions
1
Running Head: EFFECTS OF CALCIUM ON MORTALITY RATE
2
EFFECTS OF CALCIUM ON MORTALITY RATE
QUESTION 1
1. Please calculate the mean , median , and mode of the data set below. You should round the mean to TWO decimal places or your answer may be marked incorrect.
|
100 |
|
35 |
|
10 |
|
27 |
|
5 |
|
87 |
|
67 |
|
36 |
|
82 |
|
71 |
|
54 |
|
11 |
|
93 |
|
58 |
|
33 |
|
42 |
|
26 |
|
42 |
|
0 |
15 points
QUESTION 2
1. A school district is trying to determine if an analysis score of students from two different schools is the same. Using the data below, what conclusion can you provide?
You should provide a sentence conclusion, APA formatting of your statistics, and copy and paste your calculation from Excel. You may find it worth your time to also include your hypotheses.
|
East Analysis |
West Analysis |
|
82 |
35 |
|
46 |
20 |
|
23 |
36 |
|
48 |
38 |
|
72 |
56 |
|
40 |
60 |
|
75 |
36 |
|
79 |
41 |
|
57 |
48 |
|
75 |
74 |
|
44 |
59 |
|
85 |
51 |
|
40 |
22 |
|
80 |
77 |
|
57 |
75 |
|
76 |
30 |
|
63 |
45 |
|
20 |
84 |
|
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). Paragraph Arial 14px P 0 WORDS POWERED BY TINY |
20 points
QUESTION 3
1. For the following output, write a paragraph (3-4 sentences) discussing the result. Your paragraph should indicate:
1. What test was used
2. What the test measures
3. Whether the test is significant
4. What the result/decision was in terms of the variables and if any additional testing is necessary.
5. Report the statistics in APA format.
6. Make a statement of conclusion about what a researcher would learn from this result. (You may create what causes the differences in groups such as: location, worksheets, demographics, etc.)
|
SUMMARY |
|
|
|
|
|
|
|
Groups |
Count |
Sum |
Average |
Variance |
|
|
|
Group 1 |
24 |
1449 |
60.375 |
638.4185 |
|
|
|
Group 2 |
24 |
1490 |
62.08333 |
514.4275 |
|
|
|
Group 3 |
24 |
1338 |
55.75 |
500.8913 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Source of Variation |
SS |
df |
MS |
F |
P-value |
F crit |
|
Between Groups |
4253.153 |
2 |
2126.576 |
3.857765 |
0.02581192 |
3.129644 |
|
Within Groups |
38035.96 |
69 |
551.2458 |
|
|
|
|
|
|
|
|
|
|
|
|
Total |
42289.11 |
71 |
|
|
|
|
|
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). Paragraph Arial 14px P 0 WORDS POWERED BY TINY |
15 points
QUESTION 4
1. Write one to two sentences interpreting the output below and identifying the test used. Be sure to use proper APA formatting for full credit.
|
SUMMARY OUTPUT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Regression Statistics |
|
|
|
|
|
|
|
|
|
Multiple R |
0.140082939 |
|
|
|
|
|
|
|
|
R Square |
0.01962323 |
|
|
|
|
|
|
|
|
Adjusted R Square |
-0.029395609 |
|
|
|
|
|
|
|
|
Standard Error |
7.913238153 |
|
|
|
|
|
|
|
|
Observations |
22 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
|
|
|
|
df |
SS |
MS |
F |
Significance F |
|
|
|
|
Regression |
1 |
25.06778406 |
25.0677841 |
0.40032 |
0.534091772 |
|
|
|
|
Residual |
20 |
1252.386761 |
62.6193381 |
|
|
|
|
|
|
Total |
21 |
1277.454545 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 95.0% |
Upper 95.0% |
|
Intercept |
24.86622769 |
21.1210567 |
1.1773193 |
0.252889 |
-19.19152454 |
68.92397992 |
-19.19152454 |
68.92397992 |
|
Quality |
-0.154565933 |
0.244292449 |
-0.6327086 |
0.534092 |
-0.664151053 |
0.355019187 |
-0.664151053 |
0.355019187 |
|
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). Paragraph Arial 14px P 0 WORDS POWERED BY TINY |
15 points
QUESTION 5
1. Write one or two sentences intrepeting the following output while also identifying the test used. Remember to report statistics in APA format for full credit.
|
t-Test: Two-Sample Assuming Unequal Variances |
||
|
|
|
|
|
|
Group 1 Efficiency |
Group 2 Efficiency |
|
Mean |
44 |
59.44444444 |
|
Variance |
255.4117647 |
426.2614379 |
|
Observations |
18 |
18 |
|
Hypothesized Mean Difference |
0 |
|
|
df |
32 |
|
|
t Stat |
-2.50969204 |
|
|
P(T<=t) one-tail |
0.008668874 |
|
|
t Critical one-tail |
1.693888748 |
|
|
P(T<=t) two-tail |
0.017337747 |
|
|
t Critical two-tail |
2.036933343 |
|
|
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). |
Effects of Calcium on Mortality Rate
The ‘Hard Water Data Set’ is a sample of data collection showing the effect of calcium intake from hard water in a population living in the North and South regions. Data used to investigate the association of calcium content in hard water drunk and people's mortality rate over a certain period in the North and South regions.
Problem 1
From the data, there seems to be no relationship between calcium content and the mortality rate. An increase in mortality rate shows a decrease in calcium content intake. It indicates that the overall calcium intake in water was no way associated with the group's data mortality rate outcome. However, this means that hard water does not positively affect people's mortality rate in the north and south regions.
Conclusion:
In conclusion, calcium intake from hard water is essential for bone health and general body growth. As from the 'Hard Water Data Set', a higher intake of calcium didn't cause a high mortality rate in the two regions. It shows how essential calcium from hard water is for the strength and bone health of our bodies. Therefore, cancer and cardiovascular disease that might be the cause of death from calcium intake remain unclear.
References
West, S. (2010). Effects of calcium on cardiovascular events in patients with kidney disease and in a healthy population. Clinical Journal of The American Society of Nephrology, 5.
Jamal, S.A., (2009). Effects of calcium-based versus non-calcium-based phosphate binders on mortality among patients with chronic disease: a meta-analysis. Nephrology Dialysis Transplantation, 24(10), 3168-3174.