The Honest Hypocrite: Simulating the winner of the 2015 Superbowl

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Thursday, 28 January 2010

18% Simulated Chance of winning money in the Playoff Fantasy Football pool

Posted on 09:39 by kajal singh
This year I have a roster (RDK1) that is currently in fifth place in the RKB Playoff fantasy football and in striking distance of first or second place and winning money in the pool. The goal is to determine the chances of that happening. The focus of this simulation is to answer the question "With only the Superbowl to go, will the RDK1 roster be in the money at the end of the playoffs?" and "What combination of player results does RDK1 need to be in the money and what is the chance that such an outcome will occur?"

Developing the simulation required the following steps and assumptions.
1.) Collect the data for each player or teams games for this season. Turnovers and touchdowns for DEF (and special teams); field goals and extra points for the kickers; passing and rushing touchdowns for the quarterback, wide receivers, tight ends; rushing touchdowns for the running backs. I will randomly select from this history to generate simulations of the Superbowl.
2.) Assume a player's performance in the Superbowl will be identical to their performance in one of the games they played in this season. If a player didn't play they get a zero for that game, except for the kickers for which I only have partial season data. This may decrease the points slightly, and is potentially a bad assumption.
3.) Kickers get their own field goals, but only get extra points equal to the touchdowns their team scores (actually all the rushing and defense touchdowns, but only the QB passing TD's to avoid double counting). Typically a game with field goals has less touchdowns, so decoupling the game history so that a game with a lot of touchdowns for the QB could be paired with a game with a lot of field goals for the kicker could result in a higher than expected points. Possible another poor assumption.
4.) Everybody (RB and QB) gets their rushing touchdowns, but passing touchdowns are awarded only if the quarterback throws at least one. There are instances in the game history of the QB's not throwing any. I really should assign each passing touchdown to a WR, TE, or RB or player not on the list but that is to complicated to program in excel. This may result in excess points, and is an expedient assumption.
5.) The score of the game is the field goals, rushing RD's, and only the quarterback's passing TD's to avoid double counting, and the defense/special teams touchdowns. This is slightly inaccurate since the passing touchdowns for the receivers are not all counted or double counted. The simulation still generates widely varying scores.
6.) Simulate many games by bootstrapping (selecting TD's or outcomes from each particular player's history this season. Add the points for each player to the rosters that have the players on them.
7.) Used the RANK() function to determine the places. Ties get the same rank using this function and the next ranks down are eliminated. For instance 3 first places get rank 1 and the next rank is 4. Rank is important to determine who is "in the money".
8.) As to the money, it is a fraction of the total collected from all of the rosters: 70% for first place, and 30% for second place. However, a tie for first divides the total money (100%) and there is no second, a tie for second with only one first divides the second place money, 30%, among the second place tied rosters. To be in the money RDK1 needs to be alone in first, tie first, or be alone or tied for second with only one first place roster ahead.



The rosters above show RDK1 roster in fifth place, but with enough similarities to other rosters both ahead and behind it that winning money in the pool will require some fine threading of the outcomes.

Remember that the focus of this simulation is to answer the question "With only the Superbowl to go, will the RDK1 roster be in the money at the end of the playoffs?" and "What combination of player results does RDK1 need to be in the money and what is the chance that such an outcome will occur?"

The histogram above (click for larger) shows the rank of the two top RDK rosters, RDK1 and RDK6 after the outcome of 20,000 simulations. The first red bar highlights the fraction of simulations with RDK1 roster in first place and in the money (alone or tied) at 1.4% of 5000 simulations. The green bar highlights the fraction of simulations with RDK1 roster in second place (alone or tied, with no first place tie) and in the money at 16.3% of 5000 simulations. RDK1 is in the money in about 18% of the 5000 simulations. RDK1 starts in fifth place before the Superbowl and can climb to first or slip to 13th place according to the simulations. There was some hope that RDK6 might have the potential to be in the money but from its starting point at 13th place, it never rises above 3rd place and can slip to 30th in the simulations.

Another way to look at this data is go ahead and calculate the winnings for each outcome.



This chart shows that the most likely outcome, 80%, is that RDK1 has no winnings, but the rest of the bars which add up to about 20% are various outcomes with winnings for the RDK1 roster.



