
Numerical Analysis Using MATLAB, Excel and VBA
An Applied Introduction for Engineers and Scientists With Chemical Engineering ApplicationsBy Omar HalabiLength12h 8m
About this audiobook
A practical guide to numerical methods for engineers and scientists, teaching each technique in MATLAB, Excel, and VBA with chemical engineering applications.
Audiobook details
GenreScience and Nature, Technology
Length12 hrs 8 mins
Narrated byListen with 1,000+ voices
FormateBook with Audio
Publish dateSep 27, 2026
LanguageEnglish
Table of contents
1Numerical Analysis Using MATLAB, Excel and VBA
2Foreword
3Preface
4About This Book
5Chapter 1: Three Computing Environments
Show all chaptersShow less
61.1 Scripts, Functions and the Command Line
71.2 Worksheet Models and Cell Formulas
81.3 Recorded Macros, Written Macros and When They Earn Their Place
91.4 Choosing the Right Environment
101.5 Moving Data Between the Three Environments
111.6 A Verification Habit from Day One
12Chapter 2: Number Representation and Error
132.1 Floating-Point Storage
142.2 Round-Off Error and Catastrophic Cancellation
152.3 Truncation Error and Taylor Series
162.4 Conditioning and Error Propagation
172.5 Error in a Calculation Chain
182.6 Verifying Against Analytical and Limiting Cases
19Chapter 3: Roots of Equations
203.1 Bracketing and the Bisection Method
213.2 False Position and Its Failure Mode
223.3 Newton-Raphson and the Secant Method
233.4 Fixed-Point Iteration and Convergence Conditions
243.5 Solving a Cubic Equation of State
253.6 Convergence Tables and Stopping Criteria
26Chapter 4: Systems of Linear Equations
274.1 Gauss Elimination with Partial Pivoting
284.2 LU Factorization and the Determinant
294.3 Tridiagonal and Banded Systems
304.4 Iterative Solvers: Jacobi, Gauss-Seidel and SOR
314.5 Sparse and Banded Storage
324.6 Condition Number and Residual Checks
33Chapter 5: Systems of Nonlinear Equations
345.1 Multivariate Newton-Raphson
355.2 Numerical Jacobians and Finite-Difference Sensitivity
365.3 Damping, Line Search and Trust Regions
375.4 Continuation and Homotopy
385.5 Flash Calculations and Coupled Material Balances
395.6 Convergence Aids for Coupled Balances
40Chapter 6: Curve Fitting and Regression
416.1 Linear Least Squares
426.2 Polynomial and Multiple Linear Regression
436.3 Nonlinear Least Squares and Parameter Uncertainty
446.4 Fitting Reaction Rate Parameters
456.5 Residual Analysis and Model Checking
46Chapter 7: Interpolation
477.1 Lagrange and Newton Interpolation
487.2 Interpolation Error and Runge’s Phenomenon
497.3 Cubic Splines
507.4 Table Lookup for Physical Properties