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.