Spreadsheet: 275788d1383647408-lookup-and-then-calculate-average-lookup-average
Sheet: Sheet1

 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00
US | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.1 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.21 | 0.22 | 0.23 | 0.24 | 0.25 | 0.26 | 0.27 | 0.28 | 0.29 | 0.3 | 0.31 | 0.32 | 0.33
EU | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.06999999999999999 | 0.08 | 0.09 | 0.09999999999999999 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.21 | 0.22 | 0.23 | 0.24 | 0.25 | 0.26 | 0.27 | 0.28 | 0.29 | 0.3 | 0.31 | 0.32 | 0.33 | 0.34
Germany | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.07999999999999999 | 0.09 | 0.09999999999999999 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.21 | 0.22 | 0.23 | 0.24 | 0.25 | 0.26 | 0.27 | 0.28 | 0.29 | 0.3 | 0.31 | 0.32 | 0.33 | 0.34 | 0.35
Spain | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.08999999999999998 | 0.09999999999999999 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.21 | 0.22 | 0.23 | 0.24 | 0.25 | 0.26 | 0.27 | 0.28 | 0.29 | 0.3 | 0.3100000000000001 | 0.32 | 0.33 | 0.34 | 0.35 | 0.36
France | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.09999999999999998 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.21 | 0.22 | 0.23 | 0.24 | 0.25 | 0.26 | 0.27 | 0.28 | 0.29 | 0.3 | 0.3100000000000001 | 0.3200000000000001 | 0.33 | 0.34 | 0.35 | 0.36 | 0.3700000000000001
Italy | 0.06 | 0.07 | 0.08 | 0.09 | 0.09999999999999999 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.1900000000000001 | 0.2 | 0.21 | 0.2200000000000001 | 0.23 | 0.24 | 0.2500000000000001 | 0.26 | 0.27 | 0.28 | 0.29 | 0.3 | 0.3100000000000001 | 0.3200000000000001 | 0.3300000000000001 | 0.34 | 0.35 | 0.36 | 0.3700000000000001 | 0.3800000000000001
UK | 0.07 | 0.08 | 0.09 | 0.09999999999999999 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.1900000000000001 | 0.2000000000000001 | 0.21 | 0.2200000000000001 | 0.2300000000000001 | 0.24 | 0.2500000000000001 | 0.2600000000000001 | 0.27 | 0.28 | 0.29 | 0.3 | 0.3100000000000001 | 0.3200000000000001 | 0.3300000000000001 | 0.3400000000000001 | 0.35 | 0.36 | 0.3700000000000001 | 0.3800000000000001 | 0.3900000000000001
China | 0.08 | 0.09 | 0.09999999999999999 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.1900000000000001 | 0.2000000000000001 | 0.2100000000000001 | 0.2200000000000001 | 0.2300000000000001 | 0.2400000000000001 | 0.2500000000000001 | 0.2600000000000001 | 0.2700000000000001 | 0.28 | 0.29 | 0.3 | 0.3100000000000001 | 0.3200000000000001 | 0.3300000000000001 | 0.3400000000000001 | 0.3500000000000001 | 0.36 | 0.3700000000000001 | 0.3800000000000001 | 0.3900000000000001 | 0.4000000000000001
India | 0.09 | 0.09999999999999999 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.1900000000000001 | 0.2000000000000001 | 0.2100000000000001 | 0.2200000000000001 | 0.2300000000000001 | 0.2400000000000001 | 0.2500000000000001 | 0.2600000000000001 | 0.2700000000000001 | 0.2800000000000001 | 0.29 | 0.3 | 0.3100000000000001 | 0.3200000000000001 | 0.3300000000000001 | 0.3400000000000001 | 0.3500000000000001 | 0.3600000000000001 | 0.3700000000000001 | 0.3800000000000001 | 0.3900000000000001 | 0.4000000000000001 | 0.4100000000000001
Russia | 0.09999999999999999 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.1900000000000001 | 0.2000000000000001 | 0.2100000000000001 | 0.2200000000000001 | 0.2300000000000001 | 0.2400000000000001 | 0.2500000000000001 | 0.2600000000000001 | 0.2700000000000001 | 0.2800000000000001 | 0.2900000000000001 | 0.3 | 0.3100000000000001 | 0.3200000000000001 | 0.3300000000000001 | 0.3400000000000001 | 0.3500000000000001 | 0.3600000000000001 | 0.3700000000000001 | 0.3800000000000001 | 0.3900000000000001 | 0.4000000000000001 | 0.4100000000000001 | 0.4200000000000001
Brazil | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2000000000000001 | 0.2100000000000001 | 0.2200000000000001 | 0.2300000000000001 | 0.2400000000000001 | 0.2500000000000001 | 0.2600000000000001 | 0.2700000000000001 | 0.2800000000000001 | 0.2900000000000001 | 0.3000000000000001 | 0.3100000000000001 | 0.3200000000000001 | 0.3300000000000001 | 0.3400000000000001 | 0.3500000000000001 | 0.3600000000000001 | 0.3700000000000001 | 0.3800000000000001 | 0.3900000000000001 | 0.4000000000000001 | 0.4100000000000001 | 0.4200000000000001 | 0.4300000000000001
Indonesia | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.2100000000000001 | 0.2200000000000001 | 0.2300000000000001 | 0.2400000000000001 | 0.2500000000000001 | 0.2600000000000001 | 0.2700000000000001 | 0.2800000000000001 | 0.2900000000000001 | 0.3000000000000001 | 0.3100000000000001 | 0.3200000000000001 | 0.3300000000000001 | 0.3400000000000001 | 0.3500000000000001 | 0.3600000000000001 | 0.3700000000000001 | 0.3800000000000001 | 0.3900000000000001 | 0.4000000000000001 | 0.4100000000000001 | 0.4200000000000001 | 0.4300000000000001 | 0.4400000000000001
Mexico | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.21 | 0.2200000000000001 | 0.2300000000000001 | 0.2400000000000001 | 0.2500000000000001 | 0.2600000000000001 | 0.2700000000000001 | 0.2800000000000001 | 0.2900000000000001 | 0.3000000000000001 | 0.3100000000000001 | 0.3200000000000001 | 0.3300000000000001 | 0.3400000000000001 | 0.3500000000000001 | 0.3600000000000001 | 0.3700000000000001 | 0.3800000000000001 | 0.3900000000000001 | 0.4000000000000001 | 0.4100000000000001 | 0.4200000000000001 | 0.4300000000000001 | 0.4400000000000001 | 0.4500000000000001
Argentina | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.21 | 0.2200000000000001 | 0.2300000000000001 | 0.2400000000000001 | 0.2500000000000001 | 0.2600000000000001 | 0.2700000000000001 | 0.2800000000000001 | 0.2900000000000001 | 0.3000000000000001 | 0.3100000000000001 | 0.3200000000000001 | 0.3300000000000001 | 0.3400000000000001 | 0.3500000000000001 | 0.3600000000000001 | 0.3700000000000001 | 0.3800000000000001 | 0.3900000000000001 | 0.4000000000000001 | 0.4100000000000001 | 0.4200000000000001 | 0.4300000000000001 | 0.4400000000000001 | 0.4500000000000001 | 0.4600000000000001
Turkey | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.21 | 0.2200000000000001 | 0.2300000000000001 | 0.2400000000000001 | 0.2500000000000001 | 0.2600000000000001 | 0.2700000000000001 | 0.2800000000000001 | 0.2900000000000001 | 0.3000000000000001 | 0.3100000000000001 | 0.3200000000000001 | 0.3300000000000001 | 0.3400000000000001 | 0.3500000000000001 | 0.3600000000000001 | 0.3700000000000001 | 0.3800000000000001 | 0.3900000000000001 | 0.4000000000000001 | 0.4100000000000001 | 0.4200000000000002 | 0.4300000000000001 | 0.4400000000000001 | 0.4500000000000001 | 0.4600000000000001 | 0.4700000000000001
South Africa | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.21 | 0.2200000000000001 | 0.2300000000000001 | 0.2400000000000001 | 0.2500000000000001 | 0.2600000000000001 | 0.2700000000000001 | 0.2800000000000001 | 0.2900000000000001 | 0.3000000000000001 | 0.3100000000000001 | 0.3200000000000001 | 0.3300000000000001 | 0.3400000000000001 | 0.3500000000000001 | 0.3600000000000001 | 0.3700000000000001 | 0.3800000000000001 | 0.3900000000000001 | 0.4000000000000001 | 0.4100000000000001 | 0.4200000000000002 | 0.4300000000000002 | 0.4400000000000001 | 0.4500000000000001 | 0.4600000000000001 | 0.4700000000000001 | 0.4800000000000001
FOR CHART
Quarterly Trend | 1Q11 | 2Q11 | 3Q11 | 4Q11 | 1Q12 | 2Q12 | 3Q12 | 4Q12 | 1Q13 | 2Q13 | 3Q13
US | 0.02 | 0.05 | 0.08 | 0.11 | 0.14 | 0.17 | 0.2 | 0.23 | 0.26 | 0.29 | 0.32