Checks summary

Applied checks and number of participant_id involved by check:

ord check descr check.type n.err
8 round((q51_size+q52_size+q53_size+q54_size)/q55_tot,2) > 1 The sum of the sizes for the Tenure status must be less than or equal to the total size value 0
9 q61_size/q55_tot > 1 land size of Crop N.1 must be less than or equal to the total size value 3
10 q62_size/q55_tot > 1 land size of Crop N.2 must be less than or equal to the total size value 0
11 q63_size/q55_tot > 1 land size of Crop N.3 must be less than or equal to the total size value 1
12 q141_qp/q61_size crop 1 quantity produced by size unit outlier 12
13 q142_qp/q62_size crop 2 quantity produced by size unit outlier 18
14 q143_qp/q63_size crop 3 quantity produced by size unit outlier 9
15 q141_qs > q141_qp crop 1 quantity sold must be less than or equal to the quantity produced value 3
16 q142_qs > q142_qp crop 2 quantity sold must be less than or equal to the quantity produced value 2
17 q143_qs > q143_qp crop 3 quantity sold must be less than or equal to the quantity produced value 1
18 q141_qs>0 & q141_price==0 crop 1 there must be a price for sold quantities value 0
19 q142_qs>0 & q142_price==0 crop 2 there must be a price for sold quantities value 0
20 q143_qs>0 & q143_price==0 crop 3 there must be a price for sold quantities value 0
21 q141_price crop 1 price outlier 15
22 q142_price crop 2 price outlier 17
23 q143_price crop 3 price outlier 7
27 q27/q224 > 1 household members aged 14 or older involved in the farm must be less than or equal to the adults 14 or older value 0
28 q221 farmer age outlier 0
29 q224+q225+q226 total household members outlier 3
30 q261 Number of household members who emigrated outlier 8
31 q28 Number of people outside the household employed in the farm outlier 8

Number of participant_id involved by check type:

check.type n
outlier 97
value 10

For checks on a value, the cases that do not satisfy the check are reported;
for outlier checks, cases that exceed 3x IQR are reported as potential outliers.

Finally, there are tables of categorical variables with missing cases.

Checks

land size of Crop N.1 must be less than or equal to the total size

failed checks

prog session_number participant_id q61_size q55_tot q61_size/q55_tot
1 3 641 5.50 5.00 1.10
2 2 524 3.00 1.00 3.00
3 2 489 0.01 0.01 1.27

land size of Crop N.3 must be less than or equal to the total size

failed checks

prog session_number participant_id q63_size q55_tot q63_size/q55_tot
1 1 450 7.50 3.00 2.50

crop 1 quantity produced by size unit

possible outliers

prog session_number participant_id q141_qp/q61_size q141 q141_qp q61_size
1 2 489 28571.43 eggplant 400.00 0.01
2 3 653 16250.00 maize 65000.00 4.00
3 2 577 15000.00 maize 600000.00 40.00
4 1 428 15000.00 maize 15000.00 1.00
5 2 533 12920.00 matooke 12920.00 1.00
6 4 711 6666.67 coffee 10000.00 1.50
7 2 546 4117.65 maize 70000.00 17.00
8 6 790 4000.00 rice 4000.00 1.00
9 2 570 3125.00 maize 6250.00 2.00
10 3 666 3000.00 bean 3000.00 1.00
11 2 476 2200.00 coffee 2200.00 1.00
12 3 477 2086.96 coffee 240.00 0.12

crop 2 quantity produced by size unit

possible outliers

prog session_number participant_id q142_qp/q62_size q142 q142_qp q62_size
1 2 489 320000.00 aubergine 1600.00 0.00
2 1 479 57600.00 tomato 14400.00 0.25
3 1 401 42857.14 bean 300.00 0.01
4 3 500 24000.00 maize 600.00 0.03
5 3 477 23188.41 sweet potato 1600.00 0.07
6 6 771 19000.00 matooke 19000.00 1.00
7 6 768 15288.00 matooke 7644.00 0.50
8 3 616 7000.00 coffee 7000.00 1.00
9 1 486 6000.00 maize 1500.00 0.25
10 5 722 6000.00 bean 6000.00 1.00
11 1 420 5000.00 bean 2500.00 0.50
12 1 437 3000.00 bean 1500.00 0.50
13 4 681 3000.00 coffee 3000.00 1.00
14 2 546 2400.00 bean 24000.00 10.00
15 4 692 2400.00 bean 600.00 0.25
16 3 618 2000.00 bean 1000.00 0.50
17 2 574 1600.00 nakati 200.00 0.12
18 1 425 720.00 bbuga 180.00 0.25

crop 3 quantity produced by size unit

possible outliers

