Excel spreadsheet linear regression analysis with

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 ... 

Spreadsheet Summary In Chapter 15 of Applications of Microsoft Excel in Analytical Chemistry, capillary electrophoresis data are used to determine the mobilities of inorganic ions. Measurements of the anival times of ions at the detector are used with the known mobility of Na" to determine mobilities. Capillary electrophoresis results are also used to determine pK values of several weak organic acids. Linear regression analysis is used to find the pK values from measurements of arrival times at different buffer pH values. 

A regression analysis was carried out using the plotting wizard and the Linest function associated with an Excel spreadsheet (see Figure 13.2). The linearity of the plot indicates that the data are consistent with the assumed rate expression and that... 

---