Spreadsheet Summary least squares

Spreadsheet Summary Chapter 4 of Applications of Microsoft Excel in Analytical Chemistry introduces another way to perform a least-squares analysis. The Analysis ToolPak Regression tool has the advantage of producing a complete ANOVA table for the results. A chart of the fit and the residuals can be produced directly from the Regression window. An unknown concentration is found with the calibration curve, and a statistical analysis is used to find the standard deviation of the concentration. 

Spreadsheet Summary In the first exercise in Chapter 12 of Applications of Microsoft Excel in Analytical Chemistry, a spreadsheet is developed to calculate the molar absorptivity of permanganate ion. A plot of absorbance versus permanganate concentration is constructed, and least-squares analysis of the linear plot is carried out. The data are analyzed statistically to determine the uncertainty of the molar absorptivity. In addition, other spreadsheets are presented for calibration in quantitative spectrophotometric experiments and for calculation of concentrations of unknown solutions. 

Spreadsheet Summary In Chapter 12 ot Applications of Microsoft Excel in Analytical Chemistry, we investigate the multiple standard additions method for determining solution concentration. A least-squares analysis of the data leads to the determination of the concentration of the analyte as well as the uncertainty of the measured concentration. 

Spreadsheet Summary The second exercise in Chapter 13 of Applications of Microsoft Excel in Analytical Chemistry involves enzyme catalysis. A linear transformation is made so that the Michaelis constant, K, and the maximum velocity, can be determined from a least-squares procedure. The nonlinear regression method is used with Excel s Solver to find these parameters by fitting them into the nonlinear Michaelis-Menten equation. 

S Spreadsheet Summary In the final exercise of Chapter 13 of Appli-"II cations of Microsoft Excel in Analytical Chemistry, the initial-rate method is explored for determining the concentration of an analyte. Initial rates are determined from a linear least-squares analysis and are used to establish a calibration curve and equation. An unknown concentration is determined. 

---

See also in sourсe #XX -- [ , , , ]

---