cyptomcat
Hibernating
- Joined
- Nov 19, 2007
- Messages
- 68,971
You just have to hit 'file' and then 'publish to the web' which will give you a link that you can post. If you want to pm me a copy paste of the numbers, I can just put those in my spreadsheet as well.Fine. I don't care about that study. You posted it with its claims. I repeated it.
Now, fwiw, I took your data for extra time and non-extra time GT rushing.
I then added an extra column for that team's yds/rush allowed against BCS AQ (from cfbstats). I then added a column for the Ratio of GT's actual yds/rush over Opponents yds/rush average against BCS AQ.
I then calculated the average over the 4 years.
For Teams without extra prep
Average of GTAct/OppDef Ave = 1.33
StDev = .31
For Teams with extra prep
Average of GTAct/OppDef Ave = 1.33
StDev = .31
No difference.
Hopefully this works:
https://docs.google.com/spreadsheet/ccc?key=0AgBtvZUVCL--dEFSbU9TWkwyWHBWRGxYVUZqZ3FnalE#gid=0
Oh well, I'll worry about making the spread sheet public some other time.
Pretty much the same ratio was in my spreadsheet as well. I had 1.38 vs. 1.37 using defenses season average including everything not just BCS. Yours is better but result obviously about the same.
The killing happens when you look at yards per play not just yards per rush. In other words, it's seems the passing is hurting us. It's definitely very interesting.