Search National Agricultural Library Digital Collections

NALDC Record Details:

Construction of spline functions in spreadsheets to smooth experimental data

Permanent URL:
http://handle.nal.usda.gov/10113/32637
File:
Download [PDF File]
Abstract:
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.
Author(s):
Klasson, K. Thomas
Subject(s):
data analysis , computer analysis , computer software , equations
Format:
p. 422-429.
Note:
Includes references
Source:
Advances in engineering software 2008 May, v. 39, issue 5
Language:
English
Year:
2008
Collection:
Journal Articles, USDA Authors, Peer-Reviewed
Rights:
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.