Linear regression on leg length and lunge length data
1. I need to analyze the data in Worksheet 5-5 (attached). This data is real data that was collected by a doctor who specialized in leg and knee injuries. He gathered data from 43 people, indicated by their initials. Each person was required to perform three anterior (frontward) lunges with the right leg followed by three with the left leg. The distances were recorded. The person was then required to do three lateral (sideways) lunges with the right leg followed by three with the left leg. To use these lunges you will need to average the three trials to get a mean. You can use the Excel "=average(cellsReferenced)" computation to do this. By copying the formula down the column the task you can make short work of this. Not all of the tests below use the lunge information.
2. Complete a correlation and regression analysis on the data.
3. Answer the following questions:
a. Is there a difference in leg length (right v. left)? Use a paired t-test to determine the answer. Show all steps.
b. Is there a difference in lateral lunge (right v. left)? Use paired t-test to determine the answer. Show all steps.
c. Is there a correlation of height and leg length?
d. Is it possible to predict anterior lunge scores if the length of a patient's leg is known? Is it possible to predict anterior lunge scores if his/her height is known? Which is the better predictor? Show the scatter diagram with the linear regression equation for the best predictor.