Welcome!

The macros are NOT WORKING under the Excel updates from 2015 versions.

Before starting the application "Comparison of Growth Curves," please bear in mind
the following conditions / suggestions:


> Have no open Excel file simultaneously;

> The application may need to be saved in a folder where there is no other Excel file;

> You should allow access to macros;
 
> You should have previously installed and activate the Solver supplement of Excel (http://office.microsoft.com/en-us/excel-help/load-the-solver-add-in-HP010021570.aspx);


Steps for using the application

I)   Collect individual age and length data of two fish populations;
II)  For each sample separately: Enter data in the first part of the application;
III) Select the mathematical model to fit the data;
IV)  Enter initial parameters values to estimate;
V)   Determine the estimated parameters and the adjusted R2;
VI)  Repeat steps (III) and (V) for the other models and select the one that best fits the data     (comparing the      value of adjusted R2 or outputting the graph with the inputted data and the curve fitted)
VII) Transport the results to the second and third parts of the application.
VIII)If the two samples follow two different models, the comparison process ends. However, the user can compare in        terms of rates, in the third part of the application – “Punctual Comparison”.
IX)  If the two samples follow the same model and parameter values are close, infer their differences using the second part of the application – “Likelihood ratio test”.


To test initially the application You may use the following data set:

Data set 1         	Data set 2
Age	Length  	Age	Length  	
1	15,4		1	15,4
2	28,03		2	26,93
3,3	41,18		3,3	42,23
4,3	46,2		4,3	44,59
5,3	48,23		5,3	47,63
6,3	50,26		6,3	49,67
7,3	51,82		7,3	50,87
8,3	54,27		8,3	52,3
9,3	56,98		9,3	54,77
10,3	58,93		10,3	56,43
11,3	59		11,3	55,88
12,3	60,91		
13,3	61,83		

(Data Lenght-at-age for the two kinds of species of Pacific hake (adopted from Kimura, 1980))

The results should 

Good Work!

Ana Borges
cborges.ana@gmail.com