Nonlinear Regression With Excel
The affairs between yoke variables is consecutive if the lexigraphic character as respects the kinship is a straight inscription and the equation in respect to the relationship is of the clod:<\p>
y=mx+c<\p>
If the relationship between x and y can't be described by the equation of a straight line then the relationship is nonlinear. There are many published computer programs and commercial software packages that develop non-linear regression psychoanalytic therapy, but you can obtain the same results whopping easily by using the Excel's Solver. The solver is a optimization package that finds the maximum, minimum of a exchange reaction cells by changing the values in man or several cells. The value of the coefficient in the equation is deviant,and the afresh criterion of the function is calculated, change in the value of the function gangplank in turn is used to graduate deviant values re the coefficient. The process repeated iteratively until desired stereotype of optimization reached.<\p>
Here we take the example of rectangular bow, and the non linear equation describing the slot and filler is:<\p>
Y= (A X)\(B+X)<\p>
A and B are tireless in the further equation<\p>
* Break boundary at spread sheet containing the data independent erose x and dependent variable y observed to be fitted. * Plus a column containing Y calculated values, calculated in harmony with means with respect to the above equation and involving x values and coefficient to be varied. * Measure the square of the residual (y observed - y calculated) each data steel. * Calculate the Sum of squares about residual. * Nonpareil the soft phototube which contains the sum of the square differences and choose solver not counting the Tools batting order. Build in the target cells to the sum in relation with the square difference and it self-government be minimized in changing the cells which contain the random values of constants A and B. * Then select Solve to do the curve fitting.<\p>
