RANKING COMPOSITE INDEX

     

The Ranking composite index procedure allows to rank the cases and to examine the index structure in a report card. The Ranking procedure arrange the cases according to the score they receive when is used an index composed from many indicators.

 The Ranking procedure offers the following information:

Positive and negative weights can be assigned if the indicators used are "desirable features" and "undesirable features". In Report Cards, green shows a relative strength of a case in comparison with the other cases for the respective variable. Green is displayed on bars showing values higher than average for "desirable" features and values below average for "undesirable" features. Red shows a relative weakness of a case in comparison with all the other cases. Red is displayed on bars with values below average for "desirable" features and with values higher than average for "undesirable" features. The width of the bars is proportional to the variables' weights. This way, the impact of changing weights "on-the-fly" is immediately perceived in the changed amount of color on the Report Cards. The weight of each variable is displayed on the left of each bar.

Example: Ranking procedure for the TARGET_REG index (for Philippines regions). We choose to divide the cases (regions) in 3 equal groups (we used 2 breaks and equal number of cases).

 

 
Rank Index Case Color
1 100.00 NCR
2 80.23 Cagayan Valley
3 78.92 Central Luzon
4 77.38 Southern Tagalog
5 73.58 Northern Mindanao
6 69.08 Central Mindanao
7 64.98 Southern Mindanao
8 61.35 Western Visayas
9 61.16 Ilocos
10 60.82 CAR
11 58.73 Central Visayas
12 43.81 Western Mindanao
13 42.15 Caraga
14 40.39 Eastern Visayas
15 39.29 Bicol
16 0.00 ARMM

 

 

 

Group 1- the green group includes the regions with good situation according to the index used

 

Group 2- the yellow group includes the regions at the middle of the hierarchy

 

Group 3- the red group includes the regions with poor situation according to the index used

The ranking report cards allow to compare different regions and identify the similarities and the differences.

Northern Mindanao - Rank: 5

%MWRA_02_MODERN 39.70
%WRA_GAIN_EMPL_PRV 41.88
%FAM_POV_INCIDENCE 32.90
%FAM_EXP_HEALTH_1997 2.20
POP_DENSITY_2000 204.71

Central Mindanao - Rank: 6

%MWRA_02_MODERN 44.10
%WRA_GAIN_EMPL_PRV 37.54
%FAM_POV_INCIDENCE 48.40
%FAM_EXP_HEALTH_1997 2.90
POP_DENSITY_2000 163.08

If we select, for example, two regions (Northern Mindanao and Central Mindanao) we can observe that there are similarities but also differences between them. Northern Mindanao region has the percentage of poor families (% Families with annual PC income under per capita poverty threshold) under the average but Central Mindanao has the percentage of poor families greater than the average.

Therefore, the targeted interventions must differ according to the needs of each region.

Close Window