It’s easy to calculate a slope in Excel using the SLOPE function, but it’s also possible to use chart trendlines and simple arithmetic as well. This article will show you how to do all three, so keep reading! Calculate Slope in Excel with the SLOPE Function Excel SLOPE Function Formula: How to Calculate Slope in …
Since a worksheet is essentially a gigantic matrix, it’s no surprise that matrix multiplication in Excel is super easy – we just need to use the MMULT Excel function. Matrix Multiplication with the MMULT Excel function You can multiply matrices in Excel thanks to the MMULT function. This array function returns the product of two …
In the last blog post, I showed how to use VBA to create a vector plot in Excel. That plot was just a simple black and white vector plot. So in this post I’ll show you how to take that chart to the next level with a color scale to indicate the magnitude of the …
For some time now, I’ve been interested in figuring out how to create a vector plot in Excel. I didn’t really have a need for it personally, but I thought it would be an interesting challenge and might be helpful to someone else. Here’s what I came up with, created completely in Excel: Creating the …
There are two primary ways to perform numerical integration in Excel: Integration in Excel via the Spreadsheet Integration using VBA 1. Integration in Excel via the Spreadsheet This type of numerical integration is largely reserved for experimental data. It is useful for when you want to see how some integral of the experimental data progresses …
To perform linear interpolation in Excel, use the FORECAST function to interpolate between two pairs of x- and y-values directly. In the example below, the formula to interpolate and find the y-value that corresponds to an x-value of 1.4 is: =FORECAST(F2,C3:C4,B3:B4) This simple method works when there are only two pairs of x- and y-values. …
In this post, you’ll learn how to calculate a weighted standard deviation in Excel. A weighted standard deviation calculates the spread in a data set where not all the observations have the same weight. Video Subscribe to EngineerExcel on YouTube How to Calculate Weighted Standard Deviation This formula (provided by the United States National Institute …
In this post, you’ll learn how to display numbers in Excel using engineering notation, how engineering notation differs from scientific notation, and how custom formats work in Excel Contents Video Subscribe to EngineerExcel on YouTube Engineering Notation in Excel Numbers can be displayed in Excel using engineering notation by creating the following custom format: ##0.0E+0 …
You’ll also receive regular tips to help you master Excel for engineering.
Learn advanced engineering techniques in Excel with this limited time free video training.
Click the button below to get started today.
