# 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.

#### 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.

### Get Your Custom Job Done By a Professional Skilled Writer

Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Hire Writer Now. .

The post 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. appeared first on nursing term paper.

### Looking for a similar assignment? Get help from our qualified nursing experts!

Get 15% off your first order! Use our special coupon **"GET15"**