Determinacion de la curva Elevaciones-Ga

Metodo Regresion lineal:

Fecha PTS. Altura "H" Caudal X*Y

(m) "Q" (m3/s)

1/15/2019 1 1.42 126.8 180.056

1/19/2019 2 1.61 146.5 235.865
1/22/2019 3 1.15 94.8 109.02
1/26/2019 4 1.05 81.6 85.68
1/30/2019 5 1.11 89.5 99.345
3/1/2019 6 0.12 3.2 0.384
3/5/2019 7 0.77 59.4 45.738
3/12/2019 8 0.71 52.3 37.133
5/17/2019 9 0.82 66.9 54.858
3/20/2019 10 0.49 32.5 15.925
3/25/2019 11 0.34 17.8 6.052
Sumatoria
9.59 771.3 870.056

XPROM = 1.07
YPROM = 85.70 a =
Sxy = 5.35 b =
S²x = 0.02
S²y = 802.06

Ecuación de la recta
YI = a + b(Xi)
YI = -96.6563+ 259.4793(Xi)

160
H(m) Q(m3/s)
160
0.1 -163.91090118
0.2 -138.059369412
140
0.3 -112.207837645 f(x) = 96.0641278179033 x − 13
R² = 0.990765181911711
0.4 -86.3563058767 120
0.5 -60.504774109
0.6 -34.6532423412 100

0.7 -8.80171057337
0.8 17.04982119442 80

0.9 42.90135296221
60
1 68.75288473
1.1 94.60441649779 40
1.2 120.4559482656
1.3 146.3074800334 20

1.4 172.1590118012
0
1.5 198.010543569 0 0.2 0.4 0.6
1.6 223.8620753368
1.8 275.5651388723
1.9 301.4166706401
2 327.2682024079
2.1 353.1197341757
2.2 378.9712659435
2.3 404.8227977113
2.4 430.6743294791
2.5 456.5258612469
e la curva Elevaciones-Gastos

X² Y²

2.0164 16078.24
2.5921 21462.25
1.3225 8987.04
1.1025 6658.56
1.2321 8010.25
0.0144 10.24
0.5929 3528.36
0.5041 2735.29
0.6724 4475.61
0.2401 1056.25
0.1156 316.84

10.4051 73318.93

-189.7624
258.5153

PEARSON: 0.9954

Chart Title
 Chart Title

f(x) = 96.0641278179033 x − 13.3913066316481

R² = 0.990765181911711

0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8

1.8
 Método Regresion no lineal:

Fecha PTS. Altura Caudal

"Q" X*Y X²
"H" (m)
(m3/s)
1/15/2019 1 1.42 126.8 180.056 2.016
1/19/2019 2 1.61 146.5 235.865 2.592
1/22/2019 3 1.15 94.8 109.020 1.323
1/26/2019 4 1.05 81.6 85.680 1.103
1/30/2019 5 1.11 89.5 99.345 1.232
3/1/2019 6 0.12 3.2 0.384 0.014
3/5/2019 7 0.77 59.4 45.738 0.593
3/12/2019 8 0.71 52.3 37.133 0.504
5/17/2019 9 0.82 66.9 54.858 0.672
3/20/2019 10 0.49 32.5 15.925 0.240
3/25/2019 11 0.34 17.8 6.052 0.116
Sumatoria 9.59 771.3 870.056 10.405

Sistemas de ecuaciones para determinar los coeficientes:

∑_(𝒊=𝟏)^𝒏▒𝒀𝒊=𝒏𝑨+𝑩∑_(𝒊=𝟏)^𝒏▒𝑿𝒊+𝑪∑_(𝒊=𝟏)^𝒏▒ 〖𝑿𝒊〗 ^𝟐
∑_(𝒊=𝟏)^𝒏▒ 〖𝑿𝒊∗𝒀𝒊〗 =𝑨∑_(𝒊=𝟏)^𝒏▒𝑿𝒊+𝑩∑_(𝒊=𝟏)^𝒏▒ 〖𝑿
𝒊〗 ^𝟐 +𝑪∑_(𝒊=𝟏)^𝒏▒ 〖𝑿𝒊〗 ^𝟑
∑_(𝒊=𝟏)^𝒏▒ 〖〖𝑿𝒊〗 ^𝟐∗𝒀𝒊 〗 =𝑨∑_(𝒊=𝟏)^𝒏▒ 〖𝑿𝒊〗 ^𝟐
+𝑩∑_(𝒊=𝟏)^𝒏▒ 〖𝑿𝒊〗 ^𝟑 +𝑪∑_(𝒊=𝟏)^𝒏▒ 〖𝑿𝒊〗 ^𝟒

