Validation tables quaranta and dikhanov
This presentation is the property of its rightful owner.
Sponsored Links
1 / 21

Validation Tables Quaranta and Dikhanov PowerPoint PPT Presentation


  • 92 Views
  • Uploaded on
  • Presentation posted in: General

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.

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.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


Validation tables quaranta and dikhanov

Outlinevalidation tables

Introduction to Validation Tables

The Quanranta Tables (QTs)

The Dikhanov Tables (DTs)

Relation between QTs and DTs


Validation tables quaranta and dikhanov

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


Validation tables quaranta and dikhanov

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


Validation tables quaranta and dikhanov

OverviewQuaranta tables

Table details

BH table

Item table


Validation tables quaranta and dikhanov

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


Validation tables quaranta and dikhanov

Table detailsQuaranta tables


Validation tables quaranta and dikhanov

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


Validation tables quaranta and dikhanov

BH Table detailsQuaranta tables


Validation tables quaranta and dikhanov

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


Validation tables quaranta and dikhanov

Item table detailsQuaranta tables


Validation tables quaranta and dikhanov

  • 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


Validation tables quaranta and dikhanov

OverviewDikhanovtables

Table details

BH table

Item table


Validation tables quaranta and dikhanov

  • 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


Validation tables quaranta and dikhanov

  • Table detailsDikhanovtables


Validation tables quaranta and dikhanov

  • 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


Validation tables quaranta and dikhanov

  • BH detailsDikhanovtables


Validation tables quaranta and dikhanov

  • 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


Validation tables quaranta and dikhanov

  • Item detailsDikhanovtables


Validation tables quaranta and dikhanov

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


Validation tables quaranta and dikhanov

THANK YOU


  • Login