Data Table, Equation Fit or Interpolation

International Journal of Computational Science and Information Technology (IJCSITY) Vol.7, No.1/2/3/4, November 2019

8 Pages Posted: 14 Apr 2020

See all articles by Héctor G. Riveros

Héctor G. Riveros

National Autonomous University of Mexico (UNAM)

Date Written: November 2019

Abstract

The results of an experiment can be presented as a data table or as an equation that represents them. In the case of adjusting a polynomial, Excel allows us to change its degree and calculates the R2 of the adjusted equation. It is considered that if it is 1 the equation goes through all the experimental points. By adjusting Tungsten resistivity data, it is found that the equations do not go through all the points (even with R2 = 1), which is verified by calculating the differences for each point. In those cases, the best fit is the linear interpolation between consecutive points. The equation adjusted by Excel, Matlab or Origin requires checking if it corresponds to the minimum in the sum of squared differences, it is possible that it can be reduced by changing the coefficients values.

Keywords: Equation adjustment, interpolation, uncertainties

Suggested Citation

Riveros, Héctor G., Data Table, Equation Fit or Interpolation (November 2019). International Journal of Computational Science and Information Technology (IJCSITY) Vol.7, No.1/2/3/4, November 2019, Available at SSRN: https://ssrn.com/abstract=3557157

Héctor G. Riveros (Contact Author)

National Autonomous University of Mexico (UNAM)

Circuito Mario de la Cueva s/n
Lomas de las Palmas, 52760
Mexico

Here is the Coronavirus
related research on SSRN

Paper statistics

Downloads
4
Abstract Views
36
PlumX Metrics