d2jsp
Log InRegister
d2jsp Forums > Off-Topic > General Chat > Homework Help > How Can I Find The Area Under The Curve In Excel? > Take A Look ^^
Add Reply New Topic New Poll
Member
Posts: 4,874
Joined: May 8 2011
Gold: 90.00
Dec 24 2013 11:05am
actually i find the area by using indirect way. I put a linear to the curve which has same area (seems like it has same area). Then i obtain the area under the curve by using triangle area formula from the linear which i added to curve.

Is there any simple way to obtain area under the curve?
Member
Posts: 7,721
Joined: Oct 11 2008
Gold: 304.00
Dec 24 2013 11:38am
Well, if a linear fit fits it well, use a trapezoidal approximation
or just use rectangles, easiest way

I'm pretty sure excel can only do numerical integration
so, even if you had a defined function, it would not integrate it

This post was edited by saber_x3 on Dec 24 2013 11:39am
Member
Posts: 10,812
Joined: Oct 15 2009
Gold: Locked
Warn: 20%
Member
Posts: 4,874
Joined: May 8 2011
Gold: 90.00
Dec 25 2013 03:25am
thanks guys you helped a lot^^ it was so easy
Go Back To Homework Help Topic List
Add Reply New Topic New Poll