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/financial 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. What’s 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 > 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. Summary of # Farms to be checked for Validation - TCATTL Match Report Parameters - #Units=2%, Cumulative Sum=50%, 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.86‚120,722‚ 98.74‚ 13,127,508‚ 83.14‚122,265‚ 15,789,475‚ Šƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒŒ Summary of # Farms to be checked for Validation - TCATTL Match Report Parameters - #Units=2%, Cumulative Sum=50%, 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.86‚120,722‚ 98.74‚ 13,127,508‚ 83.14‚122,265‚ 15,789,475‚ Šƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒŒ Results for CEAG 2006

15. Summary of # Farms to be checked for Validation - TCATTL Match Report Parameters - #Units=2%, Cumulative Sum=50%, 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.86‚120,722‚ 98.74‚ 13,127,508‚ 83.14‚122,265‚ 15,789,475‚ Šƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒŒ Conclusions • How much validation is enough? • More focused and structured approach to Validation Process • Reduced work without quality compromise

16. Summary of # Farms to be checked for Validation - TCATTL Match Report Parameters - #Units=2%, Cumulative Sum=50%, 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.86‚120,722‚ 98.74‚ 13,127,508‚ 83.14‚122,265‚ 15,789,475‚ Šƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒŒ Contact Details If you have any Si vous avez plus de further questions questions Charlie Arcaro Phone (613) 951-7087 Charlie.Arcaro@statcan.ca Visit our website / Visitez notre site: www.statcan.ca