I've got a lot of work to get to yet--it was about halfway through this exercise when I realized there were so many ways in which to split the data that steam started coming out of my ears. Decision percentages based on yards to go in each quarter; decision percentages based on yards to go and score margin; decision percentages based on yards to go, time and score, etc. etc. etc. None of that addresses field position and whoops I've gone cross-eyed.
So here's a rough look at how the coaches handled fourth downs in 2009, broken down into general categories. More to come on this if it doesn't kill me.
FG% = FGAs/4th downs in each situation. Same deal with the other columns.
1Q/2Q/etc = decision percentages broken down by quarter.
Score categories: If State had a 4th down while up or down one score, that fell into the 1 Score category, etc. Still need to separate out the situations where we're up a score, down a score...
Yardage categories: decision percentages based on the number of yards needed for a first down.