World Cup analysis of knowledge of the crowd

After group stage of the World Cup, we have a lot of data we can evaluate and find out how good Steemit's collective guess was. The median number of points is 24 - half of users is under it and half is over - while average guess constructed by choosing most likely results according to the users gained 29 points and the best guess had 3 more points.
If you choose your results according to Steemit's average, you 94,75 % of users are behind you which is well above 50 % you should get randomly.

Distribution of points after group stage.

Number of users ahead of Steemit's average changing after each match.

The worst result for Steemit's average was Poland's loss against Colombia which 39 % expected to win, 27 % to lose and 34 % tie which was also our recommendation.

The best result for Steemit's average which helped it move ahead of lot of others was Australia's loss against Peru that was expected by only 42 %, while 34 % expected them to win and 25 % tie.

How to pick my teams to win?

The next stage requires you to choose also a score after regular time rather than only a winner and by guessing score right, you get 3 points and 1 point for guessing right a winner. This means that by guessing score a tie e.g. 2:2, you will get either 3 points or none meanwhile guessing 2:1 will also guarantee you at least 1 point for scores 1:0, 2:0, 3:1 and so on. You should not choose tie so that you increase your chances. The next step to choose a score is to look at Steemit's data. Let's assume that we have results 2:1, 1:0 and 0:8. We could compute average and get 1:3 but much better is to choose median so you get 1:0 (median is the number in the middle when you sort numbers from lowest to highest). If median leads to tie e.g. 2:2 we will look at the second most common score.

Exp score = expected score calculated as median on Steemit.

*The best guess differs from median so that we avoid ties.

Conclusion

Choosing according to Steemit's average increased you chance to 94,75 % in group stage so it is a good idea to keep guessing according to the data.
Most people expect the group winner to also win their match except Uruguay vs Portugal and Colombia vs England and most common result is 2:1.

Tools and Scripts

Data from Steemit were downloaded through great library Ditch. The json parsed data can be found in the repository below.

Repository

https://github.com/petermail/worldcup_steemit