摘要
介绍了用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.
出处
《大学物理实验》
2011年第2期69-71,共3页
Physical Experiment of College
