Excel

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 to describe a normal distribution of measurements. Sometimes it’s necessary to fit a Gaussian function to data, so this post will teach you how to perform a Gaussian fit in …

Gaussian Fit in Excel 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 that use these functions. Worksheet 03f is set up to calculate true strain from engineering strain data collected on a tensile test machine. The equation for true strain is: where …

LN, LOG, LOG10, EXP, SQRT, and FACT Functions in Excel Read More »

Scroll to Top