Sunday, September 27, 2009

Epic comeback

Quite the game in my NCAA '10 Dynasty. I'm returning Wyoming to their rightful glory and I go up against Texas Tech. At the half I find myself down 31-13 to the Red Raiders. I fight back during the third and by the start of the fourth quarter I have brought it back to a respectable 31-26 game. I get a key three-and-out and get the ball back in the middle of the fourth for what could be a game winning drive. I go the length of the field and complete a touchdown pass to my Heisman candidate WR making the score 32-31 in my advantage. I decide to go for a two point conversion to put me up by three points. But my pass is intercepted and returned 103 yards by Texas Tech. This gives them back the lead 33-32. I then have to kickoff to them. But my team is almost entirely white and they take the kickoff to the house to give them an 8 point lead. We are now down 8 with to 2:30 seconds left in the 4th when they kickoff to me. The kickoff is short and my Hiesman deserving WR makes a sweet juke and returns it himself for a TD. The 2 point conversion is good and the game is tied at 40. Lee Corso tells me this is why he loves college football.

They begin driving down the field and are almost in range of a game winning field goal when my All-American DT drives up the middle and hits the QB as he throws. My 77 overall MLB runs underneath it and picks it off. The game is now in my hands but all I need to do is drive the field and score, without giving them too much time to return the favor. I go no huddle and go 60 yards and get the touchdown on a 2 yard pass to my backup HB. I leave 10 seconds on the clock, but I make sure the ensuing kickoff goes out of bounds to prevent any returns. Texas Tech tries valiantly with their two remaining plays but ultimately falls to the hands of my tough as nail Wyoming team.

It is deemed the 7th best game to have ever been played on my Xbox 360. It is also the most exciting thing to happen to me this weekend.

Friday, September 25, 2009

Brian completes a survey.

I got a survey from my high school. It was a web based survey basically about my high school experience and what parts of it I use today. I anwsered everything truthfully until I got to the last three open ended questions. I couldn't help myself.

What would you have liked to learn in high school that you weren't taught?
2nd order differential equations, Critiques of gilded age post-romanticism art, Basic Rifle Marksmanship, Benford's law, The teachings of Jesus, Algebra, The fallacy of time travel in the Back to the Future series

What is the single best piece of advice you could give to a freshman beginning high school?
High school is 65% common sense, 10% hard work, 15% tomfoolery and 10% experimental drinking and sexual encounters.

Please describe a significant event in high school that made an impact on your life.
Once in 9th grade in order to get out of running during gym I decided to take a poo but there was no toilet paper and the toilet overflowed, needless to say it was miserable. Then one more time junior year, before a pep assembly I couldn't poo fast enough and instead of singing Hail to the Black and Gold, I spend the entire time making a mess in the toilet. It was possibly the foulest thing that has ever occurred. Since then I have been afraid to void my bowels in public. It is a determent to my professional career and physical well being.

I wonder if they are going to discount my entire survey. To be truthful my second answer is actually not the far off. But 10% hard work is pretty generous. That is unless your an idiot.

Tuesday, September 15, 2009

Youtubes Letdown

368 days ago I uploaded a video to Youtube. I then blogged about it. It has been 368 days and my goal was to have 10,000 views in the first year. My goal for next year is 20,000 views by September 10, 2010.

On a related note, the other video I uploaded is hanging in there with 234 views. My goal is 1,000 by March 27th, 2014.

Tuesday, September 8, 2009

NFL Team Analysis

Last night I finished my lengthy analysis of my calculated expected wins vs, Vegas odds. But while I was typing up this post I started to realize that teams bye weeks weren't lining up with this season schedule. Then I realized that I had done my analysis using the 2005 NFL schedule. Which means I had to redo everything. But all the information from the first post is still accurate. Again, the theme was bet on unders, and most likely there will be more teams that finish with less than 5 wins than Vegas predicts.

Tonight I redid part of my analysis, but unfortunately I didn't not have time to analyze every team, but I focused on teams that were expected to go under .500 and that had decent payouts.

After spending many additional hours developing odds for each team I am disappointed to realize that my analysis indicates that one of the safest bets is betting against the Detroit Lions. This greatly disappointments me.

My method was to determine a teams chance at winning by taking the square of the teams expected wins and dividing by the sum of both teams expected wins. So the odds of a home team winning are Home^2/(Home^2+Away^2). So if the home team was expected to win 7 games and the away was expected to win 11, the home teams chance of winning would be 7^2/(7^2+11^2) or about 29%. Using this I ended up with each teams expected number of wins. I then compared them to the over/under odds for that team. In my last post I determined that betting unders is the way to go, because there cannot be 132 wins amongst the 32 teams and there will be a few ties sprinkled in there too.

