## 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

## Free Excel Help Forum

**- Ask any question about Excel and have it answered in no time.**

## 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

Hello,

Can you create the bell curve for a z-score 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 z-score 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 non-linear 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 non-linear 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 non-linear 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 S-Curve 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 S-Curve 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 browser-based 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 browser-based 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?