An experiment with data from the open government partnership: Ranking countries
Let’s make a tiny experiment with these data.
First of all we have to know that the submitted plan could incorporate new actions or existing ones. Secondly these actions could be completed or not accordingly to the plan. Thirdly and very important, these action could have a moderate, minor or a transformative effect on the countries’ governance. Last but not least, these action could be relevant (or no) for an open government plan.
In all these dimensions of analysis there are some cases in which it is not clear the qualification (or data are not available). These cases should be also considered in this experiment with data.Also severla countries did not submit their reviews on time so their data are not available (USA, UK, S. Africa, Philippines, Mexico, Indonesia and Brazil)
Now let’s create a draft metric about the performance of the different countries.
my first attempt is
Why the log? In order to promote more detailed action plans (more actions) but without penalize those more concise. Multiplied if the action has real impact and if the action really affects governance. With these metric we could rank countries according to these graph.
Similarly the progress will be just a minor correction on above formula, and normalized by the # of actions.
And the the ranking would look like this.
Of course it is just a mere experiment. Possibly unfair with some countries because of the structure of their plan, the assigned weights or because of past experience makes them harder to be ambitious in their plan formulation.
Are we mature enoguh to create such official ranking? I strongly believe it.
Find here the raw data calculation if you want to make your own experiment.
Find here the table which assign weights for every dimension of the actions in the plan fo every country.
|New or not||how many||weights|
|a. Not started||116||0|