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
Complete... 50%
Please enter your name and email address below to receive a link to the ebook.

You’ll also receive regular tips to help you master Excel for engineering.

Complete... 50%

SIGN UP BELOW TO GET STARTED!

You’re almost there! Please enter your email address below to get started with your free training:

FREE EBOOK:

10 SMARTER WAYS TO USE EXCEL FOR ENGINEERING

By Charlie Young, P.E.

Take your engineering to the next level with advanced Excel skills.

EXCEL TRAINING FOR ENGINEERS

Learn advanced engineering techniques in Excel with this limited time free video training.

Click the button below to get started today.