Salt Creek WQ Studies - in situ Work
NH3N Regression:  Theresa to Site ISD (Above NETP) with 4-Hr. Interval Data SUMMARY OUTPUT
    USGS USGS Site ISD Site ISD
  Theresa N. 27th St. N. 70th St. Measured Predicted Regression Statistics
  T. NH3N Flow Flow T. NH3N T. NH3N Multiple R 0.749856
  (mg/l) (cfs) (cfs) (mg/l) (mg/l) R Square 0.562284
DateTime (X1) (X2) (X3) (Y) (Y') Adjusted R Square 0.554468
9/21/99 12:00 23.90 102 117 4.56 4.54 Standard Error 1.189262
9/21/99 16:00 27.47 102 129 5.88 5.37 Observations 172
9/21/99 20:00 32.89 96 127 6.10 6.36
9/22/99 0:00 32.68 99 125 6.76 6.15 ANOVA
9/22/99 4:00 29.56 75 125 8.27 6.75   df SS MS F Significance F
9/22/99 8:00 26.83 77 110 8.52 5.88 Regression 3 305.2304 101.7435 71.93688 5.67E-30
9/23/99 12:00 16.43 157 158 1.59 2.12 Residual 168 237.6098 1.414344
9/23/99 16:00 23.55 157 168 2.86 3.40 Total 171 542.8402      
9/23/99 20:00 30.69 195 173 3.25 2.89
9/24/99 0:00 33.09 218 206 4.13 3.09   Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
9/24/99 4:00 30.31 205 219 5.22 3.60 Intercept 2.532189 0.668672 3.786891 0.000212 1.212106 3.852272 1.212106 3.852272
9/24/99 8:00 27.19 205 210 3.84 2.91 X Variable 1 0.143987 0.016049 8.971927 5.59E-16 0.112304 0.17567 0.112304 0.17567
9/24/99 12:00 24.06 222 214 2.09 1.82 X Variable 2 -0.04395 0.006491 -6.77072 2.05E-10 -0.05676 -0.03113 -0.05676 -0.03113
9/24/99 16:00 30.21 212 221 3.71 3.33 X Variable 3 0.026078 0.008934 2.91884 0.003995 0.00844 0.043717 0.00844 0.043717
9/24/99 20:00 34.50 215 219 3.83 3.76
9/25/99 0:00 34.26 208 219 4.38 4.04
9/25/99 4:00 30.35 192 214 5.03 4.04
9/25/99 8:00 26.99 182 201 4.08 3.66 RESIDUAL OUTPUT
9/25/99 12:00 23.93 189 195 2.42 2.76
9/25/99 16:00 23.77 176 197 2.73 3.36 Observation Predicted Y Residuals
9/25/99 20:00 23.37 157 190 3.80 3.95 1 4.541931 0.019669
9/26/99 0:00 18.04 151 177 4.19 3.11 2 5.368903 0.510797
9/26/99 4:00 16.94 136 171 3.29 3.45 3 6.360843 -0.26284
9/26/99 8:00 14.65 130 158 2.81 3.05 4 6.146605 0.613795
9/26/99 12:00 14.72 154 153 1.52 1.87 5 6.752118 1.515782
9/26/99 16:00 17.79 154 164 1.72 2.60 6 5.879965 2.644635
9/26/99 20:00 19.31 148 168 2.51 3.19 7 2.118418 -0.53162
9/27/99 0:00 18.90 151 171 3.19 3.08 8 3.404386 -0.54329
9/27/99 4:00 17.74 130 171 3.44 3.83 9 2.892818 0.361082
9/27/99 8:00 16.30 130 158 2.75 3.29 10 3.088165 1.037535
9/27/99 12:00 16.58 160 158 1.55 2.01 11 3.598223 1.625077
9/27/99 16:00 24.08 151 173 2.67 3.87 12 2.91428 0.92122
9/27/99 20:00 31.20 154 171 3.35 4.72 13 1.820798 0.273402
9/28/99 0:00 33.54 157 171 4.56 4.92 14 3.328344 0.382856
9/28/99 4:00 30.23 160 175 5.73 4.42 15 3.762047 0.069253
9/28/99 8:00 28.91 151 186 4.63 4.91 16 4.035126 0.345874
9/28/99 12:00 26.04 170 175 2.77 3.37 17 4.044915 0.986485
9/28/99 16:00 30.92 157 181 4.54 4.80 18 3.661582 0.415318
9/28/99 20:00 35.57 154 171 4.72 5.35 19 2.756877 -0.33368
9/29/99 0:00 33.67 157 171 5.37 4.94 20 3.35732 -0.62332
9/29/99 4:00 30.01 130 168 6.04 5.52 21 3.95219 -0.15049
9/29/99 8:00 27.58 130 155 5.30 4.83 22 3.109411 1.078589
9/29/99 12:00 24.03 154 164 2.87 3.50 23 3.453776 -0.16158
9/29/99 16:00 23.01 148 168 4.71 3.72 24 3.048717 -0.23762
9/29/99 20:00 21.55 148 164 3.84 3.41 25 1.873653 -0.35785
9/30/99 0:00 20.26 151 164 3.62 3.09 26 2.602553 -0.88635
9/30/99 4:00 18.48 127 168 3.76 3.99 27 3.189414 -0.68021
9/30/99 8:00 16.90 130 153 3.18 3.24 28 3.07677 0.10993
9/30/99 12:00 16.46 157 158 1.78 2.12 29 3.832654 -0.39495
9/30/99 16:00 23.78 151 166 2.79 3.65 30 3.286295 -0.5357
9/30/99 20:00 28.28 145 166 3.38 4.56 31 2.008171 -0.45947
10/1/99 0:00 28.80 136 162 4.18 4.93 32 3.874778 -1.20378
10/1/99 4:00 26.22 102 153 5.47 5.81 33 4.715964 -1.36396
10/1/99 8:00 23.74 93 134 5.54 5.36 34 4.921049 -0.35915
10/1/99 12:00 22.51 124 129 3.41 3.69 35 4.416921 1.308479
10/1/99 16:00 28.36 110 147 4.13 5.61 36 4.909252 -0.27565
10/1/99 20:00 31.09 102 134 5.74 6.02 37 3.374137 -0.60494
10/2/99 0:00 29.34 107 129 6.17 5.42 38 4.804586 -0.26909
10/2/99 4:00 25.84 83 134 7.55 6.10 39 5.345186 -0.62469
10/2/99 8:00 23.76 75 119 6.40 5.76 40 4.939767 0.434234
10/2/99 12:00 21.41 104 114 4.38 4.02 41 5.521137 0.521163
10/2/99 16:00 21.52 104 134 3.70 4.55 42 4.832232 0.467568
10/2/99 20:00 21.53 93 132 5.60 4.99 43 3.501031 -0.63573
10/3/99 0:00 20.88 83 123 5.77 5.10 44 3.722165 0.987535
10/3/99 4:00 19.05 65 119 5.54 5.52 45 3.407631 0.436969
10/3/99 8:00 17.50 62 108 5.08 5.14 46 3.090044 0.529455
10/3/99 12:00 17.17 91 106 3.48 3.77 47 3.992813 -0.23131
10/3/99 16:00 19.39 96 127 2.86 4.42 48 3.242296 -0.0634
10/3/99 20:00 19.89 91 129 4.92 4.76 49 2.122737 -0.34704
10/4/99 0:00 19.02 93 125 5.63 4.44 50 3.649034 -0.85753
10/4/99 4:00 17.70 67 125 5.62 5.40 51 4.560663 -1.17736
10/4/99 8:00 16.77 65 110 5.39 4.96 52 4.926755 -0.75066
10/4/99 12:00 17.13 96 114 3.37 3.75 53 5.814797 -0.3419
10/4/99 16:00 26.45 93 132 3.74 5.70 54 5.357755 0.179044
10/4/99 20:00 32.30 83 123 5.11 6.74 55 3.687872 -0.28147
10/5/99 0:00 33.28 88 123 6.67 6.66 56 5.614876 -1.48598
10/5/99 4:00 24.41 65 125 8.51 6.45 57 6.020526 -0.27683
10/5/99 8:00 27.32 65 108 8.38 6.43 58 5.418418 0.753582
10/5/99 12:00 23.97 96 110 5.17 4.63 59 6.099608 1.453892
10/5/99 16:00 28.34 96 125 6.50 5.65 60 5.760526 0.640574
10/5/99 20:00 32.48 88 125 6.26 6.60 61 4.017273 0.364827
10/6/99 0:00 32.24 93 119 8.32 6.19 62 4.554677 -0.85658
10/6/99 4:00 28.47 67 123 6.86 6.89 63 4.987388 0.612912
10/6/99 8:00 26.09 67 108 8.41 6.16 64 5.098573 0.675028
10/6/99 12:00 22.02 96 112 6.11 4.40 65 5.521828 0.019772
10/6/99 16:00 20.84 91 129 5.01 4.90 66 5.143632 -0.05943
10/6/99 20:00 20.22 85 119 5.26 4.81 67 3.769467 -0.29117
10/7/99 0:00 19.11 91 121 4.78 4.44 68 4.417021 -1.55602
10/7/99 4:00 17.84 65 123 5.22 5.45 69 4.760911 0.158889
10/7/99 8:00 16.41 70 106 4.89 4.58 70 4.443434 1.191466
10/7/99 12:00 17.54 93 110 8.55 3.84 71 5.39602 0.222481
10/7/99 16:00 25.13 85 121 8.21 5.57 72 4.958834 0.430466
10/7/99 20:00 32.92 80 119 5.92 6.86 73 3.752594 -0.38659
10/8/99 0:00 34.48 88 114 4.17 6.60 74 5.695803 -1.9567
10/8/99 4:00 31.07 67 121 3.71 7.22 75 6.742902 -1.6369
10/8/99 8:00 28.63 70 106 2.99 6.34 76 6.664268 0.007031
10/8/99 12:00 24.75 91 110 5.32 4.97 77 6.450067 2.059633
10/8/99 16:00 29.46 83 119 6.33 6.23 78 6.425738 1.955562
10/8/99 20:00 33.45 85 117 6.87 6.66 79 4.63315 0.53715
10/9/99 0:00 31.28 80 119 7.41 6.62 80 5.653546 0.844154
10/9/99 4:00 28.13 67 114 8.81 6.61 81 6.601236 -0.33664
10/9/99 8:00 26.33 62 108 8.01 6.42 82 6.19047 2.13433
10/9/99 12:00 24.25 93 106 5.26 4.70 83 6.8946 -0.0324
10/9/99 16:00 21.73 93 121 4.27 4.73 84 6.160738 2.249861
10/9/99 20:00 21.21 91 123 5.99 4.79 85 4.404533 1.701167
10/10/99 0:00 19.18 83 119 6.17 4.75 86 4.897699 0.116901
10/10/99 4:00 18.21 67 117 5.45 5.26 87 4.811332 0.446568
10/10/99 8:00 18.32 55 104 4.77 5.47 88 4.439976 0.339225
10/10/99 12:00 18.33 91 99 3.83 3.75 89 5.451917 -0.23312
10/10/99 16:00 19.59 88 119 2.66 4.59 90 4.582946 0.305855
10/10/99 20:00 19.89 85 121 4.55 4.82 91 3.83916 4.71284
10/11/99 0:00 19.68 80 119 5.14 4.95 92 5.570464 2.636536
10/11/99 4:00 19.04 52 114 5.13 5.96 93 6.859704 -0.9361
10/11/99 8:00 17.97 67 101 4.85 4.81 94 6.602348 -2.43145
10/11/99 12:00 18.11 88 108 2.92 4.09 95 7.21681 -3.51071
10/11/99 16:00 27.33 85 123 4.00 5.94 96 6.342464 -3.34796
10/11/99 20:00 36.67 77 119 4.72 7.53 97 4.9652 0.3555
10/12/99 0:00 36.67 83 114 6.69 7.14 98 6.229666 0.103634
10/12/99 4:00 31.80 60 119 9.56 7.58 99 6.664121 0.201679
10/12/99 8:00 29.67 60 104 9.01 6.88 100 6.623566 0.784234
10/12/99 12:00 24.10 91 104 4.90 4.72 101 6.610941 2.197159
10/12/99 16:00 28.30 83 119 6.29 6.06 102 6.415035 1.591765
10/12/99 20:00 31.84 75 117 5.77 6.87 103 4.700998 0.560602
10/13/99 0:00 30.35 83 112 6.69 6.18 104 4.729325 -0.46422
10/13/99 4:00 26.87 57 114 8.18 6.87 105 4.794504 1.198896
10/13/99 8:00 24.51 52 99 6.17 6.36 106 4.749482 1.421818
10/13/99 12:00 20.52 80 97 4.82 4.50 107 5.260827 0.187873
10/13/99 16:00 19.44 75 117 5.41 5.09 108 5.465024 -0.69102
10/13/99 20:00 19.24 75 110 5.15 4.88 109 3.753944 0.077256
10/14/99 0:00 18.72 77 112 3.93 4.76 110 4.588777 -1.92558
10/14/99 12:00 16.78 77 101 3.39 4.20 111 4.815973 -0.26637
10/14/99 16:00 24.14 72 117 4.02 5.89 112 4.95332 0.185881
10/14/99 20:00 30.56 67 110 4.42 6.86 113 5.961321 -0.83102
10/15/99 0:00 31.24 80 108 5.85 6.33 114 4.809018 0.042082
10/15/99 4:00 27.38 55 117 7.77 7.11 115 4.088816 -1.16402
10/15/99 8:00 25.39 50 101 7.72 6.62 116 5.939391 -1.93769
10/15/99 12:00 22.26 80 101 4.56 4.86 117 7.531499 -2.8116
10/15/99 16:00 27.53 72 114 5.46 6.30 118 7.137419 -0.45102
10/15/99 20:00 32.81 72 108 5.87 6.91 119 7.577399 1.9864
10/16/99 0:00 31.34 67 110 6.81 6.97 120 6.879534 2.130966
10/16/99 4:00 28.35 55 110 8.50 7.07 121 4.715139 0.186161
10/16/99 8:00 26.18 50 99 7.53 6.69 122 6.062641 0.228959
10/16/99 12:00 23.80 80 95 5.32 4.92 123 6.871782 -1.09738
10/16/99 16:00 23.75 75 117 3.92 5.71 124 6.175267 0.511233
10/16/99 20:00 22.24 70 117 6.48 5.71 125 6.868998 1.314002
10/17/99 0:00 19.95 62 114 6.02 5.65 126 6.357755 -0.18355
10/17/99 4:00 17.95 48 108 5.57 5.82 127 4.500547 0.323453
10/17/99 8:00 16.56 55 97 4.64 5.03 128 5.086346 0.322953
10/17/99 12:00 16.08 80 101 3.36 3.97 129 4.875001 0.274699
10/17/99 16:00 17.95 75 119 2.29 4.92 130 4.764388 -0.83249
10/17/99 20:00 19.43 67 114 4.25 5.36 131 4.198194 -0.80389
10/18/99 0:00 18.86 75 112 4.72 4.87 132 5.894928 -1.87933
10/18/99 4:00 17.70 50 114 5.23 5.86 133 6.856516 -2.43252
10/18/99 8:00 16.64 50 101 5.05 5.36 134 6.330946 -0.47995
10/18/99 12:00 16.25 80 104 2.95 4.07 135 7.108561 0.664939
10/18/99 16:00 24.82 75 121 3.11 5.97 136 6.624516 1.092784
10/18/99 20:00 31.25 67 112 4.13 7.01 137 4.855397 -0.2975
10/19/99 0:00 34.92 75 112 5.93 7.18 138 6.304809 -0.84421
10/19/99 4:00 32.56 55 119 8.46 7.91 139 6.908589 -1.03919
10/19/99 8:00 30.53 50 104 9.30 7.44 140 6.968825 -0.15753
10/19/99 12:00 25.76 77 101 5.98 5.49 141 7.065681 1.434319
10/19/99 16:00 29.64 70 121 6.56 6.88 142 6.686109 0.844191
10/19/99 20:00 32.52 72 114 6.72 7.02 143 4.920667 0.394633
10/20/99 0:00 30.18 72 114 7.22 6.69 144 5.706929 -1.79173
10/20/99 4:00 26.49 55 117 8.64 6.98 145 5.709249 0.773251
10/20/99 8:00 23.61 52 104 8.54 6.36 146 5.652869 0.362831
10/20/99 12:00 19.25 83 108 4.80 4.47 147 5.823698 -0.2541
10/20/99 16:00 18.18 77 125 5.20 5.03 148 5.02906 -0.39246
10/20/99 20:00 18.16 77 117 4.90 4.81 149 3.965559 -0.61006
10/21/99 0:00 18.60 80 117 4.38 4.75 150 4.923963 -2.63366
10/21/99 4:00 17.71 57 121 4.94 5.73 151 5.358256 -1.10506
10/21/99 8:00 16.78 57 106 4.49 5.21 152 4.872443 -0.15544
153 5.856275 -0.62897
154 5.364632 -0.31683
155 4.068271 -1.11507
156 5.965308 -2.85391
157 7.008023 -2.87602
158 7.18487 -1.25037
159 7.90657 0.55333
160 7.442843 1.857657
161 5.491195 0.484505
162 6.879064 -0.32216
163 7.023303 -0.3077
164 6.686374 0.535327
165 6.980413 1.662686
166 6.358558 2.176941
167 4.4727 0.324199
168 5.025653 0.171447
169 4.814147 0.089653
170 4.745657 -0.36206
171 5.732626 -0.79043
172 5.207545 -0.71904