To work out (1) head count ratio (incidence of poverty), (2) poverty gap ratio (depth of poverty)

Fantastic news! We've Found the answer you've been seeking!

Question:

To work out

(1) head count ratio (incidence of poverty),

(2) poverty gap ratio (depth of poverty)

(3) squared poverty gap ratio (severity of poverty),

4) using the data set (described below) after adjustment of sample.2.2. To draw Lorenz Curve and to calculate Gini coefficient, using the data set.

res_id	income_wage	income_profits	income_rent	income_interest	income_pension	income_benefit	income_receiving	income_others	Total Income	Poverty Dummy	Poverty Gap Ratio	Squared Poverty Gap Ratio
1101	21,600	0	0	0	0	0	0	0	21,600
1102	0	66,000	0	0	0	0	0	0	66,000
1103	0	24,000	0	12,000	168,000	0	2,000	0	206,000
1104	9,600	0	0	0	0	0	950	0	10,550
1105	0	0	0	0	0	0	0	0	0
1106	0	60,000	0	0	0	0	0	0	60,000
1107	0	3,000	0	0	0	0	36,000	0	39,000
1108	0	84,200	0	0	0	0	0	0	84,200
1109	0	19,200	0	0	0	0	0	0	19,200
1110	0	0	0	0	0	0	25,000	0	25,000
1111	0	0	0	0	0	0	0	0	0
1112	0	0	0	0	0	0	12,000	0	12,000
1113	0	28,800	0	0	0	0	0	0	28,800
1114	0	0	84,000	0	0	0	0	0	84,000
1116	0	0	72,000	0	0	0	0	0	72,000
1117	0	6,000	0	0	0	0	0	0	6,000
1118	0	0	0	0	0	0	8,000	0	8,000
1119	0	0	0	0	216,000	0	0	0	216,000
1120	0	0	0	0	0	0	0	0	0
1121	0	61,600	0	0	0	0	0	0	61,600
1122	0	0	0	0	0	0	0	0	0
1123	0	10,560	0	0	0	0	0	0	10,560
1124	66,000	0	0	0	0	0	0	0	66,000
1125	0	0	0	0	0	0	0	0	0
1126	0	0	0	0	0	0	24,000	0	24,000
1127	105,600	0	0	0	0	0	48,000	0	153,600
1128	0	0	0	0	60,000	0	0	0	60,000
1129	0	79,200	0	0	0	0	0	0	79,200
1130	0	0	36,000	0	0	0	19,200	0	55,200
1131	0	79,200	0	0	0	0	0	0	79,200
1132	0	79,200	0	0	48,000	0	0	0	127,200
1133	0	108,000	0	0	0	0	0	0	108,000
1134	180,000	0	0	0	0	0	0	0	180,000
1135	0	0	0	0	0	0	0	0	0
1136	60,000	0	0	0	0	0	0	0	60,000
1137	0	10,560	0	0	0	0	0	0	10,560
1138	0	14,400	0	0	0	0	0	0	14,400
1139	7,920	0	0	0	0	0	0	0	7,920
1140	0	0	0	0	39,600	0	16,000	0	55,600
1141	0	9,600	0	0	0	0	0	0	9,600
1142	0	72,000	42,000	0	0	0	0	0	114,000
1143	0	0	0	0	0	0	4,800	0	4,800
1144	0	0	0	0	0	0	0	0	0
1145	72,000	0	0	0	0	0	0	0	72,000
1146	0	0	0	0	0	0	0	0	0
1147	0	0	0	0	0	0	0	0	0
1148	0	8,400	0	0	0	0	30,000	0	38,400
1149	0	0	0	0	0	0	66,000	0	66,000
1150	0	0	0	0	0	0	0	0	0
1151	0	0	0	0	0	0	72,000	0	72,000
1152	0	0	0	0	0	0	0	0	0
1153	0	0	0	0	0	0	19,200	0	19,200
1154	0	52,800	0	0	0	0	0	0	52,800
1155	0	0	0	0	0	0	0	0	0
1201	0	0	0	0	0	0	0	0	0
1202	0	0	5,000	0	0	0	0	0	5,000
1203	0	500	0	0	0	0	400	0	900
1204	72,000	0	0	0	0	0	0	0	72,000
1205	115,200	0	0	0	0	0	0	0	115,200
1206	0	3,500	0	0	0	0	0	0	3,500
1207	0	0	0	0	0	0	12,000	0	12,000
1208	100,800	37,800	0	0	0	0	0	0	138,600
1209	108,000	0	0	0	0	0	48,000	0	156,000
1210	0	0	0	0	0	0	0	0	0
1211	2,700	0	0	0	0	0	0	0	2,700
1212	0	0	0	0	0	0	0	0	0
1213	36,000	8,400	0	0	0	0	0	0	44,400
1214	0	0	0	0	0	0	0	0	0
1215	60,000	5,000	0	0	0	0	48,000	0	113,000
1216	0	72,000	0	0	0	0	0	0	72,000
1217	57,600	48,000	0	0	0	0	72,000	0	177,600
1218	0	8,640	0	0	0	0	0	0	8,640
1219	24,000	36,000	0	0	0	0	0	0	60,000
1220	24,000	12,000	0	0	0	0	0	0	36,000
1221	16,800	0	0	0	0	0	0	0	16,800
1222	96,000	0	0	0	0	0	0	0	96,000
1223	0	0	0	0	0	0	0	0	0
1224	72,000	0	0	0	0	0	0	0	72,000
1225	72,000	1,200	0	0	0	0	0	0	73,200
1226	201,600	0	0	0	0	0	0	0	201,600
1227	0	0	48,000	0	0	0	96,000	0	144,000
1228	38,400	0	180,000	0	24,000	0	0	0	242,400
1229	0	0	0	0	0	0	0	0	0
1230	24,000	9,600	0	0	0	0	0	0	33,600
1231	0	0	0	0	0	0	0	0	0
1232	0	0	0	0	0	0	0	0	0
1301	0	0	0	0	0	0	0	0	0
1302	26,400	0	0	0	0	0	2,400	0	28,800
1303	69,600	0	0	0	0	0	0	0	69,600
1304	0	0	0	0	0	0	4,800	0	4,800
1305	0	0	0	0	0	0	11,520	0	11,520
1306	48,000	0	0	0	0	0	0	0	48,000
1307	0	0	0	0	0	0	0	0	0
1308	0	0	0	0	0	0	18,000	0	18,000
1309	0	0	0	0	0	0	48,000	0	48,000
1310	0	0	0	0	0	0	0	0	0
1311	0	0	0	0	0	0	0	0	0
1312	0	0	0	0		0	7,200	0	7,200
1313	0	0	0	0	0	0	6,720	0	6,720
1315	0	0	0	0	0	0	12,000	0	12,000
1316	0	0	0	0	0	0	0	0	0
1317	0	0	0	0	0	0	36,000	0	36,000
1318	0	0	0	0	0	0	54,000	0	54,000
1319	0	0	0	0	0	0	9,600	0	9,600
1320	0	0	0	0	0	0	18,000	0	18,000
1321	12,000	0	0	0	0	0	0	0	12,000
1322	0	0	72,000	0	0	0	0	0	72,000
1323	0	0	60,000	0	0	0	6,000	0	66,000
1324	0	0	0	0	0	0	0	0	0
1325	12,000	0	0	0	0	0	0	0	12,000
1326	10,560	54,000	0	0	0	0	0	0	64,560
1327	0	0	0	0	0	0	14,400	0	14,400
1328	97,788	0	0	0	0	0	0	0	97,788
1329	14,400	0	0	0	0	0	3,600	0	18,000
1330	0	0	0	0	0	0	7,300	0	7,300
1331	0	0	0	0	0	0	19,200	0	19,200
1332	0	0	0	0	0	0	0	0	0
1333	0	0	0	0	0	0	0	0	0
1334	0	0	0	0	0	0	0	0	0
1335	0	0	0	5,000	0	0	2,250	0	7,250
1336	0	0	0	0	0	0	1,300	200	1,500
1337	0	0	0	0	0	0	18,000	0	18,000
1338	72,000	0	0	0	0	0	1,000	0	73,000
2101	0	0	0	0	0	0	87,600	0	87,600
2102	88,000	0	0	0	0	0	240,000	0	328,000
2103	0	0	0	0	0	600,000	0	0	600,000
2104	0	0	0	0	0	0	0	0	0
2105	40,000	0	0	0	0	0	120,000	0	160,000
2106	0	164,000	0	0	0	0	5,000	0	169,000
2107	0	73,000	0	0	0	0	0	0	73,000
2108	0	24,000	0	0	0	0	0	0	24,000
2109	0	0	0	0	0	0	6,000	0	6,000
2110	54,240	0	0	0	0	0	0	0	54,240
2111	48,000	0	0	0	0	0	0	0	48,000
2112	0	0	0	0	0	0	3,600	0	3,600
2113	0	0	0	0	0	0	30,000	0	30,000
2114	0	0	0	0	0	0	0	0	0
2115	0	0	0	0	72,000	0	0	0	72,000
2116	0	0	0	0	24,000	0	0	0	24,000
2117	0	0	6,000	0	48,000	0	7,200	0	61,200
2118	0	0	0	0	0	0	3,000	0	3,000
2119	0	0	0	0	18,000	0	3,600	0	21,600
2120	0	0	0	0	0	0	1,000	0	1,000
2121	0	0	0	0	0	0	1,000	29,200	30,200
2122	0	0	0	0	20,400	0	0	0	20,400
2129	0	0	0	0	0	0	500	0	500
2130	0	0	0	0	12,000	0	0	0	12,000
2131	0	0	0	0	0	0	0	0	0
2201	38,400	0	0	0	0	0	0	9,600	48,000
2202	20,000	0	0	0	0	0	0	0	20,000
2203	96,000	0	0	0	0	0	0	0	96,000
2204	108,000	0	0	0	0	0	0	0	108,000
2205	40,000	0	0	0	0	0	0	0	40,000
2206	40,000	0	0	0	0	0	0	0	40,000
2207	72,000	0	0	0	0	0	0	0	72,000
2208	60,000	0	0	0	0	0	0	0	60,000
2209	0	0	0	0	36,000	0	240,000	0	276,000
2211	0	0	0	0	0	0	0	48,000	48,000
2212	0	0	0	0	0	0	0	33,600	33,600
2213	72,000	0	0	0	0	0	0	0	72,000
2214	0	0	0	0	0	0	0	38,400	38,400
2215	180,000	0	0	0	0	18,000	0	0	198,000
2216	0	0	0	0	0	0	0	0	0
2217	184,800	0	0	0	0	0	0	0	184,800
2218	76,800	0	0	0	0	0	0	0	76,800
2219	0	0	0	0	0	0	0	48,000	48,000
2220	76,800	0	0	0	0	0	0	0	76,800
2222	0	0	0	0	0	0	24,000	0	24,000
2223	0	0	0	0	0	0	120,000	0	120,000
2224	150,000	0	0	0	0	0	180,000	0	330,000
2225	24,000	0	0	0	0	0	0	0	24,000
2226	19,800	0	0	0	0	0	0	0	19,800
2227	0	0	0	0	0	0	0	24,000	24,000
2228	38,400	24,000	0	0	0	0	0	0	62,400
2229	72,000	0	0	0	0	0	0	0	72,000
2230	0	0	0	0	0	0	0	0	0
2231	48,000	0	0	0	0	0	0	0	48,000
2232	13,440	0	0	0	0	0	0	0	13,440
2233	60,000	0	0	0	0	0	0	0	60,000
2234	72,000	0	0	0	0	0	0	0	72,000
2235	72,000	0	0	0	0	0	0	0	72,000
2236	60,000	0	0	0	0	0	0	0	60,000
2237	144,000	72,000	0	0	0	0	0	0	216,000
2238	60,000	0	0	0	0	0	0	0	60,000
2239	147,840	0	0	0	0	0	0	0	147,840
2240	168,000	0	0	0	0	0	0	0	168,000
2241	216,000	0	0	0	0	24,000	0	0	240,000
2242	72,000	0	0	0	0	0	0	0	72,000
2243	96,000	0	0	0	0	0	0	0	96,000
2244	150,000	0	0	0	0	0	36,000	0	186,000
2245	518,400	0	0	0	0	0	0	0	518,400
2246	518,400	0	0	0	0	0	0	0	518,400
2247	72,000	0	0	0	0	0	0	0	72,000
2248	99,528	0	0	0	0	0	0	0	99,528
2249	0	21,600	0	0	0	0	0	120,000	141,600
2250	96,000	0	0	0	0	0	0	0	96,000
2251	0	0	0	0	0	0	0	43,200	43,200
2252	19,200	0	0	0	0	0	0	0	19,200
2253	9,600	0	0	0	0	0	4,800	0	14,400
2254	96,000	72,000	0	0	0	0	0	0	168,000
2255	0	0	0	0	0	0	14,400	0	14,400
2256	0	0	0	0	0	0	0	0	0
2257	0	0	0	0	0	0	0	0	0
2258	0	0	0	0	0	0	0	72,000	72,000
2259	62,400	0	0	0	0	0	0	0	62,400
2301	30,000	0	0	0	0	0	0	0	30,000
2302	0	80,000	0	0	0	0	10,000	0	90,000
2303	0	0	0	0	0	0	1,800	0	1,800
2304	0	0	0	0	0	0	12,000	0	12,000
2305	0	0	0	0	0	0	0	0	0
2306	0	0	0	0	0	0	600	0	600
2307	0	3,000	0	0	0	0	0	0	3,000
2308	0	0	0	0	0	0	2,400	0	2,400
2309	0	0	0	0	0	0	2,000	0	2,000
2310	7,200	0	0	0	0	0	0	0	7,200
2311	18,800	4,800	0	0	0	0	6,000	0	29,600
2312	0	0	0	0	0	0	84,000	0	84,000
2313	0	0	0	0	0	0	0	0	0
2314	48,000	1,500	0	0	0	0	500	0	50,000
2315	4,400	0	0	0	0	0	0	0	4,400
2316	0	0	0	0	0	0	0	0	0
2317	28,800	0	0	0	0	0	0	0	28,800
2318	0	3,600	0	0	0	0	0	0	3,600
2319	7,800	500	0	0	0	0	0	0	8,300
2320	9,600	0	0	0	0	0	0	0	9,600
2321	0	0	0	0	0	0	0	700	700
2322	0	0	0	0	0	0	0	0	0
2323	10,000	500	0	0	0	0	2,500	0	13,000
2324	7,200	0	0	0	0	0	0	0	7,200
2325	0	0	0	0	0	0	0	0	0
2326	0	0	0	0	0	0	0	0	0
2327	0	0	0	0	0	0	10,950	0	10,950
2328	18,250	0	0	0	0	0	0	0	18,250
2329	88,000	0	0	0	0	0	0	0	88,000
2330	0	0	0	0	0	0	0	0	0
2331	0	0	0	0	0	0	0	200	200
2332	0	8,400	0	0	0	0	0	0	8,400
3101	0	0	0	0	0	0	0	0	0
3102	0	108,000	0	0	0	0	60,000	0	168,000
3103	0	9,600	0	0	0	0	0	0	9,600
3104	0	76,800	0	0	0	0	0	0	76,800
3105	0	0	0	0	60,000	0	0	0	60,000
3106	0	0	0	0	0	0	24,000	0	24,000
3107	0	0	0	0	0	0	108,000	0	108,000
3108	0	0	0	0	0	0	0	0	0
3109	0	33,600	0	0	0	0	0	0	33,600
3110	57,600	0	0	0	0	0	0	0	57,600
3111	9,000	73,000	0	0	0	0	3,000	0	85,000
3112	0	84,000	0	0	0	0	1,000	0	85,000
3113	0	0	0	0	0	0	0	0	0
3114	30,000	10,800	0	0	0	0	0	0	40,800
3116	0	0	0	0	0	0	0	0	0
3117	0	0	0	0	0	0	138,000	0	138,000
3119	0	0	0	0	0	0	0	0	0
3120	0	74,500	0	0	0	0	0	0	74,500
3121	0	54,000	0	0	96,000	0	0	0	150,000
3122	0	56,400	0	0	0	0	72,000	0	128,400
3123	0	18,250	0	0	0	0	0	0	18,250
3124	0	36,000	0	0	60,000	0	0	0	96,000
3125	0	0	0	0	60,000	0	24,000	0	84,000
3126	0	31,286	0	0	0	0	15,000	0	46,286
3127	0	22,300	0	0	0	0	84,000	0	106,300
3128	0	15,000	0	0	0	0	0	0	15,000
3129	124,800	0	0	0	0	0	0	208,000	332,800
3130	0	109,500	0	0	0	0	0	0	109,500
3131	0	0	0	0	0	0	24,000	0	24,000
3132	0	0	0	0	0	0	0	0	0
3133	62,000	0	0	0	0	0	0	0	62,000
3134	67,000	8,000	0	0	0	0	204,000	0	279,000
3201	96,000	0	0	0	0	0	0	0	96,000
3202	240,000	0	0	0	0	0	0	0	240,000
3203	48,000	0	0	0	0	0	0	0	48,000
3204	28,800	0	0	0	0	0	0	0	28,800
3205	14,400	0	0	0	0	0	0	0	14,400
3206	129,600	9,600	0	0	0	0	0	0	139,200
3207	0	0	0	0	0	0	0	0	0
3208	0	0	0	0	0	0	9,600	0	9,600
3209	0	0	0	0	0	0	0	0	0
3210	1,500	0	0	0	0	0	0	0	1,500
3211	0	0	0	0	0	0	0	0	0
3212	0	0	0	0	0	0	36,500	0	36,500
3213	86,400	0	0	0	0	0	0	0	86,400
3214	72,000	200	0	0	0	0	0	0	72,200
3215	240,000	0	0	0	0	0	0	0	240,000
3216	115,200	0	0	0	0	0	0	0	115,200
3217	48,000	0	0	0	0	0	0	0	48,000
3218	96,000	0	0	0	0	0	0	0	96,000
3219	72,000	24,000	0	0	0	0	0	0	96,000
3220	96,000	0	0	0	0	0	0	0	96,000
3221	0	0	0	0	0	0	0	0	0
3222	72,000	0	0	0	0	0	0	0	72,000
3223	48,000	0	0	0	0	0	0	0	48,000
3224	48,000	0	0	0	0	0	0	0	48,000
3225	48,000	0	0	0	0	0	0	0	48,000
3226	36,000	0	0	0	0	0	0	0	36,000
3227	120,000	48,000	0	0	0	0	0	0	168,000
3301	0	0	0	0	0	0	58,800	0	58,800
3302	12,600	0	0	0	0	0	84,000	0	96,600
3303	0	0	0	0	0	0	180,000	0	180,000
3304	80,000	0	0	0	0	0	192,000	0	272,000
3305	86,000	0	0	0	0	0	0	0	86,000
3306	0	24,000	144,000	0	0	0	276,000	0	444,000
3307	12,000	0	90,000	0	0	0	0	0	102,000
3308	10,000	0	0	0	0	0	0	0	10,000
3309	0	0	24,000	0	0	0	340,000	0	364,000
3310	25,000	0	0	0	0	0	0	0	25,000
3311	24,000	0	0	0	0	0	0	0	24,000
3313	40,000	0	24,000	0	0	0	300,000	0	364,000
3314	0	0	0	0	0	0	660,000	0	660,000
3315	97,400	0	0	0	0	0	40,000	0	137,400
3316	0	0	0	0	0	0	21,600	0	21,600
3317	0	0	0	0	110,000	0	0	0	110,000
3318	0	8,000	0	0	0	0	0	0	8,000
3319	0	8,000	0	0	0	0	0	0	8,000
3320	24,000	0	0	0	0	0	0	0	24,000
3321	84,000	0	0	0	0	0	0	0	84,000
3322	51,000	0	0	0	0	0	0	0	51,000
3323	0	0	0	0	0	0	50,000	0	50,000
4101	0	0	0	0	0	0	0	0	0
4102	0	0	0	0	0	0	0	0	0
4103	0	39,000	0	500	0	0	0	0	39,500
4104	0	0	0	0	0	0	0	0	0
4105	0	0	0	0	0	0	5,200	0	5,200
4106	18,000	600	0	0	30,000	0	0	0	48,600
4107	72,000	0	0	40	0	0	0	0	72,040
4108	0	54,000	0	0	0	0	0	0	54,000
4109	0	0	0	0	0	0	0	0	0
4110	0	0	0	0	0	0	0	0	0
4111	0	0	0	0	21,000	0	58,500	0	79,500
4112	41,520	0	0	0	0	0	0	0	41,520
4113	0	0	0	0	0	0	0	0	0
4114	0	84,000	0	0	0	0	0	0	84,000
4115	36,000	0	0	0	0	0	30,000	0	66,000
4116	64,000	48,000	0	0	0	0	0	0	112,000
4117	43,200	0	0	0	0	0	8,000	2,000	53,200
4118	20,160	0	0	0	0	0	0	0	20,160
4119	28,800	0	0	0	0	0	0	0	28,800
4120	0	0	0	0	0	0	30,000	0	30,000
4121	0	0	0	0	0	0	0	0	0
4122	0	13,200	0	0	0	0	0	0	13,200
4123	36,000	0	0	0	0	0	0	0	36,000
4124	10,500	0	0	0	0	0	0	0	10,500
4125	15,080	0	0	0	0	0	0	0	15,080
4126	0	0	0	0	0	0	0	0	0
4127	0	10,700	0	0	0	0	84,000	0	94,700
4128	0	25,200	0	0	22,800	0	0	0	48,000
4201	90,000	0	0	0	0	0	0	0	90,000
4202	30,000	0	0	0	0	0	0	0	30,000
4203	24,000	0	0	0	0	0	0	0	24,000
4204	90,000	0	0	0	0	0	0	0	90,000
4205	12,000	30,000	0	0	0	0	0	0	42,000
4206	3,000	0	0	0	0	0	0	0	3,000
4207	60,000	0	0	0	0	0	0	0	60,000
4208	96,000	0	0	0	0	0	0	0	96,000
4210	0	90,000	0	0	0	0	0	0	90,000
4211	60,000	0	0	0	0	0	0	0	60,000
4212	45,000	0	0	0	0	0	0	0	45,000
4213	96,000	0	0	0	0	0	0	0	96,000
4214	0	0	0	0	0	0	0	0	0
4215	0	1,400	0	0	0	0	3,600	0	5,000
4216	0	0	0	0	0	0	96,000	0	96,000
4217	24,000	0	0	0	0	0	0	0	24,000
4218	36,000	0	0	0	0	0	0	0	36,000
4219	43,200	0	0	0	24,000	0	0	0	67,200
4220	0	0	0	0	0	0	0	0	0
4221	90,000	0	0	0	0	0	0	0	90,000
4222	7,200	0	0	0	0	0	0	0	7,200
4223	48,000	0	0	0	0	0	0	0	48,000
4224	72,000	38,400	0	0	0	0	0	0	110,400
4225	72,000	0	0	0	0	0	0	0	72,000
4226	0	0	0	0	0	0	0	0	0
4227	83,000	0	0	0	0	0	0	0	83,000
4228	96,000	0	0	0	0	0	0	0	96,000
4229	0	0	0	0	0	0	2,688	0	2,688
4230	0	0	36,000	0	0	0	0	0	36,000
4302	0	0	0	0	0	0	960	0	960
4303	12,000	0	0	0	0	0	0	0	12,000
4304	0	0	0	0	0	0	0	0	0
4305	62,400	0	0	0	0	0	0	0	62,400
4306	0	0	0	0	0	0	0	0	0
4307	0	0	0	0	0	0	0	0	0
4308	0	0	0	0	0	0	1,920	0	1,920
4309	0	0	0	0	0	0	0	0	0
4310	67,200	0	0	0	0	0	0	0	67,200
4311	0	0	0	0	0	0	7,200	0	7,200