How to Do Integration in Excel (2 Handy Approaches)

Get FREE Advanced Excel Exercises with Solutions!

Integration is One of the most crucial mathematical tools. 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.


How to Do Integration in Excel: 2 Handy Approaches

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. To describe 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:

Integrate with Excel SUM Function

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)

Integrate with Excel SUM Function

  • 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)

Integrate with Excel SUM Function

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.

Integration of Large Data Sets Using ABS & SUM Functions in Excel

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)

Integration of Large Data Sets Using ABS & SUM Functions in Excel

  • 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)

Integration of Large Data Sets Using ABS & SUM Functions in Excel

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.


Download Practice Workbook


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.


<< Go Back to | Calculus in Excel | Excel for Math | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sagufta Tarannum
Sagufta Tarannum

Sagufta Tarannum, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, contributes significantly as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep interest in research and innovation, she actively engages with Excel. In her role, Sagufta not only skillfully addresses challenging issues but also demonstrates enthusiasm and expertise in gracefully navigating intricate situations, underscoring her unwavering commitment to consistently delivering exceptional content. Her interests are Advanced... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo