Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    # of Individuals

    Uploaded by

    Yuan Dirgantara
    This document contains information to calculate a Gini coefficient for a sample income distribution of 5 individuals. It provides the number of individuals, each individual's income, the total income, the cumulative share of total income, and the Lorenz curve. It then calculates the Gini coefficient for this income distribution as 0.2086956522.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    # of Individuals

    Uploaded by

    Yuan Dirgantara
    29 views4 pages
    This document contains information to calculate a Gini coefficient for a sample income distribution of 5 individuals. It provides the number of individuals, each individual's income, the total income, the cumulative share of total income, and the Lorenz curve. It then calculates the Gini coefficient for this income distribution as 0.2086956522.

    Original Description:

    ddgdgd

    Original Title

    GiniA

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains information to calculate a Gini coefficient for a sample income distribution of 5 individuals. It provides the number of individuals, each individual's income, the total income, the cumulative share of total income, and the Lorenz curve. It then calculates the Gini coefficient for this income distribution as 0.2086956522.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    29 views4 pages

    # of Individuals

    Uploaded by

    Yuan Dirgantara
    This document contains information to calculate a Gini coefficient for a sample income distribution of 5 individuals. It provides the number of individuals, each individual's income, the total income, the cumulative share of total income, and the Lorenz curve. It then calculates the Gini coefficient for this income distribution as 0.2086956522.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 4

    # of

    individuals 5 This worksheet will let you calcuate a Gini coefficient


    Individual Income distribution with up to ten individuals.
    1 4
    2 8 Step One-- Input the # of individuals into cell B2
    3 9 Step Two -- Input individual incomes into cells B3:B1
    4 10 is less than 10, leave the unneeded cells blank.
    5 15 Step Three --Mean income will appear in cell B13; th
    6 be reported in cell L29.
    7
    8
    To see a Lorenz Curve of the distribution, click below
    9
    10
    Mean 9.2
    i=
    j= 1 2 3 4 5 6
    1 0 4 5 6 11 NA
    2 4 0 1 2 7 NA
    3 5 1 0 1 6 NA
    4 6 2 1 0 5 NA
    5 11 7 6 5 0 NA
    6 NA NA NA NA NA NA
    7 NA NA NA NA NA NA
    8 NA NA NA NA NA NA
    9 NA NA NA NA NA NA
    10 NA NA NA NA NA NA
    Vertical Sum 26 14 13 14 29 0
    Horizontal
    Sum

    Gini
    Coefficient
    cuate a Gini coefficient for an income
    ividuals.

    ividuals into cell B2


    ncomes into cells B3:B12. If # of individuals
    eeded cells blank.
    ill appear in cell B13; the Gini coefficient will

    distribution, click below on LORENZ

    7 8 9 10
    NA NA NA NA
    NA NA NA NA
    NA NA NA NA
    NA NA NA NA
    NA NA NA NA
    NA NA NA NA
    NA NA NA NA
    NA NA NA NA
    NA NA NA NA
    NA NA NA NA
    0 0 0 0

    96

    0.2086956522
    # of individuals 5
    Individual Income
    1 4
    2 8
    3 9
    4 10

    C u m u l a ti v e S h a re o f To t a l In c o m e
    5 15
    6 0
    7 0
    8 0
    9 0
    10 0

    Total 46

    Population Cumulative Cumulative Perfect 1


    Share Income Share Equality
    0.9
    0 0 0 0
    0.2 4 0.0869565217 0.2 0.8

    0.4 12 0.2608695652 0.4 0.7


    0.6 21 0.4565217391 0.6
    0.6
    0.8 31 0.6739130435 0.8
    1 46 1 1 0.5
    0 0 0 0
    0.4
    0 0 0 0
    0 0 0 0 0.3

    0 0 0 0 0.2
    0 0 0 0
    0.1

    0
    0 0.1
    C u m u l a ti v e S h a re o f To t a l In c o m e

    0.9

    0.8

    0.7

    0.6

    0.5

    0.4

    0.3

    0.2

    0.1

    0
    0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1
    Population Group

    You might also like