Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Do I Integrate?
I have a spreadsheet of about 100 data points of independent variables and
matching values for dependent variables. I want to integrate the resulting curve to find the area underneath. How do I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Do I Integrate?
Myles,
To calculate the area under a curve, you can use =SUMPRODUCT(A3:A100-A2:A99,(B3:B100+B2:B99)/2) Where your x values are in A2:A100, and your Y values are in B2:B100. 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 "Myles" wrote in message ... I have a spreadsheet of about 100 data points of independent variables and matching values for dependent variables. I want to integrate the resulting curve to find the area underneath. How do I do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Do I Integrate?
see my Tip&Tricks site for more details
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Myles" wrote in message ... I have a spreadsheet of about 100 data points of independent variables and matching values for dependent variables. I want to integrate the resulting curve to find the area underneath. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
integrate | Charts and Charting in Excel | |||
You'd figure that Excel 2003 could numerically integrate! | Excel Discussion (Misc queries) | |||
How to integrate cells from different .xls into one consolidation | Excel Discussion (Misc queries) | |||
How do I integrate a variablebased formula in excel? | Excel Worksheet Functions |