To generate a country risk index, we can apply a so-called weighted average method. Assume that we have two indices: Corruption. index and RiskScore. Assume that we assign two weights of 70% and 30% to those two indices. For our final weighted country index, the higher is our value, the higher is the country risk. Based on the above method, what are the weighted average values for Afghanistan, Canada and the USA? B C D G 1 0.43 1 COUNTRY 2 Afghanistan 3 Australia 4 Austria 5 Belgium 6 Brazil 7 Canada 8 China 9 Czech Republic 10 Denmark 11 Estonia 12 Finland 13 France 14 Germany 15 Greece 16 Hong Kong 17 Iceland 18 India 19 Indonesia 20 Iran 21 Iraq 22 Ireland 23 Israel 24 Italy 25 Japan 26 Luxembourg 27 Malaysia 28 Mexico 29 Netherlands 30 New Zealand 31 Norway 32 Poland 33 Russia 34 Saudi Arabia 35 Singapore 36 Slovenia CORRUPTION.INDEX 16 76 76 75 35 81 39 59 88 73 85 72 80 45 76 76 41 38 28 18 -0.07 E F RANKING COUNTRY 1 MOZAMBIQUE 2 LAOS 3 MYANMAR 4 AFGHANISTAN 5 LIBERIA 6 HAITI 7 KENYA 8 VIETNAM 9 BENIN 10 SIERRA LEONE 11 CAPE VERDE 12 NIGERIA 13 ZIMBABWE 14 PARAGUAY 15 YEMEN 16 CAMBODIA 17 TANZANIA 18 COTE D'IVOIRE 19 CHINA 20 MONGOLIA 21 NICARAGUA 22 ARGENTINA 23 PAKISTAN 24 ANGOLA 25 SERBIA 26 TAJIKISTAN 27 ALGERIA 28 KAZAKHSTAN -29 ECUADOR 30 JAMAICA 31 THAILAND 32 SENEGAL 33 TURKEY 34 PANAMA 35 GUYANA RISKSCORE CHANGE18 19 8.22 -0.06 8.21 -0.04 7.93 7.76 -0.52 7.35 -0.07 7.34 0.01 7.33 -0.07 7.3 -0.07 7.27 0.02 7.2 -0.04 7.01 -0.01 6.89 0.03 6.87 0.01 6.74 -0.05 6.74 6.63 -0.85 6.63 -0.08 6.62 0.03 6.59 0.57 6.57 -0.08 6.53 -0.19 6.5 -0.05 6.45 -0.04 6.33 -0.16 6.33 -0.19 6.28 -2.02 6.28 -0.07 6.27 -0.09 6.25 -0.05 6.24 -0.24 6.22 -0.08 6.2 0 6.19 0.08 6.19 -0.02 6.14 0.02 73 61 52 73 81 47 28 82 89 84 60 29 49 85 60 D 60 57 Slovenia South Korea Spain Switzerland Taiwan Thailand United Arab Emir United Kingdom United States Venezuela 58 85 63 36 70 80 71 18 35 GUYANA 36 MOROCCO 37 UKRAINE 38 BOLIVIA 39 ALBANIA 40 VANUATU 41 KYRGYZSTAN 42 BOSNIA-HERZEGOVINA 43 COLOMBIA 44 PHILIPPINES 45 BANGLADESH 46 MARSHALL ISLANDS 47 HONDURAS 48 RUSSIA 49 VENEZUELA 50 UZBEKISTAN 51 INDIA 52 UNITED ARAB EMIRAT 53 BAHRAIN 54 EL_SALVADOR 55 LEBANON 56 BOTSWANA 57 DOMINICAN REPUBLIC 58 PERU 59 AZERBAIJAN 60 GHANA 61 MOLDOVA + 62 MALAYSIA 63 SAUDI ARABIA -64 TRINIDAD AND TOBA 65 COSTA RICA 66 GEORGIA 67 INDONESIA 68 MEXICO* 69 HONG KONG SAR_CH 70 ARMENIA 6.14 6.12 6.01 6.01 6 5.9 5.86 5.83 5.83 5.81 5.8 5.76 5.76 5.75 5.72 5.71 5.6 5.6 5.46 5.46 5.46 5.46 5.41 5.33 5.31 5.29 5.29 5.28 5.26 5.26 5.23 5.2 5.13 5.13 5.11 5.08 0.02 -0.1 -0.05 -0.01 0.43 -0.47 -0.33 -0.01 1.41 -0.13 0.02 -0.16 -0.09 -0.08 0.03 -0.11 0.32 -0.1 0.13 0.03 -0.53 0.06 -0.39 0.19 -0.12 -0.03 -0.08 -0.21 0.25 0.01 -0.24 -0.11 -0.6 -0.04 -0.07 -0.15 E G H 70 ARMENIA 71 GAMBIA 72 UNITED STATES 73 JAPAN 74 CYPRUS 75 ITALY 76 BRAZIL 77 QATAR 78 SWITZERLAND 79 CANADA 80 HUNGARY 81 LATVIA 82 NETHERLANDS 83 TAIWAN CHINA 84 SOUTH AFRICA 85 LUXEMBOURG 86 JORDAN 87 ROMANIA 88 GUATEMALA 89 ST. LUCIA 90 ST._VINCENT_AND_GR 91 ICELAND 92 AUSTRIA 93 KOREA SOUTH 94 GRENADA 95 SINGAPORE 96 GREECE 97 IRELAND 98 EGYPT 99 GERMANY 100 SPAIN 101 DOMINICA 102 POLAND 103 BELGIUM 104 CHILE 105 CZECH REPUBLIC 5.08 5.05 5.03 5.02 5.01 4.99 4.97 4.97 4.96 4.92 4.9 4.89 4.86 4.84 4.83 4.82 4.77 4.76 4.75 4.73 4.69 4.66 4.64 4.6 4.59 4.58 4.56 4.55 4.55 4.49 4.42 4.4 4.34 4.29 4.18 4.15 -0.15 -0.03 0.03 -0.09 0 -0.1 0.01 -0.11 -0.37 0 -0.02 0.91 -0.04 -0.31 -0.51 -0.29 -0.07 0.01 -0.2 0.25 0.23 0.07 0.3 -0.09 0.39 0.07 0 -0.03 -0.8 0.05 -0.03 0.23 -0.04 -0.17 0.02 0.03 95 SINGAPORE 96 GREECE 97 IRELAND 98 EGYPT 99 GERMANY 100 SPAIN 101 DOMINICA 102 POLAND 103 BELGIUM 104 CHILE 105 CZECH_REPUBLIC 106 UNITED KINGDOM 107 PORTUGAL 108 FRANCE 109 SLOVAKIA 110 AUSTRALIA 111 DENMARK 112 MONTENEGRO 113 MALTA 114 NORWAY 116 ISRAEL 117 SLOVENIA 118 URUGUAY 119 LITHUANIA 120 BULGARIA 121 SWEDEN 122 MACEDONIA 123 NEW_ZEALAND 124 FINLAND 125 ESTONIA 4.58 4.56 4.55 4.55 4.49 4.42 4.4 4.34 4.29 4.18 4.15 4.13 4.1 4.09 4.04 3.97 3.95 3.94 3.94 3.91 3.76 3.7 3.58 3.55 3.51 3.51 3.22 3.18 3.17 2.68 0.07 0 -0.03 -0.8 0.05 -0.03 0.23 -0.04 -0.17 0.02 0.03 -0.1 -0.56 -0.03 -0.09 -0.09 -0.16 -0.01 -0.02 -0.21 -0.08 -0.05 -0.47 0.43 -0.02 -0.24 -0.11 -0.02 0.6 -0.05