Results 1 to 5 of 5

Thread: Regarding calculation of C.D.

  1. #1

    Regarding calculation of C.D.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    You need to explain more fully & attach an example workbook
    Hope that helps

    Roy

  3. #3
    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
    Attached Files Attached Files
    Last edited by spiffy; 2013-08-14 at 02:02 PM.

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    773
    Articles
    0
    Excel Version
    2010
    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

  5. #5
    Thanks all i figured it out myself..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •