How Do I Create Lorenz Curve In Excel????


Search Excel Forum Posts, Tutorials, Macros, Tips, and More
How Do I Create Lorenz Curve In Excel????  Excel

View Answers


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
Similar Excel Video Tutorials
Helpful Excel Macros
Get Values from a Chart
 This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s
Similar Topics
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
Hello,
I am trying to make a quintile distribution of only 16 data points. The information is 16 countries and their per capita income. I have them sorted highest to lowest but I'm having trouble making the quintile distribution. After that I want to make a Lorenz curve with the data. Is there an easy way to do this in excel?
Thanks
Hello,
Can you create the bell curve for a zscore in excel 2003? I don't see it as an option in the chart wizard.
Thanks!!
Elise
Is there a way to make sure that a text box moves with a curve on a chart? For example, I have a text box on the chart that is a label for a given curve. But if I modify the curve, the text box will no longer point it properly. Is there a way to create an association between the two?
Hi Guys,
I am trying to produce a Lorenz Curve  if anyone has a good book on statistics handy, would be nice if you could look up what I mean
Anyway, what I have is the following table:
F
G
4
0,42
0,063
5
0,60
0,135
6
0,78
0,270
7
0,94
0,550
8
1,00
1,000
Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4
Now I need a line graph with the values of Column F on the xaxis, starting from the 0 / 0 point of the chart rising to 1
and
a straight line going from 0/0 to 1/1
The y axis should show the values in Column G and be ideally on the right...
Does anyone have an idea on how to achieve that with XL 2007 on XP ?
Ok, I may be doing something really dumb, but I can't figure out how to create a chart that plots a curve when I have the (x,y) position for each line on the curve. Excel tries to create the Xaxis for me based on a linear scale of it's own. Can anyone help me?
X
Y
0
175
42
160
82
140
119
120
144
100
168
80
186
60
198
40
207
20
210
0
thanks
Tim
I need to create an area chart.
my data is like this,
curve 1
x1 x2 y1 y2
curve 2
x3 x4 y3 y4
curve 3
x5 x6 y5 y6
some how i m unable to add series with different x values. My x range only lies between x1 x2 or x3 x4 or x5 x6.....
i want to show the whole xrange from x1 to x6 and stacked areas for corresponding x ranges.
Hi all,
Newbie to this forum, but need some excel help. I have collected a bunch of data from an object as it heats up. The curve is very similar to a capacitor charging current curve. In my case, manually trying to approximate this curve, I come up with a formula of y= (rise)*(1exp(time))+ambient. Is there a way in excel to fit a curve like this or do I need an aftermarket solution? I need something that will use the data points and perform calculations to determine the curve.
Thanks,
Sean
Hello Everyone,
I am having hard time to create the bell curve. I have sorted the data (please see the attached file) according to the ditribution (only the green marked data) and I believe I will have to use different formulas to create the column graph and the curve.
I would appreciate it a lot if someone could take a look at this an advise, how to do it. I have already spend couple of hours researching how to do this but it seems to be quiet complex. Is there an easy way to create that type of chart?
Thanks,
anstasija
I'm filtering through all of the chart options and I am not sure if excel offers a method to create some sort of bellcurve chart.
I have data like:
Sales Units/Store
0.07
0.08
0.09
0.10
0.11
0.11
0.11
0.12
0.13
0.15
0.16
0.16
0.17
And I would like to create a bell curve based on the data. Does excel offer me a solution? Any help would be appreciated!
If I have a limited number of data points and create a graph with the data (e.g., bell curve, normal distribution, etc.), is there something in Excel that will return all of the data points based on the curve?
For example, if I have 6 monthly data points (e.g., 5, 10, 30, 12, 7, 2) over a period of 12 months and I create a line curve, is there a function that will return all the data points for the remaining months? Also, if I smoothed the curve or did a trendline, I would get different data...
Thanks...
I have created a scatter graph with a regression curve to fit. The y axis data ranges from 0 to 1. How would I, for example, find the x value that corresponds to the y value of 0.5 according to the regression curve (it is a curve, not a straight line)?
In Excel, I am drawing normal distribution charts (your typical
bellshaped curve) using a column of x values and a column of y values,
and selecting xy chart selection with smoothed line. I need to shade a
portion of the area under the chart (typically from one x value to the
other). Is there some way in Excel's tools to generate a pattern fill
under the curve, between specified x limits? Now, I'm just using
Excel's drawing tool , Autoshapes, Freeform line, and trying to create
an area that just exactly fits under the curve, but it's difficult to
get all the points to line up under the curve correctly.
I can, of course, shade any closed area made with the drawing
tool, but how to shade part of the area under the normal curve?

