Page Banner

United States Department of Agriculture

Agricultural Research Service

Title: Construction of Spline Functions in Spreadsheets to Smooth Experimental Data

Author
item Klasson, K Thomas

Submitted to: Advances in Engineering Software
Publication Type: Peer Reviewed Journal
Publication Acceptance Date: March 12, 2007
Publication Date: March 12, 2007
Citation: Klasson, K.T. 2008. Construction of spline functions in spreadsheets to smooth experimental data. Advances in Engineering Software. 39:422-429.

Interpretive Summary: Experimental data are often in need of smoothing without a pre-determined trend line mathematical equation. This manuscript demonstrates how spreadsheet software can be programmed to smooth experimental data via curves. Once the trend lines (curves) have been constructed, it is also simple to find values on the curves and calculate slopes of the curve and areas under the curves. The formulas to carry out the calculation are listed and explained in the manuscript.

Technical 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.

Last Modified: 11/28/2014
Footer Content Back to Top of Page