How do I calculate the area under a curve in an Excel graph?
I am trying to calculate the area under a curve in an excel graph, can anyone
help? Thanks very much |
Try this post by Bernie Dietrick:
http://tinyurl.com/d4hdt Also, check out Bernard V Liengme's page at: http://www.stfx.ca/people/bliengme/E...UnderCurve.htm -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Suzanne Graham" <Suzanne wrote in message ... I am trying to calculate the area under a curve in an excel graph, can anyone help? Thanks very much |
Look at my website www.stfx.ca/people/bliengme/ExcelTips
Also, if the curve is smooth, you could use LINEST to get a formula for the best fit and integrate this (how's your calculus?) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Suzanne Graham" <Suzanne wrote in message ... I am trying to calculate the area under a curve in an excel graph, can anyone help? Thanks very much |
All times are GMT +1. The time now is 04:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com