Data Validation For the 2006 Census of Agriculture

1
Data Validation For the 2006 Census of Agriculture

• Charlie Arcaro, Statistics Canada
• ICES III - 20 June, 2007

2
Outline

• Introduction
• What is Data Validation?
• CEAG and Validation Process
• New Strategies for 2006
• Conclusions

3
Introduction

• Census of Agriculture (CEAG)
• Provides a quinquennial snapshot of Canadian
  Agriculture
• Piggyback with Census of Population
• Collects inventories of farm commodities/financia
  l information
• Approximately 229K farms 327K operators in
  CEAG 2006
• Used in redesigning Agricultural surveys
• Basic sources of sampling frames
• Intracensal corrections
• Updating the Farm Register

4
What is Data Validation?

• Major part of data quality evaluation for Census
  of Agriculture
• Costliest part of the CEAG process
  post-collection
• Analyze and change CEAG data (Sep 2006 to Feb
  2007)
• Data analyzed using both micro and macro level
  tools
• Aggregate data at various geographic levels
• Quality evaluation of small area data
• Produce reports, make presentations to
  Certification Committee and recommendations for
  publication

5
CEAG Process
Collection
Data Scanning
Editing, Matching, Follow up
Imputation
Data Validation
Output Dissemination
6
Whats Involved?

• Senior Validators prepare validation plan based
  upon knowledge and expectations
• Number of farms totals in 2006, Structural
  changes since 2001
• Validation tools on Central Processing System
  (CPS)
• Comparison/Match/Distribution tables, Top
  Contributors, Impact of Processing
• Compare references sources
• Validators responsible for many variables
• Validation done by variables and not
  questionnaire

7
Goals for CEAG Validation 2006

• More efficient use of resources
• Improve data quality at finer geographic level
• Greater scrutiny expected in 2006

8
Validation Tools

• Comparison Tables
• Compare data for 2001 and 2006 and of change
• Total values, farms reporting, average
  reporting value
• Four geographical levels
• Look for changes that makes data questionable
• Use survey data or other sources to justify
  changes
• More likely at lower levels of geography

9
Validation Tools (cont.)

• Impact of Processing Tables
• Assesses the impact made to data during
  imputation and validation (Provincial level only)
• Reports available for all variables
• No change for 2006

10
Validation Tools (cont.)

• Top Contributor Tables
• Farm records with highest value for certain
  geographic areas
• What to look for
• Imputed values,
• Jumps in consecutive values
• Compare associated variables with main variable
• Bottom Contributors
• Greenhouse variables - supposed to report in ft2
  or m2
• Locate capture and response errors

11
Validation Tools

• Top Contributor Tables
• In 2001
• Top 100 farms in each province (default)
• In 2006
• Top 100 farms or top 80 contributors in each
  province

12
Validation Tools

• Match Tables
• Compare CEAG data to selected Referential Sources
  (RS)
• Three reports are generated
• In RS not in CEAG, in CEAG not in RS, in both but
  with significant differences
• In 2001
• Top 100 from each of the 3 match reports
  (default)
• In 2006
• Using Call Management System (CMS) cutoff
  algorithm (2 units, 50 cumulative total 1
  individual total)
• Missing CEAG farms gt 30 CCS estimate

13
Validation Tools

• Distribution Tables
• Distribution of variables (Geog. Classification,
  Category..) Similar to Comparison Tables. Three
  types
• Operator Tables
• All operators at detailed geography level
• of operators, age, sex, job injuries etc.
• Livestock Tables
• Counts and farms sizes for various livestock and
  poultry (Province level)
• Other Tables
• Computer Usage, Land management
• Data on tick box variables

14
Results for CEAG 2006
Summary of Farms to be checked for Validation -
TCATTL Match Report Parameters - Units2,
Cumulative Sum50, Unit Cont.1 - TCATTL
Match Top
CCS - Total Farms
Total Report Contributor Top CCS
Top - Obs AGOPPROV Farms
Farms Farms Farms Farms
Unduplicated 1 10 59 4
46 18 13 68
2 11 110 3 100
11 6 114 3 12
103 2 100 2
2 104 4 13 122
. 100 23 14
123 5 24 304 28
100 209 101 337 6
35 193 78 100
50 27 228 7 46
123 49 100 5 3
154 8 47 147 69
100 16 13 185
9 48 217 171 100
2 2 273 10 59
165 39 100 56
31 195

1543 993
946 392 212 1781
Estimation Impact of Farms
to be checked for Validation - TCATTL
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

VALIDSTATUS
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

Checked Not Checked

ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ All
TCATTL
TCATTL ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ TCATTL
Row
Row
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ N Row
N Sum Sum N Row N Sum
Sum N Sum
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
HDPROV

ƒƒƒƒƒƒƒƒ

