## Services on Demand

## Journal

## Article

## Indicators

- Cited by SciELO
- Access statistics

## Related links

- Cited by Google
- Similars in SciELO
- Similars in Google
- uBio

## Share

## Brazilian Journal of Botany

##
*Print version* ISSN 0100-8404

### Rev. bras. Bot. vol.32 no.4 São Paulo Oct./Dec. 2009

#### https://doi.org/10.1590/S0100-84042009000400022

**POINT OF VIEW **COLUNA OPINIÃO

**Calculating germination measurements and organizing spreadsheets**

**Calculando medidas de germinação e organizando planilhas eletrônicas**

**Marli A. Ranal ^{I,1}; Denise Garcia de Santana^{II}; Wanessa Resende Ferreira^{III}; Clesnan Mendes-Rodrigues^{IV}**

^{I}Universidade Federal de Uberlândia, Instituto de Biologia, Caixa Postal 593, 38400-902 Uberlândia, MG, Brazil

^{II}Universidade Federal de Uberlândia, Instituto de Ciências Agrárias, Caixa Postal 593, 38400-902 Uberlândia, MG, Brazil

^{III}Universidade Federal de Uberlândia, Instituto de Ciências Agrárias, Programa de Pós-graduação em Agronomia, Caixa Postal 593, 38400-902 Uberlândia, MG, Brazil

^{IV}Universidade Federal de Uberlândia, Instituto de Biologia, Programa de Pós-graduação em Ecologia e Conservação de Recursos Naturais, Caixa Postal 593, 38400-902 Uberlândia, MG, Brazil

**ABSTRACT**

With the objective to minimize difficulties for beginners we are proposing the use of a conventional spreadsheet for the calculations of the main germination (or emergence) measurements, the organization of the final data for the statistical analysis and some electronic commands involved in these steps.

**Key words:** germination rate, germination time, seed germination, synchrony, uncertainty.

**RESUMO**

Com o objetivo de minimizar as dificuldades dos iniciantes, estamos propondo o uso de planilhas eletrônicas convencionais para o cálculo das principais medidas de germinação (ou emergência), a organização dos dados finais para a análise estatística e alguns comandos eletrônicos envolvidos nesses passos.

**Palavras-chave:** germinação de sementes, incerteza, sincronia, tempo de germinação, velocidade de germinação.

Scientific urgency is determined by the need for its use. Many people have been contacting us since we published the book on the analysis of the germination process *Análise da germinação: um enfoque estatístico*, (Santana & Ranal 2004), but in a special way, people from other countries have been making inquiries after the publication of the review relating to this subject (Ranal & Santana 2006).

People have been inquiring about our procedures for the calculation of the germination measurements. The book, written in Portuguese, has some intermediate tables, essential for encouraging the user, but the review is only theoretical. Members of the examining board of the Master Degree Dissertation of the third author suggested the inclusion of an annex containing the intermediate tables to facilitate the work in Forest Seed Laboratories. Without doubt researchers could save time training the new members in their laboratories and beginners could have more autonomy to study and organize their data having these instructions on hand. Besides, instructions relating to the manipulation of spreadsheets usually are omitted from papers.

Thus, the purpose of this note is to facilitate the calculations of the main germination measurements (valid for seedling emergence) by means of the use of a conventional spreadsheet, the organization of the final data for the statistical analysis and also to show some Excel commands involved in these steps. The six measurements here presented are being used by us because each one measures only one aspect of the germination process including capacity (germinability or seedling emergence), time spent to germinate or emerge (mean germination time), speed (mean germination rate), homogeneity (coefficient of variation of the germination time), uncertainty, and synchrony (see limitations of each measurement in Ranal & Santana 2006).

To obtain accurate results, firstly it is necessary to be punctual and for this, each evaluation must be made at the same time, as was planned, in hours or days. Secondly, we must be organized and the spreadsheets have been programmed to assist us.

