Trabajo

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 10

Media

Desviacin

364.82
135.331143

Q
26
13
8.67
6.5
5.2
4.33
3.71
3.25
2.89
2.6
2.36
2.17
2
1.86
1.73
1.63
1.53
1.44
1.37
1.3
1.24
1.18
1.13
1.08
1.04

649.5
590
559
514
507
487
444
430
420
411
399
367
354
321
310
298
297
286
272
249
225
199
198
180
154

Suma

Q
26
13
8.67
6.5
5.2
4.33
3.71
3.25
2.89
2.6
2.36

321
154
507
225
198
367
272
487
559
180
297

0.01674612
0.012142
0.00987959
0.00682456
0.00637897
0.00515798
0.00284421
0.0022018
0.00178229
0.00143527
0.00102135
0.00023222
6.441E-005
0.0001333
0.00034296
0.00069775
0.00073372
0.00119961
0.00199571
0.00388667
0.00682502
0.01148601
0.01170299
0.01619062
0.02510426
0.38341804

P(Z<z0)
0.96153846
0.92307692
0.88465975
0.84615385
0.80769231
0.76905312
0.73045822
0.69230769
0.65397924
0.61538462
0.57627119

2.17
2
1.86
1.73
1.63
1.53
1.44
1.37
1.3
1.24
1.18
1.13
1.08
1.04
Suma

310
430
354
430
249
286
514
444
298
411
590
399
199
626

0.53917051
0.5
0.46236559
0.42196532
0.38650307
0.34640523
0.30555556
0.27007299
0.23076923
0.19354839
0.15254237
0.11504425
0.07407407
0.03846154

Normal
Log Normal
Log Normal P(Z<z0)
Z
x
(x-Q)^2
x
0.2590481134 0.9615384615 1.7688250385 604.197115 2052.35142 670.060608
0.2552049015 0.9230769231 1.4260768723 557.812613 1036.02785 587.544707
0.2530459789 0.8846597463 1.1986077391 527.028956 1022.14768 538.472577
0.2496889306 0.8461538462 1.0200762328 502.868083 123.919581 502.846207
0.2491404401 0.8076923077 0.8694237733 482.480113 601.224848 474.623331
0.2475305649 0.7690531178 0.735732077 464.387463 511.326825 450.907263
0.2438329825
0.730458221 0.614199418 447.940309 15.5260383 430.377995
0.2425514083 0.6923076923 0.5024022234 432.810667 7.89985045 412.319618
0.2416101885 0.6539792388 0.396086086 418.422783 2.48761397 395.849978
0.2407437286 0.6153846154 0.2933812321 404.523618 41.9435296 380.564776
0.2395584567 0.5762711864 0.1923633137 390.852747 66.3777288 366.106513
0.2362144739 0.5391705069 0.0983441944 378.129032 123.855359 353.143922
0.2347718765
0.5
0
364.82
117.0724 340.075872
0.2308576449 0.4623655914 -0.094475828 352.034478 963.138834
327.9775
0.2294628919 0.4219653179 -0.196868256 338.177594 793.976798 315.350874
0.2278837395 0.3865030675 -0.288444988 325.78441 771.97344 304.470358
0.2277492856 0.3464052288 -0.395043944 311.358251 206.159385 292.276939
0.2262396724 0.3055555556 -0.508488059 296.00573 100.114625 279.83643
0.2242320827 0.2700729927 -0.612592248 281.917191 98.3506726 268.886627
0.2206981159 0.2307692308 -0.736315917 265.173525 261.582914 256.429031
0.2166440161 0.1935483871 -0.864894359 247.772858 518.603045 244.093817
0.211732193 0.1525423729 -1.025590291 226.025693 730.388104 229.508239
0.2115306812 0.1150442478 -1.200130928 202.404909 19.4032271 214.65174
0.207718274 0.0740740741 -1.446103593 169.117148 118.436478 195.333147
0.2014781041 0.0384615385 -1.768825039 125.442885 815.508798 172.598713
5.8291687457
105.450448

