Excel for RegressionExcel is a great tool for regression analysis. Here are screencasts with examples and the corresponding excel files. Nonlinear Regression to Determine Michaelis-Menten Kinetics Parameters Using Excel Solver - Determine
parameters Vmax and Km for Michaelis-Menten enzyme kinetics using
Excel Solver. (.xlsx file) Nonlinear Regression to Determine Confidence Limits for Michaelis-Menten Kinetics Parameters Using Excel - Determine
R2 value and confidence limits for
parameters for Michaelis-Menten enzyme kinetics using Excel Solver. (.xlsx file) Determine Activation Energy Using Nonlinear Regression with Excel Solver - Demonstrates
how to carry out nonlinear regression with Excel to determine the activation
energy and preexponential factor for a chemical reaction. Rate constants as a
function of temperature are used for a second-order reaction. (.xlsx file) Calculate 95% Confidence Intervals for Nonlinear Regression in Excel, Part 1 - Explains
how to determine 95% confidence intervals with Excel for parameters determined
by nonlinear regression using Excel Solver. Example
uses rate constants as a function of temperature for a chemical reaction. (.xlsx file) Calculate95% Confidence Intervals for Nonlinear Regression in Excel, Part 2 - Demonstrates
using an Excel spreadsheet to determine 95% confidence intervals with Excel for
parameters determined by nonlinear regression using Excel Solver. Example
uses rate constants as a function of temperature for a chemical reaction. (.xlsx file) Determine Kinetic Parameters for Data from Isothermal Plug Flow Reactor, Part 1: Overview - Determine
kinetic parameters using nonlinear regression on data obtained from a plug-flow
catalytic reactor. The reactant exit concentration was measured as a function
of inlet volumetric flow rate for a gas-phase reaction A --> B. (.xlsx file) Determine Kinetic Parameters for Data from Isothermal Plug Flow Reactor, Part 2: Excel Calculations - Explains
how to use Excel to determine kinetic parameters using nonlinear regression on
data obtained from a plug-flow catalytic reactor. This includes solving the differential
equation for the mass balance, creating a data table, and carrying out
nonlinear regression. The reactant exit concentration was measured as a
function of inlet volumetric flow rate for a gas-phase reaction A --> B. (.xlsx file) Determine Kinetic Parameters for Data from Isothermal Plug Flow Reactor, Part 3: Excel Spreadsheet - Demonstrates
using an Excel spreadsheet to determine kinetic parameters obtained using
nonlinear regression on data obtained from a plug-flow catalytic reactor. The reactant exit concentration was measured
as a function of inlet volumetric flow rate for a gas-phase reaction A --> B. (.xlsx file) Determine Kinetic Parameters for Data from Isothermal Plug Flow Reactor, Part 4: Confidence Limits - Demonstrates
how to use an Excel spreadsheet to determine confidence limits for kinetic
parameters that were obtained using nonlinear regression on data obtained from
a plug-flow catalytic reactor. The
reactant exit concentration was measured as a function of inlet volumetric flow
rate for a gas-phase reaction A --> B. (.xlsx file) Nonlinear Regression to Obtain Kinetic Parameters for Isothermal PFR: Multiple Reactor Conditions Changed - Demonstrates
how to determine kinetic parameters using nonlinear regression on data obtained
from a plug-flow catalytic reactor. For
a gas-phase reaction A --> B, the
feed molar flow rates of A and B, and the total pressure were changed, and the
exit molar flow rate of reactant A was measured. (.xlsx file) |