EXCEL在物理实验数据处理中的应用研究  

The Application of EXCEL in Physical Data Processing

作　　者：贺雅奇[1] 

机构地区：[1]陕西理工学院,陕西汉中723001

出　　处：《大学物理实验》2011年第2期69-71,共3页Physical Experiment of College

摘　　要：介绍了用Excel软件对实验数据进行计算平均值、标准偏差、拟合方程的方法。通过举例介绍了Excel软件在作图,直线方程拟合方面的应用技巧。实践表明:用Excel软件处理实验数据具有快捷、直观、简易的优点,掌握Excel软件能够有效的提高学生对实验数据处理的能力。The introduction of the application of EXCEL in calculating the average and the standard deviation of laboratory data and in fitting equation.The application skills of EXCEL in mapping and fitting liner equation are illustrated by using examples.Practice has proved that a good knowledge of EXCEL can effectively improve the students＇ ability in data processing with the fastness,directness and simplicity of excel software.

关 键 词：EXCEL软件 实验数据 

分 类 号：O411.3[理学—理论物理]