One-Way ANOVA and Grouping Information using Turkey Method
DBlaylock1979One-wayANOVAusingTukeyMethod.xlsx
Number of Shots
| Anova: Single Factor |
| SUMMARY |
| Groups |
Count |
Sum |
Average |
Variance |
| LOT # |
12 |
78 |
6.5 |
13 |
| (ATC) Number of Shots |
12 |
176 |
14.6666666667 |
27.1515151515 |
| (RIA) Number of Shots |
12 |
164 |
13.6666666667 |
20.7878787879 |
| ANOVA |
| Source of Variation |
SS |
df |
MS |
F |
P-value |
F crit |
| Between Groups |
476.2222222222 |
2 |
238.1111111111 |
11.7220288414 |
0.0001424883 |
3.284917651 |
| Within Groups |
670.3333333333 |
33 |
20.3131313131 |
| Total |
1146.5555555556 |
35 |
Mean Velocity
| Anova: Single Factor |
| SUMMARY |
| Groups |
Count |
Sum |
Average |
Variance |
| LOT # |
12 |
78 |
6.5 |
13 |
| (ATC) Mean Velocity |
12 |
26549 |
2212.4166666667 |
302401.537878788 |
| (RIA) Mean Velocity |
12 |
26556 |
2213 |
309462.909090909 |
| ANOVA |
| Source of Variation |
SS |
df |
MS |
F |
P-value |
F crit |
| Between Groups |
38938843.7222222 |
2 |
19469421.8611111 |
95.4574578171 |
0 |
3.284917651 |
| Within Groups |
6730651.91666667 |
33 |
203959.148989899 |
| Total |
45669495.6388889 |
35 |
Standard Deviation
| Anova: Single Factor |
| SUMMARY |
| Groups |
Count |
Sum |
Average |
Variance |
| LOT # |
12 |
78 |
6.5 |
13 |
| (ATC) Standard Deviation |
12 |
130 |
10.8333333333 |
52.1515151515 |
| (RIA) Standard Deviation |
12 |
126 |
10.5 |
72.2727272727 |
| ANOVA |
| Source of Variation |
SS |
df |
MS |
F |
P-value |
F crit |
| Between Groups |
139.5555555556 |
2 |
69.7777777778 |
1.5232635061 |
0.2329343016 |
3.284917651 |
| Within Groups |
1511.6666666667 |
33 |
45.8080808081 |
| Total |
1651.2222222222 |
35 |
Total Data Analysis
| Anova: Single Factor |
| SUMMARY |
| Groups |
Count |
Sum |
Average |
Variance |
| LOT # |
12 |
78 |
6.5 |
13 |
| (ATC) Number of Shots |
12 |
176 |
14.6666666667 |
27.1515151515 |
| (RIA) Number of Shots |
12 |
164 |
13.6666666667 |
20.7878787879 |
| LOT # |
12 |
78 |
6.5 |
13 |
| (ATC) Mean Velocity |
12 |
26549 |
2212.4166666667 |
302401.537878788 |
| (RIA) Mean Velocity |
12 |
26556 |
2213 |
309462.909090909 |
| LOT # |
12 |
78 |
6.5 |
13 |
| (ATC) Standard Deviation |
12 |
130 |
10.8333333333 |
52.1515151515 |
| (RIA) Standard Deviation |
12 |
126 |
10.5 |
72.2727272727 |
| ANOVA |
| Source of Variation |
SS |
df |
MS |
F |
P-value |
F crit |
| Between Groups |
90579913.962963 |
8 |
11322489.2453704 |
166.486571504 |
7.03082593040216E-54 |
2.0332946244 |
| Within Groups |
6732833.91666667 |
99 |
68008.4234006734 |
| Total |
97312747.8796296 |
107 |
Sheet1
| LOT # |
(ATC) Number of Shots |
(RIA) Number of Shots |
LOT # |
(ATC) Mean Velocity |
(RIA) Mean Velocity |
LOT # |
(ATC) Standard Deviation |
(RIA) Standard Deviation |
| 1 |
14 |
9 |
1 |
1419 |
1409 |
1 |
10 |
27 |
| 2 |
10 |
15 |
2 |
1832 |
1821 |
2 |
29 |
5 |
| 3 |
12 |
12 |
3 |
1812 |
1819 |
3 |
18 |
11 |
| 4 |
26 |
10 |
4 |
1902 |
1882 |
4 |
3 |
6 |
| 5 |
11 |
10 |
5 |
2679 |
2738 |
5 |
10 |
28 |
| 6 |
13 |
11 |
6 |
1426 |
1430 |
6 |
15 |
7 |
| 7 |
13 |
15 |
7 |
2352 |
2343 |
7 |
9 |
5 |
| 8 |
12 |
18 |
8 |
2367 |
2349 |
8 |
6 |
4 |
| 9 |
25 |
20 |
9 |
2894 |
2865 |
9 |
2 |
3 |
| 10 |
14 |
23 |
10 |
2116 |
2133 |
10 |
9 |
8 |
| 11 |
14 |
10 |
11 |
2696 |
2678 |
11 |
9 |
8 |
| 12 |
12 |
11 |
12 |
3054 |
3089 |
12 |
10 |
14 |