Refer to the Visual Learner: Statistics for examples to help complete the problems in the Topic 5: Correlation/Regression and Chi Square Excel Worksheet. Also to aide in the Excel calculations view the appropriate section of the Excel tutorials. Answer each question completely in the Excel worksheet provided.
2.Complete Exercise 23 and 24 in Statistics for Health Care Research: A Practical Workbook.
In order to receive full credit on calculated answers please show your work. (Use Words equation editor etc. and/or provides a short written description as to how you obtained the final result.) Exercise 24 includes 10 questions and a bonus question. Answer all questions including the bonus question.
SYS DIAS A: place correlation table here
104 61 SYS DIAS
99 64 SYS
102 65 DIAS
114 76
94 58
101 66 B: place regression equation table here
108 61 SUMMARY OUTPUT
104 41
123 72 Regression Statistics
93 61 Multiple R
89 56 R Square
112 62 Adjusted R Square
107 48 Standard Error
116 62 Observations
181 102
98 61 ANOVA
100 53 df SS MS F Significance F
127 74 Regression
107 67 Residual
116 71 Total
97 64
155 85 Coefficients Standard Error t Stat P-value Lower 95%
106 59 Intercept
110 70 SYS
105 69
118 82
133 83
113 75
113 66 C: Predicted diastolic pressure
107 67
95 59
108 72
114 79
104 73
125 73
124 85
92 46
119 81
93 64
106 64
Week 5 Workbook Exercises 23 & 24
To answer a question please click on Choose an item and on the drop-down arrow and choose an answer. Here is a resulting drop-down list:
If it is not working you can enter your answers to the table at the end of the file.
Exercise 23: Questions to be Graded
1. What is the r value for the relationship between Hamstring strength index 60/s and the Shuttle run test?
A. -0.149
B. -0.124
C. 0.247
D. 0.342
Answer: Choose an item.
Is this r value significant? Provide a rationale for your answer.
A. Yes. p-value<0.05. B. No. p-value =0.05. Answer: Choose an item. 2. Consider r = 1.00 and r = 1.00. Which r value is stronger? Provide a rationale for your answer. A. First one is stronger because it is positive. B. Neither is stronger. Both are the strongest linear relationship. Answer: Choose an item. 3. Describe the direction of the relationship between the Hamstring strength index 60/s and the Shuttle run test. A. It is positive. B. It is negative but not statistically significant. Answer: Choose an item. 4. Without using numbers describe the relationship between the Hamstring strength index 120/s and the Triple hop index. A. There is a statistically significantly positive strong relationship. B. There is no statistically significant relationship between them. Answer: Choose an item. 5. Which variable has the weakest relationship with the Quadriceps strength index 120/s? A. Hop index B. Triple hop index C. Shuttle run test D. Side step test Answer: Choose an item. Provide a rationale for your answer. A. Its absolute value is closer to 0. B. It is positive. C. It is negative. Answer: Choose an item. 6. Which of the following sets of variables has the strongest relationship? A. Hamstring strength index 120/s and the Hop index B. Quadriceps strength index 60/s and the Carioca test C. Quadriceps strength index 120/s and the Side step test D. Quadriceps strength index 60/s and the Triple hop index Answer: Choose an item. 7. In Table 5 two r values are reported as r = 0.498 and r = 0.528 (Shuttle run test or Side step test with first quadricepts strength index 60/s) A. There was as negative linear relationship for the studied variables. B. There was positive linear relationship for the studies variables. Answer: Choose an item. Indicate which would be more statistically significant and provide a rationale for your answer. A. -0.498 would be more statistically significant because p=0.004. B. -0.528 would be because p=0.002. Answer: Choose an item. 8. The researchers stated that the study showed a positive significant correlation between Quadriceps strength indices and pre- and postoperative functional stability. Considering the data presented in the Table 5 do you agree with their statement? Provide a rationale for your answer. A. Yes I agree with their statement. The values of many rs for the quadriceps index indicates a statistically significant relationship between pre and post-op functional stability. B. No. The table only show the relationship between strength indices and function after surgery. Answer: Choose an item. 9. The researchers stated that no significant relationship could be described between Hamstring strength indices 60/s and functional stability. Given the data in Table 5 explain why not. A. No p-values are<0.05. B. Some p-value is less than 0.05. Answer: Choose an item. 10. Consider the relationship reported for the Quadriceps strength index 120/s and the Hop index (r = 0.744** p = 0.000). What do these r and p values indicate related to statistical significance and clinical importance? A. The linear relationship is of statistical significance and maybe of clinical importance. B. The linear relationship is neither of statistical significance nor of clinical importance. Answer: Choose an item. Exercise 24 1. What is the r value listed for the relationship between variables 4 and 9? A. -0.45 B. -0.32 C. -0.22 D. 0.74 Answer: Choose an item. 2. Describe the correlation r = 0.32** using words. Is this a statistically significant correlation? Provide a rationale for your answer. A. It is a statistically significant moderate inverse linear relationship because p<0.01. B. It is a strong but not statistically significant relationship because it has two starts. Answer: Choose an item. 3. Calculate the percentage of variance explained for r = 0.53. Is this correlation clinically important? Provide a rationale for your answer. A. 15 percent. B. 28 percent. C. 53 percent. D. 75 percent. Answer: Choose an item. Is this correlation clinically important? A. Yes because r>=0.3 and it is significant.
“
