1 / 21

Validation Tables Quaranta and Dikhanov

Validation Tables Quaranta and Dikhanov. ICP-Africa Regional Workshop Pretoria, South Africa 20 - 24 June 2011. Outline validation tables. Introduction to Validation Tables. The Quanranta Tables (QTs). The Dikhanov Tables (DTs). Relation between QTs and DTs.

purity
Download Presentation

Validation Tables Quaranta and Dikhanov

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Validation Tables Quaranta and Dikhanov • ICP-Africa Regional Workshop • Pretoria, South Africa • 20 - 24 June 2011

  2. Outlinevalidation tables Introduction to Validation Tables The Quanranta Tables (QTs) The Dikhanov Tables (DTs) Relation between QTs and DTs

  3. Introduction tovalidation tables The main data analysis within inter-country and global validation is carried out by using two validation tables that are • The Quaranta Tables • The Dikhanov Tables The purpose of the both tables is to • Screen the national average prices for possible errors by comparing the average prices for the same product in different countries • Possible errors are highlighted by special indices This analysis can lead to • Editing of price data for an item • Editing of metadata for an item

  4. Quanranta Tablesvalidation tables The Quaranta Tables (QTs) consist of a set of tables • Table details • Summary tables for each BH • Individual tables for each item QTs can be used for the validation of • BH PPPs and PLIs • Item XR-ratios and CUP-ratios Different calculation options • EKS, EKS*, CPD, CPRD and W-CPD • Recommended method by the TAG is weighted CPD • However comparison of results for different calculation methods can be used to value given information on importance

  5. OverviewQuaranta tables Table details BH table Item table

  6. Table detailsQuaranta tables QUARANTA TABLE DIAGNOSTICS Data Selection Criteria Basic Heading Code 99.11.01.11.1 Time Period Yearly Run Date 4/13/2011 Averaging Method Arithmetic Mean Imputation CPD Summary Information No of Items included in the Analysis6 out of 6 Average weight of Basic Heading in Total Expenditure 0.0 No of Countries included in the Analysis 18 out of 18 Average Coefficient Variation 27.4 Base CountryCountry

  7. Table detailsQuaranta tables

  8. BH tableQuaranta tables BH Table # Shares are multiplied by 10000. Country XR PPP PLI (%) Weight # Items Var.Co. Country 1 4.42 1.8150 41.080% 0.0 2;*0 7.2 Country 2 959.04 718.2770 74.896% 0.0 5;*0 8.2 Country 3 1018.35 2.7696 0.272% 0.0 2;*0 33.8

  9. BH Table detailsQuaranta tables

  10. Item tableQuaranta tables Item Table 99.11.01.11.1.01 Long grain rice, prepacked Var.Co.: 25.9 1-Kilograms Country NC-Price Quotations Var.Co. XR-pr XR-ratio CUP-price CUP-ratio Pref. UoM Country 1 1.500 151 11.2 0.34 45.89 0.83 095.02 NA Country 2 - - - - - - - NA Country 3 766.38 10 3.0 72.93 9857.6 1.14 130.66 NA Geo Mean 0.74 0.87

  11. Item table detailsQuaranta tables

  12. Dikhanov Tablesvalidation tables As the QTs, the Dikhanov Tables (DTs) consist of a set of tables • Table details • Summary table for each BH • Individual tables or rows for each item DTs can be used for the validation of • Aggregated (above BH) and BH PPPs and PLIs • Item XR-Ratios and CPD(R) residuals Different lay-out options including color scheme • Aggregate/BH tables + full item statistics • Aggregate of BH tables + simple residual rows for item Different calculation options • CPD, CPRD, CPD-W

  13. OverviewDikhanovtables Table details BH table Item table

  14. Table detailsDikhanovtables DIKHANOV Country 1 Country 2 Country 3 PPP 2.93 658.13 4.04 STD 0.25 0.26 0.29 No.of Priced Items 420 513 572 ER (LCU/US$) 2.43 527.47 5.78 Rebased_XR 4.42 959.04 10.51 PLI 0.66 0.69 0.38

  15. Table detailsDikhanovtables

  16. BH detailsDikhanovtables Item Level Details Country 1 Country 2 Country 3 Item Code Item Name Yearly - 2005 Yearly - 2005 Yearly - 2005 99.11.01.11.1 Rice PPP 1.82 718.30 4.85 STD 0.05 0.07 0.27 PLI 0.41 0.75 0.46 No.of Priced Items 2 5 6

  17. BH detailsDikhanovtables

  18. Item detailsDikhanovtables Item Level Details Country 1 Country 2 Country 3 STD Item Code Item Name Yearly - 2005 Yearly - 2005 Yearly - 2005 0.25 99.11.01.11.1.01 Long grain rice -0.05 - 0.27 Count Average Price 1.50 - 5.51 13 No.of Observations 151 - 10 Coefficient of Variation 11.22 - 3.00 XR Ratio 70.44 - 108.78

  19. Item detailsDikhanovtables

  20. Relation betweenQuaranta and Dikhanov Tables Both tables provides essentially the same information, but • Dikhanov Tables can be compiled for a group of BHs (an aggregate), they use color schemes to highlight potential outliers and can be collapsed to present only residuals for items • Quaranta tables presents the relations within an item potentially clearer Relation between CUP-Ratios and CPD residuals • CPD residuals are equal to the logarithms of CUP-ratios CUP-Ratios 0 to 14 14 to 47 47 to 78 78 to 128 128 to 212 212 to 739 739 to Less than -2.0 -2.0 to -0.75 -0.75 to -0.25 -0.25 to 0.25 0.25 to 0.75 0.75 to 2.0 More than 2.0 CPD residuals

  21. THANK YOU

More Related