|
| Excel在光学实验数据处理中的应用 |
| The applied research of Excel in processing optical experiment datas |
| |
| DOI: |
| 中文关键词: 回归分析 最小二乘法 Excel函数解法 |
| 英文关键词:regression analysis least squares method Excel function |
| 基金项目: |
|
| 摘要点击次数: 4171 |
| 全文下载次数: 439 |
| 中文摘要: |
| 回归分析是一类数学模型,其研究对象是一个随机变量同一个或多个非随机变量的关系问题,在提出一元和多元线性回归的基础上,通过比较最小二乘法解法和Excel函数解法,指出Excel函数解法可以简化复杂的数学运算,并配以图表,给求解过程带来方便。 |
| 英文摘要: |
| Regression analysis is a process of constructing mathematical model which focuses on the relation between stochastic variable and one or more non stochastic variable. Based on the analysis of linear regression or multiple linear regression, this article works out the solution to it—least squares method and the Excel solution law. With the comparison of these two methods, it can be found that Excel, with the aid of graphs, can clearly display data relations when solving return problems, so that office efficiency will be achieved greatly. |
| HTML 查看全文 查看/发表评论 下载PDF阅读器 |
| 关闭 |
|
|
|