futbol

Women’s World Cup 2015 Predictions Spreadsheet

Ashley F. Miller, , , , , , , , 7 Comments
America... America... AMERICA, FUCK YEAH
America… America… AMERICA, FUCK YEAH

It’s been a helluva week on a personal level, but I’m completely stoked for the Women’s World Cup which starts Saturday.  All of the games are being shown on Fox, Fox Sports 1 or Fox Sports 2, and theoretically you can stream them through FoxSportsGo (I can’t get it to work) if you’ve got cable or pay $19.99 for a month of subscription to the online service FoxSoccer2Go — I’m waiting to buy mine until the last minute to make sure I get the final match in my month, because hopefully it works like that.

Anyway, before every world cup I like to do a FIFA spreadsheet that uses the FIFA rankings to predict the winners of every match.  This year I threw in the 538 rankings as well, and they actually did predict slightly different games.

https://docs.google.com/spreadsheets/d/17SG5zGHppxnFIV4VEilUMjTFBRA_oI7Ip_82FZOF4rw/

It’s worth noting that games never go the way my spreadsheets predict, they’re just a fun exercise in what “should” happen.  You can also download it and update it as games are played to predict based on actual results.  I will be doing that at least once, before the round of 16 begins.

Some cool takeaways: Continue reading “Women’s World Cup 2015 Predictions Spreadsheet” →

Women’s World Cup 2015 Predictions Spreadsheet
{advertisement}

Women’s World Cup 2011 Predictions

Ashley F. Miller, , , , , , , , , , 1 Comment

Group A Predictions Points
Germany (2) W W W 9 (first)
Canada (6) L T W 4 (second)
Nigeria (27) L L L 0
France (7) W T L 4

Germany has already beaten Canada, but France only beat Nigeria by 1, which is potentially good news for Canada. Canada doesn’t have to beat France outright, as long as there’s a bigger point spread between Canada and Nigeria. In fact, the only reason I’m picking Canada over France is the point deferential in the Nigeria game.

Group B Predictions Points
Japan (4) W W W 9 (First)
N Zealand (24) L L T 1
Mexico (22) T L T 2
England (10) T W L 4 (Second)

I’d love to see New Zealand tie England and then Mexico and New Zealand fight it out to go forward, knowing that if it’s a tie, England will move forward. That would be exciting!

Group C Predictions Points
US (1) T W W 7 (First)
N Korea (8) T L W 4
Colombia (31) L L L 0
Sweden (5) W W L 6 (Second)

I think the US is going to start weak, but then find its feet. I would actually like the US to come in second in this bracket, though I think assuming they’ll get out of it is an assumption. If they flat out beat N Korea tomorrow, I’ll feel a lot better about them, they’ve been pretty shaky of late. They could also easily lose or tie Sweden, meaning N Korea isn’t out of the running here.

Group D Predictions Points
Brazil (3) W T W 7 (First)
Australia (11) L W T 4
Norway (9) W T T 5 (Second)
Equatorial Guinea (61) L L L 0

Poor Equatorial Guinea. I’d love to see them tie someone. Or a beautiful upset of Brazil! That’s going to be by far the biggest difference in team quality of the tournement.

So if the games followed this prediction, we’d end up with the following matches.

Match 25
Germany vs England

Oh man, I always love Germany versus England, that’s always so great, such brilliant rivalry there. I think England doesn’t stand a chance, though.

Match 26
Japan vs Canada

Regardless of the second place Group A finisher, I have a hard time seeing any of them beating Japan this year.

Match 27
US vs Norway

This is the US game to lose, but that doesn’t really mean they won’t. Gosh, I’m awfully pessimistic about the US this year, I’m just not feeling the number 1 ranking at all.

Match 28
Brazil vs Sweden

I think this could actually be a good game. Brazil’s certainly got the advantage, but it would be a brilliant upset for Sweden to beat them. And it’s possible.

SemiFinal A/B
Germany vs Japan

Why do so many match ups remind me of WWII? I think this is easily Germany’s.

SemiFinal C/D
US vs Brazil

In my optimistic moments, I think the US could win this. In my pessimistic moments, I think it’s hopeless. It’s a close call, and I’m likely to revise my opinion seeing how the teams progress through the cup, but from here I’m going to say Brazil.

3rd Place
Japan vs US

The US has never placed lower than 3rd, we’ll see if they’ve got the ability to keep that true.

Final
Germany vs Brazil

How men’s soccer of them. I’d love to see Brazil win, as it hasn’t done so yet and it would lend more legitimacy to the Women’s Soccer program in a country where soccer is the sport.

Women’s World Cup 2011 Predictions

World Cup: Fun with Excel

Ashley F. Miller, , , , , , , , , , , , 3 Comments

First, here’s the link to the spreadsheet on Google Docs should you want to play.

Basically what I did is make a spreadsheet predicting the winners based solely on their FIFA rank.  It should be immediately noted that, in the past, FIFA rank has meant nothing.  The World Cup is high stakes game playing, and injuries, travel, exhaustion, and carding are all important.  So, the FIFA rank will probably end up being nearly useless at predicting games.  But it’s there and I have access to it.