prog session_number participant_id q143_qp/q63_size q143 q143_qp q63_size
1 3 477 60869.57 matooke 2800.00 0.05
2 1 437 30720.00 eggplant 15360.00 0.50
3 4 692 30000.00 maize 7500.00 0.25
4 3 612 19200.00 eggplant 9600.00 0.50
5 1 401 14000.00 soybean 28.00 0.00
6 3 557 6521.74 cassava 150.00 0.02
7 3 595 6000.00 cassava 1500.00 0.25
8 3 502 2000.00 bean 2000.00 1.00
9 1 417 2000.00 bean 500.00 0.25

crop 1 quantity sold must be less than or equal to the quantity produced

failed checks

prog session_number participant_id q141_qs q141_qp q141 q141_qs <= q141_qp
1 1 461 640.00 560.00 aubergine FALSE
2 1 468 5400.00 4500.00 tomato FALSE
3 4 690 800.00 320.00 sweet potato FALSE

crop 2 quantity sold must be less than or equal to the quantity produced

failed checks

prog session_number participant_id q142_qs q142_qp q142 q142_qs <= q142_qp
1 2 473 1800.00 800.00 coffee FALSE
2 1 423 4800.00 690.00 sweet potato FALSE

crop 3 quantity sold must be less than or equal to the quantity produced

failed checks

prog session_number participant_id q143_qs q143_qp q143 q143_qs <= q143_qp
1 3 485 560.00 400.00 eggplant FALSE

crop 1 price

possible outliers

prog session_number participant_id q141 q141_price
1 5 728 matooke 6500.00
2 5 732 sweet potato 5000.00
3 6 778 matooke 5000.00
4 4 694 coffee 4500.00
5 3 633 coffee 3000.00
6 1 404 coffee 3000.00
7 3 627 coffee 2700.00
8 4 701 cabbage 2273.00
9 1 435 green pepper 2143.00
10 2 535 aubergine 1875.00
11 1 403 aubergine 1875.00
12 1 423 eggplant 1875.00
13 2 524 maize 1200.00
14 2 549 coffee 800.00
15 1 411 coffee 700.00

crop 2 price

possible outliers

prog session_number participant_id q142 q142_price
1 4 684 coffee 4000.00
2 1 450 coffee 3000.00
3 1 417 coffee 3000.00
4 1 441 coffee 2800.00
5 3 508 maize 1300.00
6 2 495 aubergine 1125.00
7 2 556 maize 800.00
8 2 506 coffee 700.00
9 3 657 maize 300.00
10 3 649 maize 300.00
11 2 533 maize 300.00
12 2 498 maize 300.00
13 2 503 maize 300.00
14 1 432 maize 300.00
15 5 727 maize 300.00
16 6 798 maize 300.00
17 5 760 maize 100.00

crop 3 price

possible outliers

prog session_number participant_id q143 q143_price
1 5 765 matooke 5000.00
2 4 685 coffee 3800.00
3 4 690 coffee 3300.00
4 5 746 cabbage 1818.00
5 4 713 maize 1800.00
6 1 432 nakati 1667.00
7 6 793 maize 1200.00

total household members

possible outliers

prog session_number participant_id q224+q225+q226 q224 q225 q226
1 5 746 29.00 19.00 7.00 3.00
2 3 502 25.00 9.00 13.00 3.00
3 1 448 24.00 16.00 5.00 3.00

Number of household members who emigrated

possible outliers

prog session_number participant_id q261
1 3 658 8.00
2 2 533 7.00
3 1 402 6.00
4 1 443 6.00
5 2 523 6.00
6 5 766 6.00
7 6 789 6.00
8 5 765 5.00

Number of people outside the household employed in the farm

possible outliers

prog session_number participant_id q28 q27 q55_tot q61
1 2 577 23.00 2.00 47.00 maize
2 2 544 20.00 2.00 100.00 rice
3 2 546 15.00 2.00 30.00 maize
4 3 591 11.00 3.00 20.00 green pepper
5 3 653 10.00 1.00 5.00 maize
6 1 465 10.00 1.00 2.00 eggplant
7 1 470 10.00 3.00 12.00 tomato
8 2 507 10.00 3.00 5.00 tomato

Missing values

q171_l_ph Losses of Crop N.1 – post-harvest n %
1 1=Not at all important 183 37.97
2 2=Slightly important 178 36.93
3 3=Somewhat important 90 18.67
4 4=moderately important 21 4.36
5 5=Extremely important 9 1.87
1 0.21
Total - 482 100.00
q3211 Other n %
1 1=Not at all important 1 0.21
2 2=Slightly important 2 0.41
4 4=moderately important 2 0.41
5 5=Extremely important 3 0.62
474 98.34
Total - 482 100.00
q3311 Specify the category Other, if reported n %
3 3=Somewhat important 1 0.21
4 4=moderately important 2 0.41
5 5=Extremely important 2 0.41
477 98.96
Total - 482 100.00