This chart expands the Y axis to zoom in on the lower probability outcomes. There is a 10% chance of being alone in second place, a 4% chance of tieing second. There is even a less than 0.2% chance of being alone in first place. The less likely outcomes include situations in which I am tied with several others, up to 5 others, for first or, up to 7 others, for second. I need about 10% of the total collected to break even for the six rosters I entered.

Of course simulation generates outcomes for all of the rosters, otherwise I couldn't perform the comparisons needed to determine what place I am in or whether RDK1 roster will earn money. A less self-centered data reporting approach yields information about all of the outcomes.

The chart above (definitely click for larger) shows the histogram of the frequencies of the final rank after the Superbowl (simulated) of the top twenty rosters as they stand now(actual) before the Superbowl. The top twenty was chosen as a cutoff because it contains the lowest ranked roster that could win money in the simulations. The legend has the roster in their current ranking order (Cara H in 1st through RDK3 in 20th place). Bruschi Drink 3 ends most of the 1000 simulations in first with Tim G5 ending most of the 1000 simulations in second. there is a small but significant fraction of RDK 1 results in second place as we showed earlier. The chart will reward closer examination for the interested.

The information above can be used to determine the fraction of simulations (in this case, 5000) in which any given roster will be "in the money". The chart above shows that Bruschi Drink 3 is more than 80% likely to win some money followed by Tim G 5a at 42%. Almost a third of the time, Cara H in first place is likely to end up with some money. More annoying is that Bruschi Drink 4, a roster currently tied for 20th place, has a small but finite chance of being in the money. The results above do not total to 100% because more than one roster can be in the money (not just 1 and 2 but multiple rosters tieing for first, or one first place with multiple 2nds).

A compilation of the actual outcomes of each of 20,000 simulations can show the most likely particular outcome instead of the probabilistic compilations further above. The outcomes above compile the rosters in first or second place. Recall that in the case of a first place tie there is no second place.

As suggested by the charts further above, but shown directly in this one, the most likely first and second outcome at 22% is that Bruschi Drink 3 will be first with Tim G 5 second. The next most likely is heartening because it has Bruschi Drink 3 in first with RDK1 in second. Even so, these top twenty outcomes represent only 82% of the outcomes generated in 20,000 simulations. There are highly unlikely but predicted outcomes of all sorts, including some interesting ones with 6 tied in first place, or a first place with 8 tied for second, both only 1 time out of 20,000.

The RDK1 roster appears in these outcomes usually as a second place winner in the 2nd, 14th, 15th ,and 18th most likely outcome. You need to go down to the 17th most likely outcome to see RDK1 in first place, though it is tied with the ever successful Bruschi Drink 3.

Thus my final prediction is that Brschi Drink 3 will be in first place with Tim G 5 in second, though I am hoping for the 18% chance of RDK1, my own roster, being "in the money".
Email ThisBlogThis!Share to XShare to Facebook
Posted in fantasy football, modeling, playoff, simulations, statistics | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • Captains of the Axiom from WALL-E
    Captain Reardon 2105-2248 143 years Captain Fee 2248-2379 131 years Captain Thompson 2380-2520 140 years Captain Brace 2521-26...
  • Recreating Laffer's unemployment benefits payout vs. unemployment rate chart but not his ridiculous conclusions
    Howard points to an excellent refutation of the ridiculous claims by Laffe r that unemployment benefits drive unemployment. The chart fro...
  • Snow yesterday was fluffy
    The picture of the creek was taken while the snow was still falling. There was 5" on the pathway at 5pm yesterday. Amounts ranged up t...
  • Employment-Population Ratio - a scarier way to look at unemployment
    The Bureau of labor Statistics compiles a stat called the Employment-Population Ratio that is the number of people working of the available...
  • Tradescantia Blooming
    Just when you think a flower has washed away in the floods, or burned away in the droughts, or withered due to benighted neglect, they come ...
  • Wesley Snipes fan in Delaware
    Could this person be such a fan of Wesley Snipes that they have a BLADE II license plate to commemorate their favorite movie? Is there a co...
  • Autographed hot dog buns at Tony Packo's Cafe in Toldeo
    Tony Packo's Cafe in Toledo is world famous for it's "Hungarian hot dogs", which are really just hot dogs with a deliciou...
  • Oscar Meyer Wienermobile in Wilmington today
    The Oscar Meyer Wienermobile was at the Acme at Rt202 and Rt 141  north of Wilmington today. They let us go inside it.  I like the custom Wi...
  • My new band and its debut album
    Reddit has a make your own band and first album with artwork generator much like the one that I have done before . It's been so long si...
  • Focus not on the Rapture but on loving others.
    A Roman Catholic priest gives the right answer when asked , "How does the Rapture figure into your faith?" ...Essentially all of t...

