chirino s

30
m Q NC = 1+1.33LN (N) 1 0.040 NC = 5 2 0.147 3 0.167 ∆X = (XMAX-XMIN)/(NC) 4 0.181 ∆X = 1 5 0.222 6 0.260 CALCULO DE FRCUENCIA ACUMULAD 7 0.271 8 0.273 INTERVALOS 9 0.311 DE 10 0.457 CLASE 11 0.518 1 12 0.527 13 0.644 0.04 0.72 14 0.662 0.72 1.40 15 0.697 1.40 2.08 16 0.760 2.08 2.76 17 0.766 2.76 3.44 18 0.808 19 0.809 20 0.922 21 1.005 22 1.015 CALCULO DE LA FRECUENCIA ABSO 23 1.050 24 1.065 INTERVALOS 25 1.082 DE 26 1.126 CLASE 27 1.186 1 28 1.216 29 1.338 0.04 0.72 30 1.423 0.72 1.40 31 1.710 1.40 2.08 32 1.787 2.08 2.76 33 1.800 2.76 3.44 34 1.889 35 2.022 36 2.038 37 2.059 38 3.435 PROMEDIO 0.99 DESV.EST 0.72 Grados de libertad Calculo de Xt^2 K i i i i c e e X 1 2 ) (

Upload: vladi-garcia

Post on 11-Sep-2015

218 views

Category:

Documents


0 download

DESCRIPTION

excel hidrologico

TRANSCRIPT

PRUEBA DE CHI^2


ABEL: NUMERO DE ORDEN
ABEL: REGISTRO DE CAUDALESPRUEBA DE CHI CUADRADOmQNC = 1+1.33LN (N)10.040NC = 520.14730.167X = (XMAX-XMIN)/(NC)40.181X = 150.22260.260CALCULO DE FRCUENCIA ACUMULADA:70.27180.273INTERVALOS MARCASFRECUENCIA FRECUENCIAFRECUENCIA90.311DE DEABSOLUTAXi.fi(Xi-X)^2.fiRELATIVAACUMULADA100.457CLASECLASE110.5181234567120.5270.000.000.00130.6440.040.720.3815.005.695.540.3947370.394737140.6620.721.401.0614.0014.820.070.3684210.763158150.6971.402.081.748.0013.904.510.2105260.973684160.7602.082.762.420.000.000.000.0000000.973684170.7662.763.443.101.003.104.450.0263161.000000180.80838.0037.5014.571.000000190.809X0.99200.922S0.63211.005221.015CALCULO DE LA FRECUENCIA ABSOLUTA231.050241.065INTERVALOS LIMITEAREA BAJO
Luffi: OBTENIDO DE TABLAS FRECUENCIAFRECUENCIAFRECUENCIA251.082DE DELA CURVARELATIVAACUMULADAACUMULADA261.126CLASECLASENORMALeii271.1861234567281.2160.04-1.510.90320291.3380.040.720.38-0.970.821210.08203.0015.00301.4230.721.401.060.110.555671.376952.0014.00311.7101.402.081.741.200.26435-0.2913-11.008.00321.7872.082.762.422.280.07927-0.1851-7.000.00331.8002.763.443.103.360.01463-0.0646-2.001.00341.889352.0225.98Xc^231.45362.038372.059383.435

PROMEDIO0.99Calculo de Xt^2DESV.EST0.72Grados de libertadv= k-1-h2Nivel de significancia = 0.05

26.74106.816115.634349030562.715940.511322.049861495898.79888.3654.2825484765134.77942.913878.1495844875170.72341.412968.9750692521206.71206.713578.382271468190.173684210568517.473684210543.0328201851

PRUEBA DE SMIRNOV KOLMOGOROVPRUEBA DE SMIRNOV KOLMOGOROVm
ABEL: NUMERO DE ORDENQ
ABEL: REGISTRO DE CAUDALESQ = X
ABEL: CAUDALES ORDENADOS DE < A >P(X)
ABEL: PROBABILIDAD EMPIRICA DE LOS DATOS O FRECUENCIA ACUMULADA
ABEL: VARIABLE ESTANDARIZADA DE LA DISTRIBUCION NORMALF(Z)
ABEL: PROBABILIDAD DE LA DISTRIBUCION TEORICA= ABSm/(N+1)F(Z)-P(X)

10.040.040.0256410-1.330.06301
ABEL: VALORES TOMADOS DE LA TABLA A.20.03736900.16580.165820.150.150.0512821-1.180.082260.03097791.79811.798130.170.170.0769231-1.150.095100.01817691.74931.749340.180.180.1025641-1.130.111230.00866591.71611.716150.220.220.1282051-1.070.153860.02565491.62011.620160.260.260.1538462-1.020.153860.00001381.53601.536070.270.270.1794872-1.000.173610.00587721.51321.513280.270.270.2051282-1.000.176190.02893821.51001.510090.310.310.2307692-0.950.206110.02465921.43161.4316100.460.460.2564103-0.740.217700.03871031.16911.1691110.520.520.2820513-0.660.223630.05842131.07381.0738120.530.530.3076923-0.650.248250.05944231.05971.0597130.640.640.3333333-0.480.254630.07870330.90030.9003140.660.660.3589744-0.460.280960.07801440.87870.8787150.700.700.3846154-0.410.301530.08308540.83650.8365160.760.760.4102564-0.320.322760.08749640.76650.7665170.770.770.4358974-0.310.355690.08020740.76000.7600180.810.810.4615385-0.260.359420.10211850.71750.7175190.810.810.4871795-0.250.378280.10889950.71590.7159200.920.920.5128205-0.100.460170.05265050.61140.6114211.011.010.53846150.020.503990.03447150.54480.5448221.011.010.56410260.030.531880.03222260.53760.5376231.051.050.58974360.080.543800.04594360.51230.5123241.061.060.61538460.100.651730.03634540.50150.5015251.081.080.64102560.130.662760.02173440.48980.4898261.131.130.66666670.190.662760.00390670.46050.4605271.191.190.69230770.270.677240.01506770.42370.4237281.221.220.71794870.310.698470.01947870.40620.4062291.341.340.74358970.480.751750.00816030.34310.3431301.421.420.76923080.600.758040.01119080.30450.3045311.711.710.79487181.000.853140.05826820.20440.2044321.791.790.82051281.110.879000.05848720.18370.1837331.801.800.84615381.130.888770.04261620.18020.1802341.891.890.87179491.250.890650.01885510.15930.1593352.022.020.89743591.430.904900.00746410.13240.1324362.042.040.92307691.460.944850.02177310.12950.1295372.062.060.94871791.490.956370.00765210.12570.1257383.443.440.97435903.400.995980.02162100.01850.0185PROMEDIO0.9918239247DESV.EST0.7186116193

Calculo de = max

max= ABS(F(Z)-P(X))0.1088995

Valores criticos de o del estadistico Smirnov-Kolmogorov , para varios valores de N y niveles de significacion =0.05o= 1.36/(N)^0.50.2206211327

Criterio de decision: = 0.1088995