+ Reply to Thread
Results 1 to 8 of 8

Lorenz Curve plot

  1. #1
    Registered User
    Join Date
    01-30-2009
    Location
    Leeds,England
    MS-Off Ver
    Excel 2003,2007
    Posts
    2

    Lorenz Curve plot

    Hi,

    I need help in plotting the data in the attached Excel sheet(sheet1).The data n a lorenz curve plot on the right is given(pls scroll right and scroll down a bit as well...).In the data table, the lorenz curve has been drawn from the data taken from column Nos. 3,4 , 6 &7. the diagonal line is called the equality line which can be drawn by giving dummy values to both x and y axis. i want to understand the steps by which the shown curve has been plotted using the given data.(We picked this data and corr diag from one of the study notes) I and my friend tried it using bar graph and then using pivot table to do it. But this graph is not coming up
    Would be great if someone can tell me the "steps" to plot the shown graph using the data given.This is required by my Dad who is working on his thesis and I kinda promised him a solution for this. Positive that some gurus can help me thru with this

    P.S: Kindly suggest the steps for Excel 2003 version

    regards,
    Vasudha
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Lorenz Curve plot

    You need to create a xy-scatter chart with 3 series.

    your data is laid out such that the Y values come first. so try this.

    Select H9:H18 and create an xy-scatter line without markers.
    This will create a default set of x values which you can change.

    Right click chart and pick Source Data.
    Select the series and set the X values to I2:I21

    Also add another series and set the x value to L2:L21 with Y values K2:K21

    For the final straight line you can enter fixed values in the new series
    X: ={0,100}
    Y: ={0,100}

    format lines and labels as required
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-30-2009
    Location
    Leeds,England
    MS-Off Ver
    Excel 2003,2007
    Posts
    2

    Thumbs up SOLVED: Lorenz Curve plot

    Thanks a ton Andy!

    FInally solved

    Appreciate the speedy help!

    regards,
    Vasudha

  4. #4
    Registered User
    Join Date
    04-20-2011
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Lorenz Curve plot

    please help me to create a lorenz curve plot using excel 2007.

  5. #5
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Lorenz Curve plot

    Hi sharmila,

    please open your own thread.

    maybe would be smart to first read rules so you can get your answer ASAP.

  6. #6
    Registered User
    Join Date
    04-20-2011
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Lorenz Curve plot

    Hey!!!

    Thanku very much it worked fine...

  7. #7
    Registered User
    Join Date
    08-02-2012
    Location
    Stuttgart
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Lorenz Curve plot

    Hello Anyone
    I have some problems with plotting a Lorenz curve on excel. I have data on cumulative % of income as Y and cumulative % of households as X but when i select this data a plot a scatter graph line it doesn't come. Please let me know if you have some ideas to help.

    Thanks
    Moore

  8. #8
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Lorenz Curve plot

    Moore,

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1