Linear fitting is a common problem in data processing of college physics experiments.There are two common data processing methods:successive difference method and linear regression method.The uncertainty of the result of the successive difference method and the linear regression method was evaluated bv using the Excel software.When the comparison of the two methods was carried out quantitativelv,the disadvantages of the successive difference method are obvious.So the data should be processed with the linear regression method as far as possible when making accurate measurements.The successive diffrrence method is only suitable for rough estimation of measurement results.
赵云飞, 邱成锋, 贾小文, 张金凤, 范海英.
基于Excel的直线拟合问题不确定度评定研究
[J]. 大学物理实验, 2022, 35(1): 110-114.
ZHAO Yunfei, QIU Chengfeng, JIA xiaowen, ZHANG Jinfeng, FAN Haiying.
Research on the Uncertainty of Linear Fitting Problem Based on Excel
. Physical Experiment of College, 2022, 35(1): 110-114.