|
|||||
|
|
| 用EXCEL及其"规划求解"功能拟合曲线方程 | |
| 引用本文： | 徐海霞,任红松,袁继勇,杨德松,马智群.用EXCEL及其"规划求解"功能拟合曲线方程[J].农业网络信息,2004(2):37-39. |
| 作者姓名： | 徐海霞 任红松 袁继勇 杨德松 马智群 |
| 作者单位： | 1. 新疆石河子大学生物工程学院,石河子,832003 2. 新疆石河子大学农学院农业科学系,石河子,832003 3. 新疆天合种业北疆育种站,乌鲁木齐,832003 4. 新疆石河子大学水利建筑工程学院,石河子,832003 |
| 摘 要： | 本文提出了一种拟合曲线方程的新方法 ,即利用EXCEL电子表格软件及其“规划求解”功能对非线数据直接拟合曲线方程。该方法免去了常规法———通过适当的变量转换 ,将非线性关系的数据转化为线性回归方程求解的复杂计算以及利用专业统计软件处理需编程的麻烦。结合实例对拟合效果的验证表明用该法拟合的曲线方程精度很高。 |
| 关 键 词： | Excel Logistic方程 参数 规划求解 |
| 修稿时间： | 2003年10月10 |
The application of EXCEL and "Plan to ask and solve" function in fitting curve equation |
|
| XU Hai-xia,REN Hong-song.The application of EXCEL and "Plan to ask and solve" function in fitting curve equation[J].Agriculture Network Information,2004(2):37-39. | |
| Authors: | XU Hai-xia REN Hong-song |
| Institution: | XU Hai-xia1,REN Hong-song 2, |
| Abstract: | In this paper a new method of fitting curve equation is proposed , it uses EXCEL electronic form software and"Plan to ask and solve" function to fit the curve equation directly according to the data that are not linear relationg. This method omits the complicated calculation of routine way which needs to turn no linear relationg data into linear regression equation through the proper variable change, and the programming trouble of using professional statistics software to dealt with . The fitting effection of combing instance indicates the equation's precision is very much high . |
| Keywords: | Excel Logistic equation Parmater Plan to ask and solve |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ | |