Ma 7 Ma 8 Ma 18 Ma 32 Ma 15
22.39 21.96 22.13 24.39 20.42
21.78 21.51 21.01 23.52 21.01
23.61 21.87 23.17 23.04 20.83
23.09 22.15 21.02 23.53 20.41
23.42 21.4 22.22 22.48 20.2
22.14 21.76 24.1 24.16 20.16 Variable
23.86 21.78 21.48 22.17 20.57 Ma 15
22.57 21.55 22.59 21.63 21.09 Ma 8
23.13 21.74 23.8 21.76 19.91 Ma 32
22.01 22.32 23.47 23.8 20.48 Ma 18
22.65 21.46 23.06 21.21 20.94 Ma 7
22.44 21.86 22.37 22.35 20.88
23.01 21.82 22.52 22.6 21.24
23.09 21.53 23.67 21.13 20.72
22.04 21.47 22.7 23.01 20.85
21.55 21.69 22.89 23.14 20.18
22.91 21.6 22.64 23.2 20.23
23.95 21.05 22 23.73 20.95
22.54 21.01 22.41 22.85 20.81
22.4 22.27 22.72 22.07 21.46
22.16 23.95 22.92 20.91
22.6 22.93 23.18 21.11
22.61 22.92 20.64 20.7
24.24 24.04 23.89 20.49
23.87 23.84 21.44 20.31
22.71 24 21.46
21.59 22.7 20.67
23.07 24.02 19.99
24.4 20.86 20.72
23.1 22.06 20.23
22.31 22.99 20.58
22.6 22.6 20.52
23.42 21.69 20.47
22.08 23.5 21.08
23.26 22.57 20.93
23.35 22.86 20.43
21.53 23.21 20.91
22.34 23.64 20.26
22.94 23.12 20.4
23.52 22.86 20.71
22.83 21.11
24.74 20.89
24.45 20.53
21.38 20.98
22.77 20.24
22.69 21.06
22.5 21.21
22.57 20.7
22.22 20.96
22.62 20.21
20.28
20.8
20.55
21.42
20.81
20.63
20.07
21.26
20.94
20.53
19.96
20.44
20.84
21.02
21.37
20.89
20.64
20.96
20.79
20.5
µ 22
σ 2.97
var 8.8209
P 0.37254902
n 205
n Media Desv.Est. Varianza x
70 20.697 0.375 0.141 70
20 21.69 0.344 0.119 17
25 22.714 1.008 1.016 6
40 22.808 0.85 0.723 6
50 22.821 0.778 0.605 5
pes
1
0.85
0.24
0.15
0.1
1
2 α 0.05
OIJ
Variable Ma 15 Ma 8 Ma 32
x 70 17 6
n-x 0 3 19
n 70 20 25
EIJ
Variable Ma 15 Ma 8 Ma 32
x 35.51219512 10.14634146 0.507317073
n-x 34.48780488 9.853658537 24.49268293
70 20 25
(OIJ-EIJ)^2/EIJ
Variable Ma 15 Ma 8 Ma 32
x 16.99155265 2.763096196 5.028260956
n-x 0 15.65754511 1.587871881
Χ2c 656.4099415
Χ2α 7.814727903
5 Rechazar H0 si
con 95% de confiabilidad tengo evidencia
TRUE
que las variables no son independientes.
Ma 18 Ma 7 total PI.
6 5 104 0.507317073
34 45 101 0.492682927
40 50 205 1
Ma 18 Ma 7
0.507317073 57.32682927 104
39.49268293 -7.326829268 101
40 50 205
EIJ)^2/EIJ
Ma 18 Ma 7
5.028260956 547.6194123
0.887340169 60.84660136
iabilidad tengo evidencias suficientes y necesarias para decir
s no son independientes. almenos una proporcios es diferente
Bondad de ajuste a una distribución normal:
1 H0: Los datos se ajustan a una curva normal con media µ y desviación
H1: Los datos no se ajustan a una curva normal con media µ y desviac
2 α 0.05
3 Determinar el estadístico de prueba
Rechazar Ho si
α es la significancia
Ma 18
22.13
21.01 1
23.17 2
21.02 3
22.22 4
24.1 5
21.48 6
22.59 7
23.8
23.47
23.06
22.37
22.52
23.67
22.7
22.89
22.64
22
22.41
22.72
23.95
22.93
22.92
24.04
23.84
24
22.7
24.02
20.86
22.06
22.99
22.6
21.69
23.5
22.57
22.86
23.21
23.64
23.12
22.86
mal:
media µ y desviación σ
n media µ y desviación σ
N 40
Media 22.80825
DES V 0.8504052955
VAR 0.7231891667
Max 24.1
Min 20.86
Rango 3.24
NI 7
AI 0.4628571429
Ѵ 6
OI
LI LS F ZLI ZLS
20.86 21.3228571428571 3 -2.2909664489 -1.7466881556
21.32285714286 21.7857142857143 2 -1.7466881556 -1.2024098623
21.78571428571 22.2485714285714 4 -1.2024098623 -0.658131569
22.24857142857 22.7114285714286 9 -0.658131569 -0.1138532757
22.71142857143 23.1742857142857 10 -0.1138532757 0.4304250176
23.17428571429 23.6371428571429 3 0.4304250176 0.9747033109
23.63714285714 24.1 8 0.9747033109 1.5189816042
1
Con un 95% de confiabilidad tengo evide
necesarias para decir que los datos de la
40 distribucion con media 22.80 y una desvi
φ(Z(LI)) φ(Z(LS)) Area Int Ei (OI-EI)^2/EI
0.0109826771 0.040345723 0.047849906 1.91399624 0.6161998347
0.040345723 0.114602385 0.113568998 4.54275992 1.4232819089
0.114602385 0.255226796 0.19217362 7.6869448 1.7683959378
0.255226796 0.4546770526 0.231878575 9.275143 0.008161995
0.4546770526 0.66655675 0.199521001 7.98084004 0.5108493496
0.66655675 0.8351462749 0.12242077 4.8968308 0.7347542177
0.8351462749 0.9356164368 0.053553493 2.14213972 16.018809016
Χ2c 21.08045226
% de confiabilidad tengo evidencias suficientes y
para decir que los datos de la ma15 siguen una
con media 22.80 y una desviacion de 0.85 Χ2α 12.591587244
TRUE
1 H0: Los datos se ajustan a una curva normal con media µ y desviaci
H1: Los datos no se ajustan a una curva normal con media µ y
2 α 0.05
3 N 40
Media 22.80825
DES 0.850405296
C1 C2 C3 C4
I 2i-1 menor a mayor mayor a menor
1 1 20.86 24.1
2 3 21.01 24.04
3 5 21.02 24.02
4 7 21.48 24
5 9 21.69 23.95
6 11 22 23.84
7 13 22.06 23.8
8 15 22.13 23.67
9 17 22.22 23.64
10 19 22.37 23.5
11 21 22.41 23.47
12 23 22.52 23.21
13 25 22.57 23.17
14 27 22.59 23.12
15 29 22.6 23.06
16 31 22.64 22.99
17 33 22.7 22.93
18 35 22.7 22.92
19 37 22.72 22.89
20 39 22.86 22.86
21 41 22.86 22.86
22 43 22.89 22.72
23 45 22.92 22.7
24 47 22.93 22.7
25 49 22.99 22.64
26 51 23.06 22.6
27 53 23.12 22.59
28 55 23.17 22.57
29 57 23.21 22.52
30 59 23.47 22.41
31 61 23.5 22.37
32 63 23.64 22.22
33 65 23.67 22.13
34 67 23.8 22.06
35 69 23.84 22
36 71 23.95 21.69
37 73 24 21.48
38 75 24.02 21.02
39 77 24.04 21.01
40 79 24.1 20.86
mal con media µ y desviación σ
urva normal con media µ y desviación σ
Rechazar h0 si
p<α
C5 C6 C7 C8 C9 C10
z(c3) z(c4) φ(z(c3)) φ(z(c4)) LN(C7) LN(1-C8)
-5.9604468002 -2.7204468 1.2577459E-09 0.0032596881 -20.493944649 -0.00326501
-5.8104468002 -2.7804468 3.1153165E-09 0.0027142077 -19.586935079 -0.0027179
-5.8004468002 -2.8004468 3.3069227E-09 0.0025515959 -19.527247764 -0.00255486
-5.3404468002 -2.8204468 4.6358892E-08 0.0023978412 -16.88685272 -0.00240072
-5.1304468002 -2.8704468 1.4452762E-07 0.0020494608 -15.749795182 -0.00205156
-4.8204468002 -2.9804468 7.1618526E-07 0.0014391411 -14.149326961 -0.00144018
-4.7604468002 -3.0204468 9.6582424E-07 0.0012620102 -13.850283964 -0.00126281
-4.6904468002 -3.1504468 1.3630455E-06 0.0008151047 -13.505789009 -0.00081544
-4.6004468002 -3.1804468 2.1079284E-06 0.0007352407 -13.069804884 -0.00073551
-4.4504468002 -3.3204468 4.284591E-06 0.0004493674 -12.360485459 -0.00044947
-4.4104468002 -3.3504468 5.1578774E-06 0.0004034065 -12.174985418 -0.00040349
-4.3004468002 -3.6104468 8.5227045E-06 0.000152835 -11.672776842 -0.00015285
-4.2504468002 -3.6504468 1.0667225E-05 0.0001308923 -11.448334573 -0.0001309
-4.2304468002 -3.7004468 1.166138E-05 0.0001076101 -11.359228035 -0.00010762
-4.2204468002 -3.7604468 1.219093E-05 8.4805072E-05 -11.314818355 -8.4809E-05
-4.1804468002 -3.8304468 1.4546844E-05 6.3955393E-05 -11.138136516 -6.3957E-05
-4.1204468002 -3.8904468 1.8906919E-05 5.0029906E-05 -10.875982629 -5.0031E-05
-4.1204468002 -3.9004468 1.8906919E-05 4.8007662E-05 -10.875982629 -4.8009E-05
-4.1004468002 -3.9304468 2.0617661E-05 4.2394077E-05 -10.789362505 -4.2395E-05
-3.9604468002 -3.9604468 3.7404829E-05 3.7404829E-05 -10.193710737 -3.7406E-05
-3.9604468002 -3.9604468 3.7404829E-05 3.7404829E-05 -10.193710737 -3.7406E-05
-3.9304468002 -4.1004468 4.2394077E-05 2.0617661E-05 -10.068501908 -2.0618E-05
-3.9004468002 -4.1204468 4.8007662E-05 1.8906919E-05 -9.9441499348 -1.8907E-05
-3.8904468002 -4.1204468 5.0029906E-05 1.8906919E-05 -9.9028896023 -1.8907E-05
-3.8304468002 -4.1804468 6.3955393E-05 1.4546844E-05 -9.6573246947 -1.4547E-05
-3.7604468002 -4.2204468 8.4805072E-05 1.219093E-05 -9.3751552058 -1.2191E-05
-3.7004468002 -4.2304468 0.0001076101 1.166138E-05 -9.1369960638 -1.1661E-05
-3.6504468002 -4.2504468 0.00013089226 1.0667225E-05 -8.941135982 -1.0667E-05
-3.6104468002 -4.3004468 0.000152835 8.5227045E-06 -8.786151665 -8.5227E-06
-3.3504468002 -4.4104468 0.00040340653 5.1578774E-06 -7.8155657497 -5.1579E-06
-3.3204468002 -4.4504468 0.00044936743 4.284591E-06 -7.707669673 -4.2846E-06
-3.1804468002 -4.6004468 0.00073524068 2.1079284E-06 -7.2153126547 -2.1079E-06
-3.1504468002 -4.6904468 0.00081510472 1.3630455E-06 -7.1121939674 -1.363E-06
-3.0204468002 -4.7604468 0.00126201022 9.6582424E-07 -6.675049415 -9.6582E-07
-2.9804468002 -4.8204468 0.00143914114 7.1618526E-07 -6.5437087738 -7.1619E-07
-2.8704468002 -5.1304468 0.00204946082 1.4452762E-07 -6.1901785361 -1.4453E-07
-2.8204468002 -5.3404468 0.00239784123 4.6358892E-08 -6.0331864337 -4.6359E-08
-2.8004468002 -5.8004468 0.00255159592 3.3069227E-09 -5.9710362661 -3.3069E-09
-2.7804468002 -5.8104468 0.00271420767 3.1153165E-09 -5.9092552042 -3.1153E-09
-2.7204468002 -5.9604468 0.00325968806 1.2577459E-09 -5.7261237749 -1.2577E-09
C11
SI S -348.32818529
-0.51243024
-1.46922397 AD=-n-S 388.32818529 Si AD * => 0.6, entonces p = exp (1
-2.44122533 Si 0.34 <=AD * <.6, entonces p = e
-2.95561935 AD* 396.15542527 Si 0.2 <AD * <0.34, entonces p = 1
-3.54416552 Si AD * <= 0.2, entonces p = 1 - ex
-3.89146096
-4.5017527 P
-5.06497667
-5.55497967
-5.87144409
-6.39207918
-6.71193457
-7.15529092
-7.66755156
-8.20330479
-8.63210537
-8.97272694
-9.51652681
-9.98019953
-9.93890444
-10.4485918
-10.8236617
-11.1871899
-11.6359175
-11.8302406
-11.9533384
-12.1065352
-12.2940766
-12.5202783
-11.5279671
-11.7542028
-11.3641208
-11.5573174
-11.1807094
-11.2878989
-10.9875672
-11.0105653
-11.195693
-11.3753163
-11.3090945
0.6, entonces p = exp (1.2937 - 5.709 (AD *) + 0.0186 (AD *) ^2)
AD * <.6, entonces p = exp (0.9177 - 4.279 (AD *) - 1.38 (AD *) ^2)
* <0.34, entonces p = 1 - exp (-8.318 + 42.796 (AD *) - 59.938 (AD *) ^2)
0.2, entonces p = 1 - exp (-13.436 + 101.14 (AD *) - 223.73 (AD *) ^2)
1 H0: Los datos se ajustan a una curva normal con media µ y de
H1: Los datos no se ajustan a una curva normal con media µ y
2 α 0.05
3 N 40
Media 22.80825
DES 0.850405296
Ma 18 Etiquetas de fila Cuenta de Ma 15
22.13 19.91 1
21.01 19.96 1
23.17 19.99 1
21.02 20.07 1
22.22 20.16 1
24.1 20.18 1
21.48 20.2 1
22.59 20.21 1
23.8 20.23 2
23.47 20.24 1
23.06 20.26 1
22.37 20.28 1
22.52 20.31 1
23.67 20.4 1
22.7 20.41 1
22.89 20.42 1
22.64 20.43 1
22 20.44 1
22.41 20.47 1
22.72 20.48 1
23.95 20.49 1
22.93 20.5 1
22.92 20.52 1
24.04 20.53 2
23.84 20.55 1
24 20.57 1
22.7 20.58 1
24.02 20.63 1
20.86 20.64 1
22.06 20.67 1
22.99 20.7 2
22.6 20.71 1
21.69 20.72 2
23.5 20.79 1
22.57 20.8 1
22.86 20.81 2
23.21 20.83 1
23.64 20.84 1
23.12 20.85 1
22.86 20.88 1
20.89 2
20.91 2
20.93 1
20.94 2
20.95 1
20.96 2
20.98 1
21.01 1
21.02 1
21.06 1
21.08 1
21.09 1
21.11 2
21.21 1
21.24 1
21.26 1
21.37 1
21.42 1
21.46 2
Total general 70
curva normal con media µ y desviación σ
na curva normal con media µ y desviación σ
YI f F FR Z(YI) p(Z<z)=φ(Z) (F-1)/n
20.86
21.01
21.02
21.48
21.69
22
22.06
22.13
22.22
22.37
22.41
22.52
22.57
22.59
22.6
22.64
22.7
22.7
22.72
22.86
22.86
22.89
22.92
22.93
22.99
23.06
23.12
23.17
23.21
23.47
23.5
23.64
23.67
23.8
23.84
23.95
24
24.02
24.04
24.1
D+=(Fr-φ(Z))
D-=(φ(Z)-(F-1)/n)
1 H0: Los datos se ajustan a una curva normal con media µ y desviación σ
H1: Los datos no se ajustan a una curva normal con media µ y desviación σ
2 α 0.05
3 N 40
Media 22.80825
DES 0.8504053
c1 c2 c3 c4 c5 c6
i YI bi Z(φ(bi)) Zi(φ)Yi Zi(φ)^2
desviación σ
µ y desviación σ