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 …
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 …
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 »
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 …
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 …
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 »
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 …
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 »
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 »