hidro precipitacion.xlsx

3
AÑO PRECIPITACION MAXIMA PP MAX COREGIDA 1 1964 23.6 26.67 2 1965 25.2 28.48 3 1966 30.3 34.24 4 1967 30.0 33.90 5 1968 47.6 53.79 6 1969 26.3 29.72 7 1970 23.6 26.67 8 1971 22.5 25.43 9 1972 25.8 29.15 10 1973 29.2 33.00 11 1974 25.1 28.36 12 1982 24.8 28.02 13 1988 25.0 28.25 14 1989 25.3 28.59 15 1990 24.4 27.57 16 1991 25.8 29.15 17 1992 21.6 24.41 18 1993 29.2 33.00 19 1994 25.6 28.93 20 1995 21.0 23.73 21 1996 15.9 17.97 22 1997 17.6 19.89 23 1998 14.9 16.84 24 1999 16.9 19.10 25 2000 12.4 14.01 26 2001 28.3 31.98 27 2002 26.2 29.61 28 2003 30.4 34.35 29 2004 15.5 17.52 30 2005 13.2 14.92 31 2006 14.0 15.82 32 2007 15.2 17.18 33 2008 16.5 18.65 34 2009 30.6 34.58 35 2010 24.3 27.46 36 2011 27.2 30.74 26.71 MEDIA 26.71 DESVIACION ESTANDAR 7.7232 1.1313 0.5410 σN N

Upload: emanuel-anccasi-ramos

Post on 07-Feb-2016

7 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: HIDRO PRECIPITACION.xlsx

AÑO PRECIPITACION MAXIMA PP MAX COREGIDA (PP MAX)^2

1 1964 23.6 26.67 711.1822242 1965 25.2 28.48 810.8825763 1966 30.3 34.24 1172.3091214 1967 30.0 33.90 1149.2100005 1968 47.6 53.79 2893.1489446 1969 26.3 29.72 883.2189617 1970 23.6 26.67 711.1822248 1971 22.5 25.42 646.4306259 1972 25.8 29.15 849.95571610 1973 29.2 33.00 1088.73601611 1974 25.1 28.36 804.45976912 1982 24.8 28.02 785.34457613 1988 25.0 28.25 798.06250014 1989 25.3 28.59 817.33092115 1990 24.4 27.57 760.21518416 1991 25.8 29.15 849.95571617 1992 21.6 24.41 595.75046418 1993 29.2 33.00 1088.73601619 1994 25.6 28.93 836.82918420 1995 21.0 23.73 563.11290021 1996 15.9 17.97 322.81308922 1997 17.6 19.89 395.53254423 1998 14.9 16.84 283.48456924 1999 16.9 19.10 364.69540925 2000 12.4 14.01 196.33614426 2001 28.3 31.98 1022.65644127 2002 26.2 29.61 876.51523628 2003 30.4 34.35 1180.05990429 2004 15.5 17.51 306.77522530 2005 13.2 14.92 222.48705631 2006 14.0 15.82 250.27240032 2007 15.2 17.18 295.01497633 2008 16.5 18.65 347.63602534 2009 30.6 34.58 1195.63808435 2010 24.3 27.46 753.99668136 2011 27.2 30.74 944.701696

26.71 27774.669116

MEDIA 26.71

DESVIACION ESTANDAR 7.7232

1.1313

0.5410

σN

ῩN

Page 2: HIDRO PRECIPITACION.xlsx

COEFICIENTE DE ASIMETRIA 0.842MEDIA DE LOGARITMOS 1.4090

DESVIACION ESTANDAR DE LOS LOGARITMOS 0.12736143410201COEFICIENTE DE ASIMETRIA -0.284

N 362.639

Dato dudoso alto.Dato dudoso bajo.

PL1 (Limite Superior) 1.7306854

PL2 (Limite Inferior) 1.14650013

PL1 (Limite Superior) 53.79

PL2 (Limite Inferior) 14.012

1.7451200255.6057907

KN

CS > + 0.4CS < + 0.4

yh

Qh

=−𝟎.𝟒 < 𝐂𝐬 = −𝟎.𝟐𝟖𝟒 < 𝟎.𝟒

Page 3: HIDRO PRECIPITACION.xlsx

LOG (PPMAX)

1.431.451.531.531.731.471.431.411.461.521.451.451.451.461.441.461.391.521.461.381.251.301.231.281.151.501.471.541.241.171.201.231.271.541.441.49

0.842 1.4090 -0.28389769