(08-30-2017, 03:14 PM)timeconsumer Wrote:I took your Excel doc and calculated the correlation coefficient between intelligence and penalties and found something interesting.
Intelligence has a -.32 correlation with penalties and -0.27 with penalty yards. It's still a very weak correlation but most other ones were almost zero.
I figured, maybe it's quarterbacks, they have high intelligence and they're skewing the average because they get fewer penalties or something.....nope. Still a -0.28 and -0.22.
What if we remove the defense? -0.12 and -0.06. down to statistical noise on only offense.
So if we only include defense? -0.46 and -0.37. Now we're cooking with gas, these are more reasonable coefficients. A regression returns a significant p-value as well, but a lowly 0.2 R-Squared.
I wouldn't call this settled, and I'm certainly not about to dump points into intelligence, but it is interesting to see the trends on defense with intelligence and penalties. It definitely leaves open future analyses.
See! I needed math people in here, I did ok with the basic data retrieval and entry but didn't really know what to do with it.
Thanks for this. Penalties don't even happen enough to really worry about it, probably, but it is interesting.