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


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
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 Tutorials
Quickly Create a Huge List of Numbers in Excel
Quickly create a large list of numbers in Excel using the Fill Command. This will save you time and allow you to ...
Quickly create a large list of numbers in Excel using the Fill Command. This will save you time and allow you to ...
What is a Macro in Excel?
This is the first step to learning about Macros for Excel and how to use them. What is a Macro? A macro is a smal ...
This is the first step to learning about Macros for Excel and how to use them. What is a Macro? A macro is a smal ...
Simple Excel Function to Combine Text with a Separator
Excel function that makes combining text very easy. This function is simpler and better than the CONCATENATE functi ...
Excel function that makes combining text very easy. This function is simpler and better than the CONCATENATE functi ...
Dynamic Named Range in Excel
How to create a named range that expands automatically when a new value is added to the range. This is a great lit ...
How to create a named range that expands automatically when a new value is added to the range. This is a great lit ...
Helpful Excel Macros
Create a Line Chart with a Macro in Excel
 Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
 Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
Create a Column Chart with a Macro in Excel
 This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a rang
 This macro adds a column chart to Excel. This is an easy to use macro that allows you to quickly chart and graph a rang
Create a Bar Chart With a Macro in Excel
 Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and data
 Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and data
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
 This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s
Delete All Chart Sheets in Excel  Only Chart Sheets are Deleted  Not Embedded Charts
 Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the
 Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the
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
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
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
Hey all,
I am trying to plot the Lorenz curve.
X axis is labelled as "Number of Firms"
Y axis is labelled as "Cumulative size of firms"
Here are the datas:
Firm 1: 100
Firm 2: 200
Firm 3: 300
Firm 4: 400
Firm 5: 500
Firm 6: 600
Firm 7: 700
Could you also show all the steps of plotting the graph in details please?
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
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
Hi I have a detailed listing of health care claims (by social security number) for an organization. I want to create a bell curve (statistic curve) that will show the mean (average health care claim amount) and the standard deviations that create the curve. Does anyone know how to create this bell curve.
Thanks a lot,
Elliott
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?
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
X Y 0 175 42 160 82 140 119 120 144 100 168 80 186 60 198 40 207 20 210 0
thanks
Tim
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
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 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
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...
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
Hello
I can't seem to find a way of plotting a simple normal distribution curve from a basic set of data. I've created a histogram but playing through the chart options in excel can't find a normal distribution curve. Probably have to add more to the frequencies (SD, Mean etc) which is fine, but can't seem to plot nicely in graphical format
Attached example.
Help is always appreciate as ever.
Cheers
Matt
Hi,
My boss asked me to create belt curve chart. I am a bit confused either my types data can be used to build belt curve which known as Normal distribution
Can anyone help me?
SCORE RANGE 2013 2014
< 3.0 150 115
≥ 3 and ≤ 3.5220 280
≥ 3.5 and ≤ 4.0150 210
> 4.0 30 60
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!
I have an example that I can send if that helps.
Thanks!
I am trying to create a bell curve graff, firstly to reflect the standard IQ bell curve but then to overlay it using results captured from an IQ study I am conducting. Can anybody help?
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
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
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 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
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
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:
Then these names are used to plot the data in a Line Chart:
Code:
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.
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.
Hello,
I have problem how to draw a curve onto a polar chart that is based on degree
and its values.
Also after the curve is plotted, then I like to extract the curve equation.
Thanks
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 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