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
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