Salt Creek WQ Studies - in situ Work
NH3N Regression:  Theresa to Site IS3 = N. 27th Street with 4-Hr. Interval Data SUMMARY OUTPUT
  Interpolated        
   or Matching   USGS Site IS3 Site IS3 Regression Statistics
  Theresa Theresa N. 27th St. Measured Predicted Multiple R 0.732761
  T. NH3N Flow Flow T. NH3N T. NH3N R Square 0.536939
  (mg/l) [1] (cfs) (cfs) (mg/l) (mg/l) Adjusted R Square 0.511681
DateTime (X1) (X2) (X3) (Y) (Y') Standard Error 1.430179
9/21/99 16:00 27.47 31 102 9.05 7.72 Observations 59
9/21/99 19:00 31.53 28 96 10.02 8.73
9/22/99 9:00 23.75 34 98 8.59 6.97 ANOVA
9/22/99 19:00 19.22 26 95 6.72 4.95   df SS MS F Significance F
9/23/99 9:00 15.17 41 144 3.26 4.34 Regression 3 130.4458 43.48192 21.25828 2.85E-09
9/23/99 17:00 25.33 29 167 5.96 5.81 Residual 55 112.4976 2.045411
9/24/99 9:00 26.41 37 215 5.04 6.06 Total 58 242.9434      
9/24/99 16:00 30.21 28 211 6.03 6.41
9/25/99 10:00 25.46 26 181 4.41 5.33   Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
9/25/99 21:00 22.04 24 157 5.49 4.54 Intercept -1.51633 1.257417 -1.20591 0.233015 -4.03625 1.003591 -4.03625 1.003591
9/26/99 9:00 14.67 17 132 1.94 2.15 X Variable 1 0.293205 0.041619 7.044987 3.18E-09 0.209799 0.376612 0.209799 0.376612
9/26/99 15:00 17.02 30 154 4.31 3.69 X Variable 2 0.093485 0.025128 3.720368 0.000469 0.043128 0.143842 0.043128 0.143842
9/27/99 9:00 16.37 38 136 2.80 4.55 X Variable 3 -0.01684 0.004743 -3.55018 0.000797 -0.02635 -0.00733 -0.02635 -0.00733
9/27/99 15:00 22.20 29 151 5.95 5.16
9/28/99 9:00 28.19 35 157 4.79 7.38
9/28/99 16:00 30.92 29 156 6.96 7.63
9/29/99 8:00 27.58 23 130 5.34 6.53 RESIDUAL OUTPUT
9/29/99 15:00 23.27 27 151 6.39 5.29
9/30/99 9:00 16.79 40 136 2.74 4.86 Observation Predicted Y Residuals
9/30/99 17:00 24.91 31 150 6.30 6.16 1 7.718368 1.331932
10/1/99 9:00 23.43 24 99 5.50 5.93 2 8.730834 1.291566
10/1/99 15:00 26.90 28 113 8.44 7.08 3 6.974726 1.612874
10/2/99 9:00 23.17 19 74 4.61 5.81 4 4.949879 1.766922
10/2/99 14:00 21.47 35 107 7.43 6.25 5 4.339505 -1.0748
10/3/99 9:00 17.42 15 62 3.45 3.95 6 5.810796 0.144404
10/3/99 15:00 18.83 33 98 6.93 5.44 7 6.064813 -1.02771
10/4/99 9:00 16.86 37 75 4.45 5.62 8 6.405723 -0.37912
10/4/99 15:00 24.12 30 91 7.60 6.83 9 5.33123 -0.92593
10/5/99 8:00 27.32 23 64 6.81 7.57 10 4.544928 0.947972
10/5/99 15:00 27.25 35 90 9.23 8.23 11 2.150611 -0.20891
10/6/99 9:00 25.07 39 77 6.48 8.18 12 3.685932 0.623868
10/6/99 15:00 21.14 33 88 7.17 6.28 13 4.545617 -1.74672
10/7/99 9:00 16.69 41 74 5.02 5.96 14 5.162505 0.791195
10/7/99 14:00 21.34 36 88 6.77 6.62 15 7.377942 -2.58954
10/8/99 8:00 28.63 24 69 7.52 7.96 16 7.63359 -0.67419
10/8/99 15:00 28.28 32 85 10.25 8.34 17 6.531217 -1.19592
10/9/99 15:00 22.36 36 95 8.41 6.81 18 5.286333 1.105067
10/10/99 8:00 18.32 12 54 4.07 4.07 19 4.855734 -2.11523
10/10/99 14:00 18.96 35 93 7.50 5.75 20 6.15797 0.14173
10/11/99 9:00 18.00 34 75 6.16 5.68 21 5.930676 -0.42738
10/11/99 14:00 22.72 35 88 7.36 6.94 22 7.084812 1.355089
10/12/99 9:00 28.28 40 75 7.21 9.25 23 5.808021 -1.20152
10/12/99 15:00 27.25 28 79 7.89 7.76 24 6.247408 1.183792
10/13/99 9:00 23.51 42 65 6.20 8.21 25 3.948765 -0.49627
10/13/99 15:00 19.71 28 71 6.29 5.68 26 5.440869 1.487131
10/14/99 9:00 16.73 39 62 4.63 5.99 27 5.623051 -1.16915
10/14/99 15:00 22.30 31 70 7.19 6.74 28 6.827886 0.769614
10/15/99 9:00 24.61 38 59 6.86 8.26 29 7.566432 -0.75183
10/15/99 15:00 26.21 30 71 8.83 7.78 30 8.229151 0.999949
10/16/99 8:00 26.18 12 49 4.51 6.46 31 8.18429 -1.70439
10/16/99 15:00 23.76 37 75 9.58 7.65 32 6.283643 0.890657
10/17/99 8:00 16.56 11 54 2.77 3.46 33 5.964719 -0.94692
10/17/99 13:00 16.55 35 83 7.00 5.21 34 6.622739 0.146461
10/18/99 8:00 16.64 19 50 3.21 4.30 35 7.959815 -0.43762
10/18/99 15:00 22.68 29 72 7.61 6.63 36 8.336364 1.910236
10/19/99 8:00 30.53 20 50 6.22 8.46 37 6.805393 1.605007
10/19/99 15:00 28.67 30 76 11.61 8.41 38 4.067649 0.003351
10/20/99 9:00 22.52 34 61 4.19 7.24 39 5.74869 1.74881
10/20/99 15:00 18.45 30 76 7.39 5.42 40 5.678316 0.483784
41 6.935343 0.421956
[1] Note:  Matching ammonia values coincide with 4-Hr. interval sampling times (times divisible 42 9.251179 -2.03828
by 4).  All other values at Theresa St. effluent are interpolated to be in the same hour as the 43 7.76073 0.13327
corresponding value at N. 27th St.  Because of close proximity, no allowances have been 44 8.209426 -2.00783
made for travel time or ammonia decay. 45 5.684682 0.603218
46 5.990092 -1.35529
47 6.741379 0.449021
48 8.257587 -1.39359
49 7.778221 1.049779
50 6.456445 -1.94334
51 7.646901 1.936299
52 3.458122 -0.68952
53 5.209733 1.788767
54 4.296819 -1.08232
55 6.631414 0.973586
56 8.462929 -2.24703
57 8.414573 3.199827
58 7.237901 -3.0441
59 5.41728 1.97732