Show simple item record

dc.contributor.authorHu, W.en
dc.contributor.authorXie, J.en
dc.contributor.authorChau, Henryen
dc.contributor.authorSi, B. C.en
dc.date.accessioned2015-05-06T04:25:39Z
dc.date.issued2015-03-24en
dc.date.submitted2015-03-11en
dc.identifier.citationHu, W. Xie, J. Chau, H. W. & Si, B. C. (2015). Evaluation of parameter uncertainties in nonlinear regression using Microsoft Excel Spreadsheet. Environmental Systems Research, 4:4. DOI 10.1186/s40068-015-0031-4en
dc.identifier.urihttps://hdl.handle.net/10182/6542
dc.description.abstractBackground Nonlinear relationships are common in the environmental discipline. Spreadsheet packages such as Microsoft Excel come with an add-on for nonlinear regression, but parameter uncertainty estimates are not yet available. The purpose of this paper is to use Monte Carlo and bootstrap methods to estimate nonlinear parameter uncertainties with a Microsoft Excel spreadsheet. As an example, uncertainties of two parameters (α and n) for a soil water retention curve are estimated. Results The fitted parameters generally do not follow a normal distribution. Except for the upper limit of α using the bootstrap method, the lower and upper limits of α and n obtained by these two methods are slightly greater than those obtained using the SigmaPlot software which linearlizes the nonlinear model. Conclusions Since the linearization method is based on the assumption of normal distribution of parameter values, the Monte Carlo and bootstrap methods may be preferred to the linearization method.en
dc.format.extent12en
dc.language.isoenen
dc.publisherSpringerOpen journalsen
dc.relationThe original publication is available from - SpringerOpen journals - https://doi.org/10.1186/s40068-015-0031-4 - http://www.environmentalsystemsresearch.com/content/4/1/4/abstracten
dc.relation.urihttps://doi.org/10.1186/s40068-015-0031-4en
dc.rights© 2015 Hu et al.; licensee Springer. This is an Open Access article distributed under the terms of the Creative Commons Attribution License http://creativecommons.org/licenses/by/4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly credited.en
dc.rights.urihttp://creativecommons.org/licenses/by/4.0/en
dc.subjectbootstrapen
dc.subjectMonte Carloen
dc.subjectsoil water retentionen
dc.subjectparameter uncertaintyen
dc.subjectExcelen
dc.titleEvaluation of parameter uncertainties in nonlinear regression using Microsoft Excel Spreadsheeten
dc.typeJournal Article
lu.contributor.unitLincoln Universityen
lu.contributor.unitFaculty of Agriculture and Life Sciencesen
lu.contributor.unitDepartment of Soil and Physical Sciencesen
lu.contributor.uniten
lu.contributor.uniten
dc.identifier.doi10.1186/s40068-015-0031-4en
dc.subject.anzsrc0803 Computer Softwareen
dc.subject.anzsrc0802 Computation Theory and Mathematicsen
dc.relation.isPartOfEnvironmental Systems Researchen
pubs.issue4en
pubs.organisational-group/LU
pubs.organisational-group/LU/Agriculture and Life Sciences
pubs.organisational-group/LU/Agriculture and Life Sciences/SOILS
pubs.organisational-group/LU/Research Management Office
pubs.organisational-group/LU/Research Management Office/2018 PBRF Staff group
pubs.publication-statusPublisheden
pubs.publisher-urlhttp://www.environmentalsystemsresearch.com/content/4/1/4/abstracten
pubs.volume4en
dc.identifier.eissn2193-2697en
dc.rights.licenceAttributionen
lu.identifier.orcid0000-0002-9411-9816


Files in this item

Default Thumbnail

This item appears in the following Collection(s)

Show simple item record

Creative Commons Attribution
Except where otherwise noted, this item's license is described as Creative Commons Attribution