论文信息 - Construction of spline functions in spreadsheets to smooth experimental data

Construction of spline functions in spreadsheets to smooth experimental data

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.

K. Thomas Klasson | K. Klasson

[1] Rosamund Sutherland,et al. Mathematical Modelling: the Interaction of Culture and Practice , 1999 .

[2] A E Humphrey,et al. Computer simulation of fermentation systems. , 1967, Applied microbiology.

[3] H. C. Van Ness,et al. An extension of the spline fit technique and applications to thermodynamic data , 1967 .

[4] K. Thomas Klasson. Experimental Data Analysis , 1997 .

[5] E. Joseph Billo,et al. Excel for Scientists and Engineers , 2004 .

[6] Sergei Abramovich,et al. Spreadsheets as generators of new meanings in middle school algebra , 1997 .

[7] E. J. Billo. Excel for Chemists , 1996 .

[8] Gordon Filby. Spreadsheets in science and engineering , 1998 .

[9] J. R. Nunhez,et al. Fitting thermodynamic data using the modified spline technique , 1993 .

[10] David R. Kincaid,et al. Numerical mathematics and computing , 1980 .

[11] Tom Lyche,et al. Fortran subroutines for computing smoothing and interpolating natural splines , 1983 .

[12] R. D. Tanner. An enzyme kinetic model for describing fermentation processes , 1970, Biotechnology and bioengineering.