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

[Judit]

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

 

[Barb Reinhardt]

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/ChartsHowTo/ChartWizard.html

 

[fernando cinquegrani]

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