MS-Excelを用いた混合正規分布のパラメータ推定

• 五利江 重昭

  農林水産技術総合センター水産技術センター

書誌事項

タイトル別名

• Estimation of Parameters in a Mixture of Normal Distributions from Length Frequency Composition and Growth Formula by MS-Excel.
• ＭＳ‐Ｅｘｃｅｌを用いた混合正規分布のパラメータ推定
• シリョウ MS Excel オ モチイタ コンゴウ セイキ ブンプ ノ パラメータ スイテイ

抄録

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.

収録刊行物

• 水産増殖

  水産増殖 50 (2), 243-249, 2002

  日本水産増殖学会

キーワード

• Mixture of normal distributions
• Least squares method
• Maximum likelihood method
• Japanese flounder

詳細情報

• CRID: 1390001204717950464
• NII論文ID: 10008750797
• NII書誌ID: AN00124667
• DOI: 10.11233/aquaculturesci1953.50.243
• ISSN: 21850194
• ISSN: 03714217
• NDL書誌ID: 6212646
• Web Site: https://agriknowledge.affrc.go.jp/RN/2030651534
• Web Site: http://id.ndl.go.jp/bib/6212646
• Web Site: https://ndlsearch.ndl.go.jp/books/R000000004-I6212646
• 本文言語コード: ja
• データソース種別:
  • JaLC
  • IRDB
  • NDL
  • CiNii Articles
• 抄録ライセンスフラグ: 使用不可