If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I calculate the area under the curve using Excel?
Is there a function to calculate the area under the curve? I have tried to
use the AREAS(ref) function but failed at finding the area. Maybe I used it wrong? Any help would be greatly appreciated =) |
#2
|
|||
|
|||
AREAS returns the number of range areas of the ref.
To calculate the area under a curve, you can use =SUMPRODUCT(A2:A20-A1:A19,(B2:B20+B1:B19)/2) Where your x values are in A1:A20, and your Y values are in B1:B20. This is an approximate method for finding the area under the curve, summing the area of the trapezoids defined by pairs of points (and the points along the x axis). HTH, Bernie MS Excel MVP "munster909" wrote in message ... Is there a function to calculate the area under the curve? I have tried to use the AREAS(ref) function but failed at finding the area. Maybe I used it wrong? Any help would be greatly appreciated =) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculate the intersection of supply and demand curve | Angus | Worksheet Functions | 1 | May 4th, 2005 03:32 PM |
Can Excel calculate area for 3-D surface charts? | RAH | Charts and Charting | 2 | March 20th, 2005 03:20 AM |
HOW DO I CALCULATE SUFACE AREA DEPENDENT ON SHAPE | Randy | General Discussion | 4 | March 17th, 2005 11:35 PM |
How to calculate the area under a curve? | Gerard | General Discussion | 1 | October 3rd, 2004 08:13 AM |