1.Refer to the Visual Learner: Statistics for examples to help complete the problems in the Topic 5: Correlation/Regression and Chi Square Excel Worksheet.
1.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.

Having Trouble Meeting Your Deadline?
Get your assignment on 1.Refer to the Visual Learner: Statistics for examples to help complete the problems in the Topic 5: Correlation/Regression and Chi Square Excel Worksheet. completed on time. avoid delay and – ORDER NOW
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
