Nonlinear Regression Using the "Big Three" Spreadsheets

TCE

The Chemical Educator

ISSN: 1430-4171 (electronic version)

Table of Contents

Abstract Volume 4 Issue 3 (1999) pp 112-113

Nonlinear Regression Using the "Big Three" Spreadsheets

Roy W. Clark

Middle Tennessee State University, Murfreesboro, TN 37132

Published online: 1 June 1999

Abstract. Nonlinear regression using the spreadsheet Excel has appeared in the literature in several places. This paper extends the use of this technique to two other popular spreadsheets, Lotus 123 and Quattro Pro. Associated files, which can be downloaded, are included. These are the spreadsheet templates and ScreenCam movies that illustrate the use of equation solvers for minimization in these spreadsheets.

Key Words: Computers in Chemistry; nonlinear; regression; curvefit; spreadsheet; Beer's law; Screencam; movies

(*) Corresponding author. (E-mail: royclark@bellsouth.net )

Article in PDF format (18 KB) HTML format

Supporting Materials:

WinZip file containing Excel, Lotus 123, and Quattro Pro spreadsheet templates (15 KB) 10.1007/s00897990296b

WinZip file containing ScreenCam movies that illustrate the use of equation solvers for minimization in these spreadsheets (1.54 MB) 10.1007/s00897990296c