Creating a Lorenz Curve from Excel - University of Washington
Creating a Lorenz Curve in Excel GEOG 326 Winter 2011 Section Handout
1. Enter original data for case study
Region % Population % Income
A
15
25
B
35
35
C
30
15
D
15
5
E
5
20
2. Add a column for Income/Population
Region % Population % Income Income/Population
A
15
25
1.666666667
B
35
35
1
C
30
15
0.5
D
15
5
0.333333333
E
5
20
4
3. Sort by column % Income / % Population
Region % Population % Income Income/Population
D
15
5
0.333333333
C
30
15
0.5
B
35
35
1
A
15
25
1.666666667
E
5
20
4
4. Add columns for Cumulative % Population and Cumulative % Income
Region % Population % Income Income/Population C % Population C % Income
D
15
5
0.333333333
15
5
C
30
15
0.5
45
20
B
35
35
1
80
55
A
15
25
1.666666667
95
80
E
5
20
4
100
100
5. Add a row for zeroes
Region % Population
D
15
C
30
B
35
A
15
E
5
% Income
5 15 35 25 20
Income/Population
0.333333333 0.5 1
1.666666667 4
C % Population 0
15 45 80 95 100
C % Income 0 5
20 55 80 100
1
6. Using the cumulative % columns, insert a scatter plot with data points connected by smoothed lines.
120
100
80
60
Series1
40
20
0
0
20
40
60
80
100
120
7. Format the axes to end at 100. (Right-click on x-axis and select Format Axis. Do the
same for the y-axis.)
8. Label the axes and add a chart title. (Right-click on the chart and select Chart
Options>Titles.)
9. Label the legend line. (Right-click on the chart and select Source Data. Enter a name
such as "Case Study".)
10. Add the equality line to the chart.
a. Enter new data into the spreadsheet. You can add as many points in the line as
you want as long as you include at least (0,0) and (100,100).
X-values Y-values
0
0
100
100
b. Then right-click on the chart and select Source Data. Press the "Add" button. For the name, type "Equality". For the x values, select the x-value cells. For the y values, select the y-value cells.
Cumulative % Income
Lorenz Curve
100
90
80
70
60
50
40
30
20
10
0
0
10
20
30
40
50
60
70
80
90
100
Cumulative % Population
Case Study Equality
2
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- plain graph paper incompetech
- how to create graphs with a best fit line in excel
- a guide to using excel in physics lab
- physics and feynman s diagrams
- fundamental of physics
- creating a lorenz curve from excel university of washington
- plotting graphs
- physics 1040l lab lab 7 lenses and images
- graph interpretation and linearization
- picturing motion dot diagrams
Related searches
- university of washington hr jobs
- university of washington jobs listing
- university of washington human resources
- university of washington human resources dept
- university of washington baseball roster
- university of washington product management
- university of washington online mba
- university of washington printable map
- university of washington opioid taper
- university of washington opioid calculator
- university of washington program management
- university of washington graduate programs