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
|
17
|
|
13
|
q142_qp/q62_size
|
crop 2 quantity produced by size unit
|
outlier
|
9
|
|
14
|
q143_qp/q63_size
|
crop 3 quantity produced by size unit
|
outlier
|
4
|
|
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
|
60
|
|
28
|
q221
|
farmer age
|
outlier
|
0
|
|
29
|
q224+q225+q226
|
total household members
|
outlier
|
1
|
|
30
|
q261
|
Number of household members who emigrated
|
outlier
|
11
|
|
31
|
q28
|
Number of people outside the household employed in the farm
|
outlier
|
9
|
Number of participant_id involved by check type:
|
check.type
|
n
|
|
outlier
|
51
|
|
value
|
60
|
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
|
83
|
631
|
30000.00
|
olive
|
15000.00
|
0.50
|
|
2
|
22
|
566
|
28000.00
|
olive
|
14000.00
|
0.50
|
|
3
|
192
|
748
|
20000.00
|
broad bean
|
120000.00
|
6.00
|
|
4
|
518
|
776
|
20000.00
|
olive
|
10000.00
|
0.50
|
|
5
|
28
|
572
|
15000.00
|
olive
|
30000.00
|
2.00
|
|
6
|
196
|
752
|
15000.00
|
olive
|
30000.00
|
2.00
|
|
7
|
60
|
550
|
13333.33
|
olive
|
40000.00
|
3.00
|
|
8
|
609
|
867
|
13333.33
|
olive
|
40000.00
|
3.00
|
|
9
|
57
|
547
|
10666.67
|
olive
|
8000.00
|
0.75
|
|
10
|
41
|
585
|
10000.00
|
olive
|
5000.00
|
0.50
|
|
11
|
97
|
645
|
10000.00
|
olive
|
5000.00
|
0.50
|
|
12
|
158
|
706
|
10000.00
|
olive
|
10000.00
|
1.00
|
|
13
|
194
|
750
|
10000.00
|
wheat
|
10000.00
|
1.00
|
|
14
|
524
|
782
|
10000.00
|
olive
|
45000.00
|
4.50
|
|
15
|
548
|
806
|
9166.67
|
olive
|
55000.00
|
6.00
|
|
16
|
628
|
765
|
7500.00
|
wheat
|
15000.00
|
2.00
|
|
17
|
180
|
736
|
4000.00
|
carob
|
4000.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
|
534
|
792
|
160000.00
|
sugar beet
|
80000.00
|
0.50
|
|
2
|
9
|
553
|
10000.00
|
wheat
|
30000.00
|
3.00
|
|
3
|
114
|
662
|
10000.00
|
wheat
|
5000.00
|
0.50
|
|
4
|
513
|
725
|
10000.00
|
pea
|
10000.00
|
1.00
|
|
5
|
171
|
719
|
9000.00
|
wheat
|
9000.00
|
1.00
|
|
6
|
132
|
680
|
8000.00
|
wheat
|
4000.00
|
0.50
|
|
7
|
82
|
630
|
7500.00
|
alfalfa
|
15000.00
|
2.00
|
|
8
|
14
|
558
|
4000.00
|
grain
|
2000.00
|
0.50
|
|
9
|
28
|
572
|
4000.00
|
grain
|
4000.00
|
1.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
|
195
|
751
|
20000.00
|
olive
|
20000.00
|
1.00
|
|
2
|
534
|
792
|
8000.00
|
wheat
|
4000.00
|
0.50
|
|
3
|
59
|
549
|
6000.00
|
bean
|
3000.00
|
0.50
|
|
4
|
561
|
819
|
4000.00
|
broad bean
|
2000.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
|
13
|
503
|
2.00
|
1.00
|
2.00
|
|
2
|
15
|
505
|
2.00
|
1.00
|
2.00
|
|
3
|
21
|
511
|
2.00
|
1.00
|
2.00
|
|
4
|
48
|
538
|
8.00
|
1.00
|
8.00
|
|
5
|
20
|
564
|
3.00
|
1.00
|
3.00
|
|
6
|
52
|
596
|
2.00
|
1.00
|
2.00
|
|
7
|
66
|
610
|
2.00
|
1.00
|
2.00
|
|
8
|
69
|
617
|
2.00
|
1.00
|
2.00
|
|
9
|
71
|
619
|
3.00
|
1.00
|
3.00
|
|
10
|
74
|
622
|
3.00
|
1.00
|
3.00
|
|
11
|
82
|
630
|
2.00
|
1.00
|
2.00
|
|
12
|
86
|
634
|
2.00
|
1.00
|
2.00
|
|
13
|
94
|
642
|
3.00
|
1.00
|
3.00
|
|
14
|
114
|
662
|
3.00
|
1.00
|
3.00
|
|
15
|
117
|
665
|
2.00
|
1.00
|
2.00
|
|
16
|
125
|
673
|
2.00
|
1.00
|
2.00
|
|
17
|
127
|
675
|
3.00
|
1.00
|
3.00
|
|
18
|
137
|
685
|
3.00
|
1.00
|
3.00
|
|
19
|
142
|
690
|
2.00
|
1.00
|
2.00
|
|
20
|
145
|
693
|
2.00
|
1.00
|
2.00
|
|
21
|
147
|
695
|
2.00
|
1.00
|
2.00
|
|
22
|
149
|
697
|
4.00
|
1.00
|
4.00
|
|
23
|
153
|
701
|
4.00
|
1.00
|
4.00
|
|
24
|
154
|
702
|
2.00
|
1.00
|
2.00
|
|
25
|
156
|
704
|
4.00
|
1.00
|
4.00
|
|
26
|
164
|
712
|
2.00
|
1.00
|
2.00
|
|
27
|
169
|
717
|
2.00
|
1.00
|
2.00
|
|
28
|
509
|
721
|
2.00
|
1.00
|
2.00
|
|
29
|
511
|
723
|
3.00
|
1.00
|
3.00
|
|
30
|
514
|
726
|
2.00
|
1.00
|
2.00
|
|
31
|
177
|
733
|
3.00
|
1.00
|
3.00
|
|
32
|
180
|
736
|
2.00
|
1.00
|
2.00
|
|
33
|
191
|
747
|
5.00
|
1.00
|
5.00
|
|
34
|
195
|
751
|
3.00
|
1.00
|
3.00
|
|
35
|
621
|
758
|
2.00
|
1.00
|
2.00
|
|
36
|
624
|
761
|
6.00
|
1.00
|
6.00
|
|
37
|
628
|
765
|
3.00
|
1.00
|
3.00
|
|
38
|
631
|
768
|
2.00
|
1.00
|
2.00
|
|
39
|
634
|
771
|
2.00
|
1.00
|
2.00
|
|
40
|
517
|
775
|
2.00
|
1.00
|
2.00
|
|
41
|
521
|
779
|
2.00
|
1.00
|
2.00
|
|
42
|
530
|
788
|
2.00
|
1.00
|
2.00
|
|
43
|
537
|
795
|
5.00
|
1.00
|
5.00
|
|
44
|
543
|
801
|
2.00
|
1.00
|
2.00
|
|
45
|
546
|
804
|
2.00
|
1.00
|
2.00
|
|
46
|
547
|
805
|
2.00
|
1.00
|
2.00
|
|
47
|
563
|
821
|
2.00
|
1.00
|
2.00
|
|
48
|
566
|
824
|
2.00
|
1.00
|
2.00
|
|
49
|
570
|
828
|
2.00
|
1.00
|
2.00
|
|
50
|
577
|
835
|
2.00
|
1.00
|
2.00
|
|
51
|
591
|
849
|
2.00
|
1.00
|
2.00
|
|
52
|
595
|
853
|
2.00
|
1.00
|
2.00
|
|
53
|
598
|
856
|
5.00
|
1.00
|
5.00
|
|
54
|
612
|
870
|
3.00
|
1.00
|
3.00
|
|
55
|
638
|
875
|
3.00
|
1.00
|
3.00
|
|
56
|
641
|
878
|
3.00
|
1.00
|
3.00
|
|
57
|
651
|
888
|
2.00
|
1.00
|
2.00
|
|
58
|
654
|
891
|
2.00
|
1.00
|
2.00
|
|
59
|
657
|
894
|
2.00
|
1.00
|
2.00
|
|
60
|
659
|
896
|
2.00
|
1.00
|
2.00
|
total household members
possible outliers
|
prog
|
session_number
|
participant_id
|
q224+q225+q226
|
q224
|
q225
|
q226
|
|
1
|
190
|
746
|
13.00
|
1.00
|
1.00
|
11.00
|

