Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have the following chart in Excel:

1

I want to calculate the area under the graph line.

Any idea?

share|improve this question
    
Odd. What reason could there be to downvote this question? –  pnuts Dec 5 '12 at 10:08
add comment

2 Answers 2

up vote 1 down vote accepted

For each adjacent pair of points, take average of y-coordinates, then multiply by difference of x-coordinates, and accumulate for all pairs.

share|improve this answer
    
thanks, how to calculate +/- from average line(2.8)? –  Amir Nov 25 '12 at 9:28
add comment

For your related post (How to paint area under graph line with average line?) I suggested using a column chart. The area chart overemphasizes some points more than the values should allow. Since the points are discrete measurements, the sloping lines between measurements are meaningless, and calculating areas is going to be misleading.

So the "area" above the values is the sum of (value - average) for value > average, and the "area" below the values is the sum of (average - value) for value < average.

Very simple to calculate with two simple formulas.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.