Normal
Log Normal
Gumbel
x
(x-Q)^2
x
(x-Q)^2
x
(x-Q)^2
600.46866248 78102.733307 667.48662355 120052.98 695.55052 140288.092
554.70199297 160562.087171 585.66388896 186333.713 608.274259 206365.102
524.3283669 300.272299355 536.97777958 898.667269 556.157682 2416.47768
500.48931172 75894.3608711 501.61816386 76517.6086 518.257206 85999.789
480.37290555 79734.4577913 473.59794855 75954.2292 488.200895 84216.5596
462.5212457 9124.30837913 450.04589673 6896.62096 462.920518 9200.74571
446.29316459 30378.107224 429.65372296 24854.6964 441.015151 28566.1211
431.36504605 3095.24810096 411.71201382 5668.28086 421.724014 4260.95434
417.16880519 20116.0878219 395.34543075 26782.818 404.106124 23992.113
403.45477382 49932.0359429 380.1528976 40061.1824 387.728845 43151.2732
389.96599652 8642.67650833 365.77954502 4730.62581 372.20796 5656.23719

377.41175879 4544.34522265 352.89072333


364.28
4319.1184 339.89470112
351.66477858 5.4532590836 327.86083677
337.99246507 8465.38648366 315.29921833
325.76435577 5892.76631665 304.47274979
311.53035056 651.798799923 292.33764876
296.38232106 47357.4541874 279.95408691
282.48143853 26088.2456999 269.05218321
265.96079494 1026.51066119 256.64643627
248.79190066 26311.4674913 244.35965851
227.334404 131526.334519 229.82742038
204.02824386 38013.9856931 215.0206041
171.18386783 773.737208649 195.75905949
128.09133752 247913.03617 173.07973489
1028.9664793

1839.61415
8118.96489
683.255854
13156.2693
3077.22597
40.1657918
54777.4894
30606.7386
1710.11723
27769.0034
129724.287
33848.4181
10.5036954
205136.767
1038.86969

358.26234
344.167878
331.081261
317.37679
305.522739
292.180616
278.494697
266.377208
252.496321
238.636194
222.072427
204.968644
182.296818
154.818155

2329.25349
7367.15321
525.268577
12683.9875
3194.82007
38.2000105
55462.7475
31549.8561
2070.58477
29709.2815
135370.699
37648.167
278.996288
222012.331
1083.67653

Gumbel
(x-Q)^2

x
(x-Q)^2

422.738616 0.00806466 298.989595 700.562539 2607.3829 0.37233821


6.02846507 0.00806466 298.989595 612.108083 488.767356 0.18427066
421.375077 0.00806466 298.989595 559.287954 0.08291723 0.11816265
124.407099 0.00806466 298.989595 520.875837 47.2771304 0.05357949
1048.24871 0.00806466 298.989595 490.413778 275.102772 0.0463855
1302.68564 0.00806466 298.989595 464.792125 493.189708 0.02943521
185.559023 0.00806466 298.989595 442.591044 1.98515605 0.00801149
312.595919 0.00806466 298.989595 423.039485 48.4487664 0.00446899
583.223582 0.00806466 298.989595 405.18376 219.520961 0.00271151
926.302868 0.00806466 298.989595 388.585395 502.414504 0.00158938
1081.9815 0.00806466 298.989595 372.854984 683.561866 0.00064444
191.99091 0.00806466 298.989595 358.721104 68.5401144 1.6720E-007
193.88134 0.00806466 298.989595 344.436372 91.4629769 2.0443E-005
48.6855096 0.00806466 298.989595 331.173092 103.491797 0.00135795
28.6318564 0.00806466 298.989595 317.283615 53.0510506 0.00265879
41.8655286 0.00806466 298.989595 305.26954 52.8462113 0.00481489
22.3073092 0.00806466 298.989595 291.747303 27.5908264 0.00503431
37.9895994 0.00806466 298.989595 277.87663 65.9891363 0.00790271
9.69309264 0.00806466 298.989595 265.59556 41.0168532 0.01290599
55.1904962 0.00806466 298.989595 251.527287 6.38717719 0.02507364
364.573865 0.00806466 298.989595 237.480053 155.751735 0.04411382
930.75267 0.00806466 298.989595 220.692682 470.57245
0.073583
277.280453 0.00806466 298.989595 203.358005 28.7082159 0.0749223
235.105391 0.00806466 298.989595 180.380118 0.14448975 0.10188579
345.912131 0.00806466 298.989595 152.530504 2.15941743 0.15121754
95.9114521
80.8421084 1.32708888
80.8421084
Gamma
x
(x-Q)^2
1326.46711 1010964.12
956.960785
159,765
927.538735
160,140
867.829282
146,853
821.965499
117,389
762.256045
90,396
739.756831
102,600
684.374149
76,641
653.221391
64,777
621.203278
53,033
597.83871
47,543

