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 0
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 0
12 q141_qp/q61_size crop 1 quantity produced by size unit outlier 18
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 20
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 0
17 q143_qs > q143_qp crop 3 quantity sold must be less than or equal to the quantity produced value 0
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 0
22 q142_price crop 2 price outlier 0
23 q143_price crop 3 price outlier 0
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 163
28 q221 farmer age outlier 0
29 q224+q225+q226 total household members outlier 2
30 q261 Number of household members who emigrated outlier 13
31 q28 Number of people outside the household employed in the farm outlier 30

Number of participant_id involved by check type:

check.type n
outlier 101
value 163

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

crop 1 quantity produced by size unit

possible outliers

prog session_number participant_id q141_qp/q61_size q141 q141_qp q61_size
1 210 203 Inf    onion 50.00 0.00
2 131 124 320000.00 olive 80000.00 0.25
3 442 437 250000.00 onion 3000.00 0.01
4 238 231 33333.33 olive 1000.00 0.03
5 114 107 30000.00 bean 30000.00 1.00
6 76 68 28571.43 wheat 2000.00 0.07
7 75 67 26666.67 soft wheat 80000.00 3.00
8 158 151 25714.29 wheat 90000.00 3.50
9 157 150 20000.00 wheat 60000.00 3.00
10 159 152 20000.00 soft wheat 80000.00 4.00
11 160 153 20000.00 soft wheat 60000.00 3.00
12 173 166 20000.00 wheat 40000.00 2.00
13 179 172 17500.00 wheat 35000.00 2.00
14 191 184 15000.00 wheat 30000.00 2.00
15 192 185 15000.00 wheat 15000.00 1.00
16 379 373 15000.00 wheat 30000.00 2.00
17 53 45 13333.33 wheat 40000.00 3.00
18 133 126 6000.00 barley 6000.00 1.00

crop 2 quantity produced by size unit

possible outliers

prog session_number participant_id q142_qp/q62_size q142 q142_qp q62_size
1 447 442 120000.00 potato 30000.00 0.25
2 424 418 100000.00 potato 50000.00 0.50
3 10 2 80000.00 wheat 80000.00 1.00
4 217 210 60000.00 barley 30000.00 0.50
5 272 265 50000.00 wheat 25000.00 0.50
6 226 219 30000.00 oat 15000.00 0.50
7 505 500 30000.00 wheat 30000.00 1.00
8 27 20 26666.67 barley 40000.00 1.50
9 161 154 26666.67 bean 40000.00 1.50
10 173 166 25000.00 bean 50000.00 2.00
11 464 459 25000.00 wheat 50000.00 2.00
12 158 151 23333.33 bean 35000.00 1.50
13 76 68 20000.00 soft wheat 2000.00 0.10
14 459 454 20000.00 wheat 40000.00 2.00
15 263 256 16000.00 bean 8000.00 0.50
16 53 45 13333.33 barley 40000.00 3.00
17 165 158 13333.33 wheat 40000.00 3.00
18 56 48 12000.00 wheat 24000.00 2.00

crop 3 quantity produced by size unit

possible outliers

