Data Table, Equation Fit or Interpolation

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.

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2025-10-15
DOI
https://doi.org/10.5281/zenodo.17355574
Primary Topic
Advanced Electrical Measurement Techniques
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Data Table, Equation Fit or Interpolation

Zenodo (CERN European Organization for Nuclear Research)
Advanced Electrical Measurement Techniques
article

Data Table, Equation Fit or Interpolation

article en

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.

Zenodo (CERN European Organization for Nuclear Research)
Openalex Percentile: Top 49%
Advanced Electrical Measurement Techniques
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.