摘要
介绍用Excel VBA技术,以光电效应及普朗克常数测定实验为例实现对物理实验数据的处理.该系统实现了自动运用列表法、作图法、最小二乘法等方法处理实验数据,且操作简单,易学易用,有效地提高数据处理效率.
There is a new technology you can use Excel VBA to process experimental data, taking photoelectric effect and Planck's constant determination as an example. The system automatically chooses the tools for listing, graphing, and generalized least squares in experimental data processing, and it is easytooperateand improvehighefficiencyofdataprocessing.
出处
《四川职业技术学院学报》
2014年第1期148-150,153,共4页
Journal of Sichuan Vocational and Technical College
关键词
数据处理
DataProcessing
EXCEL
VBA