Area Under Line On Excel Graphs

[Jessica.Bush]

Hi all,

Hope you can help. I am not certain how much of this qualifies as maths and how much qualifies as excel here! But I know certain things I can do on excel I just don't know where.

I have some data and have plotted it on a graph (workbook attached). There are two lines and I am comparing the two, the one above is the better - I have 'ratings' on the x-axis and 'cover' on the y-axis and the top one gets consistently get's better coverage at the same level of ratings - which is what we want.

To compare how much better the one on top is over all the ratings I wanted to find the area underneath each of the curves and then subtract one from the other. This will leave me with the difference in area. But this leaves me with two questions:

1. How do I find the area beneath each of the curves? I believe excel can help with this?

2. What would the unit be? If I calculate the area of a field I have metres on one side (y axis) and metres on the other side (x axis) and hence I have metres squared by multiplying them together. The area would be x....

Hope you can help, I am stuck!

Thanks

[Andy Pope]

Info on the first part can be found here
http://people.stfx.ca/bliengme/Excel...UnderCurve.htm

[Everstrivin]

For the integration check out WolframAlfa at:

http://[email protected]