Unidad 3
Unidad 3
Unidad 3
i ri x
1 0.375805 0.117823 promedio 0.249165
2 0.699527 0.300599
3 0.199432 0.055608
4 0.453481 0.151046
5 0.22289 0.063043 Chart Title
6 0.634733 0.251782 1.2
7 0.65043 0.262763
8 0.461365 0.154679 1
15 0.147471 0.039887 0
16 0.409378 0.131645 1 5 9 13 17 21 25 29 33 37 41 45 49 53 57 61 65 69 73 77 81 85 89 93 97
17 0.352456 0.108642
Column C
18 0.646724 0.260127
19 0.177053 0.048716
20 0.856137 0.484724
21 0.766809 0.363975
22 0.050929 0.013068
23 0.508581 0.177615
24 0.577329 0.21529
25 0.147809 0.039986
26 0.091176 0.023901
27 0.644888 0.25883
28 0.341399 0.104409
29 0.75994 0.356717
30 0.364253 0.113239
31 0.484774 0.165788
32 0.032267 0.0082
33 0.816378 0.423719
34 0.004866 0.00122
35 0.05989 0.01544
36 0.167082 0.045705
37 0.943369 0.717801
38 0.826738 0.438237
39 0.22634 0.064156
40 0.709272 0.308842
41 0.675809 0.281606
42 0.348977 0.107303
43 0.48374 0.165286
44 0.986347 1.073452
45 0.861996 0.495118
46 0.64657 0.260018
47 0.301216 0.089603
48 0.877059 0.524013
49 0.895588 0.564853
50 0.643672 0.257976
51 0.34924 0.107404
52 0.722847 0.320797
53 0.486428 0.166591
54 0.655292 0.266264
55 0.636579 0.253049
56 0.177805 0.048944
57 0.141009 0.037999
58 0.87127 0.512509
59 0.011309 0.002843
60 0.108753 0.028783
61 0.839546 0.457438
62 0.862982 0.496911
63 0.304705 0.090855
64 0.988715 1.121061
65 0.959872 0.803919
66 0.468219 0.157881
67 0.425768 0.13868
68 0.89858 0.572122
69 0.968399 0.86364
70 0.177693 0.04891
71 0.809236 0.414179
72 0.278117 0.081473
73 0.91643 0.620517
74 0.046539 0.011914
75 0.510301 0.178491
76 0.46407 0.155938
77 0.703817 0.304195
78 0.647404 0.260608
79 0.087805 0.022975
80 0.186685 0.051659
81 0.250733 0.072165
82 0.022279 0.005633
83 0.510855 0.178774
84 0.599279 0.228623
85 0.754574 0.35119
86 0.219891 0.06208
87 0.672236 0.278865
88 0.320443 0.096578
89 0.941353 0.709054
90 0.237161 0.067677
91 0.16536 0.045189
92 0.946704 0.732973
93 0.038219 0.009742
94 0.382597 0.120558
95 0.654366 0.265594
96 0.400442 0.12789
97 0.535883 0.191905
98 0.081033 0.021126
99 0.072302 0.018762
100 0.987201 1.089603
RMADA INVERSA CONTINUAS
61 65 69 73 77 81 85 89 93 97
X p(x) P(x) Intervalos
0 1 0.1 0.1 0 0.1 FRECUENCIA
0.1 2 0.6 0.7 0.1 0.7 1 12
0.7 3 0.2 0.9 0.7 0.9 2 59
0.9 4 0.05 0.95 0.9 0.95 3 16
0.95 5 0.05 1 0.95 1 4 6
5 7
i ri x
1 0.328884 2
2 0.343732 2
3 0.949912 4 100
4 0.793265 3
5 0.684028 2
6 0.70258 3
7 0.806618 3
8 0.372361 2
9 0.167428 2
10 0.093775 1
11 0.720276 3
12 0.314569 2
13 0.500601 2
14 0.997552 5
15 0.350365 2
16 0.773709 3
17 0.579464 2
18 0.269889 2
19 0.049555 1
20 0.976839 5
21 0.69881 2
22 0.805 3
23 0.063176 1
24 0.376754 2
25 0.708187 3
26 0.096499 1
27 0.927161 4
28 0.345377 2
29 0.625504 2
30 0.549941 2
31 0.324842 2
32 0.951396 5
33 0.479229 2
34 0.953938 5
35 0.014097 1
36 0.34331 2
37 0.171925 2
38 0.503037 2
39 0.766287 3
40 0.200625 2
41 0.90691 4
42 0.890504 3
43 0.938267 4
44 0.379317 2
45 0.457403 2
46 0.931488 4
47 0.662538 2
48 0.674365 2
49 0.657505 2
50 0.548894 2
51 0.896789 3
52 0.478784 2
53 0.561987 2
54 0.688919 2
55 0.543501 2
56 0.891116 3
57 0.760184 3
58 0.609915 2
59 0.480419 2
60 0.165053 2
61 0.147874 2
62 0.073807 1
63 0.807476 3
64 0.32707 2
65 0.512892 2
66 0.595368 2
67 0.557537 2
68 0.968465 5
69 0.088069 1
70 0.054228 1
71 0.986378 5
72 0.199176 2
73 0.443332 2
74 0.195183 2
75 0.748102 3
76 0.614323 2
77 0.035387 1
78 0.636748 2
79 0.579209 2
80 0.228048 2
81 0.916964 4
82 0.760477 3
83 0.426098 2
84 0.07992 1
85 0.614089 2
86 0.826827 3
87 0.693606 2
88 0.558098 2
89 0.152536 2
90 0.069181 1
91 0.486709 2
92 0.476275 2
93 0.575718 2
94 0.675203 2
95 0.28722 2
96 0.144277 2
97 0.285364 2
98 0.021703 1
99 0.964054 5
100 0.307377 2
12
64
23
3
3
0
Refresco
33 37 41 45 49 53 57 61 65 69 73 77 81 85 89 93 97
Column O
Distribución Triangular
0.77777
i ri Frecuencia
1 0.309478 54.15551 0 1 10 10.69
2 0.306428 53.93744 0 2 10.69 23.8
3 0.703254 76.562 0 3 23.8 30.8
4 0.7806 0 47.1782 4 30.8 37.7
5 0.051126 27.94695 0 5 37.7 44.6
6 0.76002 79.1963 0 6 44.6 51.5
7 0.210354 46.40373 0 7 51.5 58.5
8 0.699844 76.40045 0 8 58.5 65.4
9 0.228456 47.93776 0 9 65.4 72.3
10 0.17028 42.75309 0 10 72.3 79.2
11 0.844291 0 41.32035 11 79.2 86.2
12 0.603199 71.64539 0 12 86.2 93.1
13 0.567931 69.81608 0 13 93.1 100
14 0.885963 0 36.80361
15 0.067542 30.62796 0
16 0.164329 42.17568 0
17 0.597596 71.3584 0
18 0.655328 74.2539 0
19 0.632623 73.13104 0
20 0.912959 0 33.41709
21 0.142671 39.98042 0
22 0.56111 69.45579 0
23 0.102814 35.45049 0
24 0.145415 40.26744 0
25 0.953117 0 27.1861
26 0.459855 63.82459 0
27 0.71988 77.34421 0
28 0.098899 34.96129 0
29 0.30832 54.07285 0
30 0.36974 58.26344 0
31 0.793887 0 46.03489
32 0.365457 57.98308 0
33 0.832893 0 42.44646
34 0.89116 0 36.18573
35 0.710868 76.92134 0
36 0.526137 67.57313 0
37 0.961233 0 25.62793
38 0.575973 70.23809 0
39 0.476872 64.81146 0
40 0.180608 43.73171 0
41 0.483713 65.20318 0
42 0.57908 70.40039 0
43 0.036044 25.06905 0
44 0.741783 78.36106 0
45 0.318636 54.80412 0
46 0.103134 35.49003 0
47 0.169832 42.70995 0
48 0.217661 47.03062 0
49 0.422512 61.59286 0
50 0.607364 71.85784 0
51 0.915573 0 33.06279
52 0.093389 34.25596 0
53 0.893493 0 35.90355
54 0.154023 41.15034 0
55 0.535195 68.06659 0
56 0.002587 14.03728 0
57 0.198939 45.40224 0
58 0.805761 0 44.98151
59 0.175189 43.22184 0
60 0.631807 73.09027 0
61 0.469094 64.3626 0
62 0.601729 71.57023 0
63 0.785455 0 46.76457
64 0.536112 68.1163 0
65 0.973783 0 22.85162
66 0.875555 0 38.00004
67 0.303808 53.74919 0
68 0.207324 46.14055 0
69 0.123008 37.8379 0
70 0.679025 75.40533 0
71 0.94688 0 28.29354
72 0.089707 33.77296 0
73 0.449783 63.23188 0
74 0.908504 0 34.0089
75 0.430878 62.10114 0
76 0.891502 0 36.14456
77 0.926844 0 31.46821
78 0.840562 0 41.69318
79 0.46904 64.35949 0
80 0.137913 39.47626 0
81 0.160744 41.8227 0
82 0.558966 69.3421 0
83 0.920315 0 32.4057
84 0.833927 0 42.34596
85 0.083647 32.95598 0
86 0.285607 52.41843 0
87 0.166689 42.40587 0
88 0.610937 72.03953 0
89 0.020834 21.4567 0
90 0.874868 0 38.0773
91 0.120681 37.57337 0
92 0.446829 63.05679 0
93 0.429594 62.02346 0
94 0.56361 69.58809 0
95 0.357643 57.46737 0
96 0.013463 19.20944 0
97 0.845472 0 41.20139
98 0.144341 40.15543 0
99 0.601433 71.55508 0
100 0.622425 72.62009 0
Frecuencia
1/landa 4 1/landa valor esperado
k 5 k parametro de forma
landa 0.25
23 25 27 29 31 33 35 37 39 41 43 45
umn N
Pi la N donde T' ES menor q e a la landa Valores que me dan
landa 3
0 9 T' ri*T N 0
1 17 T 1
2 21
3 13
4 18 100
5 10
6 9
7 3 1.00
8 0
9 0
10 0
0.049787
i Pi N T ri T' N T ri
7 1 1.00 0 1 0.799504 0.799504 1 0.799504 0.044206
11 2 2.00 0 1 0.382661 0.382661 1 0.382661 0.156236
15 3 3.00 0 1 0.677334 0.677334 1 0.677334 0.259292
15 4 3.00 0 1 0.934405 0.934405 1 0.934405 0.237853
11 5 2.00 0 1 0.469029 0.469029 1 0.469029 0.593519
19 6 4.00 0 1 0.6974 0.6974 1 0.6974 0.329341
27 7 6.00 0 1 0.384105 0.384105 1 0.384105 0.597407
27 8 6.00 0 1 0.722017 0.722017 1 0.722017 0.230685
15 9 3.00 0 1 0.917831 0.917831 1 0.917831 0.287408
7 10 1.00 0 1 0.171108 0.171108 1 0.171108 0.280085
11 11 2.00 0 1 0.061534 0.061534 1 0.061534 0.843985
19 12 4.00 0 1 0.905873 0.905873 1 0.905873 0.187128
27 13 6.00 0 1 0.819751 0.819751 1 0.819751 0.599854
11 14 2.00 0 1 0.432749 0.432749 1 0.432749 0.322106
7 15 1.00 0 1 0.144821 0.144821 1 0.144821 0.186226
19 16 4.00 0 1 0.669885 0.669885 1 0.669885 0.539268
23 17 5.00 0 1 0.504024 0.504024 1 0.504024 0.600673
11 18 2.00 0 1 0.552389 0.552389 1 0.552389 0.167338
27 19 6.00 0 1 0.825254 0.825254 1 0.825254 0.814031
7 20 1.00 0 1 0.182986 0.182986 1 0.182986 0.184807
11 21 2.00 0 1 0.10397 0.10397 1 0.10397 0.651
27 22 6.00 0 1 0.925669 0.925669 1 0.925669 0.226891
11 23 2.00 0 1 0.350763 0.350763 1 0.350763 0.216642
31 24 7.00 0 1 0.963417 0.963417 1 0.963417 0.570098
7 25 1.00 0 1 0.74008 0.74008 1 0.74008 0.053325
11 26 2.00 0 1 0.176298 0.176298 1 0.176298 0.519748
23 27 5.00 0 1 0.819314 0.819314 1 0.819314 0.490536
19 28 4.00 0 1 0.858297 0.858297 1 0.858297 0.979425
23 29 5.00 0 1 0.569946 0.569946 1 0.569946 0.920052
3 30 0.00 0 1 0.030515 0.030515 0 0 0
27 31 6.00 0 1 0.812631 0.812631 1 0.812631 0.77862
19 32 4.00 0 1 0.901358 0.901358 1 0.901358 0.429782
3 33 0.00 0 1 0.027983 0.027983 0 0 0
15 34 3.00 0 1 0.13211 0.13211 1 0.13211 0.768639
19 35 4.00 0 1 0.125573 0.125573 1 0.125573 0.999662
3 36 0.00 0 1 0.018781 0.018781 0 0 0
27 37 6.00 0 1 0.441789 0.441789 1 0.441789 0.760516
23 38 5.00 0 1 0.961085 0.961085 1 0.961085 0.296632
19 39 4.00 0 1 0.1748 0.1748 1 0.1748 0.569569
7 40 1.00 0 1 0.493309 0.493309 1 0.493309 0.055933
11 41 2.00 0 1 0.526039 0.526039 1 0.526039 0.115179
15 42 3.00 0 1 0.245187 0.245187 1 0.245187 0.628821
11 43 2.00 0 1 0.772797 0.772797 1 0.772797 0.130284
11 44 2.00 0 1 0.618774 0.618774 1 0.618774 0.546665
7 45 1.00 0 1 0.187233 0.187233 1 0.187233 0.099724
19 46 4.00 0 1 0.315612 0.315612 1 0.315612 0.608073
3 47 0.00 0 1 0.04079 0.04079 0 0 0
11 48 2.00 0 1 0.545256 0.545256 1 0.545256 0.866051
19 49 4.00 0 1 0.924941 0.924941 1 0.924941 0.442208
27 50 6.00 0 1 0.423004 0.423004 1 0.423004 0.906087
23 51 5.00 0 1 0.565134 0.565134 1 0.565134 0.568036
7 52 1.00 0 1 0.061983 0.061983 1 0.061983 0.619018
15 53 3.00 0 1 0.529067 0.529067 1 0.529067 0.830026
23 54 5.00 0 1 0.413906 0.413906 1 0.413906 0.698735
23 55 5.00 0 1 0.886322 0.886322 1 0.886322 0.487837
19 56 4.00 0 1 0.452605 0.452605 1 0.452605 0.975112
7 57 1.00 0 1 0.316621 0.316621 1 0.316621 0.046255
23 58 5.00 0 1 0.164735 0.164735 1 0.164735 0.974425
11 59 2.00 0 1 0.289796 0.289796 1 0.289796 0.763133
3 60 0.00 0 1 0.000224 0.000224 0 0 0
3 61 0.00 0 1 0.024898 0.024898 0 0 0
7 62 1.00 0 1 0.053411 0.053411 1 0.053411 0.255981
19 63 4.00 0 1 0.355068 0.355068 1 0.355068 0.70253
15 64 3.00 0 1 0.768277 0.768277 1 0.768277 0.271972
11 65 2.00 0 1 0.214132 0.214132 1 0.214132 0.272287
11 66 2.00 0 1 0.340171 0.340171 1 0.340171 0.169783
19 67 4.00 0 1 0.604769 0.604769 1 0.604769 0.400921
15 68 3.00 0 1 0.404844 0.404844 1 0.404844 0.383208
19 69 4.00 0 1 0.769188 0.769188 1 0.769188 0.28018
19 70 4.00 0 1 0.952342 0.952342 1 0.952342 0.679476
11 71 2.00 0 1 0.45749 0.45749 1 0.45749 0.4296
15 72 3.00 0 1 0.521031 0.521031 1 0.521031 0.466356
7 73 1.00 0 1 0.140714 0.140714 1 0.140714 0.081685
11 74 2.00 0 1 0.547924 0.547924 1 0.547924 0.231567
19 75 4.00 0 1 0.384677 0.384677 1 0.384677 0.317772
11 76 2.00 0 1 0.270159 0.270159 1 0.270159 0.273713
19 77 4.00 0 1 0.524927 0.524927 1 0.524927 0.78225
7 78 1.00 0 1 0.239896 0.239896 1 0.239896 0.099084
7 79 1.00 0 1 0.496436 0.496436 1 0.496436 0.087842
7 80 1.00 0 1 0.924706 0.924706 1 0.924706 0.009837
11 81 2.00 0 1 0.183521 0.183521 1 0.183521 0.412325
7 82 1.00 0 1 0.236467 0.236467 1 0.236467 0.204412
11 83 2.00 0 1 0.250501 0.250501 1 0.250501 0.872555
23 84 5.00 0 1 0.499259 0.499259 1 0.499259 0.503017
19 85 4.00 0 1 0.715819 0.715819 1 0.715819 0.554591
19 86 4.00 0 1 0.871781 0.871781 1 0.871781 0.4067
15 87 3.00 0 1 0.985872 0.985872 1 0.985872 0.668006
15 88 3.00 0 1 0.598861 0.598861 1 0.598861 0.821251
15 89 3.00 0 1 0.827435 0.827435 1 0.827435 0.63991
15 90 3.00 0 1 0.647471 0.647471 1 0.647471 0.684613
3 91 0.00 0 1 0.038175 0.038175 0 0 0
11 92 2.00 0 1 0.772309 0.772309 1 0.772309 0.807272
31 93 7.00 0 1 0.733993 0.733993 1 0.733993 0.681215
3 94 0.00 0 1 0.043033 0.043033 0 0 0
27 95 6.00 0 1 0.762697 0.762697 1 0.762697 0.501629
23 96 5.00 0 1 0.884626 0.884626 1 0.884626 0.223715
7 97 1.00 0 1 0.112888 0.112888 1 0.112888 0.006814
31 98 7.00 0 1 0.969844 0.969844 1 0.969844 0.299591
7 99 1.00 0 1 0.080575 0.080575 1 0.080575 0.221161
3 100 0.00 0 1 0.009193 0.009193 0 0 0
Chart Title
25
20
15
10
0
1 2 3 4 5 6 7 8 9 10 11
Column A Column B
Venta 6 Demanda 0 1 2
Costo 3.5 Probabilida 0.1 0.15 0.25
Ganancia 2.5
#N/A
DEMANDA int. inf int. sup
0 0 0.1
1 0.1 0.25
3 4 5 6 2 0.25 0.5
0.2 0.15 0.08 0.07 3 0.5 0.7
4 0.7 0.85
5 0.85 0.93
6 0.93 1
100 0.5
Media Desv Intervalo
CORRIDA 1 7.05 4.225 6.22191521653183 7.87808478
CORRIDA 2 5.95 3.888925 6.71221529385774 5.18778471
CORRIDA 3 6.775 3.94557 7.54831750984817 7.54831751
CORRIDA 4 6.875 4.103691 7.67930865636812 6.07069134
CORRIDA 5 6.25 4.136253 7.06069069109458 5.43930931
Menos de 30
MEDIA TOTAL 6.58
Desviación Estándar 0.461451514246
t(0.025,4) -2.776445105198
Intervalo 7.1529677
Intervalo 6.0070323
acomulado
0.1 Chart Title
0.25 10
0.5 9
0.7 8
0.85 7
6
0.93
5
1
4
3
2
1
0
1 5 9 13 17 21 25 29 33 37 41 45 49 53 57 61 65 69 73 77 81 85 89 93 97
Column H
Tiempo 3(aleatoria)(aleatorio)