实验科学与技术2023，Vol.21Issue(6)：33-35,66,4.DOI:10.12179/1672-4550.20220674
处理密立根油滴实验数据的简易循证方法
Concise and Evidence-based Method on Data Analysis in Millikan Oil-drop Experiments
摘要
Abstract
In view of the deficiencies of the existing data processing methods of the Milligan oil-drop experiment,this paper analyzes the principles of the mapping method of data processing and uses the easy-to-use WPS spreadsheet application to implement the linear regression calculation of the elementary charge through its built-in LINEST function.Through the analysis of the calculation process,the iterative method is introduced to design and optimize the algorithm to improve the accuracy and precision of the calculation.Furthermore,the formula for calculating the uncertainty of the slope based on the standard deviation results returned by the LINEST function is given.Applying the method of this paper to 15 sets of 107 data from reference literature,the results of this paper were found to be more accurate with less uncertainty and relative error.关键词
作图法/WPS表格/线性回归/迭代Key words
mapping method/WPS Spreadsheet/linear regression/iteration分类
数理科学引用本文复制引用
牛延强..处理密立根油滴实验数据的简易循证方法[J].实验科学与技术,2023,21(6):33-35,66,4.
