Following on from the Hardest Groups thread, I thought I'd take Kalimantan Gull's suggestion of using the SPI data and see how the various teams performed.
The SPI calculated how each team would perform according to their ranking and the games they were playing. so I plotted these scores against the actual points tally to get a handle on how well each team had done.
As you can see, kudos to Japan and New Zealand who massively exceeded expectations and if you take out the two zeros, then Nigeria is the worst performer, just beating our old friends France and Italy. England came a less than impressive 23rd on the list.
(note the figures are projected score, actual score and percentage - if you score 100 or more, you met expectations)
Japan 2.36 6 254.24
N Zealand 1.43 3 209.79
Argentina 5.66 9 159.01
Uruguay 4.56 7 153.51
Holland 5.95 9 151.26
Chile 4.7 6 127.66
Germany 4.79 6 125.26
Australia 3.39 4 117.99
USA 4.26 5 117.37
Slovenia 3.44 4 116.28
Slovakia 3.48 4 114.94
Sw'land 2.62 3 114.50
Mexico 3.61 4 110.80
Brazil 6.37 7 109.89
Portugal 4.61 5 108.46
Ghana 3.72 4 107.53
S Korea 3.75 4 106.67
RSA 3.76 4 106.38
Spain 6.16 6 97.40
Iv Coast 4.33 4 92.38
Paraguay 5.69 5 87.87
England 6.27 5 79.74
Denmark 4.02 3 74.63
Serbia 4.23 3 70.92
Greece 4.28 3 70.09
Algeria 2.33 1 42.92
Honduras 2.85 1 35.09
Italy 5.95 2 33.61
France 4.18 1 23.92
Nigeria 4.39 1 22.78
Cameroon 3.96 0 0.00
N Korea 1.18 0 0.00
The SPI calculated how each team would perform according to their ranking and the games they were playing. so I plotted these scores against the actual points tally to get a handle on how well each team had done.
As you can see, kudos to Japan and New Zealand who massively exceeded expectations and if you take out the two zeros, then Nigeria is the worst performer, just beating our old friends France and Italy. England came a less than impressive 23rd on the list.
(note the figures are projected score, actual score and percentage - if you score 100 or more, you met expectations)
Japan 2.36 6 254.24
N Zealand 1.43 3 209.79
Argentina 5.66 9 159.01
Uruguay 4.56 7 153.51
Holland 5.95 9 151.26
Chile 4.7 6 127.66
Germany 4.79 6 125.26
Australia 3.39 4 117.99
USA 4.26 5 117.37
Slovenia 3.44 4 116.28
Slovakia 3.48 4 114.94
Sw'land 2.62 3 114.50
Mexico 3.61 4 110.80
Brazil 6.37 7 109.89
Portugal 4.61 5 108.46
Ghana 3.72 4 107.53
S Korea 3.75 4 106.67
RSA 3.76 4 106.38
Spain 6.16 6 97.40
Iv Coast 4.33 4 92.38
Paraguay 5.69 5 87.87
England 6.27 5 79.74
Denmark 4.02 3 74.63
Serbia 4.23 3 70.92
Greece 4.28 3 70.09
Algeria 2.33 1 42.92
Honduras 2.85 1 35.09
Italy 5.95 2 33.61
France 4.18 1 23.92
Nigeria 4.39 1 22.78
Cameroon 3.96 0 0.00
N Korea 1.18 0 0.00