Oh yes, all this to prove how fast I should* have been.
 
 
 

Downriver Race results:
 
    1st       Me   
Race
min
sec
total sec
 
min
sec
total sec
Ware
40
7
2407
 
47
23
2843
Scantic
27
21
1641
 
31
46
1906
Westfield
49
0
2940
 
58
32
3512
Housatonic
76
50
4610
 
92
4
5524
Charlemont
34
9
2049
 
?
?
?

OK, using the total number of seconds for the first four races of the first place K-1 long (column four) as the independent Y variable and my total number of seconds for the first four races (column 8) as the dependent X variable, we get the following results:
 
 
Regression Statistics  
Multiple R  0.999974015 
R Square  0.99994803 
Adjusted R Square  0.999922046 
Standard Error  11.11428849 
Observations  4 

Check out that R-Squared value !!!!
I'd say there is some pretty good correlation there.
 
 
ANOVA          
  df SS MS F Significance F
Regression 1 4753581.945 4753581.945 38482.00164 2.59852E-05
Residual 2 247.0548174 123.5274087
Total 3 4753829

 
 
 
Coefficients
Standard Error
t Stat 
P-value
Lower 95%
Upper 95%
Intercept 71.18842146 15.45167503  4.607165329 0.044024318 4.705183437 137.6716595
Slope 0.820692515 0.004183614 196.1682993 2.59852E-05 0.802691862 0.838693167

Down here we see the intercept and slope for the equation of the line generated by the first four races.
 
 

Using the standard equation for a line: y = mx + b

Now we substitute the time of 2049 seconds as our y, 0.820692515 as our m, and 71.18842146 as our b and solve for x.
 

2049 =  0.820692515 x + 71.18842146

2049 - 71.18842146 = 0.820692515 x

1977.811579 = 0.820692515 x

1977.811579 / 0.820692515 = x

2409.93008 = x
 
 

So, from May 19th to June 30th, I became approximately 144 seconds older, fatter, and slower.

QED
 
 
 

* This is not the stock market. Prior performance should be indicative of future results.
 

Return to Chronicles