Number of household members who emigrated
possible outliers
|
prog
|
session_number
|
participant_id
|
q261
|
|
1
|
107
|
655
|
7.00
|
|
2
|
57
|
601
|
6.00
|
|
3
|
82
|
630
|
6.00
|
|
4
|
22
|
566
|
5.00
|
|
5
|
50
|
594
|
5.00
|
|
6
|
191
|
747
|
5.00
|
|
7
|
548
|
806
|
5.00
|
|
8
|
572
|
830
|
5.00
|
|
9
|
643
|
880
|
5.00
|
|
10
|
652
|
889
|
5.00
|
|
11
|
663
|
900
|
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
|
10
|
554
|
30.00
|
0.00
|
5.00
|
olive
|
|
2
|
544
|
802
|
30.00
|
0.00
|
100.00
|
wheat
|
|
3
|
32
|
576
|
20.00
|
1.00
|
4.00
|
olive
|
|
4
|
62
|
606
|
20.00
|
1.00
|
3.00
|
olive
|
|
5
|
629
|
766
|
20.00
|
0.00
|
7.00
|
apple
|
|
6
|
630
|
767
|
20.00
|
1.00
|
11.25
|
olive
|
|
7
|
557
|
815
|
20.00
|
1.00
|
70.00
|
carob
|
|
8
|
656
|
893
|
20.00
|
1.00
|
4.00
|
wheat
|
|
9
|
18
|
562
|
18.00
|
1.00
|
2.00
|
grain
|

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
|