期刊
PHOTOSYNTHETICA
卷 51, 期 3, 页码 445-456出版社
SPRINGER
DOI: 10.1007/s11099-013-0045-y
关键词
curve fitting; iteration; nonlinear regression; P-N/I curve; Solver function
资金
- Instituto Nacional de Ciencia e Tecnologia em Areas Umidas (INAU)
- Programa Institutos Nacionais de Ciencia e Tecnologia (CNPq/MCT)
- Fundacao de Amparo a Pesquisa do Estado de Mato Grosso (FAPEMAT)
- Conselho Nacional de Desenvolvimento Cientifico e Tecnologico (CNPq)
- Office Of The Director
- Office Of Internatl Science &Engineering [0968245] Funding Source: National Science Foundation
In this study, we presented the most commonly employed net photosynthetic light-response curves (P (N)/I curves) fitted by the Solver function of Microsoft Excel. Excel is attractive not only due to its wide availability as a part of the Microsoft Office suite but also due to the increased level of familiarity of undergraduate students with this tool as opposed to other statistical packages. In this study, we explored the use of Excel as a didactic tool which was built upon a previously published paper presenting an Excel Solver tool for calculation of a net photosynthetic/chloroplastic CO2-response curve. Using the Excel spreadsheets accompanying this paper, researchers and students can quickly and easily choose the best fitted P (N)/I curve, selecting it by the minimal value of the sum of the squares of the errors. We also criticized the misuse of the asymptotic estimate of the maximum gross photosynthetic rate, the light saturation point estimated at a specific percentile of maximum net photosynthetic rate, and the quantum yield at zero photosynthetic photon flux density and we proposed the replacement of these variables by others more directly linked to plant ecophysiology.
作者
我是这篇论文的作者
点击您的名字以认领此论文并将其添加到您的个人资料中。
推荐
暂无数据