Author
![]() |
Klasson, Kjell |
Submitted to: Advances in Engineering Software
Publication Type: Peer Reviewed Journal Publication Acceptance Date: 3/12/2007 Publication Date: 3/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. |