2010 Global Agenda Council Interlinkage Survey
The following is the exact question that was asked to the experts that comprise
The Global Agenda Network.
Question as asked in the survey:
“Please select a maximum of 5 Global Agenda Councils that your
Council would benefit from interacting with by order of priority.”
“Please select a maximum of 3 Industry/Regional Agenda Councils that
your Council would benefit from interacting with by order of
Rank 1-0, with 1 being the highest priority.
The calculation is based on the average weighting of the rankings. We
have assigned a score to each rank:
The total score for each link (sum of all the scores) is divided by
the number of valid responses received to each of the ranking
It is necessary to divide the total score by the number of responses
in order to put all the results into the same scale.
If 5 Energy security council members have responded to this question
and all put geopolitics under rank 1, the sum of all scores would be
1*5 = 5. This sum is then divided by the number of respondents (5).
This would therefore result in a weighted score of 5/5 = 1.
More complicated example:
If 3 out of 5 Energy Security members have answered that food
security is respectively Rank 1, 2 and 3. This would result in a
total score of 2.4 (1*1+1*0.8+1*0.6) for this link. If 5 Energy
Security member in total have responded to this part of the survey
this would result in a weighted score of 2.4/5 = 0.48.
We have chosen this methodology as it best reflects the overall
opinion of the members. If the Council members tend to agree on the
priorities, you will mostly have higher scores. If however there is a
large variety of linked Councils, this will result in lower scores.
If a Council has not been chosen in the top 5 it is equivalent as
giving it a score 0.
Two file formats have been provided:
- An Excel spreadsheet with the three matrices on separate sheets
- The three matrices in separate csv files.