Share
Explore BrainMass

ANOVA for total knee replacement data.

See the attached files.
Enter the attached data given to you into an Excel spreadsheet, calculate the requested statistics, and answer the following questions.

Data from Total Knee Replacement (TKR) patients was collected from 3 different clinics. The data that is given to you includes: Subject number, age, clinic and range of motion (ROM) measurements at 3 weeks, 6 weeks and 6 months post-op.

Question 1
a) You know that Clinic 1 uses a slightly different protocol than Clinic 2. To see if there is a significant difference in data between clinic 1 & 2 calculate a t-Test with ROM at 3 weeks at Clinic 1 & Clinic 2.
b) Is there a significant difference? How do you know? Explain using values. What does that tell you?
c) Calculate the median, mean and standard deviation (s) of 3 weeks ROM measurements from Clinic 1 and Clinic 2. (Show your work)
d) Using an Excel Spreadsheet set up a table to show this information.

Question 2
a) Compare ROM at 3 weeks between clinic 1, clinic 2 and clinic 3. Perform a one-way ANOVA.
You may copy and paste data onto another worksheet and rearrange columns to mimic the example from class
b) Do your results show a significant difference or not? Explain how you know by using values to explain. Explain what this means.

Questions 3
a) Now perform a one-way ANOVA to look at 3 week ROM compared to 6 week ROM and 6 month ROM from the total clinics.
b) Is there a significant difference? Explain what this means.
c) What is the mean ROM for 3 weeks, 6 weeks and 6 months?
d) Your p value (alpha) is set at .05 Why is that desirable? What does it mean

Case Age Clinic ROMWk3 ROMWk6 ROM6 M/O
1 50 1 95 90 100
2 87 1 32 46 82
3 66 1 67 78 100
4 46 1 92 85 105
5 53 1 87 85 105
6 76 1 58 50 95
7 43 1 92 95 110
8 46 1 88 90 100
9 43 1 84 80 95
10 48 1 81 90 105
11 92 2 34 63 90
12 65 2 56 71 90
13 76 2 45 63 78
14 92 2 27 35 65
15 68 2 76 70 95
16 79 2 49 56 98
17 85 2 47 58 84
18 82 2 50 60 80
19 81 2 40 40 83
20 90 2 67 70 95
21 66 3 32 67 105
22 72 3 50 67 105
23 68 3 60 65 95
24 77 3 84 80 105
25 60 3 81 85 100
26 75 3 81 94 110
27 73 3 84 90 100
28 72 3 81 95 103
29 72 3 82 90 104
30 63 3 91 95 106.

Attachments

Solution Preview

Please see the attached files.

Research Methods
34.616
Dr. Erika Lewis
Take-Home Portion of Exam 2

Instructions: Working in groups of 2 (NO more than two people), complete the following take-home exam questions as part of Exam 2. This is due next Tuesday, April 24, 2007 the same day that Exam 2 is given. It will be collected BEFORE the exam or it will be considered late. You must show all of your work for credit. Type your names onto the Excel program worksheets. Print out all of the worksheets. This assignment is worth 25% of your Exam 2 grade.

Enter the attached data given to you into an Excel spreadsheet, calculate the requested statistics, and answer the following questions.

Data from Total Knee Replacement (TKR) patients was collected from 3 different clinics. The data that is given to you includes: Subject number, age, clinic and range of motion (ROM) measurements at 3 weeks, 6 weeks and 6 months post-op.

Question 1
a) You know that Clinic 1 uses a slightly different protocol than Clinic 2. To see if there is a significant difference in data between clinic 1 & 2 calculate a t-Test with ROM at 3 weeks at Clinic 1 & Clinic 2.
b) Is there a significant difference? How do you know? Explain using values. What does that tell you?
c) Calculate the median, mean and standard deviation (s) of 3 weeks ROM measurements from Clinic 1 and Clinic 2. (Show your work)
d) Using an Excel Spreadsheet set up a table to show this ...

Solution Summary

The solution gives the complete steps of one way ANOVA of total knee replacement data.

$2.19