Calculation of Area Under a Continuos curve......Scatter Curve.

A

Abhishek Jha

The variables are part of a scatter diagram, i.e. the variables
plotted on X axis do not have any defined relationship with the
Variables of Y axis......

Hi, I am working on calculating area under a Continuous Curve.. I
have data poitnts...On X axis i have % of Cumulative numbers(Variable
X) and on Y axis i have % of Cumulative numbers(Variable Y). If i
plot a curve by joinig thses points i get a smooth curve. If i have to
calculate the exact area under the curve using Integration Function in
Excel Sheet how should i proceed.

Data points are :
Issuers Defaulters Cum Issuers % Cum Defaulters %
C 3 0 0.287907869 0
B 4 2 0.671785029 7.407407407
BB 35 5 4.030710173 25.92592593
BBB 242 15 27.25527831 81.48148148
A 293 4 55.37428023 96.2962963
AA 315 1 85.60460653 100
AAA 150 0 100 100
1042 27


Want to calculate the total area under the curve formed by joining the
data points : Cum Issuers % and Cum Defaulters %


Regards,
Abhishek
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation of Area Under a Continuos curve...... 5
Calculation of Area Under a Plotted Graph 1
Area under the curve calculation 2
Creating pattern area under part of an x-y chart 5
Separate area under a curve into two sections. 0
Area Under A Curve 5

Top