prog session_number participant_id q143_qp/q63_size q143 q143_qp q63_size
1 125 118 60000.00 watermelon 30000.00 0.50
2 357 351 50000.00 legume 50.00 0.00
3 27 20 40000.00 wheat 40000.00 1.00
4 157 150 35000.00 barley 35000.00 1.00
5 36 28 30000.00 olive 30000.00 1.00
6 215 208 21818.18 wheat 60000.00 2.75
7 46 38 20000.00 olive 20000.00 1.00
8 56 48 20000.00 soft wheat 40000.00 2.00
9 59 51 20000.00 grain 20000.00 1.00
10 120 113 17500.00 bean 35000.00 2.00
11 180 173 15000.00 oat 15000.00 1.00
12 310 304 13333.33 bean 20000.00 1.50
13 191 184 12500.00 bean 25000.00 2.00
14 281 275 12000.00 grain 3000.00 0.25
15 171 164 10317.46 wheat 65000.00 6.30
16 58 50 10000.00 wheat 30000.00 3.00
17 165 158 10000.00 bean 10000.00 1.00
18 179 172 10000.00 oat 20000.00 2.00
19 503 498 10000.00 bean 10000.00 1.00
20 307 301 6000.00 oat 3000.00 0.50

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 10 2 2.00 1.00 2.00
2 13 4 11.00 1.00 11.00
3 14 6 2.00 1.00 2.00
4 16 8 2.00 1.00 2.00
5 17 9 2.00 1.00 2.00
6 21 13 3.00 1.00 3.00
7 24 16 3.00 1.00 3.00
8 26 18 3.00 1.00 3.00
9 27 20 2.00 1.00 2.00
10 29 21 3.00 1.00 3.00
11 32 24 2.00 1.00 2.00
12 34 26 3.00 1.00 3.00
13 35 27 2.00 1.00 2.00
14 36 28 4.00 1.00 4.00
15 37 29 3.00 1.00 3.00
16 38 30 2.00 1.00 2.00
17 39 31 3.00 1.00 3.00
18 41 33 4.00 1.00 4.00
19 43 35 2.00 1.00 2.00
20 45 37 3.00 1.00 3.00
21 46 38 4.00 1.00 4.00
22 47 39 2.00 1.00 2.00
23 48 40 4.00 1.00 4.00
24 49 41 6.00 1.00 6.00
25 53 45 6.00 1.00 6.00
26 54 46 4.00 1.00 4.00
27 55 47 3.00 1.00 3.00
28 56 48 4.00 1.00 4.00
29 58 50 8.00 1.00 8.00
30 59 51 2.00 1.00 2.00
31 60 52 3.00 1.00 3.00
32 61 53 2.00 1.00 2.00
33 64 56 2.00 1.00 2.00
34 65 57 3.00 1.00 3.00
35 67 59 3.00 1.00 3.00
36 69 61 3.00 1.00 3.00
37 70 62 2.00 1.00 2.00
38 72 64 2.00 1.00 2.00
39 73 65 3.00 1.00 3.00
40 74 66 3.00 1.00 3.00
41 75 67 3.00 1.00 3.00
42 77 69 2.00 1.00 2.00
43 80 72 11.00 1.00 11.00
44 87 79 2.00 1.00 2.00
45 93 86 4.00 1.00 4.00
46 95 88 9.00 1.00 9.00
47 96 89 2.00 1.00 2.00
48 99 92 3.00 1.00 3.00
49 100 93 2.00 1.00 2.00
50 101 94 2.00 1.00 2.00
51 102 95 2.00 1.00 2.00
52 104 97 2.00 1.00 2.00
53 105 98 3.00 1.00 3.00
54 110 103 3.00 1.00 3.00
55 111 104 4.00 1.00 4.00
56 113 106 2.00 1.00 2.00
57 115 108 2.00 1.00 2.00
58 118 111 2.00 1.00 2.00
59 119 112 2.00 1.00 2.00
60 124 117 4.00 1.00 4.00
61 125 118 3.00 1.00 3.00
62 127 120 2.00 1.00 2.00
63 128 121 3.00 1.00 3.00
64 129 122 2.00 1.00 2.00
65 134 127 2.00 1.00 2.00
66 136 129 2.00 1.00 2.00
67 139 132 2.00 1.00 2.00
68 142 135 2.00 1.00 2.00
69 144 137 2.00 1.00 2.00
70 146 139 3.00 1.00 3.00
71 147 140 2.00 1.00 2.00
72 153 146 2.00 1.00 2.00
73 155 148 2.00 1.00 2.00
74 156 149 2.00 1.00 2.00
75 157 150 6.00 1.00 6.00
76 159 152 2.00 1.00 2.00
77 160 153 2.00 1.00 2.00
78 163 156 3.00 1.00 3.00
79 164 157 2.00 1.00 2.00
80 167 160 2.00 1.00 2.00
81 168 161 2.00 1.00 2.00
82 171 164 4.00 1.00 4.00
83 172 165 2.00 1.00 2.00
84 174 167 2.00 1.00 2.00
85 180 173 3.00 1.00 3.00
86 183 176 2.00 1.00 2.00
87 185 178 3.00 1.00 3.00
88 186 179 2.00 1.00 2.00
89 187 180 2.00 1.00 2.00
90 189 182 4.00 1.00 4.00
91 191 184 3.00 1.00 3.00
92 192 185 3.00 1.00 3.00
93 206 199 5.00 1.00 5.00
94 220 213 2.00 1.00 2.00
95 224 217 2.00 1.00 2.00
96 242 235 3.00 1.00 3.00
97 243 236 2.00 1.00 2.00
98 249 242 2.00 1.00 2.00
99 253 246 3.00 2.00 1.50
100 254 247 2.00 1.00 2.00
101 255 248 2.00 1.00 2.00
102 256 249 2.00 1.00 2.00
103 257 250 2.00 1.00 2.00
104 262 255 4.00 1.00 4.00
105 264 257 2.00 1.00 2.00
106 266 259 2.00 1.00 2.00
107 267 260 2.00 1.00 2.00
108 271 264 2.00 1.00 2.00
109 275 268 2.00 1.00 2.00
110 508 269 2.00 1.00 2.00
111 276 270 4.00 1.00 4.00
112 281 275 2.00 1.00 2.00
113 284 278 2.00 1.00 2.00
114 285 279 2.00 1.00 2.00
115 304 298 9.00 1.00 9.00
116 305 299 3.00 1.00 3.00
117 309 303 4.00 1.00 4.00
118 313 307 2.00 1.00 2.00
119 316 310 3.00 1.00 3.00
120 317 311 4.00 1.00 4.00
121 318 312 2.00 1.00 2.00
122 320 314 2.00 1.00 2.00
123 323 317 3.00 1.00 3.00
124 325 319 7.00 1.00 7.00
125 326 320 10.00 1.00 10.00
126 327 321 2.00 1.00 2.00
127 331 325 6.00 1.00 6.00
128 336 330 2.00 1.00 2.00
129 340 334 3.00 1.00 3.00
130 341 335 4.00 1.00 4.00
131 343 337 4.00 1.00 4.00
132 346 340 4.00 1.00 4.00
133 348 342 2.00 1.00 2.00
134 359 353 2.00 1.00 2.00
135 361 355 6.00 1.00 6.00
136 395 389 8.00 1.00 8.00
137 397 391 2.00 1.00 2.00
138 399 393 3.00 1.00 3.00
139 401 395 2.00 1.00 2.00
140 405 399 3.00 1.00 3.00
141 410 404 3.00 1.00 3.00
142 411 405 6.00 1.00 6.00
143 431 425 2.00 1.00 2.00
144 434 428 2.00 1.00 2.00
145 506 429 2.00 1.00 2.00
146 436 431 3.00 1.00 3.00
147 437 432 2.00 1.00 2.00
148 439 434 2.00 1.00 2.00
149 442 437 2.00 1.00 2.00
150 447 442 2.00 1.00 2.00
151 457 452 2.00 1.00 2.00
152 459 454 2.00 1.00 2.00
153 460 455 2.00 1.00 2.00
154 464 459 2.00 1.00 2.00
155 470 465 2.00 1.00 2.00
156 472 467 2.00 1.00 2.00
157 488 483 3.00 1.00 3.00
158 495 490 4.00 1.00 4.00
159 496 491 4.00 1.00 4.00
160 497 492 2.00 1.00 2.00
161 499 494 3.00 1.00 3.00
162 502 497 2.00 1.00 2.00
163 504 499 5.00 1.00 5.00

