Completely Randomized Design
1)Put data in Pink region and remove sample data, 2)Don’t delete an 3) if reading zero, add it but don’t add zero in blank region. Get ANO Replications/Treatments R1 R2 R3 R4 R5 R6 R7 Total Mean
T1 52 50 56 54 53
T2 58 52 60 57 56
T3 62 58 65 58 61
T4 66 69 70 67 66
265 53
283 56.6
304 60.8
338 67.6
4
Rank Mean Sqaure of Sum
20
3 35.2
2 34.8
T5
T6
T7
0 0 0 #DIV/0! #DIV/0! #DIV/0! 1 #DIV/0! #DIV/0! #DIV/0!
13.2
#DIV/0! #DIV/0! #DIV/0!
If the difference between highest and subsequent ranked treatment mean is lower than CD, it means the diff
Note: 1)Sheet has used freeze panes. 2) If any doubt in calculation, c
Don’t delete any number or formula from blue region gion. Get ANOVA table in FO coloum T8
T9
T10
T11
T12
T13
T14
T15
T16
T17
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
n CD, it means the differing treatment is not significantly different. And if the If the difference between highest and sub
n calculation, contact Dr Sangita Warade on 9860470598
T18
T19
T20
T21
T22
T23
T24
T25
T26
T27
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
etween highest and subsequent ranked treatment mean is higher than CD, it means the differing treatment is significan
T28
T29
T30
T31
T32
T33
T34
T35
T36
T37
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
g treatment is significantly different.
T38
T39
T40
T41
T42
T43
T44
T45
T46
T47
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T48
T49
T50
T51
T52
T53
T54
T55
T56
T57
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T58
T59
T60
T61
T62
T63
T64
T65
T66
T67
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T68
T69
T70
T71
T72
T73
T74
T75
T76
T77
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T78
T79
T80
T81
T82
T83
T84
T85
T86
T87
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T88
T89
T90
T91
T92
T93
T94
T95
T96
T97
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T98
T99
T100
T101
T102
T103
T104
T105
T106
T107
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T108
T109
T110
T111
T112
T113
T114
T115
T116
T117
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T118
T119
T120
T121
T122
T123
T124
T125
T126
T127
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T128
T129
T130
T131
T132
T133
T134
T135
T136
T137
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T138
T139
T140
T141
T142
T143
T144
T145
T146
T147
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T148
T149
T150
T151
T152
T153
T154
T155
T156
T157
0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T158
T159
T160
Total
Correction Factor =
square of total/n =
Error SS by direct formula 0 0 #DIV/0! #DIV/0!
0 #DIV/0!
#DIV/0! #DIV/0!
#DIV/0!
#DIV/0! #DIV/0!
#DIV/0!
1190
Standerd Error(SE) for unequal replications = Standerd Error(SE) for equal replications = 103.2
Put t value from table for df of n in the box = Critical Difference for unequal replications = t * SE Critical Difference for equal replications = t * SE
e of total/n =
suare of total n= t(number)= t-1= n-1= r= r-1= Error SS by direct formula=
equal replications = ual replications =
df of n in the box = equal replications = t * SE ual replications = t * SE
1416100 20 4 3 19 5 4 103.2 1.6062 1.6062 2.1310 3.4229 3.4229
70805
ANOVA Source of variation Between Treatments Error Total
Degree of Freedom(df)
Sum of Square(SS)
Mean Square(MS)
3 16
589.80 103.20
196.60 6.45
19
693.00 Coeficient of Variance(CV) = SD/mean=
F 30.5
10.15
Randomized Block Design
1)Put data in Pink region and remove sample data, 2)Don’t delete an 3) if reading zero, add it but don’t add zero in blank region. Get ANO Replications/Treatments R1 R2 R3 R4 R5 R6 R7
T1 22.9 25.9 39.1 33.9
T2 29.5 30.4 35.3 29.6
T3 28.8 24.4 32.1 28.6
T4 47 40.9 42.8 32.1
T5 28.9 20.4 21.1 31.8
T6
T7
Total
121.8
124.8
113.9
162.8
102.2
0
0
Mean
30.45
31.2
28.475
40.7
25.55
3
Rank Mean Sqaure of Sum
164.43
2 22.9
4 29.867
1 118.1
#DIV/0! #DIV/0! 5 #DIV/0! #DIV/0!
96.61
#DIV/0! #DIV/0!
If the difference between highest and subsequent ranked treatment mean is lower than CD, it means the diff
Note: 1)Sheet has used freeze panes. 2) If any doubt in calculation, c
Don’t delete any number or formula from blue region gion. Get ANOVA table in FO coloum T8
T9
T10
T11
T12
T13
T14
T15
T16
T17
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
n CD, it means the differing treatment is not significantly different. And if the If the difference between highest and sub
n calculation, contact Dr Sangita Warade on 9860470598
T18
T19
T20
T21
T22
T23
T24
T25
T26
T27
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
etween highest and subsequent ranked treatment mean is higher than CD, it means the differing treatment is significan
T28
T29
T30
T31
T32
T33
T34
T35
T36
T37
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
g treatment is significantly different.
T38
T39
T40
T41
T42
T43
T44
T45
T46
T47
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T48
T49
T50
T51
T52
T53
T54
T55
T56
T57
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T58
T59
T60
T61
T62
T63
T64
T65
T66
T67
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T68
T69
T70
T71
T72
T73
T74
T75
T76
T77
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T78
T79
T80
T81
T82
T83
T84
T85
T86
T87
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T88
T89
T90
T91
T92
T93
T94
T95
T96
T97
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T98
T99
T100
T101
T102
T103
T104
T105
T106
T107
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T108
T109
T110
T111
T112
T113
T114
T115
T116
T117
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T118
T119
T120
T121
T122
T123
T124
T125
T126
T127
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T128
T129
T130
T131
T132
T133
T134
T135
T136
T137
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T138
T139
T140
T141
T142
T143
T144
T145
T146
T147
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T148
T149
T150
T151
T152
T153
T154
T155
T156
T157
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
T158
T159
T160
Total 157.1 142.0 170.4 156.0 0.0 0.0 0.0
0
0
0
625.5
#DIV/0!
#DIV/0! #DIV/0!
Correction Factor =
square of tota
871.6
Standerd Error(SE) for unequal re Standerd Error(SE) for equal repli
#DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
Sqaure of Sum 332.228 246.5 275.128 17.78 #DIV/0! #DIV/0! #DIV/0!
431.9
Put t value from table for df of n i Critical Difference for unequal rep Critical Difference for equal replic
square of total/n =
suare of total n= t(number)= t-1= n-1= r= r-1= Error SS by direct formula=
391250.25 20 5 4 19 4 3 351.11
or(SE) for unequal replications = or(SE) for equal replications =
3.8248 3.8248 2.1790 8.3343 8.3343
om table for df of n in the box = ence for unequal replications = t * SE ence for equal replications = t * SE
19562.513
ANOVA Source of variation
Degree of Freedom(df)
Sum of Square(SS)
Between Replications Between Treatments Error Total
3 4 12 19
80.80 520.53 351.11 952.44
Coeficient of Variance(CV) = SD/mean=
22.64
Mean Square(MS)
F
26.93 130.13 29.26
0.92 4.45
Factorial RBD for three factors and two levels
1)Put data in Pink region and remove sample data, 2)Don’t delete an 3) if reading zero, add it but don’t add zero in blank region. Get ANO
If the difference between highest and subsequent ranked treatment mean is lower than CD, it means the diff
Note: 1)Sheet has used freeze panes. 2) If any doubt in calculation, c Replications/Treatments R1 R2 R3 R4 R5 R6 R7
T1 122.8 127.8 126
T2 108.2 117.6 107.1
T3 114.6 113.3 119.5
T4 115.8 108.6 124
T5 128.9 129.1 134.6
T6 112.4 123.8 115.8
T7 119.8 122.8 120.4
Total
376.6
332.9
347.4
348.4
392.6
352
363
Mean
125.5333
111
115.8
2
Rank Mean Sqaure of Sum
8
12.82667 66.607
one n
709.5 -43.7
two n
1405.3 -42.7 -13.7 44.7
three n
2871.5 -87.7 -36.7 80.9 60.9 -2.3 -9.3 -8.5
7
116.133 130.867 117.333 6
1
121
5
3
21.38
118.747 20.9267 68.5067
5.04
695.8 1
744.6 -40.6
721.6 -4.4
1466.2 -45 -23 36.2
Don’t delete any number or formula from blue region gion. Get ANOVA table in FO coloum
n CD, it means the differing treatment is not significantly different. And if the If the difference between highest and sub
n calculation, contact Dr Sangita Warade on 9860470598 T8 116.8 125.3 116.5
T9
T10
T11
T12
T13
T14
T15
T16
T17
358.6
0
0
0
0
0
0
0
0
0
119.533 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 4 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 49.9267 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
etween highest and subsequent ranked treatment mean is higher than CD, it means the differing treatment is significan T18
T19
T20
T21
T22
T23
T24
T25
T26
T27
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
g treatment is significantly different. T28
T29
T30
T31
T32
T33
T34
T35
T36
T37
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
T38
T39
T40
T41
T42
T43
T44
T45
T46
T47
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
0 0
T48
T49
T50
T51
T52
T53
T54
T55
T56
T57
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
T58
T59
T60
T61
T62
T63
T64
T65
T66
T67
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
T68
T69
T70
T71
T72
T73
T74
T75
T76
T77
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
T78
T79
T80
T81
T82
T83
T84
T85
T86
T87
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
0 0
T88
T89
T90
T91
T92
T93
T94
T95
T96
T97
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
T98
T99
T100
T101
T102
T103
T104
T105
T106
T107
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
T108
T109
T110
T111
T112
T113
T114
T115
T116
T117
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
T118
T119
T120
T121
T122
T123
T124
T125
T126
T127
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
0 0
T128
T129
T130
T131
T132
T133
T134
T135
T136
T137
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
T138
T139
T140
T141
T142
T143
T144
T145
T146
T147
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
T148
T149
T150
T151
T152
T153
T154
T155
T156
T157
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
T158
T159
T160
Total 939.3 968.3 963.9 0.0 0.0 0.0 0.0
0
0
0
2871.5
#DIV/0!
#DIV/0! #DIV/0!
0 0
Correction Factor =
square of tota
1113.6
Standerd Error(SE) for unequal re Standerd Error(SE) for equal repli
#DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
Sqaure of Sum 287.569 366.019 459.969 #DIV/0! #DIV/0! #DIV/0! #DIV/0!
364.0
Put t value from table for df of n i Critical Difference for unequal rep Critical Difference for equal replic
square of total/n =
suare of total n= t(number)= t-1= n-1= r= r-1= Error SS by direct formula=
8245512.25 24 8 7 23 3 2 302.90
or(SE) for unequal replications = or(SE) for equal replications =
3.7978 3.7978 2.3650 8.9819 8.9819
om table for df of n in the box = ence for unequal replications = t * SE ence for equal replications = t * SE
343563
ANOVA Source of variation Between Replications Between Treatments
Degree of Freedom(df)
2 7 T2 1 T3 1 T4 1 T5 1 T6 1 T7 1 T8 1 Error 14 Total 23 Coeficient of Variance(CV) = SD/mean=
Sum of Square(SS) 61.06 810.66 320.47 56.12 272.70 154.53 0.22 3.60 3.01 302.90 1174.62 5.97
Mean Square(MS)
F
30.53 115.81 320.47 56.12 272.70 154.53 0.22 3.60 3.01 21.64
1.41 5.35 14.81 2.59 12.60 7.14 0.01 0.17 0.14
SE
CD
1.8989241 4.4909555 1.8989241 4.4909555 2.6854842 6.3511701
Factorial RBD for two factors and four levels
1)Put data in Pink region and remove sample data, 2)Don’t delete an 3) if reading zero, add it but don’t add zero in blank region. Get ANO
If the difference between highest and subsequent ranked treatment mean is lower than CD, it means the diff
Note: 1)Sheet has used freeze panes. 2) If any doubt in calculation, c Replications/Treatments R1 R2 R3 R4 R5 R6 R7
T1 11.8 11.5 11.2
T2 12.38 12.3 12.2
T3 13.17 13.18 13.16
T4 13.85 13.88 13.8
T5 12.2 12.4 12.12
T6 12.79 12.7 12.8
T7 14.35 14.4 14.42
Total
34.5
36.88
39.51
41.53
36.72
38.29
43.17
Mean
11.5
12.293
13.17
13.8433
12.24
12.7633
14.39
16
Rank Mean Sqaure of Sum
0.18
one n
71.38 2.38
two n
152.42 4.4 9.66 -0.36
three n
313.08 5.28 20.3 -2.62 8.24 -3.52 0.98 -1.9
T1 T2 T3 T4 T5 T6 T7 T8 T9 T10 T11
659.7 8.42 39.2 -4.6 14.28 -3.52 -0.06 -2.38 33.54 -2.14 -1.4
14
11
8
0.0163 0.0002 0.00327
81.04 2.02
15
13
5
0.0416 0.00607 0.0026
75.01 1.57 160.66 0.88 10.64 -2.26
85.65 -0.69
T12 T13 T14 T15 T16
0.64 -2.2 3.52 -2.02 1.42
Don’t delete any number or formula from blue region gion. Get ANOVA table in FO coloum
n CD, it means the differing treatment is not significantly different. And if the If the difference between highest and sub
n calculation, contact Dr Sangita Warade on 9860470598 T8 14.18 14.1 14.2
T9 13 13.2 13.3
T10 13.56 13.5 13.6
T11 14.96 14.99 14.91
T12 15.08 15.1 15.09
T13 13.7 13.8 13.65
T14 14.2 14.1 14.25
T15 15.38 15.4 15.45
T16 15.5 15.3 15.6
T17
42.48
39.5
40.66
44.86
45.27
41.15
42.55
46.23
46.4
0
14.16
13.1667 13.5533 14.9533 7
12
10
4
15.09
13.7167 14.1833 3
9
15.41
6
15.4667 #DIV/0! 2
1 #DIV/0!
0.0056 0.04667 0.00507 0.00327 0.0002 0.01167 0.01167 0.0026 0.04667 #DIV/0!
80.16 1.16 170.29 1.57 9.97 -0.75 346.62 3.14 18.9 -1.98 6.04 -7E-015 -1.04 -0.48
90.13 0.41
83.7 1.4 176.33 1.57 8.93 -1.23
92.63 0.17
0 0 0 0 0 0 0 0 0 0 0 0 0 0
etween highest and subsequent ranked treatment mean is higher than CD, it means the differing treatment is significan T18
T19
T20
T21
T22
T23
T24
T25
T26
T27
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
g treatment is significantly different. T28
T29
T30
T31
T32
T33
T34
T35
T36
T37
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
T38
T39
T40
T41
T42
T43
T44
T45
T46
T47
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
0 0
T48
T49
T50
T51
T52
T53
T54
T55
T56
T57
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
T58
T59
T60
T61
T62
T63
T64
T65
T66
T67
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
T68
T69
T70
T71
T72
T73
T74
T75
T76
T77
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
T78
T79
T80
T81
T82
T83
T84
T85
T86
T87
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
0 0
T88
T89
T90
T91
T92
T93
T94
T95
T96
T97
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
T98
T99
T100
T101
T102
T103
T104
T105
T106
T107
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
T108
T109
T110
T111
T112
T113
T114
T115
T116
T117
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
T118
T119
T120
T121
T122
T123
T124
T125
T126
T127
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
0 0
T128
T129
T130
T131
T132
T133
T134
T135
T136
T137
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
T138
T139
T140
T141
T142
T143
T144
T145
T146
T147
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
T148
T149
T150
T151
T152
T153
T154
T155
T156
T157
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0
0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0
0 0 0 0 0 0
T158
T159
T160
Total 220.1 219.9 219.8 0.0 0.0 0.0 0.0
Sqaure of Sum 19.6502 19.9505 23.4012 #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0
0
0
659.7
63.0
#DIV/0!
#DIV/0! #DIV/0!
0 0
square of tota
Standerd Error(SE) for unequal re Standerd Error(SE) for equal repli
#DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
Correction Factor =
0.4
Put t value from table for df of n i CD Critical Difference for unequa CD Critical Difference for equal re
square of total/n =
suare of total n= t(number)= t-1= n-1= r= r-1= Error SS by direct formula=
435204.09 48 16 15 47 3 2 0.38
or(SE) for unequal replications = or(SE) for equal replications =
0.0918 0.0918 2.1310 0.1957 0.1957
om table for df of n in the box = ifference for unequal replications = t * SE fference for equal replications = t * SE
9066.7519
ANOVA Source of variation Between Replications Between Treatments
Degree of Freedom(df)
2 15 T2 1 T3 1 T4 1 T5 1 T6 1 T7 1 T8 1 T9 1 T10 1 T11 1 T12 1 T13 1 T14 1 T15 1 T16 1 Error 30 Total 47 Coeficient of Variance(CV) = SD/mean=
Sum of Square(SS) 0.00 62.62 2.95 64.03 0.88 8.50 0.52 0.00 0.24 46.872 0.191 0.082 0.017 0.202 0.516 0.170 0.084 0.379 63.01 8.42
Mean Square(MS)
F
0.00 4.17 2.95 64.03 0.88 8.50 0.52 0.00 0.24 46.87 0.19 0.08 0.02 0.20 0.52 0.17 0.08 0.01
0.16 0.16 0.16 0.16 0.16 0.16 0.16 0.16 0.16 0.16 0.16 0.16 0.16 0.16 0.16 0.16 0.16
SE
CD
0.045906759 0.0978273 0.045906759 0.0978273
0.064921962 0.1383487
