Nonlinear regression using spreadsheets

Trends Pharmacol Sci. 1995 Dec;16(12):413-7. doi: 10.1016/s0165-6147(00)89091-4.

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.

MeSH terms

  • Algorithms
  • Information Systems
  • Models, Theoretical*
  • Pharmacology
  • Regression Analysis
  • Statistics as Topic / standards*