Curva de Alturas - Gastos

160

140 f(x) = 14.4957609039135 x² + 70.6625292633228 x − 4.8530506638329

R² = 0.997098231874712
120

100
stos (m3/s)

80

60
 160

140 f(x) = 14.4957609039135 x² + 70.6625292633228 x − 4.8530506638329

R² = 0.997098231874712
120

100

Gastos (m3/s)
80

60

40

20

0
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8
Alturas (m)
 Y² X²*Y Xᶟ X⁴

16078.240 255.680 2.863 4.066

21462.250 379.743 4.173 6.719
8987.040 125.373 1.521 1.749
6658.560 89.964 1.158 1.216
8010.250 110.273 1.368 1.518
10.240 0.046 0.002 0.000
3528.360 35.218 0.457 0.352
2735.290 26.364 0.358 0.254
4475.610 44.984 0.551 0.452
1056.250 7.803 0.118 0.058
316.840 2.058 0.039 0.013
73318.930 1077.505 12.607 16.396

11.00 9.5900 10.4051 (a)

9.5900 10.4051 12.6072 (b) =
10.4051 12.6072 16.3964 (c)

(a)= -6.3178563
(b)= 72.53663113
(c)= 13.95182428

ECUACIÓN CUADRÁTICA
YI = a + b(Xi) + c(Xi2)
YI = -33.60383 Xi²+120.96377 Xi +61.488701

0506638329
H(m) Q(m3/s)
0506638329

0.1 445.9551437289
0.2 891.7839303317
0.3 1337.486359809
0.4 1783.062432159
0.5 2228.512147384
0.6 2673.835505483
0.7 3119.032506455
1.4 1.6 1.8
0.8 3564.103150302
0.9 4009.047437023
1 4453.865366617
1.1 4898.556939086
1.2 5343.122154428
1.3 5787.561012645
1.4 6231.873513735
1.5 6676.0596577
1.6 7120.119444538
1.8 8007.859946837
1.9 8451.540662297
2 8895.095020631
2.1 9338.523021839
2.2 9781.824665921
2.3 10224.99995288
2.4 10668.04888271
2.5 11110.97145541
 771.3
870.056
1077.505 1.18261413 -2.64223984
-2.64223984 7.30898602
1.28113373 -3.94311806
1.28113373
-3.94311806
2.27984653
 Regresion Exponencial:

Caudal
Fecha PTS. Altura "Q" ln y X²
"H" (m)
(m3/s)
1/15/2019 1 1.42 126.8 4.842611 2.0164
1/19/2019 2 1.61 146.5 4.987025 2.5921
1/22/2019 3 1.15 94.8 4.551769 1.3225
1/26/2019 4 1.05 81.6 4.401829 1.1025
1/30/2019 5 1.11 89.5 4.494239 1.2321
3/1/2019 6 0.12 3.2 1.163151 0.0144
3/5/2019 7 0.77 59.4 4.084294 0.5929
3/12/2019 8 0.71 52.3 3.956996 0.5041
5/17/2019 9 0.82 66.9 4.203199 0.6724
3/20/2019 10 0.49 32.5 3.481240 0.2401
3/25/2019 11 0.34 17.8 2.879198 0.1156
Sumatori
a 9.59 771.3 43.045553 10.4051

XPROM = 1.07 a = 545841383849.021

LnYPROM = 4.78 b = -20.8743

Para hallar los coeficientes

a = ℮^(𝑳𝒏(𝒚)
−𝒃𝑿𝒑𝒓𝒐𝒎)
b= (∑▒ 〖𝒙∗𝑳𝒏⁡(𝒚)
−
(𝑳𝒏(𝒚)∗∑▒𝒙) ̅ 〗 )/
(∑▒ 〖𝒙 ^𝟐−𝒙 ̅ 〗∗
Curva de Alturas y Gastos
∑▒𝒙 )
160
f(x) = 5.96175585928313 exp( 2.35351926219058 x )
R² = 0.808027955859999
140

