(07-02-2013 07:38 PM)omniorange Wrote: By incomplete do you mean not including the post-season numbers? My understanding is that this spreadsheet used all of the numbers that were posted over on Sports Media Watch, which this past season I believe did a two part analyis of all the regular season games.
Neil -- it only regular season games reported on Sportsmediawatch.com, no NCAA's and no conference tournaments. I matched the numbers for SU and IU.
Okay.
Ad was saying the spreadsheet was incomplete. When I looked at it initially I immediately thought you had used that 2 part series at Sports Media Watch in regard to all regular season game ratings. So I was asking Ad why he thought the spreadsheet was incomplete. I thought maybe he was referring to the post-season numbers. If not, did he think the Sports Media Watch numbers were somehow incomplete.
Not sure what you mean by the last sentence in regard to matching the numbers for SU and IU. Anyone who is familiar with the Sports Media Watch series would know IU was the most watched team last year. And it was their resurgence that allowed the BiG to perform better this past year than they have in prior years where unfortunately only incomplete data exists.
Cheers,
Neil
I did the calculation for Syracuse and Indiana based on the reported ratings on SMW. Came up with 0.7111 for SU and verified the calculation for IU as well.
So the initial spreadsheet wasn't based on the 2-part spreadsheet from Sports Media Watch. Mind telling us what you did use? Or is it somehow work related and can't reveal the source.
Cheers,
Neil
I used the Part 1 and Part 2 spreadsheet from SMW -- just entered all of the SU and all of the IU games into a spreadsheet.
(07-02-2013 07:38 PM)omniorange Wrote: By incomplete do you mean not including the post-season numbers? My understanding is that this spreadsheet used all of the numbers that were posted over on Sports Media Watch, which this past season I believe did a two part analyis of all the regular season games.
Neil -- it only regular season games reported on Sportsmediawatch.com, no NCAA's and no conference tournaments. I matched the numbers for SU and IU.
Okay.
Ad was saying the spreadsheet was incomplete. When I looked at it initially I immediately thought you had used that 2 part series at Sports Media Watch in regard to all regular season game ratings. So I was asking Ad why he thought the spreadsheet was incomplete.
I corrected it above. I had pulled out the numbers for UofL and a few other teams, and I had more games and different ratings. But I had grouped conference tournament numbers with the "regular season" since they are a part of a conference TV package, and post season number separately.
I actually have the ratings for every national TV football and basketball game from last year, regular season and post season. But I had data mined a few teams, and placed the numbers together to include the values to television, which meant conference tournaments were placed with regular season since the conferences sell them that way.
So my mistake for not making it clearer. The numbers are correct.