ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
Workbook to calculate change in Gini coefficient 2013-2020
2
3
2013 financial year data
4
Source:
Distribution of direct aid to farmers – indicative figures 2013 financial year
5
6
Amount (in thousand EUR) paid to beneficiaries receiving aid within the indicated range
7
Strat. (€ * 1000)BEBGCZDKDEEEELESFRIEITCYLVLTLUHUMTNLATPLPTROSISKFISEUKEU27
8
< 0 €-35 -45 -41 -211 -68 -482 -20 -2,775 -3 -20 -47 -71 -22 -65 -4 -2 -307 -4,218
9
≥ 0 and < 500 €531 1,027 1,091 36 5,972 1,351 48,147 60,451 5,795 1,231 128,212 4,886 7,269 20,533 37 13,429 811 13 336 122,124 21,619 202,402 4,087 1,414 199 36 3,346 668,652
10
≥ 500 and < 1 250 €236 12,307 3,964 4,705 34,064 379 149,945 149,594 24,384 7,563 227,975 5,442 15,627 35,489 109 3,632 586 5,559 12,814 358,154 32,847 134,874 14,176 3,278 5,112 11,797 17,533 1,310,368
11
≥ 1 250 and < 2 000 €3,337 8,889 4,665 7,784 40,593 3,147 142,244 147,957 28,979 14,543 174,436 3,378 9,396 22,105 148 33,531 358 5,859 17,513 330,386 23,339 446 14,045 2,519 812 13,581 21,585 1,127,037
12
≥ 2 000 and < 5 000 €17,474 27,277 18,195 3,231 194,509 7,419 469,079 50,582 126,618 100,714 505,992 7,193 17,285 44,489 767 99,734 682 25,848 93,773 730,755 63,827 74,366 36,913 6,907 49,394 46,573 996 3,403,513
13
≥ 5 000 and < 10 000 €43,644 32,942 24,746 51,483 418,241 745 605,468 703,617 295,084 227,342 55,675 5,809 14,589 44,616 167 99,178 437 50,128 174,013 406,189 76,542 6,898 26,112 6,531 105,474 68,536 194,176 4,309,747
14
≥ 10 000 and < 20 000 €
116,391 35,178 37,051 82,479 831,291 11,018 475,567 1,021,459 1,019,673 354,827 599,951 6,143 16,018 457 6,574 121,195 727 153,132 210,041 258,135 91,561 81,108 1,662 10,363 161,562 113,038 41,375 6,290,552
15
≥ 20 000 and < 50 000 €
247,467 60,396 66,981 212,054 1,551,971 19,248 327,191 1,421,949 3,516,860 391,177 739,937 6,484 21,528 54,763 18,067 192,682 1,025 374,193 158,324 198,367 123,798 147,331 9,272 23,884 156,542 221,833 986,502 11,249,826
16
≥ 50 000 and < 100 000 €
105,367 81,336 6,482 282,262 683,722 16,074 57,615 617,184 2,234,699 120,277 470,887 2,224 13,754 29,077 5,551 145,004 210 131,211 2,208 125,661 98,168 126,083 1,845 29,069 35,191 135,351 767,925 6,402,647
17
≥ 100 000 and < 150 000 €
18,492 55,604 59,412 129,824 254,394 8,613 6,708 217,073 431,436 22,802 202,178 669 7,541 1,307 613 59,097 35,395 4,439 64,604 52,322 65,592 522 2,877 5,964 40,367 317,012 2,102,513
18
≥ 150 000 and < 200 000 €
6,119 45,518 60,346 57,563 176,467 6,208 513 116,607 101,876 5,542 108,806 473 3,854 9,412 44,431 17,301 2,898 42,001 2,593 34,885 334 29,659 1,928 17,639 15,665 1,072,960
19
≥ 200 000 and < 250 000 €
2,645 27,766 53,644 32,547 154,286 2,618 71,589 3,631 2,569 62,095 232 1,098 6,051 208 40,544 10,267 1,518 22,898 14,429 20,209 238 32,114 1,733 8,803 93,074 699,485
20
≥ 250 000 and < 300 000 €
1,362 25,561 53,286 18,627 142,689 1,081 51,975 19,449 1,592 50,774 1,037 4,655 30,092 536 1,955 20,202 8,475 15,002 299 28,179 514 3,848 58,291 544,305
21
≥ 300 000 and < 500 000 €
1,418 32,506 160,481 21,292 358,286 3,346 72,496 16,254 700 70,166 394 3,228 10,737 106,537 6,354 1,465 39,524 10,655 29,667 2,681 76,162 6,172 89,107 1,119,628
22
≥ 500 000 €521 38,068 21,544 6,339 407,495 561 79,534 108,927 73,926 519 691 4,915 183,816 2,333 2,247 50,514 5,337 41,779 307 75,462 1,759 74,104 1,377,357
23
Total567,093 493,618 824,122 939,260 5,253,939 91,924 2,282,266 5,237,237 7,965,862 1,250,859 3,969,310 43,843 132,915 345,592 33,744 1,205,543 4,836 822,953 70,644 2,769,443 648,827 1,086,813 13,021 354,311 531,733 689,331 3,292,348 41,674,372
24
25
Number of beneficiaries (in thousands) per range of expenditure
26
Strat. (number * 1000)BEBGCZDKDEEEELESFRIEITCYLVLTLUHUMTNLATPLPTROSISKFISEUKEU27
27
< 0 €0.030.210.020.060.060.250.040.580.010.020.050.240.390.260.010.222.45
28
≥ 0 and < 500 €1.8145.23.210.317.074.93150.98218.3219.484.88476.1120.4627.371.320.1244.584.60.0712.01380.9182.36838.7413.84.70.590.3211.142455.31
29
≥ 500 and < 1 250 €2.7715.694.745.1139.644.63181.12182.0128.858.54285.18719.6344.90.1344.520.756.8515.08435.9941.04182.917.024.125.8113.5220.641618.18
30
≥ 1 250 and < 2 000 €2.065.612.934.8425.431.9989.4292.8218.198.95110.172.156.0314.070.0921.080.233.6610.89208.3614.7728.878.851.585.038.5513.5710.12
31
≥ 2 000 and < 5 000 €5.168.555.69.9258.122.4146.24157.3438.1429.51159.692.345.6614.610.2331.550.237.7828.03241.3520.1123.9811.92.214.6814.4630.051069.83
32
≥ 5 000 and < 10 000 €5.964.753.487.2458.591.0686.6899.6739.9531.5779.80.842.096.390.2314.120.066.924.560.0910.849.983.810.9314.599.5826.75610.45
33
≥ 10 000 and < 20 000 €
7.942.532.625.857.750.7835.272.0368.6925.2443.30.441.153.280.448.640.0510.2815.2318.956.595.771.240.7211.537.928.7442.79
34
≥ 20 000 and < 50 000 €
8.091.92.166.5351.280.6211.5647.84110.313.5124.410.220.71.820.626.20.0312.585.676.724.054.710.330.755.517.1631.37366.64
35
≥ 50 000 and < 100 000 €
1.621.140.924.0510.250.230.929.2233.811.846.890.030.20.430.092.21.970.351.831.431.810.030.410.552.0111.2595.48
36
≥ 100 000 and < 150 000 €
0.160.450.491.072.10.070.061.823.680.191.680.010.060.110.010.490.30.040.540.430.540.230.050.342.6318.00
37
≥ 150 000 and < 200 000 €
0.040.260.350.341.020.040.680.60.030.630.020.050.260.10.020.240.150.20.170.010.10.926.00
38
≥ 200 000 and < 250 000 €
0.010.120.240.150.690.010.320.170.010.280.010.030.180.050.010.10.070.090.140.010.040.423.15
39
≥ 250 000 and < 300 000 €
0.010.090.20.070.520.190.070.010.190.020.110.020.010.070.030.060.10.010.222.00
40
≥ 300 000 and < 500 000 €
0.090.420.060.950.010.20.040.190.010.030.280.020.110.030.080.010.20.020.242.99
41
≥ 500 000 €0.040.290.010.570.090.090.090.010.210.060.010.040.110.081.7
42
Total35.6686.4227.6545.732416.77702.24882.61362.31124.321.189.1933.562.86157.091.96174.475.9550.58111.841355.56182.31098.035716.3658.3664.01178.137404.87
43
44
Cumulative descending number of beneficiaries
45
Strat. (cum. number % D)
BEBGCZDKDEEEELESFRIEITCYLVLTLUHUMTNLATPLPTROSISKFISEUKEU27
46
< 0 €100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%
47
≥ 0 and < 500 €99.92%100.00%100.00%99.54%99.99%100.00%99.99%99.99%99.93%99.97%99.95%99.97%100.00%99.99%100.00%99.97%100.00%100.00%100.00%99.98%99.79%99.98%99.98%100.00%100.00%100.00%99.88%99.97%
48
≥ 500 and < 1 250 €94.84%47.70%88.39%98.88%94.73%70.60%78.49%75.26%94.55%96.04%59.91%38.90%56.57%54.59%93.88%74.42%22.69%99.86%89.26%71.88%54.61%23.59%75.77%71.27%98.99%99.50%93.62%66.81%
49
≥ 1 250 and < 2 000 €87.07%29.54%71.25%87.70%82.49%42.99%52.70%54.64%86.59%89.17%35.93%18.00%25.34%26.00%87.24%48.90%10.08%86.32%75.78%39.72%32.10%6.93%45.91%46.09%89.03%78.38%82.04%44.96%
50
≥ 2 000 and < 5 000 €81.30%23.05%60.65%77.11%74.64%31.13%39.97%44.12%81.57%81.97%26.67%11.58%15.75%17.05%82.65%36.82%6.22%79.08%66.04%24.35%23.99%4.30%30.39%36.43%80.41%65.02%74.46%35.37%
51
≥ 5 000 and < 10 000 €66.83%13.16%40.40%55.40%56.70%16.82%19.14%26.29%71.04%58.24%13.24%4.60%6.75%7.75%70.92%18.74%2.35%63.70%40.98%6.54%12.96%2.12%9.51%22.98%55.26%42.43%57.59%20.92%
52
≥ 10 000 and < 20 000 €
50.11%7.66%27.81%39.56%38.62%10.49%6.80%15.00%60.02%32.84%6.53%2.09%3.42%3.68%59.18%10.64%1.34%50.06%19.07%2.11%7.02%1.21%2.82%17.30%30.26%27.46%42.57%12.67%
53
≥ 20 000 and < 50 000 €
27.85%4.73%18.34%26.87%20.80%5.84%1.79%6.84%41.06%12.54%2.89%0.78%1.59%1.59%36.73%5.69%0.50%29.74%5.45%0.71%3.40%0.69%0.65%12.90%10.50%15.12%26.46%6.69%
54
≥ 50 000 and < 100 000 €
5.16%2.53%10.52%12.58%4.97%2.15%0.14%1.42%10.62%1.67%0.84%0.12%0.48%0.43%5.10%2.14%4.86%0.38%0.22%1.18%0.26%0.07%8.31%1.06%3.94%8.85%1.74%
55
≥ 100 000 and < 150 000 €
0.62%1.21%7.20%3.72%1.81%0.78%0.01%0.37%1.28%0.19%0.26%0.03%0.16%0.16%0.51%0.88%0.97%0.07%0.08%0.39%0.09%0.02%5.81%0.12%0.80%2.53%0.45%
56
≥ 150 000 and < 200 000 €
0.17%0.69%5.42%1.38%1.16%0.36%0.17%0.27%0.04%0.12%0.06%0.09%0.60%0.38%0.04%0.04%0.16%0.04%0.02%4.40%0.03%0.27%1.06%0.22%
57
≥ 200 000 and < 250 000 €
0.06%0.39%4.16%0.63%0.84%0.12%0.09%0.10%0.02%0.06%0.03%0.06%0.45%0.18%0.02%0.03%0.08%0.02%0.02%3.36%0.02%0.11%0.54%0.13%
58
≥ 250 000 and < 300 000 €
0.03%0.25%3.29%0.31%0.63%0.06%0.05%0.06%0.01%0.04%0.02%0.04%0.34%0.08%0.01%0.02%0.04%0.02%0.02%2.51%0.05%0.30%0.09%
59
≥ 300 000 and < 500 000 €
0.15%2.57%0.15%0.47%0.06%0.03%0.04%0.02%0.02%0.03%0.28%0.04%0.01%0.02%0.01%0.02%1.89%0.03%0.18%0.06%
60
≥ 500 000 €0.05%1.05%0.02%0.18%0.01%0.02%0.01%0.01%0.12%0.00%0.01%0.00%0.67%0.04%0.02%
61
62
Relative share of value per range of expenditure
63
Strat. (€ %)BEBGCZDKDEEEELESFRIEITCYLVLTLUHUMTNLATPLPTROSISKFISEUKEU27
64
< 0 €-0.01%0.00%0.00%-0.01%0.00%-0.01%0.00%-0.07%-0.01%-0.01%0.00%0.00%0.00%-0.01%0.00%0.00%-0.01%-0.01%
65
≥ 0 and < 500 €0.09%2.08%0.13%0.00%0.11%1.47%2.11%1.15%0.07%0.10%3.23%11.14%5.47%5.94%0.11%1.11%16.77%0.00%0.48%4.41%3.33%18.62%3.14%0.40%0.04%0.01%0.10%1.60%
66
≥ 500 and < 1 250 €0.42%2.49%0.48%0.50%0.65%4.12%6.57%2.86%0.31%0.60%5.74%12.41%11.76%10.27%0.32%3.01%12.12%0.68%1.81%12.93%5.06%12.41%10.89%0.93%0.96%1.71%0.53%3.14%
67
≥ 1 250 and < 2 000 €0.59%1.80%0.57%0.83%0.77%3.42%6.23%2.83%0.36%1.16%4.39%7.70%7.07%6.40%0.44%2.78%7.40%0.71%2.48%11.93%3.60%4.10%10.79%0.71%1.53%1.97%0.66%2.70%
68
≥ 2 000 and < 5 000 €3.08%5.53%2.21%3.44%3.70%8.07%20.55%9.66%1.59%8.05%12.75%16.41%13.00%12.87%2.27%8.27%14.10%3.14%13.27%26.39%9.84%6.84%28.35%1.95%9.29%6.76%3.03%8.17%
69
≥ 5 000 and < 10 000 €7.70%6.67%3.00%5.48%7.96%8.10%26.53%13.43%3.70%18.17%14.03%13.25%10.98%12.91%4.95%8.23%9.04%6.09%24.63%14.67%11.80%6.35%20.05%1.84%19.84%9.94%5.90%10.34%
70
≥ 10 000 and < 20 000 €
20.52%7.13%4.50%8.78%15.82%11.99%20.84%19.50%12.80%28.37%15.11%14.01%12.05%13.22%19.48%10.05%15.03%18.61%29.73%9.32%14.11%7.46%12.76%2.92%30.38%16.40%12.57%15.09%
71
≥ 20 000 and < 50 000 €
43.64%12.24%8.13%22.58%29.54%20.94%14.34%27.15%44.15%31.27%18.64%14.79%16.20%15.85%53.54%15.98%21.20%45.47%22.41%7.16%19.08%13.56%7.12%6.74%29.44%32.18%29.96%26.99%
72
≥ 50 000 and < 100 000 €
18.58%16.48%7.87%30.05%13.01%17.49%2.52%11.78%28.05%9.62%11.86%5.07%10.35%8.41%16.45%12.03%4.34%15.94%3.13%4.54%15.13%11.60%1.42%8.20%6.62%19.64%23.32%15.36%
73
≥ 100 000 and < 150 000 €
3.26%11.26%7.21%13.82%4.84%9.37%0.29%4.14%5.42%1.82%5.09%1.53%5.67%3.78%1.82%4.90%4.30%0.63%2.33%8.06%6.04%0.40%8.12%1.12%5.86%9.63%5.05%
74
≥ 150 000 and < 200 000 €
1.08%9.22%7.32%6.13%3.36%6.75%0.02%2.23%1.28%0.44%2.74%1.08%2.90%2.72%3.69%2.10%0.41%1.52%4.00%3.21%0.26%8.37%0.36%2.56%4.76%2.57%
75
≥ 200 000 and < 250 000 €
0.47%5.62%6.51%3.47%2.94%2.85%1.37%0.46%0.21%1.56%0.53%0.83%1.75%0.62%3.36%1.25%0.21%0.83%2.22%1.86%0.18%9.06%0.33%1.28%2.83%1.68%
76
≥ 250 000 and < 300 000 €
0.24%5.18%6.47%1.98%2.72%1.18%0.99%0.24%0.13%1.28%0.78%1.35%2.50%0.65%0.28%0.73%1.31%1.38%0.23%7.95%0.10%0.56%1.77%1.31%
77
≥ 300 000 and < 500 000 €
0.25%6.59%19.47%2.27%6.82%3.64%1.38%0.20%0.06%1.77%0.90%2.43%3.11%8.84%0.77%0.21%1.43%1.64%2.73%2.06%21.50%0.90%2.71%2.69%
78
≥ 500 000 €0.09%7.71%26.14%0.67%7.76%0.61%1.52%1.37%1.86%1.18%0.52%1.42%15.25%0.28%0.32%1.82%0.82%3.84%2.36%21.30%0.26%2.25%3.31%
79
80
Calculation of Gini Coefficient
81
Calculation of Area B using the trapezoidal method
82
Strat. (€ %)BEBGCZDKDEEEELESFRIEITCYLVLTLUHUMTNLATPLPTROSISKFISEUKEU27
83
≥ 0 and < 500 €0.000876420.01536080.00122453500.001070960.01253910.018829640.0100768750.000680680.000980050.025817390.077350590.0428218950.045910260.001066340.0096786450.10287556500.004542240.037895130.02570760.115043670.027592750.00342540.000397980.000099750.00096750.0133424
84
≥ 500 and < 1 250 €0.003820110.009616380.003831360.00466450.005759650.023399540.0430959150.01857570.002807670.00555630.027506080.035306450.048163080.0413829650.002897920.018559660.019858620.006330120.014936120.07214940.021937630.018937660.066254760.005457240.009024960.015208740.004654990.01754789
85
≥ 1 250 and < 2 000 €0.0049669150.00473310.003759150.0068396150.0060495050.012674520.0288667050.013974540.003026880.009926120.01374070.01138830.0145253150.0137760.003737580.011915080.0060310.00587170.017585680.0382177550.01009620.002302150.041163850.002929460.012962160.01412490.00516450.01084455
86
≥ 2 000 and < 5 000 €0.022812020.0100120650.0111660250.022791720.02429790.0193478250.0607355250.034008030.0121324950.0564345250.0254426250.013275690.0146250.01595880.0174301950.022974060.006041850.022416460.071007770.0407593550.01817940.002195640.056558250.0057924750.0630187150.03631810.0200055750.022994465
87
≥ 5 000 and < 10 000 €0.04502190.006943470.01023150.026019040.037937360.011060550.034409410.0277262350.02424610.082746180.0138686550.0044321250.005583330.0073780650.032199750.012089870.001667880.034639920.0739515750.0063447750.01178820.0010572750.0123608250.003705760.084835840.034735330.02954720.01736603
88
≥ 10 000 and < 20 000 €
0.079986960.0044170350.010383750.029162770.047001220.0097898350.008950780.0212940.06469120.064371530.007116810.0020104350.0030185250.003483470.093416340.0082058250.001382760.07425390.036448980.001314120.007351310.00070870.002213860.00440920.061914440.03491560.0433853550.01460712
89
≥ 20 000 and < 50 000 €
0.072027820.004443120.011731590.044539050.038062290.008365530.001383810.011212950.11408360.0222173350.003476360.000665550.00167670.001600850.111978910.006256170.000530.07866310.0065325150.000332940.004369320.00064410.000256320.007147770.017016320.030667540.052894380.011376285
90
≥ 50 000 and < 100 000 €
0.005369620.003081760.006972820.024490750.004410390.0025622850.00001890.001054310.016689750.000894660.00065230.0000380250.00033120.0002480950.0046142250.0018165300.004646510.0000704250.00006810.0011877050.0002030.000006390.00578920.000390580.004654680.013269080.00168192
91
≥ 100 000 and < 150 000 €
0.000128770.00106970.004549510.00352410.000718740.000534090.0000001450.000111780.000420050.000020930.000096710.0000022950.000062370.000047250.000046410.000362600.000290250.0000034650.000013980.000221650.000039260.00000080.004145260.00000840.000313510.0017285850.000169175
92
≥ 150 000 and < 200 000 €
0.000012420.000497880.003506280.0006160650.0003360.00016200.000028990.000023680.000001320.0000246600.000013050.000020400.00019372500.00005880.000001230.000005320.0000480.000009630.000000520.003247560.00000090.000048640.00038080.000044975
93
≥ 200 000 and < 250 000 €
0.0000021150.000179840.0024249750.000163090.000216090.0000256500.000009590.000003680.0000003150.000007800.0000020750.0000087500.0001327200.000016250.0000003150.0000020750.000013320.000003720.000000360.002659110.000000330.000010240.000118860.00001848
94
≥ 250 000 and < 300 000 €
0.000000360.00010360.001895710.000045540.00014960.0000070800.000003960.00000120.0000000650.0000038400.000001560.00000472500.000077500.00000390.000000140.0000010950.000003930.000002070.000000460.00174900.000002240.000042480.000009825
95
≥ 300 000 and < 500 000 €
00.00006590.003524070.0000192950.000221650.0000109200.000002760.000000600.00000265500.000002430.0000062200.000176800.0000015400.0000007150.000002460.0000013650.000002060.00275200.000001350.000029810.00001076
96
≥ 500 000 €00.0000192750.001372350.000000670.00006984000.000000760.0000013700.00000093000.0000007100.000091500000.00000041000.00071355000.00000450.00000331
97
Sum Area B0.235025430.0605439250.0765736250.1628762050.1663011950.1004789250.196290830.138080480.2388089550.243149330.1177575150.144469460.130826530.129826560.267387670.0925306850.1383876750.227192450.2250804550.197104760.1009071350.141148240.2064112050.0539229850.2495706250.171100620.1721936150.110017185
98
Gini = A/(A+B)0.529949140.878912150.846852750.674247590.667397610.799042150.607418340.723839040.522382090.513701340.764484970.711061080.738346940.740346880.465224660.814938630.723224650.54561510.549839090.605790480.798185730.717703520.587177590.892154030.500858750.657798760.655612770.77996563
99
100