If you’re unfamiliar with the way the World Cup works, I’ll explain.  It starts out with 8 groups (A-H) of 4 teams (32 teams total, 48 group matches).  Every team in each group plays each other (6 games), and whoever has the most wins in that group moves forward as 1A, whoever has the second most wins moves forward as 2A, the other two teams go home.  There are various tie-breaking things that inevitably matter as soccer is a very low-score sport, but the important thing is that every team has 3 games to prove themselves before getting kicked out.

Once a team has gotten through the group stage, it enters the knockout round, which means every game is win or go home.

Here are the games by group:

It’s fairly self-explanatory, but if you look at the last one: it’s game 48, held on 6/25, Group H, Switzerland has a FIFA ranking of 24, Honduras 38, so Switzerland to win by a 14 rank superiority.

Another interesting way of looking at the data is to group it by how closely matched two teams will be:

So, my guess would be that anything within 6 is going to be a close game, anything within 10 could easily go to the underdog, beyond 15 would probably require extremely extenuating circumstances to turn the game, and finally that N. Korea, S. Africa and New Zealand are probably completely screwed.

So, within each group there are some games that could turn out to be vitally important for the underdog to win to move forward, and where two teams are ranked closely enough that this is possible.

Mexico and Uruguay are extremely closely matched, with France significantly (but not unreachably) higher ranked, it’s likely going to be a fight to move on as 2A.  Likely, Uruguay will be coming off an easy win, and Mexico will be coming off a hard fought loss.

Australia could beat Serbia and move forward as 2D.

The only game in this group that looks even remotely close is Slovakia v Paraguay.  And fortunately for the drama, they’ll be fighting to stay in the competition.  Of course, getting to the knockout stage is probably all they’ll manage, but there’s no small pride in that.

It’s not super close, but the Americas often don’t do as well overseas, Switzerland could be the one to go forward.

So, using this same method, the rest of the Cup looks like this:

If it fell out like this, I tell you the last 9 games would be un-bloody-believable to watch.

World Cup: Fun with Excel

World Cup: Links

Ashley F. Miller, , , , , , 1 Comment

I’m sure you Americans (aka 90% of my readership) are like in total hate with me right now.  I’m sorry, this link is for you.

For you other crazy kids, I’ve got the super awesome calendar.  Seriously, it’s super cool, the information is so organized and sane, yet visually pleasing.

Then there’s this:

Running a little over 70 pages, it’s a remarkably in-depth summary of each country in this year’s finals, including football prowess, economic state, and political situation. Furthermore, it provides a primer on the potential hosts of the 2018 and 2022 World Cups, and, unsurprisingly but more than interesting, an examination of economic growth and decline vis-a-vis the international football teams of respective countries.

(Quote from here)

Do numbers and in-depth analysis with lots of charts turn you on drive you mad make you happy?  Then look at the dang thing, because it’s awesome.  And it has in-depth predictions of who’s going to win.

Also, this is the link to TNR covering the World Cup.

Next in my world cup coverage will probably be me explaining to you who I’m rooting for.  It’s complicated… sort of a hierarchical system rather than a “I want X to win”.  There may be maths and history lessons involved.

World Cup: Links

World Cup: Ashley Recommends These Games

Ashley F. Miller, , , , , , , , , , , , , , 4 Comments

Let us pretend I’ve spent no time on this and am merely grabbing some things out of a random hat.  The following are 6 games over the next few weeks that I think will be entertaining, in order of appearance, all times PST.

6/12 11:30 England (8) v USA (14)

England is hungry for another cup, but their line-up is a bit wobbly.  These two are probably competing for number 1 in their group, and will both make it out, but this game will show us if the US is going to actually do anything worthwhile and if England is going to make a real run to repeat ’66.

6/15 11:30 Brazil (1) v North Korea (105)

These are the two extremes; Brazil is FIFA rank number 1 and Korea DPR is number 105, the lowest in the competition by nearly 30.  Perhaps I’m a sadist, but this could be extremely fun to watch.  It probably helps that it’s really easy to hate North Korea, though there are some worries that there will be negative consequences for the players if they embarrass their dictator , so maybe it’s easy to root for the incredibly downtrodden underdogs?

6/17 11:30 France (9) v Mexico (17)

I generally think that the France, Uruguay, Mexico triad is going to be fun to watch, I think they’re very closely matched.  And I think my soft-spot goes to Mexico.

6/22 7:00 Mexico (17) v Uruguay (16)

These two are ranked 16 and 17, and it’s likely that this will be win or go home.  I suspect this will be a hard fought game.

6/22 11:30 Greece (13) v Argentina (7)

They’re closely matched in terms of talent, likely this will simply be for first, so not quite as much pressure, but I think we’ll see here if Argentina is going to be a real challenger.

6/25 7:00 Portugal (3) v Brazil (1)

Probably the most anticipated match of the knockout rounds.  Brazil, number 1, against Portugal, number 3.  Plus, they like speak the same language and stuff.

World Cup: Ashley Recommends These Games