How Do I Create Lorenz Curve In Excel???? 
New Excel Help Service!
We need your input to help create a new Live Online Excel Help service.
Please take our survey and let us know your thoughts!
Have a great day!
Don


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 ...
Pass Values from One Macro to Another Macro
How to pass variables and values to macros. This allows you to get a result from one macro and use it in another m ...
How to pass variables and values to macros. This allows you to get a result from one macro and use it in another m ...
Simple Excel Function to Extract a Word or Text from a Cell
Excel function that makes it easy to extract a word or text from a cell in Excel. This is a single function! It doe ...
Excel function that makes it easy to extract a word or text from a cell in Excel. This is a single function! It doe ...
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
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
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
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)?
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!
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
Hi All
Can anyone advise if there is a function or series of functions that I can use to create the standard "S" curve or Logistic curve used in the construction industry.
In my case, I simply want to know:
How much I have spent at what period in the construction process to see whether I am in front or behind my projections by looking at a created chart.
Any advise / assistance would be appreciated.
One thing I am no good at is financial stuff !!
Regards
Michael M
Can anyone advise if there is a function or series of functions that I can use to create the standard "S" curve or Logistic curve used in the construction industry.
In my case, I simply want to know:
How much I have spent at what period in the construction process to see whether I am in front or behind my projections by looking at a created chart.
Any advise / assistance would be appreciated.
One thing I am no good at is financial stuff !!
Regards
Michael M
Hi all
I am a biochemist so excuse me if I do not use the correct terms.
I have a practical problem with a set of data that I am receiving through one of my experiments. I am logging the production of biogas as a function of time. The production is not linear but increases and decreases (slowly) depending on the parameters I vary.
My flow meter logs accumulated gas production, however it would be much more informative for me to be able to display the gas production rate (as a function of time) in a graph.
My thought is that this can be done by looking at the slope of the curve as a function of time (the differential to the curve), but I dont want to do this by simply subtracting two adjacent data points as this would be too inaccurate.
Does anyone know of a way to do this? Is it possible to get excel to take the slope of a curve for any point on that curve, based on (for example) an approximated curve fit equation.
Regards
Stefan BG, Denmark
I am a biochemist so excuse me if I do not use the correct terms.
I have a practical problem with a set of data that I am receiving through one of my experiments. I am logging the production of biogas as a function of time. The production is not linear but increases and decreases (slowly) depending on the parameters I vary.
My flow meter logs accumulated gas production, however it would be much more informative for me to be able to display the gas production rate (as a function of time) in a graph.
My thought is that this can be done by looking at the slope of the curve as a function of time (the differential to the curve), but I dont want to do this by simply subtracting two adjacent data points as this would be too inaccurate.
Does anyone know of a way to do this? Is it possible to get excel to take the slope of a curve for any point on that curve, based on (for example) an approximated curve fit equation.
Regards
Stefan BG, Denmark
I have a nonlinear calibration curve that I am trying to deal with. What is the easiest way in Excel 2007 to do this? I am including an example of what I need to do. In the example I have a linear equation  this is what the data needs to correspond to. The nonlinear curve is the calibration curve. (This is only an example, my actual calibration curve has hundereds of points, so please keep that in mind when responding).
Basically, I need something of a curve fit, or look up table. When I use my sensor and get, let's say, I put 10 pounds on the sensor, but I only get a reading of 7. I need that 7 value to translate to 10  a linear fit so to speak. So how do I take this nonlinear calibration curve, and get the data to correspond to what the readings should be (linear)  I need to know if I put 10 pounds on the scale and get 7 as an output, that it is actually 10, not 7. Thanks for any help!
Basically, I need something of a curve fit, or look up table. When I use my sensor and get, let's say, I put 10 pounds on the sensor, but I only get a reading of 7. I need that 7 value to translate to 10  a linear fit so to speak. So how do I take this nonlinear calibration curve, and get the data to correspond to what the readings should be (linear)  I need to know if I put 10 pounds on the scale and get 7 as an output, that it is actually 10, not 7. Thanks for any help!
So basically I have a progess curve for the volume of Oxygen produced over the course of an experiment and I need to find the gradient of the curve at different time points throughout a single curve. I know all about differential calculus, but I really don't have the time to work it out for every point (I have over 20 curves and 20 points on each curve) and I was wondering whether excel can work out the gradient of the trendline at specific points?
Thanks.
Thanks.
I have excel 2003 and was wondering if it is possible to intercept the top of a curve on a chart and get the values from it. also, can I automatically show these values in the cells? I have attached the graph. It shows density of compacted soil in relation to moisture content. I need to find the maximum dry density and optimum moisture content.
Hi All,
With data points in A2:A13, is it possible to draw a bell curve which would depict the Skewness of the data whether negatively/positively skewed?
Is it possible to Create excel chart ( normal distribution curve) based on the output of Descriptive statistics
For example : Would it be possible to create normal distribution curve in excel using following Descriptive statistics output
Mean 118247.4547
Standard Error 210.3114405
Median 117081.5
Mode 91374
Standard Deviation 19711.01832
Sample Variance 388524243.3
Kurtosis 0.097330952
Skewness 0.450270462
Range 112097
Minimum 76095
Maximum 188192
Sum 1038685642
Count 8784
Largest(1) 188192
Smallest(1) 76095
Confidence Level(95.0%) 412.2596498
thanks ,
For example : Would it be possible to create normal distribution curve in excel using following Descriptive statistics output
Mean 118247.4547
Standard Error 210.3114405
Median 117081.5
Mode 91374
Standard Deviation 19711.01832
Sample Variance 388524243.3
Kurtosis 0.097330952
Skewness 0.450270462
Range 112097
Minimum 76095
Maximum 188192
Sum 1038685642
Count 8784
Largest(1) 188192
Smallest(1) 76095
Confidence Level(95.0%) 412.2596498
thanks ,
Hi Guys
I'm at a loss...
I need to create an SCurve graph but i have no idea where to begin.
Please could someone assist?
I have attached a workbook.
I'm at a loss...
I need to create an SCurve graph but i have no idea where to begin.
Please could someone assist?
I have attached a workbook.
Hi,
I am having some problem with excel. I know how to create a histogram and a normal distibution curve, but what I want to do is after creating a histogram superimpose a normal distribution curve over the histogram. Can you please give me some info on how to do this! Treat me as a newbie.
Thanks in advanced.
Alex
I am having some problem with excel. I know how to create a histogram and a normal distibution curve, but what I want to do is after creating a histogram superimpose a normal distribution curve over the histogram. Can you please give me some info on how to do this! Treat me as a newbie.
Thanks in advanced.
Alex
does anybody know how to find an intermediate value on a scatter plot w/ a
line following the curve...not a trendline but just a well i guess u'd call
it a trace line. Basically I have a few numbers (two columns, one x, one y)
which creates a "utility" curve just a line connecting those dots. I'm
simply tring to find a way to ask it a number and have it return the
corresponding value along the curve... so if i gave it a number off the x
axis it would give me the y axis value.
line following the curve...not a trendline but just a well i guess u'd call
it a trace line. Basically I have a few numbers (two columns, one x, one y)
which creates a "utility" curve just a line connecting those dots. I'm
simply tring to find a way to ask it a number and have it return the
corresponding value along the curve... so if i gave it a number off the x
axis it would give me the y axis value.
Is it possible to graph a curve based on descriptive statistics in Excel?
For example:
mean: 8.147
standard deviation: 0.142
Assuming a normal curve, I am told that I can graph this, but I don't believe it's possible with Excel.
That is, I can do the following: generate a random number set with a normal distribution, then create a histogram.
What I'd like to do is create a continuous line curve of the kind you see in textbooks, to illustrate rejection regions and critical values, etc. I suspect I'll need to look into some other software package or browserbased statistical application but before I say good bye to Excel on this I thought I'd check here.
Cheers
ξ
(note  in anticipation of a statistics class next year where there will be a lot of hypothesis testing for the first section. I sort of blew it in the first half of the course by just drawing all my graphs by hand, much to my prof's "delight").
For example:
mean: 8.147
standard deviation: 0.142
Assuming a normal curve, I am told that I can graph this, but I don't believe it's possible with Excel.
That is, I can do the following: generate a random number set with a normal distribution, then create a histogram.
What I'd like to do is create a continuous line curve of the kind you see in textbooks, to illustrate rejection regions and critical values, etc. I suspect I'll need to look into some other software package or browserbased statistical application but before I say good bye to Excel on this I thought I'd check here.
Cheers
ξ
(note  in anticipation of a statistics class next year where there will be a lot of hypothesis testing for the first section. I sort of blew it in the first half of the course by just drawing all my graphs by hand, much to my prof's "delight").
I have a set of data and wanting to create an Ogive Curve
71 77 68 64 55 50 45 40 35
31 33 36 40 45 50 55 63 70
72 74 66 63 61 60 56 50 46
41 38 34 39 41 46 50 56 57
51 48 42 46 51 58 59 52 47
43 44 47 53 48 48 49 50 42
Can you help me do this and the proper way to solve this? I see one response
that sorting the data from lease to greatest value will make an ogive curve.
Is there a mathematical way of doing this? Hoping for your immediate
response.
71 77 68 64 55 50 45 40 35
31 33 36 40 45 50 55 63 70
72 74 66 63 61 60 56 50 46
41 38 34 39 41 46 50 56 57
51 48 42 46 51 58 59 52 47
43 44 47 53 48 48 49 50 42
Can you help me do this and the proper way to solve this? I see one response
that sorting the data from lease to greatest value will make an ogive curve.
Is there a mathematical way of doing this? Hoping for your immediate
response.
Hi Guys
I desperately need help! I'm at my wits end!
I need to do an S curve graph but i cant seem to get it right!
Please could somebody assist?
I have attached a workbook
Thank you
I desperately need help! I'm at my wits end!
I need to do an S curve graph but i cant seem to get it right!
Please could somebody assist?
I have attached a workbook
Thank you
Hey all,
Ok I have a problem in that i have about 58 batches of data and have a
plot of a curve for each batch. I need to calculate the slope of the
steepest part of each curve and am restricted for time! Does anyone
know of a quick way to do this without printing off each graph and
calcalating tangents! Currently my data is in excel however I could
put transer it to MATLAB or download another program you can
recommend???
Also what technique do you recommend to use to fit a curve of best fit
to the data??????
Thank you
Ok I have a problem in that i have about 58 batches of data and have a
plot of a curve for each batch. I need to calculate the slope of the
steepest part of each curve and am restricted for time! Does anyone
know of a quick way to do this without printing off each graph and
calcalating tangents! Currently my data is in excel however I could
put transer it to MATLAB or download another program you can
recommend???
Also what technique do you recommend to use to fit a curve of best fit
to the data??????
Thank you
Dear All,
I am attempting to find where a horizontal line drawn across an X by Y graph intercepts the curve.
I am plotting temperature on the x axis against speed on the y axis. The results form a curve from zero to maximum, and back to zero as temperature increases.
I have an optimal rate which I would like to determine the temperature breadth of. This involves drawing a line across the function curve and determining the temperature at which it intercepts the performance curve (against the x axis "temperature").
Can anyone help? I hope my description is adequate!
Thanks!
I am attempting to find where a horizontal line drawn across an X by Y graph intercepts the curve.
I am plotting temperature on the x axis against speed on the y axis. The results form a curve from zero to maximum, and back to zero as temperature increases.
I have an optimal rate which I would like to determine the temperature breadth of. This involves drawing a line across the function curve and determining the temperature at which it intercepts the performance curve (against the x axis "temperature").
Can anyone help? I hope my description is adequate!
Thanks!
Hi,
I have a curve, I want to mark some part of this curve with a different color, how can i do that using excel?
for example, a curve as following, I want to mark the point from (4,4) to (6,6) with a different color.
x y
1 1
2 2
3 3
4 4
5 5
6 6
Thanks,
Mike
I have a curve, I want to mark some part of this curve with a different color, how can i do that using excel?
for example, a curve as following, I want to mark the point from (4,4) to (6,6) with a different color.
x y
1 1
2 2
3 3
4 4
5 5
6 6
Thanks,
Mike
Hi all,
How can i draw a distribution curve (normal curve) which skew to the left or right?Thanks
How can i draw a distribution curve (normal curve) which skew to the left or right?Thanks
I am developing tools to help do preliminary estimates of remodeling projects. By it's nature, a smalle project will cost more / square foot than a larger one. Lets take a deck as an example: I have a 100 sf deck that I've completed that cost $40/sf, a 200 sf deck that cost me $20/sf and a 400sf deck the cost me $15/sf, (A,B,C). (We can assume that the smallest deck I would ever build would be 50sf and the largest would be 2000sf). These knowns, will create a curve on a graph. The curve will generally look like the attached spreadsheet. It will never touch the x or y axis. The A, B and C points will all be related so the curve shouls have a shape similar to the image.
Assuming that I know A,B &C and I have a minimum and maximum size, what formula would I need to calculate what a 325sf deck would cost, or any other size deck between the smallest and largest parameters?
Assuming that I know A,B &C and I have a minimum and maximum size, what formula would I need to calculate what a 325sf deck would cost, or any other size deck between the smallest and largest parameters?