Excel Files

Excel for Regression

Excel 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 SolverDetermine 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 ExcelDetermine 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)
Calculate 95% 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: OverviewDetermine 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 CalculationsExplains 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 SpreadsheetDemonstrates 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 LimitsDemonstrates 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 ChangedDemonstrates 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)

Other Excel Files