How rational was Spock?

[Julia] Galef was curious to see exactly how often these predictions pan out. “I went through all of the Star Trek episodes and movies—all of the transcripts that I could find—and searched for any instance in which Spock is using the words ‘odds,’ ‘probability,’ ‘chance,’ ‘definitely,’ ‘probably,’ etc.,” she says. “I catalogued all instances in which Spock made a prediction and that prediction either came true or didn’t.”

The results, which appear in Galef’s new book The Scout Mindset, are devastating. Not only does Spock have a terrible track record—events he describes as “impossible” happen 83 percent of the time—but his confidence level is actually anti-correlated with reality. “The more confident he says he is that something will happen—that the ship will crash, or that they will find survivors—the less likely it is to happen, and the less confident he is in something, the more likely it is to happen,” Galef says.

Spock’s biggest weakness is his failure to understand that other people don’t always behave “logically.” He also makes no attempt to update his approach, even when his mistakes get his crewmates killed.

Here is the full Wired story, and here you can buy Julia’s new book.  I wonder if he is more rational in the Star Trek movies than in the TV shows, or how about in the fan fiction?  Exactly where is the demand for dramatic irrationality highest, and why?