Search National Agricultural Library Digital Collections
Back to Search
NALDC Record Details:
Construction of spline functions in spreadsheets to smooth experimental data
Download [PDF File]
Experimental data are often in need of smoothing without a pre-determined trend line equation. This manuscript demonstrates how spreadsheet software can be programmed to smooth experimental data via cubic splines. Once the trend lines (splines) have been constructed, it is also simple to interpolate values and calculate derivatives and integrals. The formulas to carry out the calculation are listed and explained in the manuscript.
Klasson, K. Thomas
Advances in engineering software 2008 May, v. 39, issue 5
Journal Articles, USDA Authors, Peer-Reviewed
Works produced by employees of the U.S. Government as part of their official duties are not copyrighted within the U.S. The content of this document is not copyrighted.
Agricultural Research Service
Web Policies and Important Links