Supposing that you are collecting data of one experiment every 24 hours from seed sowing and you are going to prepare your first table. In the first column of this table, collection dates should be written (see table 1). In the second column (*t _{i}*) the time in days must be entered. If the readings were made at intervals of 6 hours, for example, the sequence would be 6, 12, 18, 24, 30 and so on, with the result reported in hours. It is necessary to enter the number of seeds germinated at the observation (not the accumulated values) in the third column (

*n*). The second and third are the two most valuable columns of this table (

_{i}*t*and

_{i}*n*), giving support to the construction of the subsequent columns with commands from the Excel program, for example. The mathematical expressions used in each column are presented in table 1, the Excel commands of each cell in table 2, and the calculus made using such expression for seeds of

_{i}*Anadenanthera colubrina*(Vell.) Brenan are presented in table 3. The first and the seventh rows of table 1 have mathematical expressions to make their recognition easier as part of the general expressions for the germination measurements (see references mentioned). It is recommended that in the spreadsheets more simple symbols should be adopted as in tables 3 and 4. This simple form dispenses the use of the "Microsoft Equation"at this stage of the work. Excel commands were used in the tables here included due to their easy access.

The row of the last germination of the experiment (see the *n _{i}* column of all sheets) is the limit to write the germination measurements as was expressed in row 9 of table 1. This position will facilitate the use of an important Excel command when the general sheet of the experiment is constructed. The expressions and Excel commands for the most important germination measurements are presented below based on the cells of table 3.

Germinability is the germination percentage. Excel command: =C17/A19*100 (C17 is the intersection between column C and row 17 of the sheet; number of sowed seeds is in A19; for the example of table 3 this number is 25). Insert the *n* value in A19.

Mean germination time is calculated by the expression , where *t _{i}*: time from the start of the experiment to the

*i*

^{th}observation (day for the example);

*n*: number of seeds germinated in the

_{i}*i*

^{th}time (not the accumulated number, but the number correspondent to the

*i*

^{th}observation), and

*k*: last time of germination. Excel command: =D17/C17.

Variance of germination time is calculated by the expression , where : mean germination time; *t _{i}*: time between the start of the experiment and the

*i*

^{th}observation (day for the example);

*n*: number of seeds germinated in the

_{i}*i*

^{th}time, and

*k*: last time of germination. The variance value will be used to calculate the

*CV*(see the command below).

_{t}Coefficient of variation of the germination time is calculated by the expression , where *s _{t}*: standard deviation of the germination time and : mean germination time. Excel command: =SQRT(G17/(C17-1))/C19*100. Replications or samples with only one seed germinated do not have the value of this measurement because the divisor of the variance of the germination time is zero.

Mean germination rate is calculated as the reciprocal of the mean germination time. Excel command: =1/C19.

Uncertainty of the germination process is calculated by the expression , being , where *n _{i}*: number of seeds germinated on the

*i*

^{th}time, and

*k*: last day of observation. Excel command: =-J17 (see the negative signal before J17).

Synchrony of germination is calculated by the expression , being = *n _{i}*(

*n*-1)/2, where: combination of the seeds germinated in the

_{i}*i*

^{th}time, two by two, and

*n*: number of seeds germinated in the

_{i}*i*

^{th}time. Excel command: =K17/COMBIN(C17;2).

*Z*is the quotient between the sum of the partial combinations of the number of seeds germinated in each

*t*, two by two (K17) and the two by two combination of the total number of seeds germinated at the end of the experiment, assuming that all seeds that germinated did so simultaneously.

_{i}Special attention should be given to the logarithm and combination columns when in a given time *t _{i}*, no seed could germinate or when only one seed could germinate. Thus, when the relative frequency of germination (

*f*) is equal to zero, the calculus of log

_{i}_{2}

*f*will be automatically expressed in the cell as #NUM! A similar situation will occur for the combinations

_{i}*C*

_{ni}_{,2}when

*n*

_{i}__<__1. In these cases, it is necessary to delete the symbol #NUM! so that Excel recognizes only numerical values when the summation of columns J and K are processed (table 3).

