I learned how to write a Monte Carlo sim in Excel
Who says nothing good came out of the epic Sox collapse of aught-eleven?
Here’s your data. To make things a little cleaner, I’m not using as many different team quality scenarios. I have the pessimistic scenario, wherein the Sox are a terrible club (.48 ExpWP), and the Rays and Angels are very good (.6 and .57 ExpWP), I have the BPro W3% scenario, where the Sox at .61 lead the Rays and Angels at .57 and .53, and a parity scenario where the Sox at .55 are a bit behind the Rays and Angels at .57. The Monte Carlo sim also allows me to put precise numbers of each of the possible tying scenarios, so I’m listing the probably of each individual outcome. The percentages are based on running 10000 simulations of the season, using the log5 method for each team-game.
These numbers have been updated from the initial post. There was a small mistake in a few of the calculations which has now been fixed. Things look a teensy bit better after the error was corrected.
BPro W3% (Sox .61, Rays .57, Angels .53)
79% Sox
6% Rays
1% Angels
11% Sox-Rays
2% Sox-Angels
0.3% Rays-Angels
1% Doomsday Three-way
Parity (Sox .55, Rays .57, Angels .57)
71% Sox
9% Rays
1% Angels
12% Sox-Rays
4% Sox-Angels
1% Rays-Angels
2% Doomsday Three-way
Pessimistic (Sox .48, Rays .6, Angels .57)
58% Sox
16% Rays
2% Angels
17% Sox-Rays
4% Sox-Angels
1% Rays-Angels
3% Doomsday Three-way
That is the state of the spreadsheet on the morning of September 23, 2011.
Matt Clement of Alexandria
Posted: September 23, 2011 at 12:00 PM |
120 comment(s)
Login to Bookmark
Related News:
Reader Comments and Retorts
Go to end of page
Statements posted here are those of our readers and do not represent the BaseballThinkFactory. Names are provided by the poster and are not verified. We ask that posters follow our submission policy. Please report any inappropriate comments.
I'd put the Red Sox, as currently constituted, somewhere between #2 and #3, which means they have about, what, a 60% chance to take the Wild Card outright? Yikes, that is way too low for comfort. Well, at least we have two more starts from Lester and 1 from Beckett. I'm going to work hard to force my brain to believe in their long-term performance as opposed to the sense of doom I have based on their last few games. :)
Part of the reason I've been freaking out for awhile is while I expected the Sox to play poorly I thought the Rays were well poised to get on a run with that pitching staff. Instead, they've been kind enough to #### the bed in their own right. Other than Red Sox games they've played sub-.500 this month which has really saved our bacon.
I'm still not confident even in the slightest but I feel more optimistic than I have in a couple of weeks. I feel like Tampa and the Angels have really missed their chance to catch us. I'm thinking 3 wins is a good thing and 4 gets us home.
Of course, if they just manage 2 wins, TB still has to go 4-2 to tie, 5-1 to win it outright, so unless there is a complete collapse (and I wonder what the odds are of a 0-6 end to the season?), it would still seem likely that, at worst, there will be a playoff game with someone.
That could be a mess. The Sox have Wakefield starting on Saturday, the Angels have Jerome Williams and the Rays haven't announced though it should be Wade Davis' turn. Any playoff would be setting up as a 10-9 affair. I don't know if that favors the Sox or not.
Still, though, the Sox really need to win three.
Concur. Lester-Garcia is a great matchup for the Sox. If they lose this one, the sweep looms large.
But then again, you can't predict baseball.
Hahahaha.
http://www.nypost.com/p/sports/yankees/catcher_doesn_hide_his_hate_2ozRwDe9UzGh76t6e9vIJJ#ixzz1YmaJpwfA
Yeah, this sounds more like standard "I know how to say something the fans will love" than anything else to me.
I would argue that not having Martin turned out to be a positive at least long term. I think if Martin had been in the fold the Sox would have been more likely to go to him when Saltalamacchia started the year playing like crap. I think with Varitek the Sox knew that he was simply not an option as a regular so they kind of had to stick with Saltalamacchia which has turned out to be a good thing.
Boston's nightmare scenario, I assume, would be to start the game and use Lester for 3-4 innings in a game that ends up being rained out. I have no idea if that kind of thing is taken under consideration.
Nope, Boston has no say. The Yankees decide when to start the game, then the umps have control.
Is this true this weekend? I thought that for the last visit to a city the series fell under the control of MLB.
I think both MLB and the Yankees DESPERATELY want this series played. No one except the Red Sox wants a situation where the Sox are playing a meaningful game on Thursday against a lineup that would make last night look like the '27 Yankees.
you watched the 2004 ALCS without noticing who the Sox came back against?
Never heard of that. Do they have someone in attendance at every stadium to monitor field conditions, etc.?
So, why don't they let the umps decide all the time?
For example, if you think Boston's a .520 team right now, doing something like making a list of, say, .480, .481, .482, .483 to say, .560 and ordering excel to choose a random number from that list for each iteration will give you more varied results (I'm pulling the numbers out of my ass as an example).
Generally, you want to have some of a range, because when "true" probabilities are unknown, the error range of that probability should leave, when done right, a more fat-tailed distribution than you would see when monte carloing out coin flips.
;)
What is that? Avg. game time?
I thought it was Opponents' batting average...
BPro W3% (Sox .61, Rays .57, Angels .53)
79% Sox
7% Rays
1% Angels
11% Sox-Rays
2% Sox-Angels
0.3% Rays-Angels
1% Doomsday Three-way
Parity (Sox .55, Rays .57, Angels .57)
71% Sox
10% Rays
2% Angels
12% Sox-Rays
3% Sox-Angels
1% Rays-Angels
2% Doomsday Three-way
Pessimistic (Sox .48, Rays .6, Angels .57)
57% Sox
17% Rays
2% Angels
16% Sox-Rays
4% Sox-Angels
1% Rays-Angels
3% Doomsday Three-way
It very slightly increased the chances of the Rays and Angels, but by really half a percentage point here or there. Have you found a larger effect in other studies? Is maybe the fact that it's only six games hiding the effect? Or, I dunno.
The Rays and Angels losses last night did wonders for the probabilities in the sim.
BPro W3% (Sox .61, Rays .57, Angels .53)
89% Sox
3% Rays
0.2% Angels
7% Sox-Rays
1% Sox-Angels
0.1% Rays-Angels
0.5% Doomsday Three-way
Parity (Sox .55, Rays .57, Angels .57)
84% Sox
4% Rays
0.5% Angels
9% Sox-Rays
1% Sox-Angels
0.2% Rays-Angels
1% Doomsday Three-way
Pessimistic (Sox .48, Rays .6, Angels .57)
74% Sox
9% Rays
0.5% Angels
13% Sox-Rays
2% Sox-Angels
0.5% Rays-Angels
1% Doomsday Three-way
Are you ####### joking, Francona?
The only huge second-guess I have, in hindsight, and I think its hard to argue with, is the assertion
that Aceves ought to have been moved to the rotation after the Beckett injury when they were down to Lester,
Weiland, Lackey, Wakefield and Miller. And at least at that point, if not sooner.
If Wakefield pitches a great game and the Sox win tomorrow, I will be as surprised as I have ever been at a
single sporting event's outcome. Lackey, slightly less so, for some reason.
But screw 'em. I withdraw my support. I'd rather have the bet money at this point.
Whoever doesn't get the WC is going to look back with a lot of frustration.
Yup, that sums up my feeling pretty well.
To be honest, I do think if they fully collapse and not make the playoffs then Francona won't be brought back. At this point, I think we need a new thread: Who will replace Francona?
Does this include tomorrows guaranteed two losses?
I've heard Valentine's name mentioned... which would be a clusterduck of epic proportions. I'm hoping/praying there's nothing to that.
And even if Theo does leave or get fired, I imagine not much will change in regards to the FO strategy. Either Cherington will take over or they'll bring back Byrnes or something. It's not like they're going to go hire Ned Colletti or Andy MacPhail or some other baseball lifer. It's still going to be a saber guy.
and... update - the numbers are just about exactly the same as they were yesterday morning when I posted the thread:
BPro W3% (Sox .61, Rays .57, Angels .53)
77% Sox
7% Rays
0.5% Angels
13% Sox-Rays
1% Sox-Angels
0.3% Rays-Angels
1% Doomsday Three-way
Parity (Sox .55, Rays .57, Angels .57)
71% Sox
9% Rays
1% Angels
14% Sox-Rays
2% Sox-Angels
1% Rays-Angels
2% Doomsday Three-way
Pessimistic (Sox .48, Rays .6, Angels .57)
59% Sox
14% Rays
1% Angels
18% Sox-Rays
3% Sox-Angels
1% Rays-Angels
3% Doomsday Three-way
BPro W3% (Sox .61, Rays .57, Angels .53)
59% Sox
15% Rays
0.5% Angels
22% Sox-Rays
1% Sox-Angels
0.5% Rays-Angels
2% Doomsday Three-way
Parity (Sox .55, Rays .57, Angels .57)
51% Sox
19% Rays
1% Angels
23% Sox-Rays
2% Sox-Angels
1% Rays-Angels
3% Doomsday Three-way
Pessimistic (Sox .48, Rays .6, Angels .57)
40% Sox
27% Rays
1% Angels
24% Sox-Rays
2% Sox-Angels
2% Rays-Angels
4% Doomsday Three-way
Choking (Sox .40, Rays .57, Angels .53)
32% Sox
34% Rays
1% Angels
24% Sox-Rays
2% Sox-Angels
2% Rays-Angels
5% Doomsday Three-way
BPro W3% (Sox .61, Rays .57, Angels .53)
75% Sox
7% Rays
18% Sox-Rays
0.1% Sox-Angels
0.2% Doomsday Three-way
Parity (Sox .55, Rays .57, Angels .57)
70% Sox
8% Rays
21% Sox-Rays
0.1% Sox-Angels
0.3% Doomsday Three-way
Pessimistic (Sox .48, Rays .6, Angels .57)
60% Sox
13% Rays
26% Sox-Rays
0.1% Sox-Angels
0.5% Doomsday Three-way
The Angels loss this afternoon takes them just about entirely out of this thing.
Holy crap, if that truly happened and it was a media guy (or gal) that is incredibly unprofessional. It is a known courtesy (if not league rule, anyone know?) that pitchers are not spoken to on their day to pitch.
Here's September splits (not including Sunday) from BB-REF, sorted by OPS:
Player  G; GS  PA; AB  BA;  OBP;  SLG;  OPS; BAbip tOPS+ sOPS+
Gonzalez 21 21  88; 72 .333 .455 .583 1.038 .426 117  186;
Ellsbury 22 22 104 95 .358 .404 .611 1.014 .361 121  177;
Scutaro  21; 20  87; 74 .378 .429 .527 .956 .391 152  164;
Crawford 18 17  71; 67 .299 .338 .493 .831 .388 134  127;
Ortiz  21; 21  86; 73 .288 .395 .384 .779 .333  68;  118;
Pedroia  22; 22  94; 90 .267 .287 .467 .754 .292  74;  105;
Why on earth would a player ever give his cell # to a member of the media--for any reason? I accept some players may do this; there's not a snowball's chance in hell I ever would.
He/she works for Murdoch?
Red Sox John Lackey Divorcing Wife Battling Cancer
http://www.tmz.com/2011/09/26/john-lackey-divorce-boston-red-sox-krista-lackey-breast-cancer-playoffs-wild-card/
The divorce certainly puts a new, weird spin on the story of Lackey's horrible no good very bad year.
Did you use VBA or were you able to do it with Excel only? Nice work, regardless.
Without knowing more, I'm not going to say anything about the filing, but I don't understand what Lackey hoped to gain by calling attention to the TMZ inquiry.
Must be Yankee fans.
I'm more than a little disturbed by this kind of stuff going on.
Papi and Manny's names on the steroid list? Leaked by a Yankee fan.
Bedard gets served papers? The guy shows up in Yankee uniform.
Lackey gets a text right before game start? I'm sure a Yankee fan was involved somewhere.
Evil Empire my ass. This would be like if Darth Vader used a bunch of bounty hunters instead of the Empire's immeasurable resources.
I imagine he was pissed at being contacted the way he was by a member of the media. Lackey's not exactly a press friendly sort to begin with and this season isn't likely to have improved that relationship. This event is definitely not going to leave him feeling warm and fuzzy.
If you are that pitiful that all you have is to make fun of Gwyneth Paltrow because she has cellulite on her thighs or whatever then just go #### yourself.
Wait a minute...
OK, but what did he hope to gain by calling attention to it? And by suggesting that it may have been the baseball media that contacted him? And by referring to it as a personal matter without further explanation? Lackey just made his divorce filing a bigger story.
I have to disagree with Craig here. If Lackey has valid reasons for divorcing his wife, they should be in the divorce filing.
"the marriage has become insupportable because of discord or conflict of personalities." is not enough to divorce your wife while she stricken with cancer.
Why?
That's not how it's always done. It's also possible that Lackey and his wife have already worked out a settlement. I just wouldn't jump to any conclusion, either way. However, I do think Lackey was, at best, remarkably unsophisticated in raising the issue how he did.
Because generally, folks want to make the best divorce case possible. Especially when seeking to uphold a pre-nup, and maintain "separate property".
If she cheated, or beat their kids, or abused him, he'd include that b/c he doesn't want to pay, and he doesn't want to look like an ass for divorcing his cancer stricken wife.
And if she's divorcing him and he's just handling the paperwork? If their parting is completly amicable? If the cancer is completly in remission? If she's terminal and her bucket list includes "Boning the 1989 Yankee roster", and he can't get behind that?
Maybe, and I am going out on a limb here, Lackey was pissed off at the media and lashed out at them in anger without considering the repercussions of said lash out. You know, sort of how pretty much all arguments go? Start off reasonable, get pissed, get more pissed, say something you shouldn't...
Not everything has a deeper meaning.
If Lackey is divorcing his wife it is none of your ####### business.
Look, I think people get divorced far too readily these days but I think the legal terminology here probably sanitizes the situation. I'm guessing legal documents won't include phrases like \"##### is ####### crazy" or "mouth-breathing jackass needs to be neutered."
Yeah, let's pass judgment on people we don't know personally and situations we have zero actual first hand knowledge of. How very Christian of you.
I can't be 100% sure, and I don't know where they are getting divorced, but I'd bet a lot of money that that is the language used for no-fault divorce in the state where they are getting divorced. No state, now that New York has added "irretrievable breakdown of the marriage" requires proving the grounds of fault anymore in divorce, simply that one side say the marriage has broken down for a sufficiently long period. Even in places where the husband has been an abusive #######, or there is infidelity, it is unlikely that will come in to prove the grounds of divorce. It may come up when looking at custody, or something like that. In New York they even have a script where you just answer yes or no to prove the grounds of the divorce.
It seems to me that it's very possible that Lackey is deeply and horribly in the wrong, in this divorce case. It's probably the most likely scenario, if we're approaching things from a purely statistical standpoint. Of course, John and Krista Lackey are individual people with a relationship that none of us know. I don't think it's right to judge them, morally, based on the level of information we have.
My hope is that this is amicable, that this is the best for the children, that all parties involved are experiencing as little suffering as possible.
And I'm incredibly resentful that I've been forced to defend John Lackey.
I need a shower.
Whatever is actually the case, you've already jumped to a conclusion with no basis in fact. You're saying Calcaterra is wrong essentially because there is enough information in the public realm for us to judge, and you back that up by citing a lack of information in the public realm. I don't know if Lackey is a monster, but Calcaterra has it absolutely right.
Well, traditional Christianity doesn't recognize the possibility of divorce (beyond a civil separation), so requires a good reason to separate (not just, "we don't want to be married anymore").
I'm not judging the man's soul, saying he's damned (that's what the Bible quote is about). I'm judging his actions, which look pretty shitty.
You are making a specific and unargued theological claim when you say that a particular strand of Christian tradition which forbids divorce is uniquely "traditional."
I was hanging out with some Yankees fans this weekend and they all wanted Boston to miss the playoffs. Now, part of that was them wishing embarrassment on the Sox and their fans, but part of it was they didn't want the Sox in the playoffs and would rather face Tampa in a potential LCS because of illogical fear. Ten years ago or less, it would be unthinkable that Yankee fans would have a fear of Red Sox' playoff mojo. Having this thought occur to me is only enjoyable Sox-related thing right now.
Are you speaking about the "Pauline privelege"? That is a very narrow exception that allows a bishop to dissolve a marriage in favor of the faith. That has nothing in common with our modern conception of divorce and remarriage.
Both the teachings of the Catholic and Orthodox churches only provide for a second marriage (while the first spouse lives) because of some defect in the first marriage. Catholics call this a "decree of nullity", Orthodox allow it "in economia" b/c the first marriage was never spiritually completed (or some such reasoning). While both practices may be abused, both Churches uphold the indissolubility of marriage.
Dominant, historical traditions in Orthodox and Catholic Christianity don't recognize divorce. Calling these traditions exclusively "traditional Christianity" is a theological claim, not a historical or descriptive one.
This is to what I was speaking. You're ready to pass judgment on another person's actions based on a few lines you read on the internet, about something you, again, have zero first hand knowledge.
Anyway, last night I was also at dinner w/ a bunch of Yankees fans and the world's only Rays fan. It was torture, just refreshing and refreshing. These were fans like us, so I honestly don't think they care who they play, but have a minor preference for the Red Sox missing the playoffs just out of schaudenfreude.
You must be Registered and Logged In to post comments.
<< Back to main