Related Articles
- 1 Get the Area Between Curves in Excel
- 2 Calculate Aggregate Consumer Surplus
- 3 Put a Gaussian Curve on a Graph in Excel
- 4 Set Up Auto Calculate in Excel 2010
Microsoft excel exponential integral function Functions. One often needs to approximate integrals of a continuous function (think calculating. The integration is part of the important concepts that associate with mathematic, and is part of the main operations in calculus. It has to be given the function f of a variable x that is real, as well as the interval which is a, b, of that real line, and this is the definite integral.
Finding the area under a curve is a central task in calculus. This process is called finding the definite integral. Microsoft Excel does not have native calculus functions, but you can map your data to a trendline. Then, once you know the equation of this trendline, you can find the integral. This requires some basic calculus facility -- you must be able to integrate an equation and evaluate it at the beginning and end points.
1.Select the data set for which you wish to calculate area under a curve.
2.Click the 'Chart Elements' button in the upper right of the chart. This looks like a large plus sign.
3.![Microsoft Excel Exponential Integral Function Approximation Microsoft Excel Exponential Integral Function Approximation](/uploads/1/2/6/3/126347087/294984292.jpg)
Check the box next to 'Trendline.' Then, click the arrow next to 'Trendline' and select 'More Options' to open the trendline formatting options box.
![Exponential integral formulas Exponential integral formulas](https://best-excel-tutorial.com/images/Integrals/insert%20chart.png)
Select the type of function that best matches the behavior of your data set. You can choose from among Exponential, Linear, Logarithmic, Polynomial, Power and Moving Average functions.
5.Check the box next to 'Display Equation on chart.' This will allow you to view the equation so that you can integrate it.
6.Find the integral of the equation of the trendline. Most of the equation types in Excel have relatively straightforward integration processes. You can think of the integral as the opposite of the derivative. For example, the integral of a linear equation such as f(x)=3x is F(x)=(1/2)3x^2 + c. The new constant, c, will cancel out when you evaluate it. See Resources for some information about integration.
7.Evaluate the integral at the upper and lower limits of the desired region. For example, if you want to evaluate the function between x=3 and x=7: F(3) = (1/2)3(3^2) + c = 27/2 +c and F(7) = (1/2)3(7^2) + c = 147/2 + c.
8.Subtract the integral at the lower limit from the integral at the upper limit to get the total area under the plotted curve. For example, for the above function: F(7) - F(3) = (147/2 + c) - (27/2 + c) = 120/2 = 60.
References (1)
Resources (2)
About the Author
Serm Murmson is a writer, thinker, musician and many other things. He has a bachelor's degree in anthropology from the University of Chicago. His concerns include such things as categories, language, descriptions, representation, criticism and labor. He has been writing professionally since 2008.
Cite this Article Choose Citation Style
Murmson, Serm. 'Can You Calculate Area in Excel Under a Plotted Curve?' Small Business - Chron.com, http://smallbusiness.chron.com/can-calculate-area-excel-under-plotted-curve-73676.html. Accessed 14 January 2020.
Murmson, Serm. (n.d.). Can You Calculate Area in Excel Under a Plotted Curve? Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/can-calculate-area-excel-under-plotted-curve-73676.html
Murmson, Serm. 'Can You Calculate Area in Excel Under a Plotted Curve?' accessed January 14, 2020. http://smallbusiness.chron.com/can-calculate-area-excel-under-plotted-curve-73676.html
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.