How I picked my bracket

My March Madness bracket fails too early too frequently. After hearing about Nick Dopuch’s CoinFlipBets as a way to determine which teams would win football games, I decided to try my hand at creating a bracket with random selections.

Flipping a coin 63 times isn’t difficult. However, it is error-prone, as it may depend on if you start the coin as heads-up or tails-up and other issues.

So I used the =rand() function in Excel.

The drawback of =rand() is that every time Excel does anything afterward, the cells that contain =rand() produce a new random number.

I decided to run all 63 at once and then copy and paste values.

Because these operations made me lose the first number, I jotted that one down.

I then made an A or B formula where if the random number is great than 0.5 on the 0-to-1 range, show a B; otherwise show an A.

A’s represented the team written physically above its opponent in the bracket. The B’s represented the team written physically below its opponent in the bracket.

The random A or B would determine how I would mark my bracket.

For the championship game between 15 Iona and 8 Loyola Chicago, I divined Loyola Chicago’s score of 72 over Iona’s 68.

As of Friday afternoon, this hasn’t worked perfectly. But there’s a ton of basketball left to play!

This entry was posted in Off Topic and tagged , , , on by .

About raabidfun

I'm a guy living the #raabidfun lifestyle. I figured I would create a blog about crossword puzzles I do. The idea is to do the NYT crossword and the WSJ crossword daily as much as I can. That includes when I don't finish and have clearly failed. They can be difficult. Also I am not an attorney, and any legal analysis in this blog reflects my interpretation, which means it can be flawed and should not be relied upon for use in legal matters (especially against me).

Leave a Reply