Photosynthetica 2013, 51(3):445-456 | DOI: 10.1007/s11099-013-0045-y

Fitting net photosynthetic light-response curves with Microsoft Excel - a critical look at the models

F. de A. Lobo1,*, M. P. de Barros2, H. J. Dalmagro2, Â. C. Dalmolin2, W. E. Pereira3, É. C. de Souza4, G. L. Vourlitis5, C. E. Rodríguez Ortíz6
1 Departamento de Solos e Engenharia Rural, FAMEV/UFMT, Cuiabá-MT, Brasil
2 Programa de Pós-Graduação em Física Ambiental, IF/UFMT, Cuiabá-MT, Brasil
3 Departamento de Ciências Fundamentais e Sociais, CCA/UFPB, Areia-PB, Brasil
4 Departamento de Estatística, ICET/UFMT, Cuiabá-MT, Brasil
5 Department of Biological Science, CSUSM, San Marcos-CA, USA
6 Departamento de Botânica e Ecologia, IB/UFMT, Cuiabá-MT, Brasil

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.

Additional key words: curve fitting; iteration; nonlinear regression; PN, I curve; Solver function

Received: April 17, 2012; Accepted: January 17, 2013; Published: September 1, 2013  Show citation

ACS AIP APA ASA Harvard Chicago IEEE ISO690 MLA NLM Turabian Vancouver
de Lobo, F.A., de Barros, M.P., Dalmagro, H.J., Dalmolin, Â.C., Pereira, W.E., de Souza, É.C., Vourlitis, G.L., & Rodríguez Ortíz, C.E. (2013). Fitting net photosynthetic light-response curves with Microsoft Excel - a critical look at the models. Photosynthetica, 51(3), 445-456. doi: 10.1007/s11099-013-0045-y
Share...
Download citation
  • BibTeX (.bib)
  • Bookends (.ris)
  • EasyBib (.ris)
  • EndNote (.enw)
  • EndNote 8 (.xml)
  • ISI WoS (.isi)
  • Medlars (.medlars)
  • Mendeley (.ris)
  • MODS (.xml)
  • Papers (.ris)
  • RefWorks (.txt)
  • RefManager (.ris)
  • RIS (.ris)
  • MS Word (.xml)
  • Zotero (.ris)
    • Open full article

    Supplementary files

    Download filephs-201303-0015_S11.xlsx

    File size: 338.38 kB

    Download filephs-201303-0015_S1.xlsx

    File size: 334.89 kB

    Download filephs-201303-0015_S2.xlsx

    File size: 334.53 kB

    Download filephs-201303-0015_S3.xlsx

    File size: 339.72 kB

    Download filephs-201303-0015_S4.xlsx

    File size: 347.48 kB

    Download filephs-201303-0015_S5.xlsx

    File size: 349.27 kB

    Download filephs-201303-0015_S6.xlsx

    File size: 350.2 kB

    Download filephs-201303-0015_S7.xlsx

    File size: 337.89 kB

    Download filephs-201303-0015_S8.xlsx

    File size: 339.82 kB

    Download filephs-201303-0015_S9.xlsx

    File size: 338.38 kB

    References

    1. Abe, M., Yokota, K., Kurashima, A., Maegawa, M.: High water temperature tolerance in photosynthetic activity of Zostera japonica Ascherson and Graebner seedlings from Ago Bay, Mio Prefecture, central Japan. - Fish. Sci. 75: 1117-1123, 2009. Go to original source...
    2. Baly, E.C.C.: The kinetics of photosynthesis. - Proc. R. Soc. Lond. B 117: 218-239, 1935. Go to original source...
    3. Brown, A.M.: A step-by-step guide to non-linear regression analysis of experimental data using a Microsoft Excel spreadsheet. - Comput. Methods Programs Biomed. 65: 191-200, 2001. Go to original source...
    4. Campbell, G.S., Norman, J.M.: An Introduction to Environmental Biophysics. 2nd Ed. Springer-Verlag, New York 1998. Go to original source...
    5. Chen, L., Tam, N.F.Y., Huang, J. et al.: Comparison of ecophysiological characteristics between introduced and indigenous mangrove species in China. - Est. Coast Shelf Sci. 79: 644-652, 2008. Go to original source...
    6. Christie, D.: Resampling with Excel. - Teach. Stat. 26: 9-13, 2004. Go to original source...
    7. Devacht, S., Lootens, P., Roldán-Ruiz, I. et al.: Influence of low temperatures on the growth and photosynthetic activity of industrial chicory, Cichorium intybus L. partim. - Photosynthetica 47: 372-380, 2009. Go to original source...
    8. Donovan, T.M., Welden, C.W.: Spreadsheet Exercises in Ecology and Evolution. Sinauer Associates, Sunderland 2002.
    9. Dubois, J.-J.B., Fiscus, E.L., Booker, F.L. et al.: Optimizing the statistical estimation of the parameters of the Farquhar-Von Caemmerer-Berry model of photosynthesis. - New Phytol. 176: 402-414, 2007. Go to original source...
    10. Falkowski, P.G., Raven, J.A.: Aquatic Photosynthesis. Princeton University Press, Princenton 2007. Go to original source...
    11. Gallegos, C.L., Platt, T.: Photosynthesis measurements on natural populations of phytoplankton: numerical analysis. - Can. Bull. Fish. Aquat. Sci. 210: 103-112, 1981.
    12. Govindjee, Beatty, J.T., Gest, H., Allen, J.F.: Discoveries in Photosynthesis. Springer, Dordrecht 2005. Go to original source...
    13. Harley, P.C., Baldocchi, D.D.: Scaling carbon dioxide and water vapor exchange from leaf to canopy in a deciduous forest. I. Leaf model and parametrization. - Plant Cell Environ. 18: 1146-1156, 1995. Go to original source...
    14. Hunt, R., Causton, D.R., Shipley, B., Askew, A.P.: A modern tool for classical growth analysis. - Ann. Bot. 90: 485-488, 2002. Go to original source...
    15. Jacovides, C.P., Tymvios, F.S., Asimakopoulos, D.N. et al.: Global photosynthetically active radiation and its relationship with global solar radiation in the Eastern Mediterranean basin. - Theor. Appl. Climatol. 74: 227-233, 2003. Go to original source...
    16. Jassby, A.D., Platt, T.: Mathematical formulation of the relationship between photosynthesis and light for phytoplankton. - Limnol. Oceanogr. 21: 540-547, 1976. Go to original source...
    17. Jones, H.B., Archer, N., Rotenberg, E., Casa, R.: Radiation measurement for plant ecophysiology. - J. Exp. Bot. 54: 879-889, 2003. Go to original source...
    18. Jones, M.B.: Photosynthetic responses of C3 and C4 wetland species in a tropical swamp. - J. Ecol. 76: 253-262, 1988. Go to original source...
    19. Kaipiainen, E.L.: Parameters of photosynthesis light curve in Salix dasyclados and their changes during the growth season. - Russ. J. Plant Physiol. 56: 445-453, 2009. Go to original source...
    20. Kok, B.: On the interrelation of respiration and photosynthesis in green plants. - Biochim. Biophys. Acta 3: 625-631, 1949. Go to original source...
    21. Kumar, K.V., Sivanesan, S.: Isotherm parameters for basic dyes onto activated carbon: comparison of linear and non-linear method. - J. Hazard. Mater. 129: 147-150, 2006. Go to original source...
    22. Lambers, H., Chapin III, F.S., Pons, T.L.: Response of photosynthesis to light. - In: Lambers, H., Chapin III, F.S., Pons, T.L. (eds.): Plant Physiological Ecology. Pp. 26-47. Springer, New York 2008. Go to original source...
    23. LI-COR Bioscience: Using the LI-6400 Version 5. LI-COR Bioscience, Inc., Lincoln, NE, USA 2004.
    24. Lloyd, J., Grace, C., Miranda, A.C. et al.: A simple calibrated model of Amazon rainforest productivity based on leaf biochemical properties. - Plant Cell. Environ. 18: 1129-1145, 1995. Go to original source...
    25. Long, S.P., Hällgren, J.-E.: Measurement of CO2 assimilation by plants in the field and the laboratory. - In: Hall, D.O., Scurlock, J.M.O., Bolhàr-Nordenkampf, H.R. et al. (eds.): Photosynthesis and Production in a Changing Environment. A Field and Laboratory Manual. Pp. 129-167. Chapman and Hall, London 1993. Go to original source...
    26. Lootens, P., Van Waes, J., Carlier, L.: Effect of a short photoinhibition stress on photosynthesis, chlorophyll a fluorescence and pigment contents of different maize cultivars. Can a rapid and objective stress indicator be found? - Photosynthetica 42: 187-192, 2004. Go to original source...
    27. Luo, Y., Hui, D., Cheng, W. et al.: Canopy quantum yield in a mesocosm study. - Agric. For. Meteorol. 100: 35-48, 2000. Go to original source...
    28. Nobel, P.S.: Physicochemical and Environmental Plant Physiology. Elsevier, Amsterdam 2009.
    29. Nobel, P.S.: Achievable productivities of certain CAM plants: basis for high values compared with C3 and C4 plants. - New Phytol. 119: 183-205, 1991. Go to original source...
    30. Ögren, E.: Convexity of the photosynthetic light-response curve in relation to intensity and direction of light during growth. - Plant Physiol. 101: 1013-1019, 1993. Go to original source...
    31. Prado, C.H.B.A., de Moraes, J.P.A.P.V., de Mattos, E.A.: Gas exchange and leaf water status in potted plants of Copaifera langsdorffii. 1. Responses to water stress. - Photosynthetica 30: 207-213, 1994.
    32. Prado, C.H.B.A., de Moraes, J.P.A.P.V.: Photosynthetic capacity and specific leaf mass in twenty woody species of cerrado vegetation under field conditions. - Photosynthetica 33: 103-112, 1997. Go to original source...
    33. Prioul, J.L., Chartier, P.: Partitioning of transfer and carboxylation components of intracellular resistance to photosynthetic CO2 fixation: A critical analysis of the methods used. - Ann. Bot. 41: 789-800, 1977. Go to original source...
    34. Ratkowsky, D.A.: Nonlinear Regression Modeling - A Unified Practical Approach. Marcel Dekker, New York 1983.
    35. Ratkowsky, D.A.: Handbook of Nonlinear Regression Models. Marcel Dekker, New York 1990.
    36. Seber, G.A.F., Wild, C.J.: Nonlinear Regression. Wiley-Interscience, Hoboken 2003. Go to original source...
    37. Sharkey, T.D., Bernacchi, C.J., Farquhar, G.D., Singsaas, E.L.: In Practice: Fitting photosynthetic carbon dioxide response curves for C3 leaves. - Plant Cell Environ. 30: 1035-1040, 2007. Go to original source...
    38. Singsaas, E.L., Ort, D.R., DeLucia, E.H.: Variation in measured values of photosynthetic quantum yield in ecophysiological studies. - Oecologia 128: 15-23, 2001. Go to original source...
    39. Smith, E.L.: Photosynthesis in relation to light and carbon dioxide. - PNAS 22: 504-511, 1936. Go to original source...
    40. Stanhill, G., Fuchs, M.: The relative flux density of photosynthetically active radiation. - J. Appl. Ecol. 14: 317-322, 1977. Go to original source...
    41. Vervuren, P.J.A., Beurskens, M.H.H., Blom, C.W.P.M.: Light acclimation, CO2 response and long-term capacity of underwater photosynthesis in three terrestrial plant species. - Plant Cell Environ. 22: 959-968, 1999. Go to original source...
    42. Webb, W.L., Newton, M., Starr, D.: Carbon dioxide exchange of Alnus rubra: a mathematical model. - Oecologia 17: 281-291, 1974. Go to original source...
    43. Wertin, T.M., Teskey, R.O.: Close coupling of whole-plant respiration to net photosynthesis and carbohydrates. - Tree Physiol. 28: 1831-1840, 2008. Go to original source...
    44. Ye, Z.-P.: A new model for relationship between irradiance and the rate of photosynthesis in Oryza sativa. - Photosynthetica 45: 637-640, 2007. Go to original source...
    45. Zeinalov, Y.: Mechanisms of photosynthetic oxygen evolution and fundamental hypotheses of photosynthesis. - In: Pessarakli, M. (ed.): Handbook of Photosynthesis. Pp. 3-19. Taylor and Francis, Boca Ratón 2005. Go to original source...

    Return to the content