Abstract
The Solver program on MS-Excel's worksheet was applied for the estimation of parame- ters 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 fl ounder, 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 meth- ods. 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 meth- od. If the merits and demerits of MS-Excel's Solver are well understood by users, the worksheet is considered a suitable method for modifi cation to estimate the parameters of other species.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
