[go: up one dir, main page]

0% encontró este documento útil (0 votos)
112 vistas9 páginas

Ejemplos de Completación de Datos Hidrología

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1/ 9

BP ENE FEB MAR ABR MAY JUN JUL AGO SET

1971 40.1 1.1 0.1 0.0 6.1 7.9


1972 136.0 195.0 250.0 78.0 0.0 0.0 0.0 4.0 16.0
1973 112.0 73.0 133.7 90.0 18.0 1.0 4.0 2.0 64.0
1974 155.2 209.0 141.0 11.0 1.0 37.0 0.0 0.0 26.0
1975 123.0 165.0 225.0 63.0 142.2 3.0 0.0 19.0 49.6
1976 149.0 91.0 93.0 75.0 12.0 12.0 0.0 5.0 8.0
1977 85.3 168.5 93.4 25.6 25.5 0.0 0.0 0.0 48.0
1978 58.2 184.6 46.8 29.6 37.3 0.0 2.0 0.0 49.0
1979 67.0 130.0 179.0 57.0 11.0 0.0 0.0 15.0 43.0
1980 64.0 55.0 64.0 32.0 7.0 3.0 0.0 0.0 0.0
1981 67.0 225.0 135.2 37.8 0.0 0.0 0.0 11.9 8.3
1982 51.1 138.0 106.8 52.0 0.0 0.0 0.0 2.0 7.0
1983 91.6 37.3 128.7 72.0 44.3 16.2 0.0 0.0 14.8
1984 81.6 280.0 214.6 70.2 37.1 0.0 0.0 0.0 30.0
1985 24.0 86.0 34.4 70.0 23.0 0.0 0.0 12.0 68.3
1986 118.0 84.2 64.0 115.2 17.0 0.0 0.0 8.0 1.8
1987 146.1 90.0 139.8 78.6 23.3 0.0 0.0 0.0 24.3
1988 137.3 137.8 76.4 106.0 14.2 0.0 0.0 2.0 22.2
1989 135.0 122.8 136.6 122.0 19.0 3.0 0.0 8.0 26.4
1990 79.7 101.0 79.7 39.2 7.6 17.0 0.0 0.0 6.0
1991 52.8 59.5 211.0 34.5 21.5 0.0 0.0 0.0 7.5
1992 12.3 79.0 100.1 65.7 12.8 9.0 1.0 6.1 6.7
1993 131.4 128.0 174.4 105.8 18.1 2.0 0.0 0.0 65.5
1994 136.6 193.0 204.7 82.5 40.4 0.0 0.0 0.0 45.8
1995 101.7 51.0 130.2 76.6 41.9 0.0 0.0 0.9 5.2
1996 105.0 115.5 139.3 123.2 21.4 0.0 0.0 2.0 24.0
1997 86.4 109.8 37.8 56.8 16.2 0.6 0.0 0.0 11.9
1998 188.1 180.8 210.6 154.9 50.2 5.2 0.0 0.0 5.0
1999 95.0 128.0 6.0 0.0 0.0 0.0 0.0 22.4
2000 50.0 187.0 135.0 55.0 38.0 0.0
2001
97.9 131.2 127.3 69.6 23.4 3.6 0.2 3.6 24.6
42.1 59.0 63.2 33.7 26.8 7.9 0.8 5.2 20.7
OCT NOV DIC
21.5 28.3 92.6 1.0
17.0 38.0 74.0 2.0 808.0
54.0 87.0 177.0 3.0 815.7
54.2 39.9 44.0 4.0 718.3
96.0 143.0 37.0 5.0 1065.8
20.2 13.9 48.2 6.0 527.3
30.6 121.0 59.0 7.0 656.9
41.0 44.0 48.0 8.0 540.5
0.0 36.0 33.0 9.0 571.0
140.0 113.0 100.0 10.0 578.0
122.2 195.5 67.4 11.0 870.3
147.0 100.4 67.0 12.0 671.3
40.1 58.8 111.8 13.0 615.6
60.3 31.9 84.9 14.0 890.6
9.0 22.3 78.0 15.0 427.0
23.9 54.4 85.3 16.0 571.8
2.0 59.0 75.0 17.0 638.1
41.3 88.7 63.7 18.0 689.6
126.0 24.0 19.0 722.8
124.5 99.8 74.4 20.0 628.9
88.6 41.5 63.6 21.0 580.5
56.6 20.5 10.1 22.0 379.9
66.4 93.2 211.3 23.0 996.1
12.4 62.5 63.6 24.0 841.5
33.1 61.7 78.1 25.0 580.4
69.6 35.8 35.6 26.0 671.4
40.0 93.2 210.2 27.0 662.9
118.4 55.8 76.9 28.0 1045.9
31.0 73.0 68.0 29.0 423.4
30.0

