Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, this is the excel data in the table below. The question is below the table. Thank you! KwaZulu-Natal Income Dynamics Study (KIDS) Total households=560

image text in transcribed

Hello, this is the excel data in the table below. The question is below the table. Thank you!

KwaZulu-Natal Income Dynamics Study (KIDS)
Total households=560Income for year 1993Income for year 2004
Z= 375 Rand403.3708801715.9863892
804.444397215.6878815
699.8947754834.3627319
516.4165039617.0653687
231.73120121045.05603
225.1553497332.8474731
331.370636807.541626
466.26638791024.537048
1233.2897953036.851318
4832.51269512594.35742
2584.0334472726.50415
1946.1464842472.79541
983.75616462870.185547
1458.3918462057.693848
1018.3134166706.968262
1794.8968512023.762207
608.7307739793.3864136
2737.3513184338.129395
717.92340092595.745361
501.12803961202.480762
1970.3298342473.84082
1007.7849122424.072998
1106.7313232563.873779
1328.1950681919.459351
1308.8692632919.35498
1083.6405032087.920166
490.5142822984.4877319
2036.3314217856.218262
540.8159791507.474121
1327.8061653175.19502
508.594635691.8740845
1178.7862554195.709961
480.07852171232.654785
543.00781251024.678955
491.32556151323.893921
821.28289791674.214355
1303.715821296.521606
1598.2335212992.159424
742.22015381537.617065
360.16425781366.411328
843.8751221484.4390869
587.04217531423.369507
1196.0114751219.986084
560.10986334661.496582
456.8345032430.5539856
458.32873541234.248047
619.3710327726.1689453
295.7696533749.3662109
403.8401489927.2747192
190.1690063205.6964722
340.9747009181.664093
227.8948669249.2902222
415.65789791291.089478
310.8838806745.2025146
368.0180969342.6249084
435.3716736713.0124512
112.9266891282.6669006
248.1908875629.9457397
191.2565765471.5817871
85.70563965280.3321045
261.0491333408.0547791
180.7667847346.8024902
117.8045883595.6344604
181.1347961397.8823547
385.38174442279.977295
5377.5083012656.61377
1144.5007321034.092285
1252.331665993.0718384
591.53033451394.160278
1319.4725593399.517969
118.4703369146.1097107
120.6782303900.8846436
807.49975591219.472046
964.72497561732.350342
884.53356932092.327148
294.1766663422.9545288
121.1902847340.3692322
149.9099579814.6223755
312.4038696225.9904785
56.30753784114.7047852
287.25128171384.605591
187.1914368587.0516968
266.632019415.0280762
99.04311371588.1035767
152.6906433345.5647888
286.9953308382.1789856
609.1298828467.9883118
105.1644669291.0764465
198.4193573296.0665283
230.1946121667.9582764
116.7385254260.6979828
614.8477783367.0401611
119.320793245.69946289
65.2967262397.26255035
30.115837179.48334503
51.00203705110.3693695
39.47735977628.6992188
182.8366699160.7923737
22.1242389789.13731384
98.1558898938.53040161
74.32161713133.2900391
652.1238403684.9014282
472.549469101.0367813
983.1565552643.0280151
767.65093991144.095947
869.2270508612.4308472
209.1896362403.2528687
615.5823975978.8856201
723.21582031209.736328
851.37779541131.457324
114.8647232918.5106201
319.7865906806.5625
444.7249451747.4790039
475.97348022158.993164
680.4852905645.8693237
217.6221161430.5996399
102.6989212247.2526093
329.0351563192.9485779
354.3807068336.0322876
222.2694092260.7091064
404.6320191093.66394
206.1496582164.8638306
204.8265991221.314682
498.7068176464.5680847
612.4425049844.9262085
607.8600464606.868042
747.6694946661.9274292
432.0348511428.5056763
287.3779907164.2263489
494.8545837357.4176636
1009.18103250.1750031
356.8578796380.9688721
251.5420074373.946106
436.3839722458.2060852
339.37979132168.025391
1100.933594387.2657776
666.6749878359.3865662
333.6410828204.5197601
395.2870483887.6420288
595.2384521321.9875977
342.169342759.3844604
315.6079102531.1033936
124.8723907317.6392822
442.7409058151.7843475
794.9343872943.1988525
282.9705505436.9239807
458.8659363247.3714905
1697.129395609.6630249
596.5373535142.0951691
301.0275238548.3119629
545.98626711029.997437
654.10638431637.622314
423.1581116565.2261963
422.1424255141.6790771
1174.771484175.5641174
1229.437256809.6599731
1555.11377105.0011826
307.73162841044.557129
358.2235413133.8527451
345.8463074405.2656494
380.2032471214.8479919
657.0094604707.5661011
351.0921936124.8993149
193.377243312.5283203
252.1277313398.4075623
342.1760864152.1724243
341.3247681360.1314087
385.38906864362.875
199.277847388.33179474
292.0777557509.5972412
423.0661926310.2303772
149.4207001312.3649597
208.6797943512.3132629
164.9106141076.764038
204.7795715173.5731964
261.8491211339.8937683
148.5779572272.698822
489.91470341740.333252
567.3181763904.788208
43.84972839833.9572266
539.6296997664.3486328
230.4329834149.3354034
541.197998991.8790894
526.3990479358.5476379
365.224823265.508667
712.37127691508.7854
619.9460449496.7266235
402.303772492.6075134
696.7167358776.1906128
191.7804123380.8163086
160.2720032500.594635
271.3208313134.8633728
390.5955505269.0678101
1914.388184995.8806763
326.4606934184.1420746
411.5157166388.1419678
517.708374866.1711426
212.13591141.2060089
439.7967529282.8490906
5.12961731520.7818848
634.1730347319.6663513
425.0147705998.0904541
608.3234253299.7333374
275.943237390.66553497
578.8220825876.4171143
441.7025452274.1003113
190.008575496.70588684
151.4430237103.4247818
577.9108276345.3799438
322.6404694399.1936157
300.5937805287.7052612
594.0722046724.3147583
611.8637695860.3525391
763.5594482524.7663574
516.69873054741.93457
899.4077148694.9903564
381.7778015664.6712036
188.8454132113.4939423
441.7728271269.5730286
134.6310791362.8814453
269.3305359221.288559
741.2200928128.5245132
172.0688934108.7144089
200.6873169630.4369507
205.4258881119.8901062
556.461731233.0840149
434.949585308.3138733
252.3407288244.6372223
293.8835144287.2416077
748.4531982897.3058594
249.0864105239.4784241
479.0057983168.2596436
184.4542542264.6898193
551.272399969.36869049
512.4747925268.1540222
676.7189941144.9622498
415.3724976234.9329224
191.9753113161.368576
330.0542603230.9176636
242.311853175.1474854
259.649551434.59810829
513.7927856715.3001709
202.6398773213.8705292
80.62261963203.7421722
246.7871399349.4151001
386.1786194260.8837585
115.0824738114.9921417
306.856933635.58071709
121.0572128383.1462097
374.9125244634.5779297
611.587524469.97369766
405.7728882608.161499
107.367103686.16501617
235.3053894139.8132477
408.3165588678.6401367
221.1204071262.2900696
557.6663818374.5154724
194.9592438204.8157043
181.4318237379.9564209
412.9305768148.5406323
288.857482977.43386078
451.689209598.3134155
229.162262394.3475952
240.6298065980.5223389
275.9189758463.056488
275.4275818382.6570435
546.5731201848.9104004
378.316711446.89273071
782.5639648146.0392303
137.9632538248.4950867
297.1100159267.8993225
217.0333252486.2674561
175.891647379.85928345
116.2591858235.2574768
213.5723419218.9876404
275.1517334217.8837585
290.5314026352.8702698
591.6176758153.563446
401.6408386627.6160278
500.2940332528.573623
290.4154053177.7420959
221.980651991.2195282
226.5676575285.2752991
226.5776978472.3492432
225.4170227331.6888123
173.1595154159.4766846
181.9729462197.6328583
92.45822906122.4551544
300.410553250.0238342
207.9086282138.0273065
221.9442444408.1757202
407.9786987124.8087006
377.8522034352.3382874
356.7196655220.7648163
111.822685298.43664551
118.1936646146.971817
165.8091278652.6621094
346.5770874291.2626343
555.7682495386.0322571
401.1751184476.6974023
161.0384827569.7892456
513.3996582152.6158142
391.0965881140.7101593
156.1081543154.3838654
408.5720215422.2365417
408.12426761073.299561
533.4953003506.6539001
157.4219208188.5783081
149.66326937.54120445
348.2869611304.9281262
357.7678223117.9671936
336.3917847121.3573685
183.0175476271.3470459
146.427124186.0671082
109.4635773101.8305969
118.6497879140.2688141
359.4475708240.4485626
299.9135742278.0853271
525.9320679240.1897125
362.9223743365.8107715
263.6926575222.3236084
140.9104004148.3925018
231.335022374.1114502
248.8043518166.2096405
221.9273682361.2745667
504.5979614368.0048828
188.133514448.11222458
376.095459324.7229919
403.8060913186.8334198
223.946969177.00549652
182.111282390.32692719
340.2562256134.103363
163.8368073338.8321228
399.0598145134.1121368
411.31445311232.861694
541.1116333642.4136963
179.5555878461.2835999
325.382598999.1223526
193.7664032103.6125031
143.7356476119.7305908
166.5474243107.083931
130.9773178209.7900696
168.787765563.24865723
203.298965584.23747253
372.4031677264.8235168
332.6835938515.139801
394.6157227173.8612671
167.6098022123.0085831
160.0274353106.5584488
226.9767709296.7186182
405.26297469.1714172
336.3027344271.9050293
267.0365906193.4945679
230.8344269788.3745728
507.3076782617.0064697
532.434082225.4246674
585.90625479.2232971
315.6025085164.3250732
361.31427125.9643631
122.234097139.0406445
294.7399292358.1091309
232.3974915156.2430878
632.866333263.3866577
310.043457200.8682098
181.189743141.5493469
311.88265991209.046387
531.6608887232.590744
202.4338531383.0188904
410.8908081347.3432007
389.8522382260.6867505
479.5638123684.4776001
131.8331757159.7225494
254.5279236235.397583
388.044281198.7699738
435.9927063207.8289642
157.53160187.87085724
163.791976990.54111481
258.593277202.7414856
225.254425234.3412781
26.8006967262.47665344
228.9512177207.4194794
180.0050049506.5094299
123.1982727210.2055206
146.00691221701.458618
207.3385162152.5903931
608.4007568881.6647339
201.0564423154.3921814
354.3800964924.7540283
278.4292603119.4015579
204.8623956190.6392023
586.5131836286.6081543
210.636673321.4647827
318.9493408653.975647
805.9042358290.7011414
1452.8226321033.842407
148.6360931186.3420715
289.9957886301.9502258
187.425216797.04460144
338.4916077346.3917236
187.2293939152.3355005
293.6735535453.9403076
201.5005646387.5801697
661.4012451210.6724243
184.0950317408.0892029
142.1785889433.4039612
143.1852722131.0583801
158.4340668304.5980225
150.6703949235.6257477
197.0519104118.6409607
266.3595859222.0979541
262.3035278317.0782776
201.1643982256.5209656
340.467498889.24210358
229.6934052199.8141632
219.0622101545.814209
236.7763214678.8595581
155.5774994356.3771667
126.5567093397.9273376
251.974212635.58543587
358.315047280.6674609
287.7319031851.2846069
270.8837891171.7625885
107.545661991.55374146
186.98921276.56539917
270.0793457143.3257446
394.647522165.7210541
445.31604218.5929413
157.5261078165.7900696
494.3066101288.6860962
206.7768146147.2381396
196.3929291202.1020203
174.456512599.89629364
508.875833.9091797
352.534576490.6911087
153.6063232114.7561188
270.303527879.5839386
499.0735779186.7456207
163.5047302213.7232361
397.8845825130.3740921
437.9197821142.9413794
240.0498962183.0045776
202.0409851215.3991547
247.534256290.3923645
125.19944279.5981445
219.6328125234.3615875
207.0465851507.9136963
167.22845461731.368164
585.2888184352.9523315
99.73423767125.8152084
280.5382445132.0844473
459.1369019116.2446518
260.754394571.18418884
335.9640198117.4328156
126.4320526206.9159698
224.8905945381.8894348
154.1324158525.0116577
123.3684387193.104126
373.6835327677.0923462
195.8843384275.5907898
457.1301782894.7215723
313.4390869102.4147491
304.69830321039.866089
156.253067269.6455383
375.5664978644.1860352
475.0075378898.3294678
627.06115721394.255859
364.21377561611.350586
357.1221313205.5488586
231.6773071253.1460114
361.7028745326.6455426
266.0938721152.4271088
263.8083801540.6832886
577.2548828401.6556702
736.062744184.37587738
765.812561229.6665344
168.8521423545.8570557
426.9398193804.2293091
187.484558183.54940796
125.724914659.08794022
142.7919992209.6528345
210.4658661393.6232605
220.181381290.89794922
371.3907166102.7934723
105.3962402198.2472229
338.1403503132.4978485
361.1324158198.3512268
184.8260956222.4111023
305.21090778.94225311
164.1805115194.842804
430.3241846314.2476892
375.9417725339.2164917
1621.9519041432.296631
95.10002899292.2854614
260.9871521312.419281
174.9881744133.3677979
323.2468872290.9458923
567.9307251514.8549805
106.7583237106.9786911
240.8939972399.4844971
361.3460529643.2976367
484.0450562859.183667
965.3332764258.8254578
839.87373051001.235278
619.6998047740.4784424
278.07744141254.067236
270.1864197399.4169678
397.6447632969.0499512
559.51966551229.444458
1479.9477543644.221582
5799.01523415113.22891
3100.8401373271.80498
2335.3757812967.354492
1180.5073973444.222656
1750.0702152469.232617
1221.9760998048.361914
2153.8762212428.514648
730.4769287952.0636963
3284.8215825205.755273
861.50808113114.894434
601.35364751442.976914
2364.3958012968.608984
1209.3418952908.887598
1328.0775883076.648535
1593.8340822303.351221
1570.6431153503.225977
1300.3686042505.504199
588.61713871181.385278
2443.5977059427.461914
648.97917481808.968945
1593.3673973810.234023
610.313562830.2489014
943.02900393356.567969
384.0628174986.1238281
434.40625819.7431641
393.06044921059.115137
657.02631841339.371484
1042.9726561037.217285
1278.5868162393.727539
593.7761231230.093652
288.13140631093.129063
675.1000977387.5512695
469.63374021138.695605
956.8091797975.9888672
448.08789063729.197266
365.4676025344.4431885
366.6629883987.3984375
495.4968262580.9351563
236.6157227599.4929688
323.0721191741.8197754
152.1352051164.5571777
272.7797607145.3312744
182.3158936199.4321777
332.52631841032.871582
248.7071045596.1620117
294.4144775274.0999268
348.2973389570.4099609
90.34135132226.1335205
198.55271503.9565918
153.0052612377.2654297
68.56451172224.2656836

