Construction of spline functions in spreadsheets to smooth experimental data

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. [Copyright &y& Elsevier]