Estimation of parameters in a mixture of normal distribution from length frequency composition and growth formula by MS-Excel
2002
Gorie, S. (Fisheries Research Agency, Yokohama (Japan))
The Solver program on MS-Excel's worksheet was applied for the estimation of parameters in a mixture of normal distributions and Age-Length key. In the present study, I used the length frequency composition and growth formula of Japanese flounder, Paralichthys olivaceus, caught in the coastal waters of Hyogo Prefecture located in the Sea of Japan as a sample, and estimated the mixture rate and Age-Length key with the non-linear least squares and maximum likelihood methods. The mixture rates estimated by the two methods were almost the same, but the non-linear least squares method was more stable in obtaining a solution than the maximum likelihood method. If the merits and demerits of MS-Excel's Solver are well understood by users, the worksheet is considered a suitable method for modification to estimate the parameters of other species.
Show more [+] Less [-]AGROVOC Keywords
Bibliographic information
This bibliographic record has been provided by Agriculture, Forestry and Fisheries Research Information Technology Center