10 59 34.91
7,532 81.70 110 65.09 1,687 18.30
169 9,219 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒ
ƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒ
ƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 11 110
10.30 31,398 37.21 958 89.70
52,981 62.79 1,068 84,379
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
12 103 6.03 30,194 27.93
1,604 93.97 77,895 72.07 1,707
108,089 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒ
ˆƒƒƒƒƒƒƒƒƒƒƒ 13 122 8.59
27,185 29.90 1,299 91.41 63,725 70.10
1,421 90,910 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆ
ƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒ
ƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 24 304
1.89 119,186 8.69 15,797 98.11
1,252,855 91.31 16,101 1,372,041
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
35 193 0.68 272,994 12.21
28,099 99.32 1,963,652 87.79 28,237
2,236,646 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒ
ƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒ
ƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 46 123 1.08
149,619 10.46 11,242 98.92 1,281,057
89.54 11,365 1,430,676
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
47 147 0.65 351,040 11.69
22,481 99.35 2,653,138 88.31 22,628
3,004,178 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒ
ƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒ
ƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 48 217 0.68
1,468,421 22.11 31,593 99.32 5,174,387
77.89 31,810 6,642,808
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
59 165 2.13 204,398 25.22
7,594 97.87 606,131 74.78 7,759
810,529 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒ
ˆƒƒƒƒƒƒƒƒƒƒƒ All 1,543 1.26
2,661,967 16.86120,722 98.74 13,127,508
83.14122,265 15,789,475
Šƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒŒ
Summary of Farms to be checked for Validation -
TCATTL Match Report Parameters - Units2,
Cumulative Sum50, Unit Cont.1 - TCATTL
Match Top
CCS - Total Farms
Total Report Contributor Top CCS
Top - Obs AGOPPROV Farms
Farms Farms Farms Farms
Unduplicated 1 10 59 4
46 18 13 68
2 11 110 3 100
11 6 114 3 12
103 2 100 2
2 104 4 13 122
. 100 23 14
123 5 24 304 28
100 209 101 337 6
35 193 78 100
50 27 228 7 46
123 49 100 5 3
154 8 47 147 69
100 16 13 185
9 48 217 171 100
2 2 273 10 59
165 39 100 56
31 195

1543 993
946 392 212 1781
Estimation Impact of Farms
to be checked for Validation - TCATTL
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

VALIDSTATUS
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

Checked Not Checked

ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ All
TCATTL
TCATTL ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ TCATTL
Row
Row
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ N Row
N Sum Sum N Row N Sum
Sum N Sum
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
HDPROV

ƒƒƒƒƒƒƒƒ

10 59 34.91
7,532 81.70 110 65.09 1,687 18.30
169 9,219 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒ
ƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒ
ƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 11 110
10.30 31,398 37.21 958 89.70
52,981 62.79 1,068 84,379
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
12 103 6.03 30,194 27.93
1,604 93.97 77,895 72.07 1,707
108,089 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒ
ˆƒƒƒƒƒƒƒƒƒƒƒ 13 122 8.59
27,185 29.90 1,299 91.41 63,725 70.10
1,421 90,910 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆ
ƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒ
ƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 24 304
1.89 119,186 8.69 15,797 98.11
1,252,855 91.31 16,101 1,372,041
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
35 193 0.68 272,994 12.21
28,099 99.32 1,963,652 87.79 28,237
2,236,646 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒ
ƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒ
ƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 46 123 1.08
149,619 10.46 11,242 98.92 1,281,057
89.54 11,365 1,430,676
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
47 147 0.65 351,040 11.69
22,481 99.35 2,653,138 88.31 22,628
3,004,178 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒ
ƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒ
ƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 48 217 0.68
1,468,421 22.11 31,593 99.32 5,174,387
77.89 31,810 6,642,808
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
59 165 2.13 204,398 25.22
7,594 97.87 606,131 74.78 7,759
810,529 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒ
ˆƒƒƒƒƒƒƒƒƒƒƒ All 1,543 1.26
2,661,967 16.86120,722 98.74 13,127,508
83.14122,265 15,789,475
Šƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒŒ
Total Cattle (TCATTL) 109,920 Farms Total Cattle (TCATTL) 109,920 Farms
Validated Farms Total Total
New Methods 1,551 1.41 3,346,211 20.15
Previous Methods 2,928 2.66 3,992,312 20.73
Total Pigs (TOPIGS) 11,506 Farms Total Pigs (TOPIGS) 11,506 Farms
Validated Farms Total Total
New Methods 1,466 12.74 7,018,275 45.71
Previous Methods 2,808 24.40 7,255,827 47.25
Alfalfa (ALFALFA) 88,064 Farms Alfalfa (ALFALFA) 88,064 Farms
Validated Farms Total Total
New Methods 1,916 2.18 1,220,928 9.62
Previous Methods 2,562 2.91 1,187, 804 9.36
15
Conclusions
Summary of Farms to be checked for Validation -
TCATTL Match Report Parameters - Units2,
Cumulative Sum50, Unit Cont.1 - TCATTL
Match Top
CCS - Total Farms
Total Report Contributor Top CCS
Top - Obs AGOPPROV Farms
Farms Farms Farms Farms
Unduplicated 1 10 59 4
46 18 13 68
2 11 110 3 100
11 6 114 3 12
103 2 100 2
2 104 4 13 122
. 100 23 14
123 5 24 304 28
100 209 101 337 6
35 193 78 100
50 27 228 7 46
123 49 100 5 3
154 8 47 147 69
100 16 13 185
9 48 217 171 100
2 2 273 10 59
165 39 100 56
31 195

