How do i create Lorenz curve in Excel????
 

How do i create Lorenz curve in Excel? I dont find it! I have Excel 97. Is it
possible that there isnt such option on this version? Or its there under
another name? I could find it under Chart wizard in another version. Please
help, i would need it urgently!

Thanks,
Judit

What is a Lorenz curve?

"Judit" wrote in message
...
How do i create Lorenz curve in Excel? I dont find it! I have Excel 97. Is
it
possible that there isnt such option on this version? Or its there under
another name? I could find it under Chart wizard in another version.
Please
help, i would need it urgently!

Thanks,
Judit

Having reviewed what a Lorenz curve is, you'll need to have the following
information:

Cumulative % of X from 0 to 100
Cumulative % of Y from 0 to 100

For the perfect equality line, X = Y
You'll need to figure out the Lorenz curve for yourself.

I would use the Chart Wizard and an XY Scatter chart for this type of data.

http://www.peltiertech.com/Excel/Cha...artWizard.html

"Judit" wrote in message
...
How do i create Lorenz curve in Excel? I dont find it! I have Excel 97. Is
it
possible that there isnt such option on this version? Or its there under
another name? I could find it under Chart wizard in another version.
Please
help, i would need it urgently!

Thanks,
Judit

In ,
Judit scrive:
How do i create Lorenz curve in Excel? I dont find it! I have Excel 97. Is it
possible that there isnt such option on this version? Or its there under
another name? I could find it under Chart wizard in another version. Please
help, i would need it urgently!

http://www.prodomosua.it/zips/lorenz.xls
[from: http://groups.google.it/groups?th=eaeb7a425b06340d]
.f