用Excel实现实验数据的计算机处理 |
| |
作者单位: | 潍坊学院物理与电子科学系 |
| |
摘 要: | 本文简要探讨了Excel软件在物理实验数据处理中的应用,并以两个普通物理实验为例,介绍了用Excel进行实验数据的误差计算、数据筛选、线性拟合等操作的思路和技巧。通过Excel的各种函数以及绘制图表等功能的灵活应用,可以为实验室及科学研究提供一种更方便、更快捷、更可靠的数据处理方法。
|
关 键 词: | EXCEl 误差计算 数据处理 最小二乘法 |
THE EXPERIMENTAL DATA PROCESSING WITH EXCEL |
| |
Authors: | wang jing-song |
| |
Institution: | wang jing-song Department of Physics and Electronic Sciences,Weifang University,Weifang,Shandong 261061,china |
| |
Abstract: | The application of Excel in the course of processing physics experimental data has been discussed in this thesis. Train of thought and skills in processing experimental data by Excel is introduced by two physics experiments, for instance, error calculation, data selection, linear regression and so on. The data processing of laboratory and scientific research will be more reliable, quicker and director by applying different kinds of functions and chatting of Excel, etc. |
| |
Keywords: | Excel Error calculate Data processing least square method Marco |
本文献已被 CNKI 等数据库收录! |
|