Non-Linear Regression Using the Solver

In this chapter you ll learn how to use the Solver, Excel s powerful optimization package, to perform non-linear least-squares curve fitting. 

---

In the present model the pre-exponential factors and activation energies are optimised by non-linear regression using the Solver module on Microsoft Excel. The amounts of coke associated with CO2 evolution at Pi and P2 are also optimised, while a mass balance determines the coke quantity associated with CO at P5 and CO2 at P3. The oxygen partial... 

A non-linear regression analysis is employed using die Solver in Microsoft Excel spreadsheet to determine die values of and in die following examples. Example 1-5 (Chapter 1) involves the enzymatic reaction in the conversion of urea to ammonia and carbon dioxide and Example 11-1 deals with the interconversion of D-glyceraldehyde 3-Phosphate and dihydroxyacetone phosphate. The Solver (EXAMPLEll-l.xls and EXAMPLEll-3.xls) uses the Michaehs-Menten (MM) formula to compute v i- The residual sums of squares between Vg(,j, and v j is then calculated. Using guessed values of and the Solver uses a search optimization technique to determine MM parameters. The values of and in Example 11-1 are ... 

There are many published computer programs and commercial software packages that perform non-linear regression analysis, but you can obtain the same results very easily by using the Solver. When applied to the same data set, the Solver gives the same results as commercial software packages. 

NonLin.xls illustrates the use of the Solver to perform multiple non-linear regression analysis. 

---