Gaussian Fit in Excel
A Gaussian function has many different purposes in engineering although most people probably recognize it as a “bell curve”. Most commonly, it can be used …
Excel
Solving Systems of Simultaneous Nonlinear Equations in Excel
Unlike simultaneous linear equations, simultaneous non-linear equations cannot be solved using linear algebra. However, we can extend the concept of using Goal Seek from solving …
Solving Systems of Simultaneous Nonlinear Equations in Excel Read More »
Nonlinear Curve Fitting in Excel Using Charts
In engineering, you’ll encounter data than doesn’t follow a linear trend. In those cases, you’ll need to use nonlinear methods. Excel has a few different …
Multiple Linear Regression in Excel
You saw in the pressure drop example that LINEST can be used to find the best fit between a single array of y-values and multiple …
Evaluating Derivatives of Equations in Excel with VBA
We can extend the concept of finite differences into VBA if we know the function and aren’t constrained to dealing with tabular data. For example, …
Evaluating Derivatives of Equations in Excel with VBA Read More »
Dynamic Linear Regression in Excel with LINEST
Excel also can perform a regressions with a function. The function LINEST can find the equation of a best fit line through data. LINEST uses …
Managing and Adding Named Cells in an Excel Worksheet
If you ever want to modify a named range because you’ve made a mistake or you want to assign a different cell to the variable, …
Managing and Adding Named Cells in an Excel Worksheet Read More »
LN, LOG, LOG10, EXP, SQRT, and FACT Functions in Excel
Excel features many of the common mathematical functions that you’ll encounter in engineering: logarithms, exponentials, square roots and factorials. This section covers three example problems …
LN, LOG, LOG10, EXP, SQRT, and FACT Functions in Excel Read More »