image text in transcribed
The KwaZulu-Natal province is located on the Indian Ocean coast of South Africa and is home to approximately 20% of South Africa's population. The KwaZuluNatal Income Dynamics Study (KIDS) is the same data set used by Carter and May in the article \"One Kind of Freedom.\" While they used the 1993 and 1998 data, another round was added in 2004. This problem set asks you to use this updated KIDS data set to explore measures of poverty and income distribution in the rst 10 years of the post-apartheid period. The excel spreadsheet KIDS Data.xls contains the KIDS data. Use the worksheet \"KIDS data,\" which contains columns representing monthly percapita income (in Rand, the South African currency) for each KIDS household for the years 1993 and 2004. These income figures have been adjusted to the year 2000 South African price level. The data set includes information on 560 households that provided complete information in 1993 and 2004. Report your answers using two decimal points. Exception: Reportyozn' F GT -2 using THREE decinm/ points. 1. Poverty Measures The national poverty line in South Africa in terms of monthly per-capita income is Z=375 Rand.l Calculate and report in Table 2 the various poverty indices for 1993 and 2004: Table 1: Poverty Measures 1993 2004 Poverty H eadcount Index Poverty Gap Index FGT2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microeconomics Principles, Problems and Policies

Authors: Campbell R. McConnell, Stanley L. Brue, Sean Masaki Flynn

20th edition

978-0077660819, 77660811, 978-1259450242

More Books

Students also viewed these Economics questions