120
 Curva de Alturas y Gastos
160
f(x) = 5.96175585928313 exp( 2.35351926219058 x )
R² = 0.808027955859999
140

120

100

Gastos (m3/s) 80

60

40

20

0
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8

Alturas (m)
 x ln y (ln y)2

6.8765076796 23.45088170413
8.0291109398 24.87042262408
5.2345348207 20.71860475508
4.6219207251 19.37610085154
4.9886048741 20.19818082097
0.1395780972 1.352919806352
3.1449065543 16.68145932755
2.8094674235 15.65782028067
3.4466231531 17.66688155732
1.7058076438 12.1190325596
0.9789274755 8.289783756507

41.975989386 180.3820880438

ECUACIÓN EXPONENCIAL
Yi= a * e(b*x)
Yi=17.92494711 * e(1.8329*x)

H(m) Q(m3/s)
0.1 67,687,107,783.47
0.2 8,393,545,626.36
0.3 1,040,842,347.81
0.4 129,069,744.92
0.5 16,005,304.83
 0.6 1,984,739.20
0.7 246,117.76
0.8 30,519.85
0.9 3,784.62
1 469.31
1.1 58.20
1.2 7.22
1.3 0.89
1.4 0.11
1.5 0.01
1.6 0.00
1.8 0.00
1.9 0.00
1.2 1.4 1.6 1.8 2 0.00
2.1 0.00
2.2 0.00
2.3 0.00
2.4 0.00
2.5 0.00
 Metodo Regresion Logaritmica :

Caudal
Fecha PTS. Altura "Q" ln x ln2x y ln x
"H" (m) (m3/s)
1/15/2019 1 1.42 126.8 0.3506568716 0.1229602416 44.463291321
1/19/2019 2 1.61 146.5 0.476234179 0.2267989932 69.768307223
1/22/2019 3 1.15 94.8 0.1397619424 0.0195334005 13.249432137
1/26/2019 4 1.05 81.6 0.0487901642 0.0023804801 3.9812773962
1/30/2019 5 1.11 89.5 0.1043600153 0.0108910128 9.3402213715
3/1/2019 6 0.12 3.2 -2.120263536 4.4955174629 -6.784843316
3/5/2019 7 0.77 59.4 -0.261364764 0.0683115399 -15.52506699
3/12/2019 8 0.71 52.3 -0.342490309 0.1172996117 -17.91224316
5/17/2019 9 0.82 66.9 -0.198450939 0.0393827751 -13.2763678
3/20/2019 10 0.49 32.5 -0.713349888 0.5088680625 -23.18387136
3/25/2019 11 0.34 17.8 -1.078809661 1.1638302855 -19.20281197
Sumatoria
9.59 771.3 -3.594925925 6.775773866 44.917324856

LnXprom = -0.399436 a = 112.105703

Yprom = 85.7 b = 66.107434

a= 

b = 

Gráfica

Curva deAlturas y Gastos

160

140

120
f(x) = 48.8669725021161 ln(x) + 89.8995261000672
 Curva deAlturas y Gastos
160

140

120
f(x) = 48.8669725021161 ln(x) + 89.8995261000672
100 R² = 0.798248004244706
Gastos (m3/s)

80

60

40

20

0
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8

Alturas(m)
Y²

16078.24
21462.25
8987.04
6658.56
8010.25
10.24
3528.36
2735.29
4475.61
1056.25
316.84

73318.93

ECUACIÓN LOGARÍTMICA

Yi= a + b*lnx
Yi=193.4696 + 225.7249 * lnx

H(m) Q(m3/s)
0.1 -152.217992
0.2 5.70989263
0.3 32.5141505
 0.4 51.5320741
0.5 66.2835217
0.6 78.3363319
0.7 88.5268378
0.8 97.3542555
0.9 105.14059
1 112.105703
1.1 118.406415
1.2 124.158513
1.3 129.449931
1.4 134.349019
1.5 138.909961
1.4 1.6 1.8 1.6 143.176437
1.8 150.962771
1.9 154.537017
2 157.927885
2.1 161.153277
2.2 164.228596
2.3 167.167188
2.4 169.980695
2.5 172.679332