| EXCEL在统计预测分析中的应用 |
| |
| 引用本文： | 彭燕. EXCEL在统计预测分析中的应用[J]. 湖南工业大学学报, 2002, 16(1) |
| |
| 作者姓名： | 彭燕 |
| |
| 作者单位： | 株洲工学院,信息与计算科学系,湖南,株洲,412008 |
| |
| 摘 要： | 根据回归预测中实例，借助ＥＸＣＥＬ进行相关分析，判断出其相关程度，并在此基础上建立回归模型，最后用ＥＸＣＥＬ完成计算分析、统计检验及预测，使回归预测分析的计算过程更简捷，统计预测方法更为实用。
|
| 关 键 词： | 回归模型 EXCEL 预测分析 |
Use of Excel in Statistical Estimation |
| |
| PENG Yan. Use of Excel in Statistical Estimation[J]. Journal of Hnnnan University of Technology, 2002, 16(1) |
| |
| Authors: | PENG Yan |
| |
| Abstract: | A return model is established on the basis of data analysis of practical estimation examples,and relevance analysis aided by EXCEL, which is also used to help accomplish the calculation analysis,test and estimation of this model.It is proved that the computing in the estimation analysis is much simpler and the statistical estimation method much more practical. |
| |
| Keywords: | regression model Excel estimation analysis |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
