| 基于Excel的实验数据最小二乘法计算探讨 |
| |
| 引用本文： | 唐曙光. 基于Excel的实验数据最小二乘法计算探讨[J]. 大学物理实验, 2003, 16(4): 43-45 |
| |
| 作者姓名： | 唐曙光 |
| |
| 作者单位： | 南京工程学院,南京,210013 |
| |
| 摘 要： | 最小二乘法是实验数据处理中最重要的方法之一，但因其计算比较繁杂，教学中使用较困难。本对Excel中三种计算方法进行比较，探讨最小二乘法计算的简便方法。
|
| 关 键 词： | Excel 最小二乘法 误差理论 数据分析 数据处理 函数 |
| 文章编号： | 1007-2934(2003)04-0043-03 |
| 修稿时间： | 2002-12-20 |
STUDY ON HOW TO USE THE LEAST SQUARE METHOD IN THE ANALYSIS OF EXPERIMENTAL DATA |
| |
| Tang Shu-guang. STUDY ON HOW TO USE THE LEAST SQUARE METHOD IN THE ANALYSIS OF EXPERIMENTAL DATA[J]. Physical Experiment of College, 2003, 16(4): 43-45 |
| |
| Authors: | Tang Shu-guang |
| |
| Abstract: | The least square method is one of the most important methods that can be used to analyze experimental data.But owing to its complicated calculation,the method is difficult to use in our teaching practice.This paper has made comparision between three calculation methods in Excel to find out the easiest way in calculation by the least square method. |
| |
| Keywords: | least sqhare method data processing excel |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