Here are 3 Under picks that I might consider making.

Detroit Lions, O/U: 4.5, Expected Wins: 3.62, +105
From the numbers it is quite easy to see why there is no likely way this team wins 5 games. They are only playing four teams that are expected to have sub .500 seasons. There opponents are expected to win 8.43 games on average. In order to get the 5 wins they are going to need to beat the four bottom teams they face. But even their computed odds of beating their weakest opponent (St. Louis) is 28%. There odds of winning all 4 is 0.5%. Like I said before, I would be surprised if the worst team in the league gets 5 wins. Plus this bet has a positive payout of $105 for every $100 bet.

Tampa Bay, O/U 5.5, Expected Wins : 4.61, +105
I would write an entire paragraph on how Tampa Bay isn't going to win a single game because they have absolutely no offense. But I'm here to look at quantitative numbers not qualitative. Tampa Bay is only playing ONE team that is expected to go under .500. That team is Miami who is expected to have 7 wins, but maybe you should hold off on this until you finish the entire post. To win this bet Tampa Bay has to win at least 6 games. My calculations indicate that Tampa has about an average 30% chance of winning any given game. Also this is another bet with a better than 2:1 payout.

Miami, O/U 7, Expected Wins: 6.32, +100
Miami doesn't have as much of a difference between my expected number of wins and the Vegas line, but it is still rather large. Miami is playing three games against opponents slated to win less than 8 games, but two of the are the Jets who are expected to win 7.5 games. The real thing to look at is Miami's overall opponents who are picked to win an average 8.84 games. That's some stiff competition for a team trying to win 7 games. Miami only plays one team which is expected to be worse than it, and that is Tampa Bay. For this bet to lose Miami would have to win 8 games in a division where every other team is expected to be better than you. Note: this bet offers even pay.

The one vital aspect to these last two picks are that the teams have to play each other. Not only do they have to play each other, but they are each others easiest game of the season. Both teams are counting on the win to get above their over/under. Miami will not win 7 games with a loss against Tampa Bay, and it will be equally hard for Tampa to win 5 without getting the easy one against Miami. This game should serve as to cover one of the two bets, and then if the winning team doesn't beat their O/U you have a double payout. If these two teams tie, I will be a very happy man.

Again, the great thing about these three bets is that they pay even money or better. Usually in sports betting you have to put up 110 for every 100 you want to win. So these bets should earn some cash.

Initial NFL Betting Analysis

As you all must know, I spend a lot of my spare time doing useless analysis.

But occasionally my statistical analysis can make me money. I spent so much time researching Big Ten college football teams that I've barely had time to look at NFL. I don't like betting NFL games. Mostly because both teams are very well figured out and the odds makers are much more accurate than college football. In College Football I have the edge because I can spend more time evaluating each team in a match up that the guy who has to handicap 60 games. But the only thing about NFL betting that really interests me is betting on regular season wins. Because sport books put out lines on all teams it is possible to look at each team compared to the strength of each team they face. Eventually you create a spreadsheet with each team and the expected wins of each team they play and that looks like this.

And now you can analyze each team compared to the teams they play. I'll do this analysis over the next few nights. A few drawbacks of this analysis are that; each opponent plays different teams and each team has a different strength of schedule which affects their line, the amount you have to risk to win $100 varies with each bet. I.E. right now you have to bet $135 on the lions winning 4.5 games to win $100, but you only have to bet 95 on the Lions winning less than 4.5 games to win $100. So the lines don't necessarily match up evenly.

But the only analysis that I have done is on some overall numbers, comparing predicted outcomes to last years actual outcomes.


The first row of this chart shows that teams are on average overvalued by an eighth of a win. There have to be equal amounts of wins and losses. The reason for this is that there are lots of casual bettors that will bet their team to win more games regardless of the O/U line.

The other noticeable thing about this chart is that there are a lot of teams that are expected to go over .500. This is possible and reasonable, but in order for this to happen there have to be a lot of above average teams and there have to be a good number of terrible teams. But the odds makers are predicting that there aren't. For last year to have 16 teams go over .500 there were 6 teams that achieved less than 5 wins. But this year the bookmakers expect 18 teams to go over .500 with only one team getting less than 5 wins. Either they're expecting all the teams under .500 to go 5-11 or 6-10 or people should start betting the unders.

Also only one team getting over 11 wins? Over the last 5 regular seasons there were an average of 4.6teams getting more that 11 wins a season. Maybe betting overs on some Superbowl favorites is in order.

Overall it appears that the odds makers are coming out pretty conservative. Last year there were 11 teams with over 11 wins or less than 5. Initial lines for this year have only 2 teams falling in those categories. Perhaps tomorrow I should also look at what the lines looked like going into last season.

