Related Experiment Videos
A step-by-step guide to non-linear regression analysis of experimental data using a Microsoft Excel spreadsheet.
1Department of Neurology, Box 356465, University of Washington School of Medicine, Seattle, WA 98195-6465, USA. ambrown@u.washington.edu
Computer Methods and Programs in Biomedicine
|May 8, 2001
Summary
This study presents a simple, accessible method for non-linear regression analysis using Microsoft Excel's Solver function. This approach offers a cost-effective and intuitive alternative for biological data analysis.
Area of Science:
- Biological data analysis
- Scientific computing
Background:
- Non-linear regression analysis is crucial for biological data interpretation.
- Fitting complex non-linear functions to data can be challenging.
- Commercial software for this analysis is often expensive and difficult to learn.
Purpose of the Study:
- To introduce a simple, user-friendly method for non-linear regression analysis.
- To provide a step-by-step guide for implementing this method.
- To demonstrate its applicability across various biological fields.
Main Methods:
- Utilizing the Solver function in Microsoft Excel.
- Employing an iterative least squares fitting routine.
- Applying the method to user-defined functions of the form y=f(x).
Main Results:
- Successful implementation of non-linear regression using Excel Solver.
- Achieved optimal goodness of fit between data and user-input functions.
- Demonstrated the method's suitability for fast and reliable data analysis.
Conclusions:
- The Excel Solver method provides an accessible and cost-effective alternative for non-linear regression.
- This technique simplifies complex data analysis in biology.
- It empowers researchers to perform advanced statistical analyses without specialized software.