浅析Excel软件在大学物理实验数据处理中的应用技巧

Analysis on Application Skills of Excel Software in Data Processing of Experiment of College Physics

介绍了用Excel软件计算测量列平均值、标准偏差和不确定度的方法,通过举例介绍了Excel软件在作图、直线方程拟合、指数曲线拟合、二次多项式曲线拟合以及重复计算物理公式值方面的应用技巧。实践表明,用Excel软件处理大学物理实验数据具有快捷、直观、简易的优点,掌握它能有效提高学生物理实验数据处理能力。

The methods that calculate the arithmetic mean, standard deviation and unce;tainty of a series of measurements using the Excel were introduced. With some examples, we analyze the application skills of Excel in plotting, linear fitting, exponential fitting, quadratic polynomial fitting and repetition calculation of physics formula value. It is shown that the adoption of Excel in data processing of Experiment of College Physics has the advantages of rapidity, visualization and simplicity. Mastering such skills can greatly improve the students＇ abilities of data processing.