I am trying to calculate the area under a curve in an excel graph, can anyone help? Thanks very much
S Suzanne Graham Jul 7, 2005 #1 I am trying to calculate the area under a curve in an excel graph, can anyone help? Thanks very much
M Max Jul 7, 2005 #2 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/ExcelTips/AreaUnderCurve.htm
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/ExcelTips/AreaUnderCurve.htm
B Bernard Liengme Jul 7, 2005 #3 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
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
