H. Riveros. International Journal of Computational Science and Information Technology (IJCSITY), 7 (1/2/3/4):
1- 8(November 2019)
DOI: 10.5121/ijcsity.2019.7402
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.
%0 Journal Article
%1 noauthororeditor
%A Riveros, Héctor G.
%D 2019
%J International Journal of Computational Science and Information Technology (IJCSITY)
%K Equation adjustment, interpolation, uncertainties.
%N 1/2/3/4
%P 1- 8
%R 10.5121/ijcsity.2019.7402
%T DATA TABLE, EQUATION FIT OR INTERPOLATION
%U http://aircconline.com/ijcsity/V7N4/7419ijcsity02.pdf
%V 7
%X 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.
@article{noauthororeditor,
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.
},
added-at = {2019-12-12T07:05:22.000+0100},
author = {Riveros, Héctor G.},
biburl = {https://www.bibsonomy.org/bibtex/2d00284121c47077b7bfd70361888b44c/anderson_sam},
doi = {10.5121/ijcsity.2019.7402},
interhash = {a2e092c03dc371ba6568ca2c98d679da},
intrahash = {d00284121c47077b7bfd70361888b44c},
journal = {International Journal of Computational Science and Information Technology (IJCSITY)},
keywords = {Equation adjustment, interpolation, uncertainties.},
month = {November},
number = {1/2/3/4},
pages = {1- 8},
timestamp = {2019-12-12T07:05:22.000+0100},
title = {DATA TABLE, EQUATION FIT OR INTERPOLATION},
url = {http://aircconline.com/ijcsity/V7N4/7419ijcsity02.pdf},
volume = 7,
year = 2019
}