Nonlinear Regression: Example Problems
Try to solve these problems before watching the solutions in the screencasts.
Example Problem 3
Determine \(R^2\) value and confidence limits for parameters for Michaelis-Menten enzyme kinetics using Excel Solver. Excel file here.
Example Problem 4 (optional)
Demonstrates how to carry out nonlinear regression with Excel to determine the activation energy and pre-exponential factor for a chemical reaction. Rate constants as a function of temperature are used for a second-order reaction.
Excel file here.