How to calculate seed germination parameters (GP, GE, GRI, MGT and VI) in MS Excel?

Поділитися
Вставка
  • Опубліковано 21 січ 2025

КОМЕНТАРІ • 56

  • @think.mediocrity
    @think.mediocrity 11 місяців тому +1

    SUBSCRIBED, liked and sending you love.

  • @Dr.Wajid_Nazeer_Ansari
    @Dr.Wajid_Nazeer_Ansari 4 місяці тому

    Good effort, Weldon sir

  • @SiyabAlam-z1v
    @SiyabAlam-z1v Рік тому +1

    SIr I just watched your video and learnt alot from it.I want to connect with you.I am from Swat Pakistan and working at NARC Islamabad.

  • @mamaiefoundation4777
    @mamaiefoundation4777 6 місяців тому +1

    how do i add my values on the sheet ?

    • @mamaiefoundation4777
      @mamaiefoundation4777 6 місяців тому

      i have 9 treatments and 4 replications and the test took 20 days so i need to know how will i add my values on the sheet ?

    • @researchgate1989
      @researchgate1989  5 місяців тому

      @@mamaiefoundation4777 you need to modify the sheet accordingly and extend the formula as well.

  • @keitadjibrils.3167
    @keitadjibrils.3167 3 роки тому +2

    Thanks for the link 🤗

  • @benromdhaneoumayma8193
    @benromdhaneoumayma8193 2 роки тому

    Vraiment merci beaucoup pour la vidéo et surtout pour le fichier excel. ça m'a trop aidé

    • @researchgate1989
      @researchgate1989  Рік тому

      Je suis heureux d'être utile à la communauté de la recherche.

  • @sherekhan2212
    @sherekhan2212 3 роки тому +2

    Very informative video

  • @phd_unispeed3350
    @phd_unispeed3350 3 роки тому +2

    I don't understand what mean's Dxn and how to calculate it ?

    • @researchgate1989
      @researchgate1989  3 роки тому +2

      Dxn (Here D=the day that may be day 1st, 2nd,3rd, and so on while n=number of seeds germinated on that specific day. For example if its 1st day then D=1 and n= zero so we can calculate as Dxn=1*0) and continue the same for 2nd, 3rd and keep calculating.
      Hope it is clear now.

    • @sheetalchand1831
      @sheetalchand1831 Рік тому

      @@researchgate1989 sir in cae 3 seeds germinated on day 5 but total no. of seeds germinated are 5 out of 10 then what will be the value of n is it 3 or 5
      also is this sheet (updated one in the comments) reliable enough to use for thesis calculation?
      hoping for a reply.
      thank you,.

  • @dahbiaizountar61
    @dahbiaizountar61 3 роки тому +1

    Vraiment merci infiniment 💚💚

  • @olasuyikehindeezekiel6873
    @olasuyikehindeezekiel6873 3 роки тому +1

    Please how do I calculate emergence index

  • @gourabroy8712
    @gourabroy8712 8 місяців тому +1

    How to calculate average root length and hypocotyle length

  • @tlinha
    @tlinha 2 роки тому +3

    Thank you very much for your video!!! Can I ask about the germination rate index, why do you still divide the number of seeds by 5 from the 6th day to the 8th day? For example: =(E5/1)+(F5/2)+(G5/3)+(H5/4)+(I5/5)+(J5/5)+(K5/5)+(L5/5), but as I understood, I think it should be =(E5/1)+(F5/2)+(G5/3)+(H5/4)+(I5/5)+(J5/6)+(K5/7)+(L5/8).

    • @researchgate1989
      @researchgate1989  2 роки тому

      It depends when germination rate is stable

    • @tlinha
      @tlinha 2 роки тому

      @@researchgate1989 I have seen in your excel file. For example, in treatment T4, the germination rate is stable from the 3rd day but your formula doesn't change. Why?

    • @researchgate1989
      @researchgate1989  2 роки тому

      @@tlinha please consider control

    • @tlinha
      @tlinha 2 роки тому

      @@researchgate1989 sorry, can you explain more details?

    • @FabianGalvez-zo2fe
      @FabianGalvez-zo2fe Рік тому +2

      @@tlinha The same question. Also, T6, rep2 germination rate becomes stable at second measurement and formula keeps the same!

  • @rahilabibi2071
    @rahilabibi2071 2 роки тому +2

    Aslam Alaikum sir..how can we measure radicle and hypocotyl lenght

  • @artloverrarts
    @artloverrarts 2 роки тому

    Thank you!! Youre amazing

  • @chandrimaroy619
    @chandrimaroy619 2 роки тому

    Sir I am doing a work with Lathyrus sativus seeds ,i have a paper as reference there , I have seen the germination percentage of 3rd day is 89%+- 1 can you please explain this to me,and also tell me how can I calculate this......help please

  • @ObitodellaLL
    @ObitodellaLL 2 роки тому

    Thank you! Nice video :D

  • @TIZIANALOMBARDI
    @TIZIANALOMBARDI Рік тому

    sorry, what is Sum germinated?

  • @ThroughTheWorlds
    @ThroughTheWorlds Рік тому +1

    Hi 👋🏻 Thanks for this video! I have one question: what does it mean "DxN"? 🤔

  • @biologyquestionsbank8927
    @biologyquestionsbank8927 3 роки тому +1

    Can you please provide me any reference paper to cite all these. Thanks

    • @researchgate1989
      @researchgate1989  3 роки тому +3

      doi.org/10.1007/s00344-020-10104-5
      ageconsearch.umn.edu/record/209260/
      doi.org/10.1080/15427528.2011.576381
      en.cnki.com.cn/Article_en/CJFDTotal-CYKX200706012.htm

  • @huhuhuhuhu634
    @huhuhuhuhu634 Рік тому

    Hi sir, want to ask on the calculation of MGT, you put in formula in Dxn "(5*L6)" while it is on the 8th day. Shouldn't you should put (8*L6) since it is in the 8th day?

    • @sajjadsafi4221
      @sajjadsafi4221 Рік тому

      yes, MGT has problem. he called D*n, the number of days.......

  • @Dr.Wajid_Nazeer_Ansari
    @Dr.Wajid_Nazeer_Ansari 4 місяці тому

    Plz check, GP should be Sum number of seed/10*100 (P5/10*100)

  • @fatimazahraakhrif4883
    @fatimazahraakhrif4883 2 роки тому +1

    Hiii , Thanks for ur video !! Please can u explain how did u get 50 ?? sum germinated seeds ? thanks

  • @IbrahimEshkab
    @IbrahimEshkab 7 місяців тому +1

    assalamu alium, would you please send this excel sheet. Jazak Allah

  • @bushraparveen9900
    @bushraparveen9900 4 роки тому +2

    Thanks for making video, I just wanted to ask that when we are calculating MGT and putting formula in excel than how we will calculate number of days? from start of germination or start of experiment for example germination started at day 4 and 2 seed germinated than we will write D*n= 2*1 or 2*4??

    • @researchgate1989
      @researchgate1989  4 роки тому +1

      Please click the link (drive.google.com/file/d/1-E0I...
      )
      Then double click the cell below Sum # germinated it will show you how we sum the number of seeds germinated. Next, click the cell below Dxn it will show you the formula (day+#of seeds germinated on that day). Next, click the cell below MGT it will show you the formula MGT=Dxn /Sum # germinated.
      Simply you can calculate the number of days from the start of the experiment (day 1st means 24 hrs).
      If you need further assistance please share your email ID.

    • @brookemoseley4699
      @brookemoseley4699 4 роки тому +2

      @@researchgate1989 so i looked at the spreadsheet but the formula does no(t match with what has been plugged in for Dxn. How come after 5 days the remaining Dxn is times 5, so it goes (1*2)+2*3)+(3*6)+(4*9)+(5*8)+(5*9)+(5*10) etc

    • @aguarongoespadadehercules8819
      @aguarongoespadadehercules8819 4 роки тому +2

      I have the same question why you dont continue with =(1×..)+(2×..)+(3×..)+(4×..)+(5×..)+(6×..)+(n×..)..

    • @aguarongoespadadehercules8819
      @aguarongoespadadehercules8819 4 роки тому +1

      @@researchgate1989 help my friend

    • @researchgate1989
      @researchgate1989  4 роки тому +1

      @@aguarongoespadadehercules8819 Please click the link and you will find the updated MS Excel spreadsheet
      drive.google.com/file/d/1wEuP9IZEjHuajdJ2YwQCcxU8PsJOP7m0/view?usp=sharing

  • @agathiyaninadimai8055
    @agathiyaninadimai8055 3 роки тому +2

    Sir can you please give full explanation for this vedio please sir

    • @researchgate1989
      @researchgate1989  3 роки тому +1

      Its detailed tutorial, if any point please mention.

  • @akshitkukreti6689
    @akshitkukreti6689 2 роки тому +1

    Very informative video.
    Sir can you please give me this excel sheet?

  • @vikarkanalen
    @vikarkanalen 3 роки тому +1

    Of course the one I need to understand is glossed over quickly.. :(