Realizado Excel

7/23/2019 Realizado Excel

1/13

Ene Feb Mar Abr May Jun Jul Ago Set Oct Nov Dic

0.000

10.000

20.000

30.000

40.000

50.000

0.000

!0.000

"0.000

#0.000

100.000

COMPARACIN DE PRECIPITACIN PROMEDIO MENSUALESTACIN PLU. CANDARAVE

1#4$1#"!

1#""$2010

%ro&e'io 1#4$1#"!

(ro&e'io 1#""$2010

Tiempo (meses)

Precipitaci

Prom

e!io

Mes"a#(

$%.&

$'.(


2/13

1#4

1#5

1#

1#!

1#"

1##

1#!0

1#!1

1#!2

1#!3

1#!4

1#!5

1#!

1#!!

1#!"

1#!#

1#"0

1#"1

1#"2

1#"3

1#"4

1#"5

1#"

1#"!

1#""

1#"#

1##0

1##1

1##2

1##3

1##4

1##5

1##

1##!

1##"

1###

2000

2001

2002

2003

2004

2005

200

200!

200"

0.0

100.0

200.0

300.0

400.0

500.0

00.0

!00.0

PRECIPITACIN TOTAL ANUAL ESTACIN PLU. CANDARAVEPERIODO $&%'*$*

Tiempo (a+os)

PrecipitaciTota#A"a#(mm)

$,,$-,


3/13

1#4

1#5

1#

1#!

1#"

1##

1#!0

1#!1

1#!2

1#!3

1#!4

1#!5

1#!

1#!!

1#!"

1#!#

1#"0

1#"1

1#"2

1#"3

1#"4

1#"5

1#"

1#"!

1#""

1#"#

1##0

1##1

1##2

1##3

1##4

1##5

1##

1##!

1##"

1###

2000

2001

2002

2003

2004

2005

200

200!

200"

0.0

100.0

200.0

300.0

400.0

500.0

00.0

!00.0

PRECIPITACIN TOTAL ANUAL ESTACIN PLU. CANDARAVEPERIODO $&%'*$*

Tiempo (a+os)

PrecipitaciTota#A"a#(mm)


4/13


5/13

PRUEBAS ESTADSTICAS PARAMTR

ESTACIN PLUVIOMTAO ENE FEB MAR ABR MAY JUN

19! 1 2. ".3 55.2 3!.1 0 019" 2 5#.5 11.3 23.! .5 0 019 3 5.3 "". 3.5 0 20.3 019# 4 5".1 11!.3 101.# 23.! 0.2 019$ 5 #!." "1." 220.! 0 1#.3 42.5199 6 3".! 10".2 2#.3 "." 0 019#% 7 1"2.# !5.1 14#. 11.5 1 019#1 8 201.3 154.5 40.2 0.! 0 019#& 9 302.0 "4.1 1#4.# 2 0 019#' 10 455." 31.5 1!#.! 15." 0 019#! 11 1!#.! 10".1 45.2 14.2 0 1

19#" 12 253.5 23.! 1"4 2.# 2 019# 13 2!". 113.3 !0." 24.4 0 019## 14 1. 2.4 2!2.4 0 ".! 019#$ 15 214.2 4! 15.1 2!.1 0 019#9 16 12!.1 43.2 1"#.5 0 0 019$% 17 0.0 1.5 203.1 0 0 019$1 18 154.5 315.4 135." 0 0 019$& 19 1"#.0 54.3 0 0 0 019$' 20 0.0 4.5 2." 0 0 019$! 21 23. 30# 1#.2 1 0 1.!

19$" 22 "5.! 2"0." 25." 25.3 1.1 2.519$ 23 102.4 255.1 20!.3 0 0 019$# 24 ".! 0.# .! 2.1 22." 019$$ 25 !.5 !.# 3. 13.5 5.4 019$9 26 1!2.! 1#3.3 !4.5 0.3 0.1 0199% 27 153.3 133. #.4 0.4 0.2 0.21991 28 305.! ".5 40. ".1 0.3 1.199& 29 4.0 23 .4 #.2 1.4 0.3199' 30 30.1 1#.! 2#. 13.! 0.1 0.4199! 31 "4.! 243.# 4# 0 0 0199" 32 33.5 "3.2 1.2 40 3 0199 33 4.1 0.5 24.! #." 0 0199# 34 133.4 112.4 31." 15.5 4. 0199$ 35 204.5 42." 11.! 0.# 0.# ."1999 36 "4.0 23". 1".! 25.5 1.2 0.5&%%% 37 11." ##.# 101.5 0 4.! 0.5&%%1 38 202.# 1#4.5 1!#.2 52.1 0 1.3&%%& 39 55.1 10#.4 "!." 10 0 5


6/13

&%%' 40 54. 12.3 !. ".4 !.! 0&%%! 41 14"." #!.2 3.1 4.2 0 0.5&%%" 42 "3. 154.1 5" .1 0 0&%% 43 114.5 12.1 12." 0.# 0 0&%%# 44 #2.! 130 1.# 21.1 0 0&%%$ 45 21".1 4#.4 1#." 0 0 0

13653.5906 10808.8839 7230.35573 140.726957 33.9193676 78.07

n


7/13


8/13

ICAS T DE STUDENT Y F DE FISHER

ICA VILACOTA (mm)JUL AGO SET OCT NOV DIC

0 15 0 2 42 "1 144.1

0 1.5 13.3 0 1.! 32 143.1

0 0 0 0 2.! 2.! 111.0

0. 0 33.! 0.3 0 "1.1 9.8

0 0 0.4 23. 34.4 0.# 2.3

0 0 1!.3 0 1!.5 .! 2.1

0 0 0 0.3 0 15.# 0.3

0 0 0 0 #.3 101.3 6.3

0 0 2 .5 5. 1!2 4.0

0.3 20.5 0.# 0 0.5 0 8.5

0 "1 0 0 3.! 1.2 14.3

0 0 0 0." 0 13".5 58.7

0 0 15.1 0 0 !".5

0 0 0 0 2.# 30.3

0 0 0 0 0 14.3

0 0 0 3.2 0 51.4

0 0 0 "1.5 0 0

0 21.2 0 0 0 #.!

0 0 0 15.1 1#.2 0

0 0 ".! 0 0 43.

0 2.5 0 2.3 15.1 #.3

1. 0.5 0.4 0 0 5.!

4.3 2.2 0 0.5 0 ".4

0.1 0 0 !.5 0.4 1".5

0 0 0.2 0.# 0 0.#

0 0 0 0 0 25.4

0 0.5 0 0.! .2 204.5

0 0 0.1 2.2 2." 12.4

0 0.5 0 # 20".3 !.#

0 43. 0.3 1.1 4." 11.2

0 0 0 0 0 1!.3

0 0 0 4.2 45.! 20.4

0 0 0.4 1.4 10.! 51.2

0 33. 45." 0 1".4 3#.5

0 0 0 1.! 1.# 35."

0 0 13.1 1!.5 0 33.3

0 0 0 13.5 0 0.5

0 0 3. ".# ".2 1.3

1.3 0 0.5 14.4 2"." 25.


9/13

3. 4.4 0 3.2 !.1 5#."

21.1 24.1 1." 0 0 2#.3

0 0 ".4 0 22.# "2.5

0 0 0.! 2".3 1".4 2.1

0 0 0 0 0.1 !.1

0 2.2 0 3.# 0 144.3

0.88588933 307.395415 70.64992095 440.6411067 1229.16119 1996.08747

k

1 2 3 4 xprom

1 70 74 68 75 69.667

2 75 77 70 70 74.833

3 74 70 65 73 68.000

4 72 80 60 72 72.167

5 68 72 72 71

6 59 76 73 72

s2 33.87 12.97 23.60 2.97

Est.Interna 18.35

Varianza me 8.91

n 6

Estimacin 53.44

Fprueba 2.91

Grado de Libertad: Numerador

k-1 3.00 F FISHER

Grado de Libertad: Denominador

k(n-1) 20

Ftabla= 3.1

PERIODO AOSEst.Interna 2999.197009 1

Varianza me 3294.02649 2

n 23

Estimacin 75762.60926

Fprueba 25.26096453

Grado de Libertad: Numerador

k-1 11

Grado de Libertad: Denominador

k(n-1) 242

Ftabla=


10/13


11/13

1

2

3

4

5

!

"

#

10

11

12


12/13

276 42.0 76.8747911 5909.7335 1631086.45

264 33.8 59.6621765 3559.5753 939727.88

0.60232417

,-./m

S0

S0& S

0&


13/13

Documents

Realizado Excel