You need to explain more fully & attach an example workbook
i have a table as follow
CD at 5%: Plant growth Stages: 0.021, Treatments: 0.027, Treatment x Growth Stages: 0.047
Treatments (%) Plant growth stages Pre-flowering Flowering Post-flowering Control 9.25 10.34 25.19 0.10 % 10.24
13.44 25.64 0.15 % 16.32 20.64 30.23
0.20 % 21.94
27.23 37.44
0.25 % 22.04 31.76 40.14
i want to know how is this C.D at 5% calculated in excel for Plant growth Stages, Treatments and Treatment x Growth Stages as has been calculated in the above example..
Looking forward for your help
You need to explain more fully & attach an example workbook
Hope that helps
Roy
Consider the above table we have factors N(Nitrogen) and K (Potassium) the interaction of different levels (0,40,80, 120) of which we want to check.. we do a two factor ANOVA whose results are as
K0 K40 K80 K120 N0 4.752 5.010 5.413 5.251 N40 4.832 5.769 6.566 6.352 N80 5.328 6.181 7.084 7.054 N120 6.402 6.957 8.558 7.059
upto here it is clear to me but the table has an additional bit of stat which is
S.of Vari. df SS MSS F. value Significance Potassium 3 16.225347 5.408449 285762.338 ** Nitrogen 3 29.125817 9.708606 512966.623 ** Interaction 9 3.871900 0.430211 22730.757 ** Error 30 0.000568 0.000019 this is the part that i am not able to do.. i want to know how this C.D. at 5% is calculated
C.D. at 5% Potassium 0.00363 Nitrogen 0.00363 Interaction 0.00725
Hope you understand now
Last edited by spiffy; 2013-08-14 at 03:02 PM.
Spiffy
The spreadsheet looks like its calculations have been pasted as values from another source, which means that it won't be any help unless the user understands the elements of the calculations, and all the variables used are in the sheet (there is no guarantee of this when calculation results are pasted as values). Can you not go back to the source of this data and get an explanation or better still a copy of the calculations from there?
Hercules
Thanks all i figured it out myself..
Bookmarks