# Regarding calculation of C.D.

#### spiffy

##### New member
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..

#### royUK

##### New member
You need to explain more fully & attach an example workbook

#### spiffy

##### New member
 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

#### Attachments

• Book1.xlsx
11.8 KB · Views: 15
Last edited:

#### Hercules1946

##### New member
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

##### New member
Thanks all i figured it out myself..