Wednesday, September 2, 2009

Brian Analyses his Fantasy Football Draft

We just had our fantasy football draft and I've spent most of the night analyzing the results. Sometimes I think I do more engineering work at home than I do at the actual work. For reference my team is Power Dump. I'm sure you remember my team from last year.

I went through each team and looked at how their picks compared with average player picks. So for example Nick picked up Carson Plamer with the 68th overall pick. So far this year Carson Palmer has been taken with the 90.3 pick on average. So I took each teams average picks along with the average draft pick and compared them. I decided that many times the later rounds don't matter as much and people generally use those picks on risky players and players that won't really impact the team. So I also compared the first 12 rounds to drop out any crazy outliers from the final 5 rounds.

The average pick is the your average overall pick for those rounds. If you had a later picks then your average pick is obviously higher than someone who picked early in the draft. This accounts for the first 5 rounds being perfectly even. [We do a keeper league so the first 5 picks are preselected -ed] The average selection is the average overall pick that your players went for in all of Yahoo drafts.

IN DRAFT ORDER here are the results:

Fuck you Brad Watson
FIRST 12 ROUNDS:
Average Pick - 46.5
Average Selection - 54.5
FIRST 14 ROUNDS:
Average Pick - 54.3
Average Selection - 62.9
OVERALL
Average Pick - 66.0
Average Selection 70.9

Power Dump
FIRST 12 ROUNDS:
Average Pick - 47.0
Average Selection - 50.3
FIRST 14 ROUNDS:
Average Pick - 54.,9
Average Selection - 55.5
OVERALL
Average Pick - 66.7
Average Selection 64.7

Caketown Spartans
FIRST 12 ROUNDS:
Average Pick - 47.6
Average Selection - 46.0
FIRST 14 ROUNDS:
Average Pick - 55.5
Average Selection - 56.8
OVERALL
Average Pick - 67.4
Average Selection 67.1

CMU
FIRST 12 ROUNDS:
Average Pick - 48.2
Average Selection - 50.3
FIRST 14 ROUNDS:
Average Pick - 56.2
Average Selection - 56.1
OVERALL
Average Pick - 68.1
Average Selection 66.7

*Nick you did really well drafting the last 5 rounds. All your picks were below their average pick.

Shit
FIRST 12 ROUNDS:
Average Pick - 48.8
Average Selection - 57.4
FIRST 14 ROUNDS:
Average Pick - 56.8
Average Selection - 64.3
OVERALL
Average Pick - 68.9
Average Selection 75.3

Cougar Cornbread
FIRST 12 ROUNDS:
Average Pick - 49.4
Average Selection - 53.8
FIRST 14 ROUNDS:
Average Pick - 57.5
Average Selection - 59.5
OVERALL
Average Pick - 69.6
Average Selection 70.0

*Evan you also did rather well for yourself in the last 5 rounds

Go Blue
FIRST 12 ROUNDS:
Average Pick - 50.0
Average Selection - 48.0
FIRST 14 ROUNDS:
Average Pick - 58.1
Average Selection - 66.3
OVERALL
Average Pick - 70.3
Average Selection 74.4

Believe in Now
FIRST 12 ROUNDS:
Average Pick - 50.5
Average Selection - 47.2
FIRST 14 ROUNDS:
Average Pick - 58.8
Average Selection - 56.7
OVERALL
Average Pick - 71.0
Average Selection 66.7


So who had the best draft?

That is subjective to how much you value late round picks. But since it is my belief that the first 12 rounds are the ones that really matter I've computed the delta between the average pick and average selection to come up with a best draft ranking.

Best Draft Rankings:
1. Believe in Now (-3.3)
2. Caketown Spartans (-1.6)
3..CMU (+2.1)
4. Power Dump (+3.2)
5. Cougar Cornbread (+4.5)
6. Go Blue (+8.0) TIE
6. Fuck You Brad Watson (+8.0) TIE
8. Shit (+8.6)

Now we can look at who has the best team by average draft pick.

Best Team First 12 Rounds:
1. Caketown Spartans (46.0)
2. Believe in Now (47.2)
3. Power Dump (50.3) TIE
3. CMU (50.3) TIE
5. Cougar Cornbread (53.8)
6. Fuck You Brad Watson (54.5)
7. Shit (57.4)
8. Go Blue (58.0)

Finally we can rank the best teams overall.

Best Team Overall (All Rounds):
1. Power Dump (64.7)
2. Believe in Now (66.7) TIE
3. CMU (66.7) TIE
4. Caketown Spartans (67.1)
5. Cougar Cornbread (70.0)
6. Fuck You Brad Watson (70.9)
7. Go Blue (74.4)
8. Shit (75.3)


Note: This analysis doesn't include any transactions made after the draft.