Regarding calculation of C.D.

[spiffy]

i have a table as follow

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

CD at 5%: Plant growth Stages: 0.021, Treatments: 0.027, Treatment x Growth Stages: 0.047


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

[royUK]

You need to explain more fully & attach an example workbook

[spiffy]

	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

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

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

upto here it is clear to me but the table has an additional bit of stat which is

C.D. at 5%
Potassium	0.00363
Nitrogen	0.00363
Interaction	0.00725

this is the part that i am not able to do.. i want to know how this C.D. at 5% is calculated

Hope you understand now

[Hercules1946]

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

[spiffy]

Thanks all i figured it out myself..