| 浅析Excel软件在大学物理实验数据处理中的应用技巧 |
| |
| 引用本文： | 汪建军. 浅析Excel软件在大学物理实验数据处理中的应用技巧[J]. 江西科学, 2005, 23(5): 660-663 |
| |
| 作者姓名： | 汪建军 |
| |
| 作者单位： | 浙江万里学院应用物理研究所,浙江,宁波,315101 |
| |
| 摘 要： | 介绍了用Excel软件计算测量列平均值、标：位偏差和不确定度的方法，通过举例介绍了Excel软件在作图、直线方程拟合、指数曲线拟合、二次多项式曲线拟合以及重复计算物理公式值方面的应用技巧。实践表明．用Excel软件处理大学物理实验数据具有快捷、直观、简易的优点，掌握它能有效提高学生物理实验数据处理能力。
|
| 关 键 词： | Excel软件 实验数据 技巧 |
| 文章编号： | 1001-3679(2005)05-0660-04 |
| 收稿时间： | 2005-04-24 |
| 修稿时间： | 2005-06-28 |
Analysis on Application Skills of Excel Software in Data Processing of Experiment of College Physics |
| |
| WANG Jian-jun. Analysis on Application Skills of Excel Software in Data Processing of Experiment of College Physics[J]. Jiangxi Science, 2005, 23(5): 660-663 |
| |
| Authors: | WANG Jian-jun |
| |
| Affiliation: | Institute of Applied Physics ,ZheJiang Wanli University,Zhejiang Ningbo 315100 PRC |
| |
| Abstract: | The methods that calculate the arithmetic mean,standard deviation and uncertainty 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. |
| |
| Keywords: | Excel software Data processing Skill |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
