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

Application of Excel to physical experimental data processing

作　　者：田红梅[1] 

机构地区：[1]深圳职业技术学院物理实验室,广东深圳518055

出　　处：《深圳信息职业技术学院学报》2008年第2期33-37,共5页Journal of Shenzhen Institute of Information Technology

基　　金：深圳职业技术学院校级科研项目2207K124G0

摘　　要：以霍尔器件测量磁感应强度实验为例,介绍Excel分析处理物理实验数据的方法。利用Excel处理物理实验数据不仅快捷准确,免除了大量繁杂的运算工作,而且方法简便,结果可视,且可随着输入数据即时更新。经过几年来在物理实验教学当中的应用,表明该方法在实现学生实验数据的管理和分析处理方面非常有效。A method of managing and processing physical experimental data in Excel platform is introduced and demonstrated by an experiment of ＂Measurement of Magnetic Field Strength by Hall Effect＂ . The method is not only a rapid and accurate way of freeing from complex work, but also a simple way with visual results which can he updated along with the input data. The method has been well used in the teaching process of college physics experiment for years. The experimental results show that the method is very efficient in managing and processing physical experimental data.

关 键 词：霍尔效应 EXCEL 磁感应强度 物理实验 数据处理 

分 类 号：O4-39[理学—物理]