| Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Generalized Least Square Method | Share |
Generalized Least Square Method
Excel Help for Generalized Least Square Method in Excel Multiple Regression Analysis and Forecasting Template
| Forum Topic | Post Reply Login |
Generalized Least Square Method | Rate this: (3/5 from 1 vote) |
 | Generalized Least Square Method(Least Cubic Method ) When studying the relating relations between the two variable numbers (x, y), we can get a series of binate data(x1, y1, x2, y2.....xm, ym), describing the data into the x - y orthogonal coordinate system(Chart), the points are found near a curve. suppose the one-variant non-linear variant of the curve such as (Formula 1) Y = a0 + a1 X k (Formula 1) There into, a0, a1 and k are arbitrary real numbers To set the curve variant, the numbers of a0, a1 and k must be set. Use the same way with "The Least Square Method" Data Regression based on the square sum of the deviation of the true measure value Yi and computing value. order: ' Φ = ∑( Yi - Y ) 2 (Formula 2) Take (Formula2-1) to (Formula2-2) to get : Φ = ∑( Yi - a0 - a1 X k ) 2 (Formula 3) When the square of ∑( Yi - a0 - a1 X k) 2 is the smallest, we can use function φ to get the partial differential coefficients of a0, a1 and k, make the three partial differential coefficients zero. (Formula 4) (Formula 5) (Formula 6) Get three variant groups about a0,a1 and k which are the unknown numbers, solve the groups can get mathematical model. Also, we can judge the right of the mathematical model with the help of correlation coefficient R, statistical variable F, residual standard deviation S to judge, it is better that R tends to 1,the absolute value of F is bigger and S tends to 0. the validation is good, but error of model computing sometimes are big, to improve the mathematical model farther, the biggest error, equal error and the equal relating error of computing model are computed to validate the model. The Method to do multivariate nonlinear model chart eamil:[email protected] Web address: [http://www.eaihua.com/] | |
| wyp | ||
| Posted by eaihua on | ||
| Replies - Displaying 1 to 3 of 3 | Order Replies By: Most recent | Chronological | Highest Rated |
| Rate this: (3.7/5 from 4 votes) huhu need help..badly i hope someone can tell "easier"softwares |
| Posted by STAT on |
| Rate this: (4/5 from 2 votes) An Excel add-in which includes this method can be found here. |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Rate this: (3/5 from 1 vote) |
| Posted by STAT on |
| Displaying page 1 of 1 |
| Find relevant Excel templates and add-ins for Generalized Least Square Method in the Excel Business Solutions Directory |