|
|
【答案】应助回帖
★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★ ★
pengxp163: 金币+50, 翻译EPI+1, ★★★很有帮助, 版主真的很赞！牺牲假期为虫友助力，十万分感激！ 2014-05-02 15:53:46
|
The Mcrosoft EXCEL softwares provided four methods with nonlinear experimental data fitting . The advantages of the first importance of programming calculation & random sampling method are no need to transform the equation and suitable for non-linear fitting of any data. The programming calculation method is simple and its accuracy is poor,relatively and sometimes the results are difficult to make sure of . The latter are combined with the VBA mixed programming to achieve the purpose of screening and optimization and improved the fitting precision. The next two methods are excel function formula and regression analysis method . The former can get fitting result of high precision by function formula inputting based on the principle of least squares . The latter is with the highest fitting accuracy by the use of EXCEL mathematical analysis tools . Hower , before the application of both of these methods, multivariate polynomial equation transformation of data is required .It is natural that both of these methods are not suitable for nonlinear experimental data which is difficult to transform and it is necessary to grasp these four non-linear fitting method to process experimental data of projects. |
|
回复此楼