Categories

  • 80's TV shows
  • 9
  • A-team
  • accident
  • actors
  • aircraft
  • airplane
  • allium
  • alphabet
  • aluminum
  • animals
  • anniversary
  • Apollo 11
  • art
  • astronauts
  • astronomy
  • auction
  • Baltimore Orioles
  • baptisia
  • baptist
  • Baseball
  • bathroom
  • bathroom remodel
  • Battlestar galacta
  • bee
  • Bensi
  • bicycle
  • biden
  • biology
  • bird watching
  • blogs
  • Blue Heron
  • books
  • Boxing Day
  • brachiopod
  • broadband
  • BSG
  • Caddyshack
  • calendar
  • cancer
  • car
  • carriages
  • cars
  • cartoons
  • caterpillar
  • charts
  • chemistry
  • cherry trees
  • Chicago
  • chicken
  • children
  • Chrysler auto plant
  • cigar
  • cigar rolling
  • cinema
  • clouds
  • color
  • comics
  • commentary
  • coprology
  • creationist
  • croatian
  • cuba
  • cucumber
  • curling
  • curveball
  • daffodils
  • data presentation
  • Dealware
  • Delaware
  • deldot
  • DeLorean
  • design
  • Detroit Tigers
  • dinner
  • drilling
  • Dupont Country Club
  • Easter Island
  • eclipse
  • economics
  • el lector
  • electric
  • elements
  • Escanaba
  • evolution
  • experiment
  • explosion
  • face blindness
  • fantasy football
  • father's day
  • fayette
  • ferns
  • fireworks
  • flash mob
  • flashlight
  • flooding
  • flowers
  • flowrate
  • flu
  • fluid mechnics
  • fossil
  • fox
  • fragrance
  • frog
  • frost
  • fun
  • funeral
  • furniture
  • games
  • garden
  • gardening
  • generations
  • generator
  • genetics
  • Ghostbusters
  • gifts
  • glass tile
  • golf
  • government
  • graffiti
  • graph
  • graphing
  • great egret
  • greenville
  • groundhog
  • groundhog's day
  • Guerrilla Drive In
  • H1N1
  • hard drive
  • health care
  • histograms
  • history
  • home maintenance
  • horses
  • hubris
  • ideas
  • IHM
  • Immaculate Heart of Mary
  • Incredible Hulk
  • Independence day
  • internet
  • ipod touch
  • iris
  • IRS
  • joe-pie weed
  • juniper
  • junk
  • Key West
  • knowledge
  • labor
  • Lake Michigan
  • language
  • LCROSS
  • lego
  • license plate
  • lily of the valley
  • Lincoln Park Zoo
  • linguistics
  • lobster
  • logging
  • love
  • lunar eclipse
  • magnolia
  • manhole
  • maps
  • March Madness
  • marching band
  • marketing
  • math
  • measurement
  • memory
  • meta
  • meterology
  • military records
  • modeling
  • modelling
  • models
  • Monarch Butterfly
  • monster truck
  • monte carlo
  • moon
  • mosaic
  • mountain
  • mountain ash
  • mouse
  • movie
  • movies
  • museum
  • names
  • NASA
  • NASA Wallops space
  • National Park
  • NCAA Basketball
  • network
  • New Castle County
  • NFL
  • NOAA
  • nodes
  • Norristown
  • Northern Water Snake
  • Northern Water Snake.
  • obama
  • panorama
  • parenting
  • parking
  • pencil
  • pennsylvania
  • peonies
  • personality
  • philadelphia
  • phillies
  • philosophy
  • pi
  • picture
  • pictures
  • Pillsbury Doughboy
  • Pittsburgh
  • playoff
  • Point to Point
  • polar bear
  • politics
  • preparation
  • president
  • probability
  • progress
  • prosopagnosia
  • psychology
  • Quantum Leap
  • quiz
  • raccoon
  • rain
  • reader
  • refinery
  • religion
  • remodeling
  • restaurants
  • review
  • reviews
  • robotic groundhog
  • robots
  • rock
  • rocket launch
  • rotisserie
  • Sagarin
  • satellites
  • saw mill
  • scat
  • Science
  • Science Fiction
  • scifi
  • screaming yellow
  • sculpture
  • separated at birth
  • Septa
  • sf
  • shellpot creek
  • signs
  • Simpsons
  • simulations
  • slime mold
  • slug
  • snakes
  • snow
  • snow chairs
  • soccer
  • solar eclipse
  • space
  • speed test
  • spider
  • spring
  • Spring Beauty
  • stars
  • State fair
  • statistics
  • storage
  • strawberries
  • sun
  • survival
  • t-shirt
  • tableau
  • taxes economics statistics sussex delaware
  • technology
  • television
  • terminator
  • test
  • tetris
  • time
  • time travel
  • titles
  • toad lily
  • tomato
  • traffic cams
  • transpass
  • travel
  • trees
  • trivia
  • truck
  • tuba
  • Tufte
  • tulips
  • tunnel
  • turnpike
  • twitter
  • unemployment
  • university
  • UP State Fair
  • urinal
  • V
  • vaccination
  • Verizon FIOS
  • video
  • Virginia
  • visualization
  • vocabulary
  • WALL-E
  • Wallops
  • Walt Disney World
  • war on children
  • weather
  • website
  • white heron
  • wikipedia
  • wilmginton
  • Wilmington
  • wine
  • winter solstice
  • Winterthur
  • wood
  • zoo

