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?