Linear Regression on Leg Length and Lunge Length
Not what you're looking for?
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.
Purchase this Solution
Solution Summary
A correlation analysis and a regression analysis were performed on a set of data (found in the attached Excel spreadsheet). These analyses, as well as additional t-tests, were used to answer questions about the data (questions 3a - 3d).
Solution Preview
1. I need to analyze the data in Worksheet 5-5. 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.
I calculated the average lunge for each person in the Excel worksheet.
2. Complete a correlation and regression analysis on the data.
I did these analyses in SPSS, just because I think it's easier to do a regression analysis using that software rather than Excel. If you prefer using Excel, you should still get the same results.
I only used the data in the second Excel worksheet (the means we calculated in part 1).
Correlation analysis:
(1) First, I looked at the correlations between each of the variables except for gender (using Pearson's correlation coefficient). There are several statistically significant correlations:
height and ...
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.