{"id":1427,"date":"2012-06-20T21:07:34","date_gmt":"2012-06-20T19:07:34","guid":{"rendered":"http:\/\/www.theusrus.de\/blog\/?p=1427"},"modified":"2012-06-20T21:07:34","modified_gmt":"2012-06-20T19:07:34","slug":"the-good-the-bad-62012-euro-2012-statistics","status":"publish","type":"post","link":"https:\/\/www.theusrus.de\/blog\/the-good-the-bad-62012-euro-2012-statistics\/","title":{"rendered":"The Good & the Bad [6\/2012]: Euro 2012 Statistics"},"content":{"rendered":"

This one is almost too bad to present, but I could not resist:<\/p>\n

\"\"<\/p>\n

The pie chart shows the number of spectators for the past european soccer championships of the last 50 years – in a pie chart (found on an insert of the “11Freunde<\/a>” soccer magazine ).<\/p>\n

Now “the Good” is too obvious and thus too easy: a simple time series:<\/p>\n

\"\"<\/p>\n

Now that looks like a success story. An almost steadily increasing number of spectators bringing in the base cash flow from ticket sales (there are two hick-ups in 1968 \/ Italy and 1988 \/ Germany with extremely high number of fans seeing the matches).<\/p>\n

The story behind these number is easy when we look at the number of games played at each of the tournaments:<\/p>\n

\"\"<\/p>\n

The system was changed twice in 1980 and 1996 such that far more teams now compete and far more games are played accordingly.<\/p>\n

Looking at the number of spectators per game flattens the time series to an almost constant number of roughly 30,000 to 40,000 spectators per game – a number which is almost unchanged for the last 16 years:<\/p>\n

\"\"<\/p>\n

There are a several other interesting statistics on the insert, but let’s leave with these figures for now.<\/p>\n

Still a long way for the German team to go if they really want to be the champion this time, which I don’t happen to have a good proof for like 2 years ago<\/a> in the world championship – although I have something (even worse) in mind …<\/p>\n

(Sorry for making the graphs in MS Excel, but it was just the fastest …)<\/p>\n","protected":false},"excerpt":{"rendered":"

This one is almost too bad to present, but I could not resist: The pie chart shows the number of spectators for the past european soccer championships of the last 50 years – in a pie chart (found on an insert of the “11Freunde” soccer magazine ). Now “the Good” is too obvious and thus […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1427","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/www.theusrus.de\/blog\/wp-json\/wp\/v2\/posts\/1427","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.theusrus.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.theusrus.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.theusrus.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.theusrus.de\/blog\/wp-json\/wp\/v2\/comments?post=1427"}],"version-history":[{"count":6,"href":"https:\/\/www.theusrus.de\/blog\/wp-json\/wp\/v2\/posts\/1427\/revisions"}],"predecessor-version":[{"id":1433,"href":"https:\/\/www.theusrus.de\/blog\/wp-json\/wp\/v2\/posts\/1427\/revisions\/1433"}],"wp:attachment":[{"href":"https:\/\/www.theusrus.de\/blog\/wp-json\/wp\/v2\/media?parent=1427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.theusrus.de\/blog\/wp-json\/wp\/v2\/categories?post=1427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.theusrus.de\/blog\/wp-json\/wp\/v2\/tags?post=1427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}