Salt Creek WQ Studies in situ Work - Velocity/Flow Regressions
Site IS3 = N. 27th St. Site ISD = Above NETP SUMMARY OUTPUT Site ISF = Above Stevens Creek Site ISG = Below 84th St. Site ISI = Above Waverly Road
Port. Mtr. Port. Mtr. Port. Mtr. SUMMARY OUTPUT Port. Mtr. Port. Mtr. Port. Mtr. Port. Mtr. Port. Mtr. Port. Mtr. SUMMARY OUTPUT Port. Mtr. Port. Mtr. Port. Mtr. SUMMARY OUTPUT Port. Mtr. Port. Mtr. Port. Mtr. SUMMARY OUTPUT
Velocity Flow Flow ^(2/3) Velocity Flow Flow ^(2/3) Regression Statistics Velocity Flow Flow ^(2/3) Velocity Flow Flow ^(2/3) Velocity Flow Flow ^(2/3)
(fps) (cfs) [1] Regression Statistics (fps) (cfs) [1] Multiple R 0.908525 (fps) (cfs) [1] Regression Statistics (fps) (cfs) [1] Regression Statistics (fps) (cfs) [1] Regression Statistics
Date/Time (Y) (X1) (X2) Multiple R 0.826387 Date/Time (Y) (X1) (X2) R Square 0.825417 Date/Time (Y) (X1) (X2) Multiple R 0.787398 Date/Time (Y) (X1) (X2) Multiple R 0.756865 Date/Time (Y) (X1) (X2) Multiple R 0.822908
9/21/99 16:00 1.36 126.2 25.2 R Square 0.682916 9/21/99 16:00 1.55 120.9 24.5 Adjusted R Square 0.783468 9/21/99 15:00 1.42 134.2 26.2 R Square 0.619996 9/21/99 14:00 1.25 131.5 25.9 R Square 0.572844 9/25/99 11:00 1.41 214.8 35.9 R Square 0.677178
9/22/99 19:00 1.23 95.7 20.9 Adjusted R Square 0.635877 9/22/99 19:00 1.36 112.8 23.3 Standard Error 0.087131 9/22/99 18:00 1.42 145.1 27.6 Adjusted R Square 0.57071 9/22/99 17:00 1.15 126.2 25.2 Adjusted R Square 0.521875 9/26/99 10:00 1.39 188.9 32.9 Adjusted R Square 0.629934
9/23/99 17:00 1.26 134.5 26.3 Standard Error 0.077076 9/23/99 17:00 1.46 143.9 27.5 Observations 30 9/23/99 18:00 1.62 169.4 30.6 Standard Error 0.119498 9/23/99 18:00 1.45 184.7 32.4 Standard Error 0.076573 9/27/99 8:00 1.25 173.7 31.1 Standard Error 0.073855
9/24/99 16:00 1.50 186.7 32.7 Observations 30 9/24/99 16:00 1.74 228.5 37.4 9/24/99 16:00 1.71 218.5 36.3 Observations 30 9/24/99 15:00 1.52 236.2 38.2 Observations 30 9/28/99 9:00 1.37 195.6 33.7 Observations 30
9/25/99 13:00 1.33 152.0 28.5 9/25/99 12:00 1.34 154.5 28.8 ANOVA 9/25/99 12:00 1.60 202.8 34.5 9/25/99 12:00 1.28 180.7 32.0 9/29/99 9:00 1.20 162.0 29.7
9/26/99 12:00 1.28 130.5 25.7 ANOVA 9/26/99 12:00 1.42 139.0 26.8   df SS MS F Significance F 9/26/99 11:00 1.55 138.0 26.7 ANOVA 9/26/99 11:00 1.24 143.6 27.4 ANOVA 9/30/99 11:00 1.18 136.4 26.5 ANOVA
9/27/99 9:00 1.08 109.6 22.9   df SS MS F Significance F 9/27/99 9:00 1.25 116.2 23.8 Regression 2 1.005017 0.502508 66.19108 3.89E-11 9/27/99 9:00 1.38 124.9 25.0   df SS MS F Significance F 9/27/99 8:00 1.18 138.5 26.8   df SS MS F Significance F 9/21/99 13:00 1.35 148.7 28.1   df SS MS F Significance F
9/28/99 12:00 1.38 134.7 26.3 Regression 2 0.358249 0.179124 30.1523 1.32E-07 9/28/99 11:00 1.37 163.9 29.9 Residual 28 0.21257 0.007592 9/28/99 11:00 1.50 170.1 30.7 Regression 2 0.652351 0.326176 22.84171 1.56E-06 9/28/99 10:00 1.39 155.3 28.9 Regression 2 0.220171 0.110085 18.77494 7.76E-06 9/22/99 16:00 1.47 157.4 29.2 Regression 2 0.320371 0.160185 29.36754 1.68E-07
9/29/99 11:00 1.28 134.1 26.2 Residual 28 0.166338 0.005941 9/29/99 11:00 1.30 126.1 25.1 Total 30 1.217587       9/29/99 10:00 1.26 117.2 23.9 Residual 28 0.399835 0.01428 9/29/99 10:00 1.32 142.5 27.3 Residual 28 0.164176 0.005863 9/23/99 18:00 1.60 211.1 35.5 Residual 28 0.152726 0.005455
9/30/99 9:00 1.35 118.9 24.2 Total 30 0.524587       9/30/99 10:00 1.10 106.6 22.5 9/30/99 10:00 1.37 120.4 24.4 Total 30 1.052187       9/30/99 11:00 1.35 136.3 26.5 Total 30 0.384347       9/24/99 15:00 1.59 246.0 39.3 Total 30 0.473097      
10/1/99 9:00 1.22 92.2 20.4 10/1/99 11:00 0.98 97.0 21.1   Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 10/1/99 11:00 1.24 92.6 20.5 10/1/99 11:00 1.26 106.4 22.5 10/1/99 10:00 1.22 141.7 27.2
10/2/99 9:00 1.03 71.1 17.2   Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 10/2/99 11:00 1.04 94.4 20.7 Intercept 0 #N/A #N/A #N/A #N/A #N/A #N/A #N/A 10/2/99 11:00 1.04 80.5 18.6   Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 10/2/99 10:00 1.05 88.8 19.9   Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 10/2/99 10:00 1.15 132.3 26.0   Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
10/3/99 9:00 0.95 63.2 15.9 Intercept 0 #N/A #N/A #N/A #N/A #N/A #N/A #N/A 10/3/99 10:00 0.94 73.6 17.6 X Variable 1 -0.0035 0.001328 -2.63733 0.013484 -0.00622 -0.00078 -0.00622 -0.00078 10/3/99 9:00 0.90 64.8 16.1 Intercept 0 #N/A #N/A #N/A #N/A #N/A #N/A #N/A 10/3/99 9:00 1.05 86.6 19.6 Intercept 0 #N/A #N/A #N/A #N/A #N/A #N/A #N/A 10/3/99 8:00 1.12 118.5 24.1 Intercept 0 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
10/4/99 9:00 1.06 72.3 17.4 X Variable 1 -0.01114 0.001401 -7.94917 1.17E-08 -0.01401 -0.00827 -0.01401 -0.00827 10/4/99 11:00 0.98 81.6 18.8 X Variable 2 0.068637 0.006515 10.53448 3.01E-11 0.055291 0.081984 0.055291 0.081984 10/4/99 11:00 1.26 112.1 23.2 X Variable 1 -0.00872 0.001778 -4.90169 3.63E-05 -0.01236 -0.00507 -0.01236 -0.00507 10/4/99 10:00 1.20 97.9 21.2 X Variable 1 -0.01139 0.001085 -10.4889 3.32E-11 -0.01361 -0.00916 -0.01361 -0.00916 10/4/99 10:00 1.21 121.6 24.5 X Variable 1 -0.00692 0.001143 -6.05351 1.58E-06 -0.00926 -0.00458 -0.00926 -0.00458
10/5/99 8:00 1.24 77.8 18.2 X Variable 2 0.107889 0.006672 16.17024 9.83E-16 0.094222 0.121556 0.094222 0.121556 10/5/99 11:00 1.02 84.1 19.2 10/5/99 11:00 1.21 92.4 20.4 X Variable 2 0.098923 0.008966 11.03346 1.05E-11 0.080557 0.117288 0.080557 0.117288 10/5/99 10:00 1.14 96.6 21.1 X Variable 2 0.107901 0.005479 19.69493 6.07E-18 0.096679 0.119124 0.096679 0.119124 10/5/99 9:00 1.23 125.0 25.0 X Variable 2 0.082766 0.006145 13.46855 9.33E-14 0.070178 0.095353 0.070178 0.095353
10/6/99 9:00 1.14 75.8 17.9 10/6/99 11:00 1.04 89.3 20.0 10/6/99 10:00 1.22 105.1 22.3 10/6/99 10:00 1.22 102.3 21.9 10/6/99 9:00 1.25 127.7 25.4
10/7/99 9:00 1.26 87.7 19.7 10/7/99 11:00 1.05 84.0 19.2 10/7/99 11:00 1.20 100.8 21.7 10/7/99 10:00 1.21 97.8 21.2 10/7/99 9:00 1.19 121.9 24.6
10/8/99 12:00 1.21 87.2 19.7 10/8/99 12:00 1.20 101.7 21.8 RESIDUAL OUTPUT 10/8/99 11:00 1.42 114.5 23.6 10/8/99 11:00 1.34 106.9 22.5 10/8/99 11:00 1.33 139.4 26.9
10/9/99 11:00 1.16 97.9 21.2 RESIDUAL OUTPUT 10/9/99 10:00 0.82 71.3 17.2 10/9/99 9:00 1.23 94.0 20.7 RESIDUAL OUTPUT 10/9/99 9:00 1.25 90.9 20.2 RESIDUAL OUTPUT 10/9/99 8:00 1.23 131.0 25.8 RESIDUAL OUTPUT
10/10/99 10:00 1.03 78.8 18.4 10/10/99 10:00 1.07 80.5 18.6 Observation Predicted Y Residuals 10/10/99 9:00 1.27 78.0 18.3 10/10/99 8:00 1.18 93.6 20.6 10/10/99 8:00 1.40 145.2 27.6
10/11/99 9:00 0.97 79.4 18.5 Observation Predicted Y Residuals 10/11/99 11:00 1.04 79.9 18.6 1 1.254613 0.295387 10/11/99 10:00 1.48 95.0 20.8 Observation Predicted Y Residuals ########### 1.22 90.6 20.2 Observation Predicted Y Residuals 10/11/99 9:00 1.22 126.0 25.1 Observation Predicted Y Residuals
10/12/99 9:00 1.25 93.1 20.5 1 1.308507 0.051493 10/12/99 11:00 1.08 96.3 21.0 2 1.207172 0.152828 10/12/99 11:00 1.52 103.0 22.0 1 1.423134 -0.00313 ########### 1.27 97.0 21.1 1 1.293077 -0.04308 ########### 1.32 139.7 26.9 1 1.481868 -0.07187
10/13/99 9:00 1.21 79.6 18.5 2 1.191116 0.038884 10/13/99 11:00 0.99 89.1 19.9 3 1.380636 0.079364 10/13/99 11:00 1.20 84.8 19.3 2 1.466686 -0.04669 ########### 1.18 84.7 19.3 2 1.277934 -0.12793 ########### 1.12 107.6 22.6 2 1.417428 -0.02743
10/14/99 9:00 1.14 77.9 18.2 3 1.333789 -0.07379 10/14/99 13:00 1.02 83.0 19.0 4 1.764796 -0.0248 10/14/99 12:00 1.41 104.5 22.2 3 1.551894 0.068106 ########### 1.17 81.7 18.8 3 1.396609 0.053391 10/14/99 9:00 1.30 120.0 24.3 3 1.374425 -0.12442
10/15/99 9:00 1.25 88.6 19.9 4 1.444341 0.055659 10/15/99 11:00 1.14 93.7 20.6 5 1.434956 -0.09496 10/15/99 11:00 1.48 102.9 22.0 4 1.683951 0.026049 ########### 1.19 94.1 20.7 4 1.433772 0.086228 10/15/99 9:00 1.23 133.5 26.1 4 1.435112 -0.06511
10/16/99 9:00 1.03 70.1 17.0 5 1.379456 -0.04946 10/16/99 10:00 1.10 97.5 21.2 6 1.35477 0.06523 10/16/99 9:00 1.26 101.8 21.8 5 1.646778 -0.04678 10/16/99 9:00 1.22 98.5 21.3 5 1.391441 -0.11144 10/16/99 9:00 1.09 107.7 22.6 5 1.338359 -0.13836
10/17/99 8:00 1.07 81.8 18.8 6 1.321917 -0.04192 10/17/99 10:00 1.04 85.2 19.4 7 1.2273 0.0227 10/17/99 10:00 1.05 110.1 23.0 6 1.438729 0.111271 ########### 1.01 77.9 18.2 6 1.323954 -0.08395 10/17/99 9:00 1.17 138.9 26.8 6 1.24907 -0.06907
10/18/99 8:00 1.01 80.0 18.6 7 1.249858 -0.16986 10/18/99 9:00 1.05 96.6 21.1 8 1.48139 -0.11139 10/18/99 9:00 1.13 101.6 21.8 7 1.38298 -0.00298 10/18/99 9:00 1.05 95.4 20.9 7 1.311541 -0.13154 10/18/99 8:00 1.19 123.3 24.8 7 1.293878 0.056122
10/19/99 7:00 1.11 81.2 18.8 8 1.334368 0.045632 10/19/99 9:00 1.04 98.9 21.4 9 1.284176 0.015824 10/19/99 9:00 1.14 98.8 21.4 8 1.554129 -0.05413 10/19/99 9:00 1.17 99.2 21.4 8 1.349358 0.040642 10/19/99 8:00 1.22 125.8 25.1 8 1.323413 0.146587
10/20/99 8:00 1.09 84.2 19.2 9 1.332628 -0.05263 10/20/99 10:00 1.05 93.4 20.6 10 1.169627 -0.06963 10/20/99 9:00 1.13 100.3 21.6 9 1.347441 -0.08744 10/20/99 9:00 1.13 102.3 21.9 9 1.321348 -0.00135 10/20/99 8:00 1.21 127.8 25.4 9 1.473288 0.126712
10 1.28412 0.06588 11 1.109168 -0.12917 10 1.362476 0.007524 10 1.30592 0.04408 10 1.54684 0.04316
[1] Note:  (2/3) exponent determined by trial and 11 1.174731 0.045269 12 1.092267 -0.05227 11 1.217539 0.022461 11 1.211415 0.048585 11 1.268837 -0.04884
error for best correlation. 12 1.05954 -0.02954 13 0.947571 -0.00757 12 1.142551 -0.10255 12 1.136653 -0.08665 12 1.233275 -0.08328
13 1.007718 -0.05772 14 1.005382 -0.02538 13 1.031057 -0.13106 13 1.126081 -0.07608 13 1.176625 -0.05663
14 1.066947 -0.00695 15 1.022865 -0.00286 14 1.322662 -0.06266 14 1.177373 0.022627 14 1.189844 0.020156
15 1.099467 0.140533 16 1.05841 -0.01841 15 1.216366 -0.00637 15 1.171839 -0.03184 15 1.204005 0.025995
16 1.087906 0.052094 17 1.02217 0.027829 16 1.286916 -0.06692 16 1.195448 0.024553 16 1.215007 0.034993
17 1.152623 0.107377 18 1.139138 0.060862 17 1.263891 -0.06389 17 1.176951 0.033049 17 1.191107 -0.00111
18 1.150091 0.059909 19 0.930384 -0.11038 18 1.334451 0.085549 18 1.213306 0.126694 18 1.260347 0.069653
19 1.20107 -0.04107 20 0.997606 0.072394 19 1.225691 0.004309 19 1.146471 0.103529 19 1.228172 0.001828
20 1.105139 -0.07514 21 0.993341 0.046659 20 1.12596 0.14404 20 1.158716 0.021284 20 1.281505 0.118495
21 1.108508 -0.13851 22 1.104641 -0.02464 21 1.231453 0.248547 21 1.145085 0.074915 21 1.208105 0.011896
22 1.17901 0.07099 23 1.057063 -0.06706 22 1.275776 0.244224 22 1.173552 0.096448 22 1.261462 0.058538
23 1.109625 0.100375 24 1.015205 0.004795 23 1.170173 0.029827 23 1.116706 0.063294 23 1.12766 -0.00766
24 1.100038 0.039962 25 1.087676 0.052324 24 1.283753 0.126247 24 1.101429 0.068571 24 1.183059 0.116941
25 1.157141 0.092859 26 1.112391 -0.01239 25 1.275241 0.204759 25 1.160938 0.029062 25 1.237945 -0.00794
26 1.053277 -0.02328 27 1.030474 0.009526 26 1.269321 -0.00932 26 1.179897 0.040103 26 1.128128 -0.03813
27 1.121734 -0.05173 28 1.106583 -0.05658 27 1.31266 -0.26266 27 1.081198 -0.0712 27 1.258483 -0.08848
28 1.111852 -0.10185 29 1.121372 -0.08137 28 1.268239 -0.13824 28 1.166649 -0.11665 28 1.196968 -0.00697
29 1.118464 -0.00846 30 1.085703 -0.0357 29 1.25289 -0.11289 29 1.182818 -0.01282 29 1.207287 0.012713
30 1.13457 -0.04457 30 1.261159 -0.13116 30 1.195448 -0.06545 30 1.215411 -0.00541