58.2 66.8 79.9


43.9 41.6 47.6
BP ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV
1953 139.0 251.3 42.8 75.4 27.4 3.0 0.0 0.0 0.0 0.0 80.8
1954 209.6 94.9 106.9 17.8 0.0 0.0 24.9
1955 89.1 187.2 120.0 57.0 0.0 0.0 0.0 0.0 7.1 16.6 6.4
1956 79.6 112.9 33.3 0.0 0.0 0.0 0.0 0.0 4.2 22.6
1957 15.4 73.7 37.4 71.3 13.7 0.0 0.0 0.0 9.5 144.8 8.9
1958 50.5 86.0 148.5 44.6 5.9 0.0 0.0 0.0 17.8 26.8 7.1
1959 10.7 166.2 142.5 38.0 75.4 0.0 0.0 0.0 0.0 90.2 11.9
1960 64.0 95.0 71.3 129.5 8.9 0.0 0.0 5.9 8.9 14.8 62.4
1961 128.8 60.6 63.5 116.3 19.6 0.0 0.0 0.0 4.2 0.0 96.8
1962 121.2 82.6 191.9 47.5 3.0 0.0 0.0 0.0 39.2 32.1 50.5
1963 84.2 103.4 169.4 126.6 2.4 0.0 0.0 0.0 23.7 38.8 104.6
1964 42.1 52.8 135.4 52.3 38.6 0.0 1.2 3.6 5.4 23.2 34.5
1965 54.1 51.0 26.2 11.9 17.9 0.0 0.0 0.0 22.6 53.6 19.0
1966 154.4 32.2 57.7 25.0 7.8 0.0 0.0 0.0 9.6 87.7 52.4
1967 90.3 139.7 174.6 29.7 0.0 0.0 10.6 3.6 21.1 121.8 25.0
1968 73.1 29.7 65.5 5.9 5.4 0.0 0.0 11.9 3.6 58.8 23.8
1969 29.7 60.1 85.5 39.2 1.8 0.0 0.0 0.0 0.0 39.8 60.3
1970 123.0 14.2 20.7 114.0 46.2 10.4 2.4 9.6 52.9 38.7 47.8
1971 1.7 81.3
1972 0.0 1.0
1973 7.4 7.5 12.8 62.3 115.8 116.8
1974 129.1 151.1 169.2 119.2 0.5 12.5 3.8 21.5 26.2 30.8 27.3
1975 142.0 176.3 237.0 51.6 78.3 6.9 0.0 18.1 39.9 56.2 61.1
1976 162.9 76.7 143.0 39.9 39.9 10.1 1.1 0.7 9.9
1977 197.4 147.9 100.3 28.8 20.1 0.0 0.5 1.3 36.2 24.3 122.3
1978 62.0 152.4 58.7 68.8 20.2 0.0 2.6 0.0 55.4 36.1 45.5
1979 89.7 97.8 181.4 105.4 17.0 0.0 0.0 8.1 35.7 18.4 15.7
1980 56.9 81.1 41.1 8.0 1.1 0.0 4.3 0.0 174.4 117.5
1981 120.8 157.9 205.6 43.9 0.0 2.1 0.0 13.6 4.6 106.8 99.3
1982 84.2 160.0 98.4 72.2 2.9 0.0 0.3 0.6 12.7 154.0 118.2
1983 126.2 76.9 191.2 79.9 18.7 18.0 0.9 1.3 28.5 55.5 49.3
1984 122.3 253.9 214.5 94.6 81.9 14.9 2.3 0.9 35.1 119.0 62.9
1985 48.9 90.9 114.5 101.5 39.3 0.0 5.3 5.3 68.2 20.0 34.9
1986 131.3 102.9 71.8 154.6 6.9 0.0 1.8 6.6 20.2 11.9 56.0
1987 161.2 131.9 119.9 123.3 24.6 0.0 0.5 22.6 48.0 38.9 60.7
1988 131.7 105.6 99.9 120.2 41.2 0.3 0.0 1.1 34.2 53.7 50.3
1989 117.7 133.5 145.9 113.7 19.8 1.9 0.0 22.0 24.3 101.2 19.0
1990 121.0 90.2 103.6 40.0 6.1 7.8 0.0 0.0 12.0 128.7 122.0
1991 104.6 58.4 181.4 72.4 43.7 0.0 0.0 0.0 4.3 95.5 31.4
1992 48.6 54.9 97.1 62.8 14.2 22.0 3.3 14.3 31.7 81.2 30.6
1993 90.3 158.7 85.8 26.7 8.4 0.3 0.0 66.5 80.9 82.4
1994 110.0 118.6 121.8 104.5 6.9 106.4
1995 138.4 79.7 161.8 74.9 50.7 2.1 0.8 0.6 8.1 63.2 69.3
1996 141.2 207.0 110.0 70.4 8.4 0.7 0.0 0.0 31.7 25.3
1997 102.2 151.5 39.3 54.1 13.7 0.4 0.6 0.0 15.7 58.1 92.9
1998 148.2 160.8 164.8 104.8 11.4 5.5 0.0 5.5 22.4 43.9 42.6
1999 126.9 230.2 118.4 102.2 50.6 21.2 9.2 2.9 74.5 38.2 26.0
2000
2001
DIC Dic H Dic A
136.0
51.6
78.4