Blog Archive

  • ►  2015 (2)
    • ►  January (2)
  • ►  2014 (77)
    • ►  December (1)
    • ►  November (1)
    • ►  September (4)
    • ►  August (9)
    • ►  July (20)
    • ►  June (14)
    • ►  May (3)
    • ►  April (8)
    • ►  March (5)
    • ►  February (5)
    • ►  January (7)
  • ►  2013 (30)
    • ►  December (3)
    • ►  November (5)
    • ►  September (3)
    • ►  August (3)
    • ►  June (2)
    • ►  May (4)
    • ►  April (3)
    • ►  March (2)
    • ►  February (4)
    • ►  January (1)
  • ►  2012 (41)
    • ►  November (5)
    • ►  October (4)
    • ►  September (3)
    • ►  August (1)
    • ►  July (4)
    • ►  June (9)
    • ►  May (3)
    • ►  April (3)
    • ►  March (4)
    • ►  February (1)
    • ►  January (4)
  • ►  2011 (82)
    • ►  December (3)
    • ►  November (4)
    • ►  October (1)
    • ►  September (5)
    • ►  August (7)
    • ►  July (4)
    • ►  June (5)
    • ►  May (8)
    • ►  April (15)
    • ►  March (9)
    • ►  February (6)
    • ►  January (15)
  • ▼  2010 (129)
    • ►  December (6)
    • ►  November (2)
    • ►  October (3)
    • ►  September (6)
    • ►  August (15)
    • ►  July (20)
    • ►  June (8)
    • ►  May (7)
    • ►  April (15)
    • ►  March (10)
    • ►  February (22)
    • ▼  January (15)
      • 18% Simulated Chance of winning money in the Playo...
      • Who will win Playoff Fantasy Football Pool?
      • Cartoon about taxes by Rube Goldberg
      • Cajuns in PA? GEAUKRT license plate.
      • What military aircraft are you? Quiz.
      • University of Delaware auctions off former Chrysle...
      • Playoff Fantasy football arises again
      • Vice President Biden and President Obama in my nei...
      • If Obsession (with a new idea, book, author...) is...
      • That old tuba argument again
      • Aspiring to Tuftian perfection - presenting data
      • Cable Connector Quiz
      • Water burbling under the ice on Shellpot Creek
      • Shellpot Creek water fall not quite frozen yet
      • Happy New Year
  • ►  2009 (139)
    • ►  December (11)
    • ►  November (9)
    • ►  October (15)
    • ►  September (19)
    • ►  August (14)
    • ►  July (28)
    • ►  June (22)
    • ►  May (21)
Powered by Blogger.

About Me

kajal singh
View my complete profile