Excel

Calculate Slope in Excel

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 …

Calculate Slope in Excel Read More »

Create a Vector Plot in Excel

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 …

Create a Vector Plot in Excel Read More »

Numerical Integration in Excel

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 …

Numerical Integration in Excel Read More »

Linear Interpolation in Excel

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

Linear Interpolation in Excel Read More »

Weighted Standard Deviation in Excel

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 …

Weighted Standard Deviation in Excel Read More »

Engineering Notation in Excel

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 …

Engineering Notation in Excel Read More »

Scroll to Top