Sagufta Tarannum
One of the most crucial mathematical tools is integral. We can use it to compute area, volume, and many other beneficial metrics. We can also use it when examining data from machinery or equipment that collects a lot of measurements. This article will go through how to do integration in Excel in some easy ways.
Download Practice Workbook
Download the practice workbook from here.
2 Handy Approaches to Do Integration in Excel
In this article, we are going to discuss 2 handy approaches to do integration in Excel. Here, we have used the SUM function both individually and after using the ABS function. So, without further delay, let’s see the approaches below.
1. Apply Excel SUM Function to Do Integration
In this method, we will use the SUM function in Excel to calculate the integral values. For describing this method, we have used a dataset (B4:D9) in Excel that contains the values which are needed to calculate the Area of a Trapezoid. Here, we will use the SUM function in Excel to find the integral below:
The steps to do so are below.
Steps:
- Firstly, set the height of the trapezoids (dx). In this example, let’s call it Height and set it to 0.2 in cell C12.
- Secondly, set the values of a from 0 to 1 with the specified Height step.
- Thirdly, to calculate the value of b, type the formula in cell C5:
=B5^2+3*B5^3+2
- After that, press the Enter key and then drag the fill handle below to get all the b values.
- Next, to calculate the Area of Trapezoid type the below formula in cell D6.
=0.2/2*(C5+C6)
- Afterward, press the Enter button and drag the fill handle to get all the values of the Area of Trapezoid.
- Then, to calculate the Definite Integral, type the formula below in cell C13.
=SUM(D6:D10)
Here, the range D6:D10 indicates the values of the Area of Trapezoid.
- Finally, click on the Enter key to get the Definite Integral.
2. Integration of Large Data Sets Using ABS & SUM Functions in Excel
In this method, we will learn the steps to integrate a large data set using both the ABS and the SUM functions. For this, we have used a dataset (B4:G8) that contains the values of water content (B5:B8) and Dry Density (C5:C8) from a dry density vs water content chart. Here, we need to calculate the area under the curve (Integral Value) by using the ABS & SUM functions. Let’s see the steps below.
Steps:
- First, select the columns representing the width and height of the trapezoid. Here, we selected w(%) as width (w) and Dry Density as height (h). Here, we assumed that the area under the curve is divided into some trapezoidal areas.
- Next, to calculate the width (w) of the first trapezoid, click on cell D5 and type the formula:
=ABS(B6-B5)
- Then, to find all the w values press Enter and drag the fill handle up to the cell B15.
- Subsequently, to calculate the height (h) of the first trapezoid, select cell E5 and type the formula below:
=0.5*(C5+C6)
- Consequently, press the Enter key and drag the fill handle up to the cell (E7) before the last cell of the dataset.
- Afterward, to compute the area (A) of each trapezoid, type the formula below in cell (A5):
=D5*E5
- After pressing the Enter key and then dragging the fill handle up to cell A7, we’ll get the areas (A) of each trapezoid.
- Now, to find the desired Integral Value, go to cell (G5) and then type the formula below:
=SUM(F5:F7)
In this formula, the range F5:F7 refers to the areas (A) of each trapezoid.
- Lastly, press Enter.
- In this way, we can calculate the desired Integral Value.
Read More: How to Do Trapezoidal Integration in Excel (3 Suitable Methods)
Conclusion
I hope the above methods will be helpful for you to do integration in Excel. Download the practice workbook and give it a try. Let us know your feedback in the comment section. Follow our website ExcelDemy to get more articles like this.