565.820597
534.667838
512.168624
487.938701
470.631613
447.267044
423.902475
400.537907
377.173338
352.943415
327.848137
303.618214
277.657582
244.774115

47,010
39,002
42,908
37,249
34,984
26,829
22,665
19,685
19,337
19,020
19,009
12,934
10,981
9,344
1,546

4.54244803 Gamma
1
1
Y
1
x
(x-Q)^2
89.7982276 2.27122402
13.50 160.868109 1373.14418
523,661
89.7982276 2.27122402
9 160.868109 989.705749
159,765
89.7982276 2.27122402
8.89 160.868109 959.174352
160,140
89.7982276 2.27122402
8.20 160.868109 897.213575
146,853
89.7982276 2.27122402
7.67 160.868109 849.620514
117,389
89.7982276 2.27122402
6.98 160.868109 787.659737
90,396
89.7982276 2.27122402
6.72 160.868109 764.312198
102,600
89.7982276 2.27122402
6.08 160.868109 706.841333
76,641
89.7982276 2.27122402
5.72 160.868109 674.513971
64,777
89.7982276 2.27122402
5.35 160.868109 641.288626
53,033
89.7982276 2.27122402
5.08 160.868109 617.043105
47,543
89.7982276 2.27122402
4.71 160.868109 583.817761
47,010
89.7982276 2.27122402
4.35 160.868109 551.490399
39,002
89.7982276 2.27122402
4.09 160.868109 528.14286
42,908
89.7982276 2.27122402
3.81 160.868109 502.999356
37,249
89.7982276 2.27122402
3.61 160.868109 485.03971
34,984
89.7982276 2.27122402
3.34 160.868109 460.794189
26,829
89.7982276 2.27122402
3.07 160.868109 436.548668
22,665
89.7982276 2.27122402
2.80 160.868109 412.303146
19,685
89.7982276 2.27122402
2.53 160.868109 388.057625
19,337
89.7982276 2.27122402
2.25 160.868109 362.914121
19,020
89.7982276 2.27122402
1.96 160.868109 336.872635
19,009
89.7982276 2.27122402
1.68 160.868109 311.729131
12,934
89.7982276 2.27122402
1.38 160.868109 284.789663
10,981
89.7982276 2.27122402
1.00 160.868109 250.666336
9,344
1,380
9,344

1546.30444
1546.30444

523660.901
159764.686
160139.512
146852.644
117388.817
90396.2777
102599.904
76641.1234
64777.3613
53032.8515
47542.7956
47009.9414
39002.4576
42908.1643
37248.7514
34983.8533
26828.5364
22664.9013
19684.9728
19337.023
19020.3048
19008.8635
12934.3153
10980.8735
9344.38061
1546.30444

También podría gustarte