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 2
10 q62_size/q55_tot > 1 land size of Crop N.2 must be less than or equal to the total size value 3
11 q63_size/q55_tot > 1 land size of Crop N.3 must be less than or equal to the total size value 2
12 q141_qp/q61_size crop 1 quantity produced by size unit outlier 20
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 14
15 q141_qs > q141_qp crop 1 quantity sold must be less than or equal to the quantity produced value 0
16 q142_qs > q142_qp crop 2 quantity sold must be less than or equal to the quantity produced value 1
17 q143_qs > q143_qp crop 3 quantity sold must be less than or equal to the quantity produced value 4
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 3
20 q143_qs>0 & q143_price==0 crop 3 there must be a price for sold quantities value 3
21 q141_price crop 1 price outlier 7
22 q142_price crop 2 price outlier 4
23 q143_price crop 3 price outlier 4
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 2
28 q221 farmer age outlier 0
29 q224+q225+q226 total household members outlier 3
30 q261 Number of household members who emigrated outlier 1
31 q28 Number of people outside the household employed in the farm outlier 10

Number of participant_id involved by check type:

check.type n
outlier 81
value 20

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 q61_size q55_tot q61_size/q55_tot
1 0 510 Maize 5.00 3.00 1.67
2 0 47 Maize 0.83 0.50 1.66

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

failed checks

prog session_number participant_id q62 q62_size q55_tot q62_size/q55_tot
1 0 147 Beans 1.50 1.00 1.50
2 0 145 Beans 1.50 1.00 1.50
3 0 47 Beans 0.83 0.50 1.66

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

failed checks

prog session_number participant_id q63 q63_size q55_tot q63_size/q55_tot
1 0 403 Beans 1.25 1.00 1.25
2 0 47 Pegion Peas 0.83 0.50 1.66

crop 1 quantity produced by size unit

possible outliers

prog session_number participant_id q141_qp/q61_size q141 q141_qp q61_size
1 0 28 11520.00 Kales 2880.00 0.25
2 0 281 9000.00 Green Grams 4500.00 0.50
3 0 401 9000.00 Maize 9000.00 1.00
4 0 147 9000.00 Maize 2700.00 0.30
5 0 148 9000.00 Maize 9000.00 1.00
6 0 26 9000.00 Maize 2700.00 0.30
7 0 146 9000.00 Maize 9000.00 1.00
8 0 357 7500.00 Maize 4500.00 0.60
9 0 149 4500.00 Maize 2700.00 0.60
10 0 25 4500.00 Maize 9000.00 2.00
11 0 61 3600.00 Maize 1800.00 0.50
12 0 111 3600.00 Maize 1800.00 0.50
13 0 252 3000.00 Maize 1500.00 0.50
14 0 264 3000.00 Maize 1500.00 0.50
15 0 224 2666.67 Maize 4000.00 1.50
16 0 402 2400.00 Maize 1200.00 0.50
17 0 316 2100.00 Maize 2100.00 1.00
18 0 145 2100.00 Maize 630.00 0.30
19 0 381 2000.00 Maize 3000.00 1.50
20 0 258 540.00 Pegion Peas 270.00 0.50

crop 2 quantity produced by size unit

possible outliers

prog session_number participant_id q142_qp/q62_size q142 q142_qp q62_size
1 0 146 5625.00 Beans 4500.00 0.80
2 0 56 4800.00 Mangoes 1200.00 0.25
3 0 28 4320.00 Tomatoes 540.00 0.12
4 0 381 2000.00 Beans 1000.00 0.50
5 0 441 2000.00 Beans 1000.00 0.50
6 0 238 1600.00 Beans 800.00 0.50
7 0 439 1400.00 Beans 700.00 0.50
8 0 291 1200.00 Green Grams 600.00 0.50
9 0 224 1200.00 Beans 600.00 0.50
10 0 402 1080.00 Pegion Peas 270.00 0.25
11 0 362 900.00 Beans 90.00 0.10
12 0 451 900.00 Beans 90.00 0.10
13 0 111 900.00 Beans 225.00 0.25
14 0 196 750.00 Beans 225.00 0.30
15 0 517 720.00 Pegion Peas 180.00 0.25
16 0 55 720.00 Green Grams 180.00 0.25
17 0 279 720.00 Pegion Peas 180.00 0.25
18 0 292 540.00 Pegion Peas 270.00 0.50

