Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Judit
 
Posts: n/a
Default 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
  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

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



  #3   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

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



  #4   Report Post  
fernando cinquegrani
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating GIFs in Excel 2003 for use in Dreamweaver Lou Crandall Charts and Charting in Excel 2 January 2nd 05 08:58 PM
Vertical ND Curve on Combination Chart Phil Hageman Charts and Charting in Excel 4 December 30th 04 07:07 PM
How do i create a log graph in excel Mark Bennett Charts and Charting in Excel 2 December 8th 04 07:14 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 09:05 PM
Is there a way to create a standard OHLC bar chart in Excel? [email protected] Charts and Charting in Excel 3 December 2nd 04 10:49 PM


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"