Excel spreadsheet files
Spreadsheet files are listed in dark blue. Corresponding screencasts are listed in light blue. Click the spreadsheet to download it. Click the screencast to view it on YouTube. Hover your mouse over each screencast to read a description.
Nonlinear Regression
Temperature-Dependent Heat Capacity
Gibbs Free Energy and Chemical Equilibrium
Statistics
Nonlinear Regression
- NLR for Enzyme Kinetics Using Solver and NLR for Enzyme Kinetics 2nd Method CLNonlinear Regression to Determine Michaelis-Menten Kinetics Parameters Using Excel Solver
Nonlinear Regression to Determine Confidence Limits for Michaelis-Menten Kinetics Parameters Using Excel
Nonlinear Regression for Enzyme Kinetics – Second Method for Confidence Limits
- Activation Energy Calculation Using SolverDetermine Activation Energy Using Nonlinear Regression with Excel Solver
Calculate 95% Confidence Intervals for Nonlinear Regression in Excel, Part 1
Calculate 95% Confidence Intervals for Nonlinear Regression in Excel, Part 2
- NLR to Fit 2 Parameters from PFR DataDetermine Kinetic Parameters from Isothermal Plug Flow Reactor, Part 1: Overview
Determine Kinetic Parameters from Isothermal Plug Flow Reactor, Part 2: Excel Calculations
Determine Kinetic Parameters for Data from Isothermal Plug Flow Reactor, Part 3: Excel Spreadsheet
Determine Kinetic Parameters for Data from Isothermal Plug Flow Reactor, Part 4: Confidence Limits
- NLR to Fit PFR Data – Change FA0/FB0/PNonlinear Regression to Obtain Kinetic Parameters for Isothermal PFR: Multiple Reactor Conditions Changed
- Analyze VCRL DataAnalyze data from Virtual Catalytic Reactor Laboratory (VCRL)
- Determing Marules Parameters from VLE Data (Excel file only available to instructors) Analyze VLE Data using Nonlinear Regression
Temperature-Dependent Heat Capacity
- NIST WebBook ExampleCalculating Enthalpy and Entropy Using the NIST WebBook
- Adiabatic Flame Temperature CalculationCalculate Adiabatic Flame Temperature
Adiabatic Flame Temperature Spreadsheet
- Heat Capacity ExamplesUse Heat Capacity to Calculate Outlet Temperature
Calculate Heat Added Example
- Heat of Reaction vs. TemperatureCalculate Heat of Reaction at an Elevated Temperature
Gibbs Free Energy and Chemical Equilibrium
- Gibbs Free Energy as a Function of TemperatureCalculate Gibbs Free Energy Change for a Reaction at Elevated Temperature
Gibbs Free Energy of Reaction Spreadsheet
- Plot Gibbs Free Energy vs Reaction ExtentGibbs Free Energy of a Chemical Reaction as a Function of Temperature
- WGS Chemical Equilibrium by Gibbs MinimizationChemical Equilibrium Using Gibbs Minimization: Example
- Multiple Reactions Chemical Equilibrium by Gibbs MinimizationMulti Reaction Chemical Equilibrium Using Gibbs Minimization Spreadsheet
- NH3 Formation – Chemical Equilibrium by Gibbs MinimizationCalculate NH3 Formation Equilibrium Using Gibbs Minimization Spreadsheet
How Accurate is the Shortcut Van’t Hoff Method for Chemical Equilibrium Calculations?
Statistics
- Bumper cars – Beta and PowerPower of the Test
- Burritos_ANOVA_starterSingle-Factor ANOVA, Part 2
Graphical Presentation of Data
- Bus TiresRandomized Complete Block Design
- FE Exam dataComparison of Means, Variance Unknown, Part 2
- HexaneStarterPolynomial Models and Multicollinearity
- Hockey SticksComparison on Means, Variance Known, Part 2
- Natural GasComparison of Means, Variance Unknown, Part 1
- Natural Gas – F testThe F Distribution and Comparison of Variances
- Old FaithfulDescriptive Statistics
Graphical Presentation of Data
- Replicated 2^3 DesignAnalyzing a Factorial Design in Minitab
Higher Order Full Factorial Design, Part 2
- Satisfaction Data – Confidence and Prediction IntervalsConfidence Intervals in Multiple Linear Regression
- Satisfaction Data – starter 1Matrix Approach to Multiple Linear Regression
- Satisfaction Data – starter 2Hypothesis Tests in Multiple Linear Regression, Part 2
- T-Distribution SimulationThe T Distribution
- Turbine_Data_starterModel Building Techniques
- UltraMembrane_Factorial_starterThe 2^2 Factorial Design, Part 2
- UltraMembrane_Statistical_starterStatistical Analysis of the 2^2 Factorial Design
- Unreplicated 2^5 DesignSingle Replicate of the 2^k Design
- Variance SimulationVariance Known or Unknown?
- Volvo and Bank TemperaturesPaired T Tests
- Zirconia DataSimple Linear Regression Using Least Squares Estimators
Hypothesis Tests for Simple Linear Regression
- Solve a Nonlinear Equation in ExcelSolving a Nonlinear Equation in Excel
- Multiple Nonlinear Equations Using SolverSolve a Set of Nonlinear Equations Using Solver
- Nonideal Osmotic PressureCalculate Molecular Weight from Osmotic Pressure for Nonideal Solution
- Ternary FlashIsothermal Flash of a Ternary MixtureIsothermal Flash of a Ternary Mixture – Spreadsheet
- Energy Balance on a Tank with Steam FeedEnergy Balance on Tank with Steam Feed Part 2Energy Balance on Tank with Steam Feed – Spreadsheet
- Material Balances on a System with Purge and RecycleMaterial Balances on a System with PurgeMaterial Balances on a System with Purge and Recycle – Spreadsheet
- Steam TablesIntroduction to Steam TablesIntroduction to Steam Tables 2How to Use Steam TablesSteam Tables: InterpolationProperties of Liquid Water in Steam TablesWater Properties from Steam TablesQuality of Steam
- Addition Polymerization in a CSTR