crop 3 quantity produced by size unit

possible outliers

prog session_number participant_id q143_qp/q63_size q143 q143_qp q63_size
1 0 504 21000.00 Mangoes 10500.00 0.50
2 0 509 10000.00 Mangoes 10000.00 1.00
3 0 358 5400.00 Beans 2700.00 0.50
4 0 153 3600.00 Maize 1800.00 0.50
5 0 381 2000.00 Pegion Peas 1000.00 0.50
6 0 408 1440.00 Green Grams 360.00 0.25
7 0 104 1200.00 Green Grams 360.00 0.30
8 0 65 1000.00 Pegion Peas 200.00 0.20
9 0 238 1000.00 Pegion Peas 500.00 0.50
10 0 24 1000.00 Vegetables 500.00 0.50
11 0 39 900.00 Pegion Peas 90.00 0.10
12 0 439 800.00 Pegion Peas 400.00 0.50
13 0 415 700.00 Green Grams 350.00 0.50
14 0 449 560.00 Cow Peas 280.00 0.50

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 0 374 60.00 0.00 Beans 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 0 269 10.00 9.00 Green Grams FALSE
2 0 213 20.00 0.00 Pegion Peas FALSE
3 0 367 20.00 0.00 Sorghum FALSE
4 0 377 60.00 0.00 Green Grams FALSE

crop 2 there must be a price for sold quantities

failed checks

prog session_number participant_id q142 q142_qp q142_qs q142_price q142_qs>0 & q142_price==0
1 0 374 Beans 0.00 60.00 0.00 TRUE
2 0 431 Beans 150.00 150.00 0.00 TRUE
3 0 541 Beans 4.00 4.00 0.00 TRUE

crop 3 there must be a price for sold quantities

failed checks

prog session_number participant_id q143 q143_qp q143_qs q143_price q143_qs>0 & q143_price==0
1 0 213 Pegion Peas 0.00 20.00 0.00 TRUE
2 0 367 Sorghum 0.00 20.00 0.00 TRUE
3 0 377 Green Grams 0.00 60.00 0.00 TRUE

crop 1 price

possible outliers

prog session_number participant_id q141 q141_price
1 0 484 Maize 7500.00
2 0 94 Maize 6750.00
3 0 97 Maize 5400.00
4 0 100 Maize 4500.00
5 0 479 Maize 2250.00
6 0 303 Maize 2200.00
7 0 464 Maize 1350.00

crop 2 price

possible outliers

prog session_number participant_id q142 q142_price
1 0 328 Pegion Peas 70.00
2 0 476 Pegion Peas 60.00
3 0 402 Pegion Peas 60.00
4 0 268 Pegion Peas 40.00

crop 3 price

possible outliers

prog session_number participant_id q143 q143_price
1 0 94 Green Grams 3000.00
2 0 138 Cow Peas 80.00
3 0 487 Cow Peas 30.00
4 0 294 Cow Peas 20.00

household members aged 14 or older involved in the farm must be less than or equal to the adults 14 or older

failed checks

prog session_number participant_id q27 q224 q27/q224
1 0 106 3.00 2.00 1.50
2 0 173 2.00 1.00 2.00

total household members

possible outliers

prog session_number participant_id q224+q225+q226 q224 q225 q226
1 0 268 20.00 15.00 3.00 2.00
2 0 43 18.00 10.00 6.00 2.00
3 0 71 18.00 9.00 7.00 2.00

Number of household members who emigrated

possible outliers

prog session_number participant_id q261
1 0 268 18.00

Number of people outside the household employed in the farm

possible outliers

prog session_number participant_id q28 q27 q55_tot q61
1 0 434 30.00 2.00 24.00 Maize
2 0 44 20.00 3.00 2.00 Maize
3 0 121 18.00 2.00 16.00 Maize
4 0 395 11.00 1.00 6.00 Maize
5 0 94 10.00 1.00 2.00 Maize
6 0 175 10.00 2.00 5.00 Maize
7 0 279 10.00 3.00 2.00 Maize
8 0 224 10.00 3.00 4.00 Maize
9 0 265 10.00 2.00 6.00 Maize
10 0 433 10.00 3.00 6.00 Maize

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