@letekro ,
@QuantumMechanic ,
@PatsFanSince74 or anyone else.
Need some help. I'm a little stumped with these charts.
I understand that they used both the Logo and Non Logo gauge to inflate the football for each chart respectively to test or replicate game day results. I also understand they used a "master gauge" to measure the re-pressurizing readings. They performed 3 separate tests for 3 various start times for each gauge.
Question 1: Even IF they used both the logo and the non logo gauge for all six tests (3 logo + 3 non logo) shouldn't the re-pressurizing rate be similar for each respective team?
To calculate the re-pressurizing rates I used the average start time and the average pressure reading. I find that there is a anywhere from a 81% to 109% difference of re-pressurizing in the colt's balls between the logo and non logo gauges and a 29% to 67% difference of re-pressurizing in the Patriots footballs. This is comparing similar average start times for each team.
So for example (see Excel image below): Using the Non logo gauge the Colt's footballs that were measured at an average start time of 8:15 (8 minutes and 15 seconds) had an 81% decrease in inflation rate than those that were set using the Logo Gauge with an average start time of 8:12. I thought we would have seen the same or at least similar rates regardless of which gauge was used to inflate.
Secondly, I had to assume at least a 1.18 pressure drop (71 deg F to 48 deg) because if I did not the Patriots footballs would have incurred a negative pressure drop using the Logo gauge which of course is not possible. I attribute this partially to the difference between the actual Logo gauge reading and the "master" gauge setting. I did assume, however, and this may be my error, that if the beginning and ending temperatures stayed constant for both groups the results would be fairly accurate. Hence the assumed pressure drop of 1.18. If I used the pressure drop of 0.98 (67 degrees F to 48 deg) I would have started with a higher pressure reading than the Patriots footballs measured during their first measurements at 2:21 seconds.
Beyond all that I find it odd that they used the Colt's footballs as the control although they admittedly do not know the initial parameters that Colt's footballs were exposed to and just willingly assume they were good. That of course is based off of Walt Anderson's non recollection and, of course, Paul Weiss's keen recollection of the events that transpired that day.
One thing to note and I find this critical because it bypasses all this timeline BS:
"
The pressure of the Patriots ball that had been intercepted by the Colts was separately tested three times and the measurements—11.45, 11.35 and 11.75 psi, respectively—were written on athletic tape that had been placed on the ball for identification."
"
these equations predict that the Patriots balls should have measured between 11.52 and 11.32 psig at the end of the first half"
Second Chart Data: Logo Gauge "Master gauge readings"