I've already read tons of materials about this problem...but still can't
fully learn how I can solve my spcific problem. Is there any macro or script
that could help me...?
I've got a data set X Y and I want to approximate the curve plotted with a
bilinear, so that the area under the two curves (non linear and bilinear) is
equal...
Hope someone help me...
thanks in advance

uriel78 wrote:
I've already read tons of materials about this problem...but still can't
fully learn how I can solve my spcific problem. Is there any macro or script
that could help me...?
I've got a data set X Y and I want to approximate the curve plotted with a
bilinear, so that the area under the two curves (non linear and bilinear) is
equal...

I hope I'm ot being too simplisitc here --
Do you mean quadratic (2nd order) instead of bilinear?
With least squares, you could get y = A x ^2 + B x + C, which would be
close. From this you could get the area under the curve. You could
adjust C to make the area exactly equal to the area under the
non-linear curve. Have you done this on a worksheet (before thinking
about a macro)?


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---