Area under a curve in Excel.
Area under a curve in Excel.
(OP)
Hello all,
Is it possible to find the area under a curve (or trendline, more importantly) in Microsoft Excel?
I have some curves in Excel and have fitted trendlines to these curves based on sixth order polynomials. I need to know if there is an add-in or function that will save me the trouble of integrating the polynomials myself.
Thanks.
Is it possible to find the area under a curve (or trendline, more importantly) in Microsoft Excel?
I have some curves in Excel and have fitted trendlines to these curves based on sixth order polynomials. I need to know if there is an add-in or function that will save me the trouble of integrating the polynomials myself.
Thanks.
RE: Area under a curve in Excel.
-- drej --
RE: Area under a curve in Excel.
integral(X^n* dx)=1/[a*(n+1)]*X^(n+1) for n<>-1; for n=-1 we get 1/a*ln(X)
with some effort you can make a simple Vba code for it.
m777182
RE: Area under a curve in Excel.
good luck!
-pmover