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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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 news:[email protected],
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