Table 3 has data of one replication of one treatment of *Anadenanthera colubrina* seeds, in this case, matrix number 1 (individual marked to collect the seeds). As the experiment was composed by seeds of five matrixes, each one with four replications, we constructed 20 sheets similar to this. At this moment we invite you to prepare your spreadsheet using table 3 as a model, the commands presented above, and the commands presented in table 2. At the end of this operation, the numbers of the 19^{th} row of table 3 will be copied in a general sheet, that is, in the sheet of your experiment, including all replications of each treatment (table 4).

The sequence of the germination measurements included in the last row of table 3 was determined to make use one important Excel command, necessary to make the preparation of the general sheet of the experiment easier. The values of the germination measurements presented in this row will be copied in a new sheet for statistical analysis. The measurements sequence presented in row number 1 of table 4 is the same as that presented in the 18^{th} row of table 3. To prepare row number 2 of table 4 you will click on the first position to copy the first measurement (C2, table 4), including the equal sign (=). Then you will return to the replication sheet (table 3) and click on the cell containing the value that will be copied (B19 of table 3), giving enter. Automatically the program shows the general sheet of the experiment (table 4) with the newly-copied value (96). If you observe, the Excel command included in this cell is =Sheet1!B19 (name of the sheet, exclamation point, letter of the column, and number of the row indicating the position of the copied number). Do not worry about this command because it is processed automatically. Click now over the newly-copied value and drag the row until column H. All values expressed in the 19^{th} row of table 3 are automatically copied. If some modification is processed in the sheet of one replication, the general sheet of the experiment will be automatically modified and this is the second advantage of this command. All things will be processed if all sheets of the experiment are saved in the same file.

Table 4, written according to the international system (point to separate decimals), could be copied to process the statistical analysis, using the command copy, special paste, and the option "values". Only the values will be copied, without the commands which are unnecessary for the statistical programs.

The final table used for publication is presented in table 5. By the way, the standard deviation communicated along side the mean germination time means the deviation of the mean time of all germinated seeds of each replication in relation to the mean time of the treatment. This mean time was obtained from the means of the replications and then includes the variability among seeds (genetic and environmental factor) and the variability among replications of the same treatment, including the effects of the experimental condition. The same is valid for the mean germination rate.

The procedures related to tables 4 and 5 are recommended if the experiment is based on some type of design, including treatments and replications, but if the experiment is based on samples, the organization and calculus presented on tables 1 and 2 can also be applied. The same calculus presented on tables 1 and 3 can also be processed if other statistical applications are chosen by the researchers as curves with means and dispersion measurements.

After the construction of one sheet like table 3 it will be tempting to use the commands SELECT RANGE, CTRL+C, and CTRL+V to copy a new sheet for the second replication of the experiment, for a second studied sample or for a second experiment, but pay attention because some numbers must be modified as the column of dates, the values of *n _{i}*, the

*n*value for the calculation of the germinability if the size of the sample is different, and the cells with the #NUM! command.

These instructions can be used for a free construction, without a spreadsheet model, but there is an electronic spreadsheet for download associated with this paper.

The last important point is the construction of the sheets when zero appears in several cells. In the spreadsheets for download there is one example and instructions related to zeros, to prepare the sheets for the statistical analysis. Consult Ranal & Santana (2006) if there are any doubts relating to zeros.

Our experience indicates that several days of instructions will be saved in our laboratories using these instructions with the advantage that the new student can repeat the operation *n* times to feel secure.

Acknowledgements – The authors register their thanks to the readers of the references here cited because their questions stimulated the organization of this note. Review of the English text was done by Mr. John David Bagnall. Anaximandro Rende helped us with the construction of spreadsheet version for download.

**References**

FERREIRA, W.R. 2007. Variabilidade de cinco espécies arbóreas da região de cerrado do Brasil Central para medidas de germinação e emergência. Dissertação de mestrado, Universidade Federal de Uberlândia, Uberlândia. [ Links ]

RANAL, M.A. & SANTANA, D.G. 2006. How and why to measure the germination process? Revista Brasileira de Botânica 29:1-11. [ Links ]

SANTANA, D.G. & RANAL, M.A. 2004. Análise da germinação: um enfoque estatístico. Editora UnB, Brasília. [ Links ]

(received: April 24, 2008; accepted: October 14, 2009)

1 Corresponding author: ranal@ufu.br

**Anexo**