Monday, January 28, 2013

Star Trek: fun with TV.com ratings

I recently decided to crunch some numbers regarding Star Trek to see what the results would be.

I went to TV.com and copied the average rating as voted by users (on a scale of 1-10, decimals allowed) for every episode and film. Ratings are current as of 1/26/13 except DS9 seasons 2-7, which are current as of 1/27/13. DS9 Season 3's "Through the Looking Glass" was unlisted, so the rating comes from IMDb. I then figured various averages.

Okay...

Star Trek (The Original Series)

Season 1

248.1 total / 30 episodes = 8.27

Season 2

209 total / 26 episodes = 8.038461538461538

Season 3

174.9 total / 24 episodes = 7.2875

Series

632 total / 80 episodes = 7.9

Conclusions: Each season got worse, though the drop between seasons 1 and 2 is small compared to the depths that season 3 sank to, which is noticeably below the series as a whole.

Star Trek (The Animated Series)

Season 1

122.5 total / 16 episodes = 7.65625

Season 2

46.5 total / 6 episodes = 7.75

Series

169 total / 22 episodes = 7.681818181818182

Conclusions: Um,...TOS Season 3 is still the worst. Not much else to say here.

Star Trek: The Next Generation

Season 1

189.6 total / 26 episodes = 7.292307692307692

Season 2

158.2 total / 22 episodes = 7.190909090909091

Season 3

207.2 total / 26 episodes = 7.969230769230769

Season 4

206.5 total / 26 episodes = 7.942307692307692

Season 5

203.9 total / 26 episodes = 7.842307692307692

Season 6

209.2 total / 26 episodes = 8.046153846153846

Season 7

202.8 total / 26 episodes = 7.8

Series

1377.4 total / 178 = 7.738202247191011

Conclusions: Seasons 3-7 are far above seasons 1-2. Season 2 is technically worse than season 1, but that's only because of "Shades of Gray".

Star Trek: Deep Space Nine

Season 1

154.9 total / 20 episodes = 7.745

Season 2

204.5 total / 26 episodes = 7.865384615384615

Season 3

212.5 total / 26 episodes = 8.173076923076923

Season 4

213.9 total / 26 episodes = 8.226923076923077

Season 5

212.6 total / 26 episodes = 8.176923076923077

Season 6

211.4 total / 26 episodes = 8.130769230769231

Season 7

216.6 total / 26 episodes = 8.330769230769231

Series

1426.4 total / 176 episodes = 8.104545454545455

Conclusions: The series went out on top. Five of its seasons beat TNG's best season. Its final season beat TOS' best season.

Star Trek: Voyager

Season 1

129.7 total / 16 episodes = 8.10625

Season 2

198.3 total / 26 episodes = 7.626923076923077

Season 3

205.1 total / 26 episodes = 7.888461538461538

Season 4

210.3 total / 26 episodes = 8.088461538461538

Season 5

209.2 total / 26 episodes = 8.046153846153846

Season 6

201.9 total / 26 episodes = 7.765384615384615

Season 7

211.2 total / 26 episodes = 8.123076923076923

Series

1365.7 total / 172 episodes = 7.940116279069767

Conclusions: The series has higher average ratings than I expected. I was surprised that some of these seasons beat seasons of TOS, TNG, and DS9. Even more surprisingly, the series as a whole beats TOS and TNG. Oh, and TAS, but who cares?

Star Trek: Enterprise

Season 1

211.9 total / 26 episodes = 8.15

Season 2

212.8 total / 26 episodes = 8.184615384615385

Season 3

205.9 total / 24 episodes = 8.579166666666667

Season 4

186.4 total / 22 episodes = 8.472727272727273

Series

817 total / 98 episodes = 8.336734693877551

Conclusions: Well, I'm certainly surprised, considering how much flack that Enterprise got back in the day. Um, I'll get more into this later. Let's get through the movies first.

Films

Star Trek: The Motion Picture: 8.0
Star Trek II: The Wrath of Khan: 9.2
Star Trek III: The Search for Spock: 8.2
Star Trek IV: The Voyage Home: 9.2
Star Trek V: The Final Frontier: 7.0
Star Trek VI: The Undiscovered Country: 8.8
Star Trek: Generations: 8.0
Star Trek: First Contact: 9.5
Star Trek: Insurrection: 8.8
Star Trek: Nemesis: 6.5
Star Trek (2009 film): 9.5