11.9
10.1
133.0
50.5
107.5
34.4
140.1
10.1
54.6
41.6
31.6
30.3
158.6
99.0 HuarazAnta
0.0 93
0.0 74
94.7 94.7 177
54.9 54.9 44
51.1 51.1 37
57.0 57.0 48
100.9 100.9 59
50.1 50.1 48
0.0 33
89.7 89.7 100
59.8 59.8 67
134.4 134.4 67
126.5 126.5 112
66.4 66.4 85
87.8 87.8 78
175.0 175.0 85
113.0 113.0 75
77.7 77.7 64
8.1 8.1 0
55.7 55.7 74
54.2 54.2 64
12.6 12.6 10
126.9 126.9 211
122.2 122.2 64
183.9 183.9 78
0.0 36
183.3 183.3 210
58.2 58.2 77
0.0 68
Huaraz (Y)Anta (X) XY X2 Y2
1 94.7 177 16761.9 31329 8968.09 Resumen
2 54.9 44 2415.6 1936 3014.01
3 51.1 37 1890.7 1369 2611.21 Estadísticas de la regresión
4 57.0 48 2747.4 2323 3249.00 Coeficiente de correlación múltiple
5 100.9 59 5953.1 3481 10180.81 Coeficiente de determinación R^2
6 50.1 48 2404.8 2304 2510.01 R^2 ajustado
7 89.7 100 8970 10000 8046.09 Error típico
8 59.8 67 4030.52 4543 3576.04 Observaciones
9 134.4 67 9004.8 4489 18063.36
10 126.5 112 14142.7 12499 16002.25 ANÁLISIS DE VARIANZA
11 66.4 85 5637.36 7208 4408.96 Grados de libertad
12 87.8 78 6848.4 6084 7708.84 Regresión
13 175.0 85 14927.5 7276 30625.00 Residuos
14 113.0 75 8475 5625 12769.00 Total
15 77.7 64 4949.49 4058 6037.29
16 55.7 74 4144.08 5535 3102.49
17 54.2 64 3447.12 4045 2937.64 Intercepción
18 12.6 10 127.26 102 158.76 Variable X 1
19 126.9 211 26813.97 44648 16103.61
20 122.2 64 7771.92 4045 14932.84
21 183.9 78 14362.59 6100 33819.21
22 183.3 210 38529.66 44184 33598.89 Análisis de los residuales
23 58.2 77 4475.58 5914 3387.24
2136 1934.5 208831.45 219096.27 245810.64 Observación
92.9 84.1 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
cas de la regresión
0.5640837384
0.3181904639
0.2857233431
39.246410674
23

Grados de libertad
Suma de cuadrados
Promedio de los cuadrados F Valor crítico de F
1 15095.35293 15095.35293 9.8003905602 0.0050539686
21 32345.895766 1540.2807508
22 47441.248696

Coeficientes Error típico Estadístico t Probabilidad Inferior 95% Superior 95% Inferior 95.0% Superior 95.0%
49.351538463 16.130958695 3.0594299692 0.0059534607 15.805373432 82.897703493 15.805373432 82.897703493
0.5174022307 0.1652747866 3.1305575478 0.0050539686 0.1736944963 0.8611099652 0.1736944963 0.8611099652

Pronóstico para Y Residuos


140.9317333 -46.2317333
72.117236615 -17.21723662
68.495421 -17.395421
74.290325984 -17.29032598
79.878270076 21.021729924
74.186845538 -24.08684554
101.09176154 -11.39176154
84.224448814 -24.42444881
84.017487922 50.382512078
107.19710786 19.302892141
93.278987852 -26.87898785
89.70891246 -1.90891246
93.485948744 81.514051256
88.156705768 24.843294232
82.310060561 -4.610060561
87.846264429 -32.14626443
82.258320337 -28.05832034
54.577300993 -41.97730099
158.67862982 -31.77862982
82.258320337 39.941679663
89.760652683 94.139347317
158.10948736 25.190512637
89.139770006 -30.93977001
Variable X 1 Curva de regresión
ajustada
200.0
Y
100.0 Pronóstico para Y
Y

0.0
0 50 100 150 200 250
Variable X 1

También podría gustarte