artmorris
Help! I have created a bell curve that shows me payment distribution for our sales force compensation. The bell curve works beautifully, however, I would also like to show in this same chart the budgeted average as well as the actual average. I am currently using the rectangle shape in the drawing toolbar to manually input the bars that represent these two data points. I was wondering if there is any way to have excel automatically chart these along with my bell curve.
I have an example that I can send if that helps.
Thanks!
How do I find the equation of given data sets and their curve? How to fit the curve in excel 2007?
a B
0.0625 0.179
0.1250 0.484
0.1875 0.626
0.2500 0.735
0.3125 0.802
0.3750 0.838
0.4375 0.882
0.5000 0.907
0.5625 0.938
0.6250 0.963
0.6875 0.977
0.7500 0.999
0.8125 1.022
0.8750 1.041
0.9375 1.053
1.0000 1.066
I have a spreadsheet with 53 rows, representing referrals. We track how long each referral took to resolve. It ranges from 30 minutes to an occasional high of 40 hours or more. I got my average times, median time, and Standard Deviation. I would like to display this as a bell curve so hat I can show the distribution. How do I create a bell curve chart? thanks
Is it possible in excel to find the equation for a curve?
I have 6 known x,y data points on a curve. I need to find the equation for the curve.
Thanks,
Bob Hiller
I use chromotography(GPC) in my research. This gives bell shaped curve. To compare two cuvres, I need area under the curve. Can any one teach me the way of calculating area under the curve in excel worksheet?(The curve will be in the shape of "Normal distriubution" shape).
Please help
Saravanan
Please see the attached two curves which i want to transfer to excel to automate my
calculations, i made a try in the attached workbook and i need your advice and comments
for the first curve
having t,x i got y
now, is what i have done is true and accurate (using the linear equation) or there a best fit polynomial or other way to do that
I tried LINEST on the rows A3 to A8 if i complete to A33 will it differ or be more accurate
if i have t=12 (or any value between 0,30 which have no exact values on the attached curve) and x =14.5 for example how can i interpolate to find y
with the same x i got y in the curve in the second sheet
is my polynomial is accurate , is there a better way
thanks in advance
I there any way, throgh commands or programming to have cells controlled by some kind of curve widget?
I would like to have a cells colum to reflect the Y values of a curve that I could manipulate with the mouse. Basically the opposite of what and excel chart can do very easily.
Thank you in advance.
P.
can any one help me with customising a bell curve using excel. i already made a bell curve using sample data from microsofts help articles but i do not know how to shade/fill color inside the curve. is it actually possible using excel?
I have a tab/worksheet with several named ranges
The named ranges are defined in this format:
Insert>Name>Define "plot_time"
Code:
=OFFSET('Curve Fitter (TC#116)'!$C$13,0,0,COUNTA('Curve Fitter (TC#116)'!$D:$D)1)
Then these names are used to plot the data in a Line Chart:
Code:
Series1>XValues = ='Curve Fitter (TC#116)'!plot_time
This works fine except I need to copy another version of the entire worksheet. Now the new sheet has a new name of course. So my hardcoded links are broken. I need something like the equivalent VBA ThisWorkbook, which would be dynamically updated to reference ThisSheet containing the current chart.
I have a chart with established 4 curves in a standard X and Y graph in an excel worksheet.
I am putting together a program that will allow the user to input an X and Y coordinate  the program will identify one or more of the 4 curves if the X and Y points correlate with one of the existing curves or will display the closest curve along with the modified coordinates to fit the curve.
Is there builtin function with Excel to perform this? Any help would be appreciated.
I want to create a bell chart in excel. I have already created the frequency chart and have the bin values. However the bell chart is not working. I have sample data from 1 to 50 where I want to use the original data, and also the issue is my standard deviation, lower limit, upper limit and the mean changes based on values entered.
I have attached the spreadsheet for details
Value is inputed in Cell F9, F10, F11 and sample data is entered in column E13 to E62. The standard deviation, mean value are calculated and stored in N16 and N14 column respectively. Also I want to add a line for upper and lower limit that can change based on the input in F10 and F11.
Can someone help me to create a bell curve and also a normal curve on the same bell curve chart so one can compare the results.
I would sincerely appreciate the help
I have discovered how to create a normal distribution (Bell) curve on my excell spreadsheet. The instructions on the net all seem the same, and the curve always covers the same width 1 to 8 or 9. I am trying to produce a curve to lok at a number of ratings the lowest is 0 and the highest 5 How do I amend the width of the bell. I belive it is something to do with the standard deviation number which is generated and used. But now I'm lost