Nonlinear regression using spreadsheets

Abstract

Pharmacologists are often required to analyse nonlinear experimental effects by fitting the data to defined theoretical models. This may require a specialized computer program capable of performing nonlinear regression analysis, which can prove costly given the variety of pharmacological research. Here, Wayne Bowen and Jeff Jerman describe a generic method of performing nonlinear regression using spreadsheet applications, and demonstrate how this approach can be used to create automated systems of data analysis.