Validation tables quaranta and dikhanov
Download
1 / 21

Validation Tables Quaranta and Dikhanov - PowerPoint PPT Presentation


  • 143 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Validation Tables Quaranta and Dikhanov' - purity


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Validation tables quaranta and dikhanov

Validation Tables Quaranta and Dikhanov

  • ICP-Africa Regional Workshop

  • Pretoria, South Africa

  • 20 - 24 June 2011


Outlinevalidation tables

Introduction to Validation Tables

The Quanranta Tables (QTs)

The Dikhanov Tables (DTs)

Relation between QTs and DTs


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


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


OverviewQuaranta tables

Table details

BH table

Item table


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


Table detailsQuaranta tables


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


BH Table detailsQuaranta tables


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


Item table detailsQuaranta 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


OverviewDikhanovtables

Table details

BH table

Item table


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



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



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



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



ad