Film Rankings (Best to Worst)

1. Star Trek: First Contact
1. Star Trek (2009 film)
3. Star Trek II: The Wrath of Khan
3. Star Trek IV: The Voyage Home
5. Star Trek VI: The Undiscovered Country
5. Star Trek: Insurrection
7. Star Trek III: The Search for Spock
8. Star Trek: The Motion Picture
8. Star Trek: Generations
10. Star Trek V: The Final Frontier
11. Star Trek: Nemesis

Conclusions: A bit surprising. I expected Wrath of Khan to be on top and Final Frontier to be at the bottom, just under Nemesis.

Series Rankings

Star Trek: Enterprise
Star Trek: Deep Space Nine
Star Trek: Voyager
Star Trek (The Original Series)
Star Trek: The Next Generation
Star Trek (The Animated Series)

Conclusions: Whaaa...? TOS and TNG totally got their butts handed to them by Enterprise, DS9, and Voyager!

Season Rankings

ENT Season 3
ENT Season 4
DS9 Season 7
TOS Season 1
DS9 Season 4
ENT Season 2
DS9 Season 5
DS9 Season 3
ENT Season 1
DS9 Season 6
VGR Season 7
VGR Season 1
VGR Season 4
TNG Season 6
VGR Season 5
TOS Season 2
TNG Season 3
TNG Season 4
VGR Season 3
DS9 Season 2
TNG Season 5
TNG Season 7
VGR Season 6
TAS Season 2
DS9 Season 1
TAS Season 1
VGR Season 2
TNG Season 1
TOS Season 3
TNG Season 2

Conclusions: The second half of Enterprise is the best Star Trek television EVER. Think about that. TNG Season 6 and Voyager Season 5 tie EXACTLY. TOS Season 3 isn't the worst Star Trek after all. Thanks, "Shades of Gray".

Various Averages

TOS + TAS: 801 total / 102 episodes = 7.852941176470588
TOS film franchise (excl. Generations): 50.4 total / 6 films = 8.4
TOS film franchise (incl. Generations):
58.4 total / 7 films = 8.342857142857143
TOS franchise (incl. TAS, excl. Gen.):
851.4 total / 108 stories = 7.883333333333333
TOS franchise (incl. TAS, incl. Gen.):
859.4 total / 109 stories = 7.884403669724771
TOS franchise (excl. TAS, excl. Gen.):
682.4 total / 86 stories = 7.934883720930233
TOS franchise (excl. TAS, incl. Gen.):
690.4 total / 87 stories = 7.935632183908046
TNG film franchise:
32.8 total / 4 films = 8.2
TNG franchise:
1410.2 total / 182 stories = 7.748351648351648
Film franchise (incl. reboot):
92.7 total / 11 films = 8.427272727272727
Film franchise (excl. reboot):
83.2 total / 10 films = 8.32
Television (incl. TAS):
5787.5 total / 726 episodes = 7.971763085399449
Television (excl. TAS):
5618.5 total / 704 episodes = 7.980823863636364
Prime Universe (incl. TAS, excl. ENT):
5053.7 total / 638 stories = 7.92115987460815
Prime Universe (incl. TAS, incl. ENT):
5870.7 total / 736 stories = 7.976494565217391
Prime Universe (excl. TAS, excl. ENT):
4884.7 total / 616 stories = 7.929707792207792
Prime Universe (excl. TAS, incl. ENT):
5701.7 total / 714 stories = 7.985574229691877
Live-Action Franchise:
5711.2 total / 715 stories = 7.987692307692308
Full Screen Franchise:
5880.2 total / 737 stories = 7.978561736770692

Well, that was exhausting, but I certainly had fun doing it, and I was surprised along the way. Thoughts?

Welcome to my blog

Hello and welcome to Tuxedo Mark's Pop Culture Blog.

My name is Mark Moore. I've been on the Internet since September of 1996. I've written many things over the years, spread across many sites, and I thought it was a good idea to finally have a centralized place where I can share my thoughts on any geeky aspect of any part of pop culture that I wish. Topics will skew toward sci-fi and fantasy and will cover live-action, cartoons, anime, comic books, etc.

Enjoy your stay and have fun!