total household members

possible outliers

prog session_number participant_id q224+q225+q226 q224 q225 q226
1 293 287 26.00 4.00 4.00 18.00
2 10 2 20.00 1.00 3.00 16.00

Number of household members who emigrated

possible outliers

prog session_number participant_id q261
1 354 348 10.00
2 26 18 8.00
3 25 17 7.00
4 133 126 7.00
5 79 71 6.00
6 123 116 6.00
7 188 181 6.00
8 280 274 6.00
9 31 23 5.00
10 265 258 5.00
11 297 291 5.00
12 315 309 5.00
13 385 379 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 431 425 150.00 2.00 4.00 onion
2 122 115 100.00 0.00 7.80 soft wheat
3 166 159 100.00 1.00 9.00 soft wheat
4 62 54 90.00 1.00 25.00 soft wheat
5 139 132 60.00 2.00 12.40 oat
6 260 253 60.00 0.00 26.00 grain
7 190 183 50.00 0.00 14.00 grain
8 38 30 40.00 2.00 13.00 grain
9 44 36 40.00 0.00 12.50 onion
10 168 161 40.00 2.00 10.00 soft wheat
11 188 181 40.00 1.00 9.00 soft wheat
12 189 182 40.00 4.00 11.00 soft wheat
13 202 195 40.00 1.00 17.00 garlic
14 395 389 40.00 8.00 7.25 onion
15 412 406 40.00 0.00 3.00 onion
16 432 426 40.00 1.00 2.00 wheat
17 437 432 40.00 2.00 12.00 onion
18 447 442 40.00 2.00 1.25 onion
19 266 259 35.00 2.00 5.00 wheat
20 36 28 32.00 4.00 5.00 onion
21 63 55 30.00 0.00 5.00 onion
22 290 284 30.00 1.00 2.00 nectarine
23 296 290 30.00 1.00 5.00 onion
24 403 397 30.00 0.00 1.00 wheat
25 421 415 30.00 1.00 7.00 onion
26 429 423 30.00 1.00 4.00 onion
27 49 41 29.00 6.00 6.00 onion
28 67 59 26.00 3.00 12.00 onion
29 167 160 26.00 2.00 9.00 soft wheat
30 276 270 25.00 4.00 13.00 onion

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