| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculating the area under a graph
I am analysing a number of large graphs within Microsoft Excel 2000. It is
important that I calculate the area under these graphs. Can anyone tell me how this can be done? Thank you in advance. |
|
#2
|
|||
|
|||
|
http://groups-beta.google.com/group/...rting/browse_t
hread/thread/877c08ec206cf7e/468b068ab8e4d657?q=area+under+graph&rnum=1&hl=e n#468b068ab8e4d657 Mangesh "William Woolnough" <William wrote in message ... I am analysing a number of large graphs within Microsoft Excel 2000. It is important that I calculate the area under these graphs. Can anyone tell me how this can be done? Thank you in advance. |
|
#3
|
|||
|
|||
|
There are two ways:
a) using the trapezoid or Simpson's rule - see www.stfx.ca/people/bliengme/ExcelTips and b) use LINEST to find the line of best fit; do a manual integration of the function and compute the definite integral best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "William Woolnough" <William wrote in message ... I am analysing a number of large graphs within Microsoft Excel 2000. It is important that I calculate the area under these graphs. Can anyone tell me how this can be done? Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate the area under a curve in an Excel graph? | New Users to Excel | |||
| Calculating the Area of objects in Feet and Inches | Excel Discussion (Misc queries) | |||
| Area under the graph | Charts and Charting in Excel | |||
| Area under the graph | Excel Discussion (Misc queries) | |||
| finding the area under the curve in a graph in excel | Excel Discussion (Misc queries) | |||
Linear Mode