1543 993
946 392 212 1781
Estimation Impact of Farms
to be checked for Validation - TCATTL
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

VALIDSTATUS
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

Checked Not Checked

ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ All
TCATTL
TCATTL ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ TCATTL
Row
Row
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ N Row
N Sum Sum N Row N Sum
Sum N Sum
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
HDPROV

ƒƒƒƒƒƒƒƒ

10 59 34.91
7,532 81.70 110 65.09 1,687 18.30
169 9,219 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒ
ƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒ
ƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 11 110
10.30 31,398 37.21 958 89.70
52,981 62.79 1,068 84,379
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
12 103 6.03 30,194 27.93
1,604 93.97 77,895 72.07 1,707
108,089 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒ
ˆƒƒƒƒƒƒƒƒƒƒƒ 13 122 8.59
27,185 29.90 1,299 91.41 63,725 70.10
1,421 90,910 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆ
ƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒ
ƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 24 304
1.89 119,186 8.69 15,797 98.11
1,252,855 91.31 16,101 1,372,041
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
35 193 0.68 272,994 12.21
28,099 99.32 1,963,652 87.79 28,237
2,236,646 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒ
ƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒ
ƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 46 123 1.08
149,619 10.46 11,242 98.92 1,281,057
89.54 11,365 1,430,676
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
47 147 0.65 351,040 11.69
22,481 99.35 2,653,138 88.31 22,628
3,004,178 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒ
ƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒ
ƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 48 217 0.68
1,468,421 22.11 31,593 99.32 5,174,387
77.89 31,810 6,642,808
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
59 165 2.13 204,398 25.22
7,594 97.87 606,131 74.78 7,759
810,529 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒ
ˆƒƒƒƒƒƒƒƒƒƒƒ All 1,543 1.26
2,661,967 16.86120,722 98.74 13,127,508
83.14122,265 15,789,475
Šƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒŒ

• How much validation is enough?
• More focused and structured approach to
  Validation Process
• Reduced work without quality compromise

16
Contact Details
Summary of Farms to be checked for Validation -
TCATTL Match Report Parameters - Units2,
Cumulative Sum50, Unit Cont.1 - TCATTL
Match Top
CCS - Total Farms
Total Report Contributor Top CCS
Top - Obs AGOPPROV Farms
Farms Farms Farms Farms
Unduplicated 1 10 59 4
46 18 13 68
2 11 110 3 100
11 6 114 3 12
103 2 100 2
2 104 4 13 122
. 100 23 14
123 5 24 304 28
100 209 101 337 6
35 193 78 100
50 27 228 7 46
123 49 100 5 3
154 8 47 147 69
100 16 13 185
9 48 217 171 100
2 2 273 10 59
165 39 100 56
31 195

1543 993
946 392 212 1781
Estimation Impact of Farms
to be checked for Validation - TCATTL
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

VALIDSTATUS
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

Checked Not Checked

ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ All
TCATTL
TCATTL ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ TCATTL
Row
Row
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ N Row
N Sum Sum N Row N Sum
Sum N Sum
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
HDPROV

ƒƒƒƒƒƒƒƒ

10 59 34.91
7,532 81.70 110 65.09 1,687 18.30
169 9,219 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒ
ƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒ
ƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 11 110
10.30 31,398 37.21 958 89.70
52,981 62.79 1,068 84,379
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
12 103 6.03 30,194 27.93
1,604 93.97 77,895 72.07 1,707
108,089 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒ
ˆƒƒƒƒƒƒƒƒƒƒƒ 13 122 8.59
27,185 29.90 1,299 91.41 63,725 70.10
1,421 90,910 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆ
ƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒ
ƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 24 304
1.89 119,186 8.69 15,797 98.11
1,252,855 91.31 16,101 1,372,041
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
35 193 0.68 272,994 12.21
28,099 99.32 1,963,652 87.79 28,237
2,236,646 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒ
ƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒ
ƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 46 123 1.08
149,619 10.46 11,242 98.92 1,281,057
89.54 11,365 1,430,676
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
47 147 0.65 351,040 11.69
22,481 99.35 2,653,138 88.31 22,628
3,004,178 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒ
ƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒ
ƒƒˆƒƒƒƒƒƒƒƒƒƒƒ 48 217 0.68
1,468,421 22.11 31,593 99.32 5,174,387
77.89 31,810 6,642,808
ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒ
59 165 2.13 204,398 25.22
7,594 97.87 606,131 74.78 7,759
810,529 ƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒ
ƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒˆƒƒƒƒƒƒƒ
ˆƒƒƒƒƒƒƒƒƒƒƒ All 1,543 1.26
2,661,967 16.86120,722 98.74 13,127,508
83.14122,265 15,789,475
Šƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒŒ
If you have any Si vous avez plus
de further questions questions Charlie
Arcaro Phone [phone] Charlie.Arcaro_at_stat
can.ca Visit our website / Visitez notre site
www.statcan.ca