0% encontró este documento útil (0 votos)
122 vistas35 páginas

Generación y Análisis de Tiempos de Proceso

El documento describe un experimento en el que se generan 200 números aleatorios entre 0 y 1 usando la función ALEATORIO de una hoja de cálculo. Estos números se usan en la función -3ln(1-ri) para calcular tiempos de proceso simulados. Se calcula un promedio móvil de 5 y 10 valores para estos tiempos a medida que se procesan más piezas, para determinar si el tiempo promedio de proceso es estable al aumentar la cantidad de números de 100 a 200.

Cargado por

alejandro
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLSX, PDF, TXT o lee en línea desde Scribd
0% encontró este documento útil (0 votos)
122 vistas35 páginas

Generación y Análisis de Tiempos de Proceso

El documento describe un experimento en el que se generan 200 números aleatorios entre 0 y 1 usando la función ALEATORIO de una hoja de cálculo. Estos números se usan en la función -3ln(1-ri) para calcular tiempos de proceso simulados. Se calcula un promedio móvil de 5 y 10 valores para estos tiempos a medida que se procesan más piezas, para determinar si el tiempo promedio de proceso es estable al aumentar la cantidad de números de 100 a 200.

Cargado por

alejandro
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLSX, PDF, TXT o lee en línea desde Scribd

Genere en una hoja de cálculo 100 números con la función xi = -3ln (1-ri); donde ri es un número pseu

obtenido a partir de la función ALEATORIO de la hoja de cálculo. Suponga que estos valores son tiemp
Determine un promedio móvil de estos valores conforme se va realizando el procesamiento de las piezas
tiempo promedio de proceso es estable? ¿Y si en lugar de 100 se generan 200 números? (Sugerencia: Pa
números aleatorios es necesario copiarlos y pegarlos mediante pegado especial de só

FUNCIÓN -3ln(1-ri)

100 Números
ri TIEMPOS MM5 MM10
0.719009435 3.80830256
0.0873344612 0.27415739
0.9146214315 7.38198049
0.115861474 0.36942457
0.7220968008 3.84144729 3.13506246
0.2353382272 0.80496501 2.53439495
0.3365087479 1.23071883 2.72570724
0.2420615039 0.83145911 1.41560296
0.391380473 1.48968587 1.63965522
0.2349449693 0.80342254 1.03205027 2.08355637
0.4970267122 2.06165465 1.2833882 1.90889158
0.0638571888 0.19796171 1.07683678 1.90127201
0.8033952903 4.87968035 1.88648102 1.65104199
0.2599877539 0.90326563 1.76919698 1.7044261
0.5881975394 2.66163453 2.14083937 1.58644482
0.6820141777 3.43724544 2.41595753 1.84967287
0.6118142839 2.83881421 2.94412803 2.0104824
0.5260528874 2.23997862 2.41618769 2.15133436
0.7243715005 3.86610401 3.00875536 2.38897617
0.9782344252 11.4822771 4.77288387 3.45686162
0.5781661185 2.58943106 4.603321 3.50963927
0.8382433873 5.46498739 5.12855563 4.03634183
0.5238883135 2.22630845 5.1258216 3.77100464
0.89784097 6.84367369 5.72133554 4.36504545
0.4139704492 1.60315519 3.74551116 4.25919751
0.4160169898 1.61365017 3.55035498 4.07683799
0.132776666 0.42737622 2.54283274 3.83569419
0.6375441717 3.044558 2.70648265 3.91615213
0.146361346 0.47474189 1.43269629 3.57701591
0.7736403997 4.45689118 2.00344349 2.87447732
0.0629580804 0.19508178 1.71972981 2.6350424
0.6349590548 3.02323726 2.23890202 2.39086738
0.4536757245 1.8136277 1.99271596 2.34959931
0.583000539 2.62401105 2.42256979 1.92763304
0.2554321883 0.88485404 1.70816237 1.85580293
0.3365862672 1.23106936 1.91535988 1.81754485
0.3540275858 1.31099544 1.57291152 1.90590677
0.8059497873 4.91891498 2.19396897 2.09334247
0.7891655596 4.67004629 2.60317602 2.51287291
0.6606002473 3.24172996 3.0745512 2.39135679
0.6464007512 3.11877322 3.45209198 2.68372593
0.1981151282 0.6623707 3.32236703 2.44763927
0.2862059927 1.01148259 2.54088055 2.36742476
0.6023047912 2.76620812 2.16011292 2.38164447
0.7403632132 4.0454148 2.32084988 2.69770054
0.5409917377 2.3360612 2.16430748 2.80819973
0.8488148493 5.66775009 3.16538336 3.24387519
0.4446884387 1.76467785 3.31602241 2.92845148
0.697292584 3.58496569 3.47977393 2.81994342
0.8628887468 5.96088785 3.86286854 3.09185921
0.6495011559 3.14519361 4.02469502 3.09450125
0.985104951 12.6201792 5.41518084 4.2902821
0.631362442 2.99382404 5.66101008 4.48851625
0.9891792253 13.5788622 7.65978939 5.56978166
0.7907927318 4.69328941 7.4062697 5.63456912
0.9801129024 11.7530524 9.12784145 6.57626824
0.0775029456 0.24201329 6.65220827 6.03369456
0.6553925626 3.19604812 6.69265308 6.17683158
0.4229620165 1.64954156 4.30678895 5.98328917
0.1436099263 0.46508794 3.46114865 5.43370918
0.4853798488 1.99297866 1.50913391 5.31848768
0.4045938908 1.55553471 1.7718382 4.21202323
0.1520428178 0.49477541 1.23158366 3.96211837
0.6131208022 2.84892836 1.47146102 2.88912498
0.9020018704 6.96842066 2.77212756 3.11663811
0.4738661189 1.92659872 2.75885157 2.13399274
0.133960465 0.43147416 2.53403946 2.15293883
0.6092658357 2.81918351 2.99892108 2.11525237
0.4067650432 1.56649422 2.74243425 2.10694763
0.5657552483 2.50244088 1.8492383 2.31068293
0.7409177471 4.05182907 2.27428437 2.51656797
0.6457932795 3.11362374 2.81071428 2.67237687
0.9361244255 8.25245471 3.89736852 3.4481448
0.9849995668 12.5990286 6.1038754 4.42315483
0.7961588296 4.77124249 6.55763572 4.20343701
0.4630897341 1.8657729 6.12042449 4.19735443
0.4606415998 1.85212498 5.86812474 4.33941951
0.6848925285 3.46452456 4.91053871 4.40395362
0.4326823045 1.70050747 2.73083448 4.41735494
0.2037131413 0.68338735 1.91326345 4.23544959
0.6095788641 2.82158786 2.10442644 4.11242547
0.5006244855 2.0831908 2.15063961 4.00938217
0.7574962711 4.25021458 2.30777761 3.60915816
0.3682754384 1.3779054 2.2432572 2.48704584
0.4463298811 1.77355867 2.46129146 2.18727746
0.1988573787 0.66514888 2.03000366 2.06721505
0.6187853381 2.89317794 2.19200109 2.17132035
0.1624846873 0.53194719 1.44834762 1.87806261
0.5938950903 2.70343126 1.71345279 1.97835499
0.705098012 3.66333667 2.09140839 2.27634992
0.4418866701 1.74957971 2.30829455 2.16914911
0.2967153631 1.05598074 1.94085512 2.0664281
0.6583822467 3.22218854 2.47890338 1.9636255
0.5317598381 2.27632184 2.3934815 2.05346714
0.7186260347 3.80421197 2.42165656 2.25653248
0.0325526573 0.09928284 2.09159719 2.19994587
0.4022772746 1.54388491 2.18917802 2.06501657
0.4956329491 2.053353 1.95541091 2.21715715
0.7345430851 3.97890819 2.29592818 2.34470484
0.557817444 2.44809738 2.02470526 2.22318091

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
1-ri); donde ri es un número pseudoaleatorio entre cero y uno,
ponga que estos valores son tiempos de proceso de cierta pieza.
ndo el procesamiento de las piezas, y grafique ese promedio. ¿El
an 200 números? (Sugerencia: Para evitar que se recalculen los
s mediante pegado especial de sólo valores).

FUNCIÓN -3ln(1-ri)

200 Números
ri TIEMPOS MM5 MM10
0.56979703 2.53049444
0.52347458 2.22370262
0.35652985 1.32263892
0.2264319 0.7702247
0.82231671 5.18325776 2.40606369
0.46002843 1.84871638 2.26970808
0.6168638 2.87809426 2.4005864
0.51566274 2.1749214 2.5710429
0.97424782 10.9777084 4.61253965
0.83069318 5.32812816 4.64151373 3.52378871
0.33274036 1.21372814 4.51451608 3.39211208
0.65933106 3.23053238 4.58500371 3.49279505
0.7770646 4.5026197 5.05054336 3.81079313
0.17418996 0.57417154 2.96983598 3.79118782
0.58514935 2.63951008 2.43211237 3.53681305
0.52756275 2.24955105 2.63927695 3.57689651
0.84320628 5.55847267 3.10486501 3.84493436
0.00733922 0.02209884 2.20876083 3.6296521
0.67230045 3.3469743 2.76332139 2.86657869
0.69377481 3.55030357 2.94548008 2.68879623
0.64115438 3.07458907 3.11048769 2.87488232
0.39068341 1.48625187 2.29604353 2.70045427
0.21340425 0.72012246 2.43564825 2.32220454
0.26284408 0.91486755 1.94922691 2.35627415
0.3053665 1.09311272 1.45778873 2.20163441
0.8566969 5.82838003 2.00854693 2.55951731
0.13152696 0.4230562 1.79590779 2.04597566
0.08927145 0.28053118 1.70798954 2.0718189
0.58624147 2.64741824 2.05449968 2.00186329
0.91479644 7.38813608 3.31350435 2.38564654
0.6828573 3.44521031 2.8368704 2.42270866
0.68039962 3.42205159 3.43666948 2.61628864
0.80156446 4.85187297 4.35093784 3.02946369
0.90059854 6.92576529 5.20660725 3.63055346
0.73901415 4.02986727 4.53495349 3.92422892
0.31786145 1.14756747 4.07542492 3.45614766
0.87368787 6.20699769 4.63241414 4.03454181
0.44042866 1.74175278 4.0103901 4.18066397
0.62076138 2.90876898 3.20699084 4.20679904
0.06991408 0.21743495 2.44450437 3.48972893
0.08005054 0.25030963 2.2650528 3.17023886
0.93625019 8.25836708 2.67532668 3.65387041
0.59560182 2.71606587 2.8701893 3.4402897
0.84008633 5.49936349 3.3883082 3.29764952
0.40355335 1.55029644 3.6548805 3.04969244
0.3646665 1.36081564 3.8769817 3.07101725
0.20162265 0.67552176 2.36041264 2.51786966
0.21940784 0.74310739 1.96582095 2.41800512
0.37907229 1.42962182 1.15187261 2.27009041
0.15225317 0.49551971 0.94091727 2.29789888
0.6127497 2.84605205 1.23796455 2.55747313
0.37916309 1.43006055 1.3888723 1.87464247
0.92999781 7.97768618 2.83578806 2.4008045
0.72437313 3.86612171 3.32308804 2.23748033
0.65804794 3.21925416 3.86783493 2.4043761
0.8763933 6.2719515 4.55301482 2.89548968
0.40019615 1.53345777 4.57369427 2.98128329
0.05656842 0.17469429 3.01309589 2.92444198
0.78717677 4.64188007 3.16824756 3.2456678
0.06932417 0.21553276 2.56750328 3.21766911
0.68352787 3.45156026 2.00342503 3.27821993
0.67561106 3.37743619 2.37222072 3.47295749
0.37962914 1.43231347 2.62374455 2.81842022
0.04134191 0.12666237 1.72070101 2.44447429
0.02121844 0.06434036 1.69046253 2.12898291
0.66233454 3.2570989 1.65157026 1.82749765
0.05702673 0.17615204 1.01131343 1.69176707
0.30859035 1.10706836 0.94626441 1.78500448
0.34869705 1.28634115 1.17820017 1.44945059
0.56706734 2.51151925 1.66763594 1.67904924
0.87083857 6.14007676 2.24423151 1.94790089
0.6272238 2.96033109 2.80106732 1.90619038
0.75991888 4.28033523 3.4357207 2.19099255
0.5037142 2.1018099 3.59881445 2.38850731
0.18995257 0.63198743 3.22290808 2.44527201
0.44217968 1.75115511 2.34512375 2.29467763
0.37718399 1.42051238 2.03716001 2.41911367
0.3963394 1.51422947 1.48393886 2.45982978
0.35096949 1.29682664 1.3229422 2.46087833
0.71250115 3.73960925 1.94446657 2.58368733
0.94764497 8.84912175 3.3640599 2.85459183
0.82030765 5.14952712 4.10986285 3.07351143
0.07740724 0.24170207 3.85535737 2.66964811
0.44969331 1.79183863 3.95435976 2.63865098
0.41256189 1.59595316 3.52562855 2.73504756
0.86799261 6.07469221 2.97074264 3.16740127
0.18380778 0.60931615 2.06270044 3.08628164
0.871993 6.16701091 3.24776221 3.55155979
0.82446918 5.21982199 3.93335888 3.94385932
0.76918758 4.39844976 4.4938582 4.00974337
0.00069819 0.00209529 3.27933882 3.12504073
0.79033892 4.68678893 4.09483338 3.07876691
0.77139705 4.42730588 3.74689237 3.49732729
0.82882398 5.29518876 3.76196573 3.8476623
0.09031823 0.28398134 2.93907204 3.71646512
0.2163071 0.73121415 3.08489581 3.18211732
0.45201132 1.80450196 2.50843842 3.3016359
0.6275701 2.96311936 2.21560112 2.98124674
0.38891102 1.47753811 1.45207098 2.60701836
0.99348616 15.1014807 4.41557085 3.67732145
0.77459818 4.46961185 5.16325039 4.1240731
0.45388918 1.81480008 5.16531001 3.83687422
0.23051179 0.78608896 4.72990393 3.47275252
0.15986324 0.52257178 4.53891067 2.99549083
0.10836908 0.34410899 1.58743633 3.00150359
0.76627558 4.36083761 1.56568148 3.36446594
0.7448748 4.09800262 2.02232199 3.593816
0.03525597 0.1076774 1.88663968 3.30827181
0.05160276 0.1589455 1.81391442 3.17641254
0.88290442 6.43429427 3.03195148 2.3096939
0.32149605 1.16359492 2.39250294 1.97909221
0.96704464 10.2378037 3.62046316 2.82139257
0.73485798 3.98246905 4.39542149 3.14103058
0.90774405 7.14956558 5.7935455 3.80372996
0.3509573 1.2967703 4.76604071 3.89899609
0.40356929 1.55037662 4.84339705 3.61794999
0.66267621 3.26013605 3.44786352 3.53416334
0.19462023 0.64932406 2.78123452 3.588328
0.86162209 5.9333005 2.5379815 4.1657635
0.45109424 1.79948553 2.63852455 3.70228263
0.96301499 9.891728 4.30679483 4.57509594
0.63808867 3.04906816 4.26458125 3.85622238
0.82747206 5.27158834 5.18903411 3.98513431
0.43817047 1.72967042 4.34830809 3.4431448
0.13148861 0.42292374 4.07299573 3.35576014
0.94906978 8.93189642 3.88102942 4.09391212
0.43108181 1.69205589 3.60962696 3.93710411
0.21047878 0.7089857 2.69710643 3.94307027
0.72001452 3.81905258 3.11498287 3.73164548
0.1053861 0.33408915 3.09721595 3.58510584
0.70082982 3.62022816 2.0348823 2.95795586
0.49175199 2.03035722 2.10254256 2.85608476
0.72491322 3.87200601 2.73514662 2.71612653
0.94049018 8.46484191 3.66430449 3.38964368
0.10763206 0.34163021 3.6658127 3.38151433
0.42710166 1.67114099 3.27599527 2.65543878
0.99842992 19.36989 6.74390183 4.4232222
0.77430385 4.46569693 6.86264001 4.79889332
0.09015393 0.28343954 5.22635954 4.44533202
0.04203251 0.1288243 5.18379836 4.42480553
0.70481403 3.66044911 5.58165998 4.42882763
0.62061732 2.90762965 2.28920791 4.51655487
0.99930079 21.7966602 5.75540057 6.30902029
0.43213065 1.69759172 6.038231 5.63229527
0.78394312 4.59664071 6.93179428 6.05779632
0.76488949 4.34309891 7.06832424 6.32499211
0.14932508 0.48517568 6.58383345 4.43652068
0.89383956 6.72841116 3.57018364 4.6627921
0.32367005 1.17322269 3.46530983 4.75177042
0.98555476 12.7121713 5.08841594 6.01010511
0.69078902 3.52119435 4.92403503 5.99617964
0.62260904 2.92342079 5.41168406 5.99775875
0.95572493 9.35200054 5.93640193 4.75329278
0.15058358 0.48961719 5.79968083 4.63249533
0.66827 3.31030164 3.9193069 4.50386142
0.09194601 0.28935432 3.2729389 4.09848696
0.95098824 9.04708475 4.49767169 4.95467787
0.87075083 6.13803963 3.85487951 4.89564072
0.45256048 1.80750986 4.11845804 4.95906944
0.61946778 2.89855326 4.03610836 3.97770763
0.42175175 1.64325601 4.3068887 3.7899138
0.58053595 2.60633233 3.01873822 3.75820495
0.9032825 7.00788291 3.19270687 3.52379319
0.50164991 2.08935737 3.24907637 3.68376721
0.18718476 0.62175437 2.7937166 3.41491248
0.08662462 0.271825 2.51943039 3.41315955
0.41417504 1.60420269 2.31900446 2.66887134
0.09213636 0.28998326 0.97542453 2.0840657
0.58130451 2.61183415 1.07991989 2.16449813
0.52386869 2.22618481 1.40080598 2.09726129
0.23927259 0.82044056 1.51052909 2.01497974
0.11535578 0.36770917 1.26323039 1.79111743
0.14914051 0.48452484 1.30213871 1.13878162
0.69200397 3.53300513 1.4863729 1.2831464
0.16703777 0.54830095 1.15079613 1.27580106
0.22971283 0.78297564 1.14330315 1.32691612
0.0777023 0.24266168 1.11829365 1.19076202
0.25946898 0.90116328 1.20162134 1.25188002
0.06894377 0.21430681 0.53788167 1.01212729
0.85759863 5.84731692 1.59768487 1.3742405
0.2240999 0.76119451 1.59332864 1.36831589
0.73806008 4.01892039 2.34858038 1.73343702
0.58980847 2.67339325 2.70302638 1.95232386
0.1999769 0.66934404 2.79403383 1.66595775
0.95875246 9.56449151 3.53746874 2.5675768
0.50259425 2.09504758 3.80423936 2.698784
0.0203988 0.06182919 3.01282111 2.68070075
0.93041377 7.9955658 4.07725562 3.390141
0.00917854 0.02766277 3.94891937 3.3714766
0.10606477 0.33636586 2.10329424 2.82038149
0.97417243 10.9689379 3.8780723 3.84115583
0.53412049 2.29148473 4.32400341 3.66841226
0.72601912 3.88409083 3.50170842 3.78948202
0.70596948 3.67221511 4.23061889 4.08976913
0.69822625 3.59423319 4.88219235 3.4927433
0.53369959 2.28877556 3.14615988 3.51211609
0.84356151 5.56527706 3.80091835 4.06246088
0.62786708 2.96551251 3.61720269 3.55945555
0.15161505 0.4932624 2.98141214 3.60601551
0.7096976 3.7104964 3.00466478 3.94342857
Media móvil 1
TIEMPOS
20
19
18
17
16
15
14
13
12
11
10
Valor

9
8
7
6
5
4
3
2
1
0
1 2 3 4 5 6 7 8 9 10111213141516171819202122232425262728293031323334353637383940414243444546474849

Punt

Media móvil 2
TIEMPOS

25
24
23
22
21
20
Valor

0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
Punt
Media móvil 100 Números
TIEMPOS MM5 MM10

3940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910
0

Punto de datos

Media móvil 200 Números


TIEMPOS MM5 MM10
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105

Punto de datos
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
929394959697989910
0
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
Genere en una hoja de cálculo números con las siguientes funciones:
a) xi= - 20 *ln (ri*rj)

b) xi = - 10 * ln (ri*rj*rk*rl)

c) xi = - 5 *ln (ri *rj *rk *rl *rm *rn*ro *rp)

Donde (ri, rj, rk, rl, rm, rn, ro,


rp)son números pseudoaleatorios entre cero y uno, obtenidos a partir de la función
ALEATORIO de la hoja de cálculo. Suponga que estos valores son tiempos de reparación de
una máquina. Determine un promedio móvil de estos valores conforme se van realizando
mantenimientos, y grafique ese promedio. ¿Cuál de las tres funciones llega a estado estable
más rápidamente? ¿En qué punto del tiempo llega cada una ha estado estable? ¿A qué valor
converge el promedio en cada una?
ri rj rk rl rm rn
1 0.559023548 0.95203241 0.64643438 0.3507804 0.30168168 0.40941116
2 0.232857555 0.85522882 0.39529878 0.69954272 0.25366249 0.66671708
3 0.728987339 0.06325838 0.95767442 0.60696397 0.71355215 0.91301245
4 0.9296371 0.96826484 0.27350328 0.4023983 0.30787182 0.04709813
5 0.449795633 0.40571684 0.66414657 0.57470658 0.25075406 0.50793576
6 0.262575533 0.97790906 0.14017296 0.38290983 0.77341318 0.13835774
7 0.416239894 0.63880946 0.61849406 0.52107772 0.07298438 0.43782596
8 0.922724696 0.11094134 0.44659529 0.25095185 0.60777718 0.67273307
9 0.534107476 0.12580709 0.40055859 0.64055856 0.15110522 0.46873303
10 0.746409366 0.37945639 0.92056061 0.60566124 0.66011722 0.31379308
11 0.822659589 0.53133161 0.64215539 0.5780862 0.84542 0.16026068
12 0.887899481 0.16125654 0.31182109 0.29754179 0.03082615 0.16472685
13 0.428663673 0.98795362 0.44420151 0.1527088 0.90944665 0.46467147
14 0.179250272 0.15108241 0.34751605 0.26372105 0.63648418 0.46669249
15 0.965699155 0.43275423 0.18945678 0.94644758 0.79479766 0.26208706
16 0.548116526 0.67994893 0.17681372 0.09384924 0.09572009 0.15773188
17 0.67697743 0.54337893 0.55395547 0.48978229 0.06788417 0.92068531
18 0.603768065 0.29691682 0.08707509 0.052771 0.49505361 0.4238013
19 0.843495194 0.93739274 0.85990614 0.66570069 0.50995902 0.39962683
20 0.866280868 0.90130329 0.57338689 0.86281455 0.63751442 0.96610357
21 0.159435448 0.4299029 0.22526951 0.68634507 0.8275123 0.63005585
22 0.902722067 0.28055537 0.36964127 0.83911153 0.77008033 0.16244555
23 0.56000369 0.89845412 0.53446318 0.59881922 0.57168037 0.2061761
24 0.193338718 0.68757416 0.0897838 0.630788 0.70813855 0.18845509
25 0.216811154 0.71237852 0.00849056 0.95631019 0.83655954 0.16237432
26 0.231781009 0.5036126 0.36809815 0.04675693 0.91463699 0.23205491
27 0.245848177 0.29632818 0.15316175 0.22620343 0.26139645 0.72613052
28 0.229010029 0.97582092 0.78903094 0.20364874 0.55647184 0.82514975
29 0.935337498 0.16102809 0.28589537 0.30776684 0.43823318 0.58100596
30 0.136826725 0.51136422 0.70010211 0.42914724 0.41366207 0.98037079
31 0.979412512 0.2168774 0.19908995 0.46900097 0.7427428 0.2033803
32 0.045973192 0.05311083 0.17589334 0.94791917 0.63984105 0.53026947
33 0.011177685 0.6889682 0.56230566 0.8685316 0.49294486 0.39512213
34 0.00433273 0.28233762 0.69177828 0.92301215 0.43655644 0.19044913
35 0.85191436 0.6267423 0.54587407 0.73320517 0.74383644 0.92053122
36 0.328767784 0.03009356 0.81843346 0.91190169 0.85307307 0.9995801
37 0.257986409 0.88358613 0.91959051 0.87448159 0.5401752 0.66243864
38 0.458695272 0.2457253 0.77958137 0.49309922 0.77403094 0.9467907
39 0.794119043 0.15204967 0.37508375 0.64354832 0.95814135 0.39769914
40 0.564917856 0.51086412 0.22918212 0.64602567 0.88051097 0.04460361
41 0.740312949 0.24098151 0.91018415 0.72624428 0.54740283 0.46545303
42 0.713982436 0.85794541 0.85407133 0.27201816 0.04235231 0.28404008
43 0.287684107 0.20404917 0.02356694 0.40972999 0.30597681 0.82378427
44 0.539247428 0.92298163 0.81722658 0.94311976 0.55423103 0.7723578
45 0.763821876 0.86544703 0.10120393 0.56214696 0.50750715 0.28692457
46 0.096217481 0.09978495 0.93853036 0.80418746 0.29666837 0.20058314
47 0.060687602 0.40625566 0.80998435 0.96221341 0.70197871 0.06711516
48 0.841525356 0.0394504 0.62617751 0.94570235 0.85719104 0.27986177
49 0.832470165 0.92498144 0.70865298 0.91113256 0.85787514 0.84554306
50 0.225653316 0.15150671 0.85727052 0.29150894 0.72980896 0.54700998
51 0.766216702 0.79450402 0.04928125 0.76189756 0.82520446 0.28283389
52 0.39000764 0.64844005 0.42347069 0.62855777 0.60623715 0.81878329
53 0.306850056 0.04856595 0.19689032 0.26200051 0.48916411 0.52414668
54 0.187904441 0.1992988 0.4016324 0.78430776 0.58730528 0.79895543
55 0.77155976 0.44931409 0.31497799 0.83672903 0.15375756 0.93962411
56 0.74814331 0.68327551 0.80085267 0.64079875 0.12172606 0.05104087
57 0.277711679 0.57518295 0.72409721 0.98196746 0.76872697 0.55522695
58 0.270133748 0.61481602 0.81414251 0.97300318 0.30624579 0.00363545
59 0.443387407 0.70016867 0.12376831 0.12183853 0.5822775 0.81427548
60 0.486757981 0.09137496 0.48376062 0.38929829 0.22093549 0.99290658
61 0.179417602 0.92857177 0.031873 0.90608952 0.05524041 0.84070144
62 0.956365979 0.53513315 0.39145628 0.6001889 0.81486864 0.22470334
63 0.269909062 0.31471599 0.92681806 0.89371724 0.39834565 0.21677553
64 0.596122543 0.36412606 0.44964628 0.57731837 0.8693077 0.42692435
65 0.429860777 0.74116747 0.07572643 0.85109388 0.68623985 0.11886422
66 0.671577701 0.18286444 0.47082815 0.41220739 0.02087357 0.44923853
67 0.428554551 0.20392396 0.83077633 0.3753659 0.84821495 0.01557406
68 0.423746416 0.30413339 0.27471334 0.25702374 0.180716 0.43265485
69 0.980925157 0.28504159 0.79552385 0.80015417 0.37309235 0.54469072
70 0.339546033 0.30400103 0.47585924 0.45721171 0.51999913 0.37795665
71 0.444406994 0.18874316 0.49369469 0.45003965 0.51990463 0.67182131
72 0.303434398 0.60192046 0.47998525 0.87733136 0.17385149 0.47639628
73 0.188879097 0.32585214 0.94992787 0.19917614 0.88912011 0.06903929
74 0.034527359 0.84787078 0.64167271 0.9154405 0.49750656 0.5987984
75 0.918255256 0.75577685 0.1256875 0.84663443 0.75562016 0.07412391
76 0.443896281 0.21454084 0.49231652 0.78351387 0.09379986 0.9048653
77 0.99652733 0.58549344 0.03090342 0.28796932 0.00773153 0.24998871
78 0.880016998 0.07585572 0.76444551 0.72706835 0.41394396 0.82398719
79 0.0619944 0.84853616 0.21216714 0.29165351 0.10547516 0.75960972
80 0.036396746 0.5701253 0.27882997 0.87791241 0.2956176 0.15848989
81 0.936237698 0.0061062 0.98733135 0.89946919 0.02809353 0.27513841
82 0.397283168 0.01992072 0.99354165 0.42442893 0.26264156 0.58168582
83 0.172774843 0.47227491 0.75630606 0.05501727 0.43436206 0.81396995
84 0.113952458 0.47826416 0.81631137 0.14184694 0.97844196 0.95437865
85 0.622826249 0.63056458 0.849653 0.11300085 0.58339159 0.24737375
86 0.421392889 0.78072673 0.16051803 0.52294106 0.10954781 0.89679139
87 0.532104014 0.2178596 0.46623432 0.31498107 0.55477975 0.6728441
88 0.392178109 0.31059048 0.01674211 0.28050067 0.6175502 0.39890211
89 0.235855737 0.37480648 0.56990177 0.63186261 0.43667879 0.2387739
90 0.038958841 0.13983902 0.88907881 0.06185937 0.47947717 0.01110149
91 0.135898353 0.51891716 0.44621834 0.2482842 0.430015 0.5678832
92 0.027860996 0.28382382 0.54578987 0.19451285 0.25857978 0.08983446
93 0.067328479 0.60693132 0.98801303 0.08073705 0.7984973 0.59621595
94 0.690706011 0.89484903 0.78965697 0.83783432 0.53608661 0.89247741
95 0.189401483 0.45971988 0.12160846 0.47202453 0.48856875 0.0695218
96 0.884487362 0.99232913 0.57827585 0.64650912 0.5809595 0.14606082
97 0.901630593 0.29424102 0.85375433 0.3097691 0.09075892 0.06441673
98 0.80629968 0.60149098 0.60273781 0.69328967 0.03489817 0.697469
99 0.404051108 0.79617362 0.48425732 0.62680444 0.8255284 0.2056184
100 0.490998549 0.09139038 0.14138474 0.41523107 0.66850472 0.59368302
= - 20 *ln (ri*rj) a) xi= - 20 *ln (ri*rj)
*rk*rl)
TIEMPOS MM5
1 12.614397683
2 32.274291677
3 61.532532576
(ri, rj, rk, rl, rm, rn, ro, 4 2.1042124397
de la función 5 34.02123495
empos de reparación de 6 27.191101798 28.5093339
me se van realizando 7 26.492851321 31.4246747
llega a estado estable
estable? ¿A qué valor 8 45.583560306 30.2683866
9 54.003276144 27.0785922
ro rp 10 25.22993353 37.4584049
0.32154562 0.62304461 11 16.551634897 35.7001446
0.65115528 0.9224033 12 38.873109703 33.5722512
0.19868936 0.37884176 13 17.184043524 36.0483029
0.52421426 0.94959141 14 72.178041911 30.3683996
0.90381984 0.09157198 15 17.449764781 34.0033527
0.11039032 0.62679729 16 19.740099238 32.447319
0.20780859 0.91327051 17 20.001314208 33.0850118
0.62672462 0.83868167 18 34.37736804 29.3106527
0.96030643 0.5943897 19 4.6970801972 32.7493176
0.29819169 0.19483513 20 4.9491912653 19.2531253
0.16063494 0.09755132 21 53.606241018 16.7530106
0.17214254 0.04826159 22 27.466494486 23.5262389
0.66385425 0.96578132 23 13.737830938 25.019275
0.48585726 0.77557355 24 40.357943956 20.8913676
0.60139056 0.68981365 25 37.357488956 28.0235403
0.77907404 0.17142708 26 42.95820466 34.5051999
0.41999089 0.4114417 27 52.386576611 32.3755926
0.30229626 0.7226238 28 29.969313429 37.359609
0.65619423 0.96679428 29 37.86048649 40.6059055
0.68017775 0.6855418 30 53.194262275 40.106414
0.39617827 0.73461528 31 30.984508466 43.2737687
0.91201842 0.35431308 32 120.30142384 40.8790295
0.62669865 0.99546995 33 97.327920893 54.4619989
0.28198709 0.54884187 34 134.1241812 67.9337204
0.86769547 0.39493253 35 12.549782124 87.1864593
0.23500615 0.22311871 36 92.316955967 79.0575633
0.43915216 0.73871499 37 29.572297611 91.3240528
0.24697159 0.54050988 38 43.65820413 73.1782276
0.7291861 0.02533057 39 42.28139891 62.4442842
0.05868718 0.59876078 40 24.85453145 44.0757277
0.99274114 0.92289086 41 34.47434682 46.5366776
0.13991374 0.29895563 42 9.8022344011 34.9681558
0.79437188 0.46734536 43 56.705730723 31.0141431
0.16912277 0.82692383 44 13.954534277 33.6236485
0.27497235 0.72718211 45 8.2785954609 27.9582755
0.73492041 0.29820264 46 92.917642955 24.6430883
0.96295081 0.55108782 47 74.0557691 36.3317476
0.35818418 0.11609873 48 68.105003275 49.1824545
0.22435731 0.3214587 49 5.2267900091 51.462309
0.95487624 0.47194024 50 67.517616002 49.7167602
0.2287013 0.60854149 51 9.9265495033 61.5645643
0.56373232 0.53034076 52 27.49549341 44.9663456
0.47832232 0.3218721 53 84.124573219 35.6542904
0.44353295 0.99670564 54 65.695436366 38.8582044
0.19763093 0.61082296 55 21.187485032 50.9519337
0.76633876 0.52057178 56 13.420356991 41.6859075
0.08961821 0.31129463 57 36.684778956 42.384669
0.59855246 0.02355975 58 35.905405803 44.2225261
0.96848762 0.77834676 59 23.394907945 34.5786926
0.88903663 0.14961008 60 62.255441662 26.1185869
0.11775001 0.15679477 61 35.842936367 34.3321783
0.23335723 0.58003967 62 13.397085967 38.8166941
0.6212664 0.74537057 63 49.315096999 34.1591555
0.36295837 0.62497407 64 30.551283672 36.8410938
0.71219406 0.93284602 65 22.876451397 38.2723689
0.0960905 0.43250478 66 41.942714086 30.3965709
0.73231772 0.99881615 67 48.746906811 31.6165264
0.363032 0.57471614 68 40.978179097 38.6864906
0.93049066 0.32254111 69 25.487586138 37.019107
0.0226385 0.84050074 70 45.41739882 36.0063675
0.96220292 0.92651339 71 49.567651879 40.514557
0.63644467 0.61275728 72 34.004396204 42.0395445
0.92507565 0.60400001 73 55.759194421 39.0910424
0.98744592 0.66531189 74 70.62060562 42.0472455
0.58788086 0.55492499 75 7.3057797889 51.0738494
0.35565654 0.87150573 76 47.028390528 43.4515256
0.67397809 0.0854366 77 10.775580359 42.9436733
0.7574726 0.25792401 78 54.134724979 38.2979101
0.31291149 0.6430619 79 58.89907582 37.9730163
0.99615624 0.44727179 80 77.503500241 35.6287103
0.28670428 0.25160595 81 103.28672816 49.6682544
0.74522325 0.13850849 82 96.782014658 60.9199219
0.25756115 0.13013152 83 50.119201038 78.1212088
0.80655443 0.62355585 84 58.191320123 77.318104
0.40711072 0.4317334 85 18.692547984 77.1765528
0.25758501 0.67247306 86 22.234394709 65.4143624
0.61118393 0.94500786 87 43.096414773 49.2038957
0.80945251 0.81458285 88 42.106384227 38.4667757
0.71839734 0.45254532 89 48.517607492 36.8642124
0.98920763 0.52168672 90 104.25025866 34.9294698
0.36198484 0.26475935 91 53.037182216 52.041012
0.81269161 0.13241549 92 96.798582243 58.2015695
0.34424201 0.76495823 93 63.950232129 68.942003
0.87556322 0.67676732 94 9.6228250644 73.3107725
0.97246324 0.68458179 95 48.820484146 65.5318161
0.97200837 0.73883087 96 2.6089499451 54.4458612
0.30777696 0.23569111 97 26.538128424 44.3602147
0.56536356 0.86377427 98 14.472870627 30.3081239
0.03189314 0.02740497 99 22.683038097 20.4126516
0.28157254 0.8224888 100 62.078583529 23.0246942
0.30505388 0.37239863 25.6763141
0.78495317 0.11552882
0.77673594 0.7556213
0.90943032 0.75551374
0.37146615 0.06267982
0.39644267 0.98473785
0.99344756 0.27007202
0.21930969 0.28249861
0.52987145 0.31675854
0.29794469 0.9034566
b) xi = - 10 * ln (ri*rj*rk*rl) c) xi = - 5 *ln (ri *rj *rk *rl *rm *rn*ro *rp)

TIEMPOS MM5 TIEMPOS MM5


21.1459837 29.0688479087
28.9915639 25.9303821921
36.1915989 33.171573693
23.1196519 36.2156856515
26.6420982 36.0832395328
42.8438902 27.2181793 45.9505421571 32.0939457956
24.5696633 31.5577606 37.8113547993 35.4702846453
44.6777468 30.6733805 30.0265018083 37.8464791667
40.6047378 32.3706101 36.3434876548 37.2174647898
18.4570358 35.8676273 31.3284161692 37.2430251905
18.1853899 34.2306148 39.8670591767 36.2920605177
43.2118179 29.2989147 71.9729605049 35.0753639217
35.4990161 33.0273456 24.27877842 41.9076850628
59.9870988 31.1915995 40.9429158917 40.7581403851
25.9112229 35.0680717 25.1985652717 41.6780260325
50.857291 36.5589091 56.4608067477 40.452055853
23.0453098 43.0932893 34.1636529032 43.7708053672
71.0164635 39.0599877 50.9222019476 36.2089438469
7.92701175 46.1634772 14.192090905 41.5376285524
9.51209664 35.7514598 10.994096072 36.187463555
45.4714457 32.4716345 32.1636102317 33.3465697151
25.4395866 31.3944655 28.7615048508 28.4871304119
18.2617953 31.8733209 22.1810459983 27.4067008014
48.8903342 21.3223872 43.8444169907 21.6584696116
66.8134765 29.5150517 48.7430550052 27.5889348287
62.101086 40.9753277 53.5415640494 35.1387266153
59.819101 44.3012557 43.8470254022 39.4143173789
33.2677403 51.1771586 30.5941372428 42.4314214891
43.2356649 54.1783476 48.4156722486 44.114039738
38.6219741 53.0474137 40.5657745868 45.0282907896
39.2037442 47.4091132 29.4899356905 43.392834706
78.0643475 42.8296449 60.3076476444 38.5825090342
55.8305706 46.4786942 41.0493285592 41.8746334826
71.5481172 50.9912602 58.0459629353 43.9656717459
15.431858 56.6537507 17.6579367113 45.8917298832
49.0843407 52.0157275 32.9286960648 41.3101623081
16.9656573 53.9918468 16.7893442667 41.997914383
31.3895328 41.7721087 33.1489809263 33.2942537074
35.3543406 36.8839012 35.6482753922 31.7141841809
31.5288092 29.6451459 35.9357541256 27.2346466722
21.3769452 32.8645361 27.3851880139 30.8902101551
19.4973873 27.323057 37.8876113593 29.7815085449
74.7545386 27.829403 53.6230894178 34.0011619635
9.58127607 36.5024042 13.1144579901 38.0959836618
32.8053945 31.3477913 36.608109706 33.5892201813
49.272451 31.6031083 43.3393520594 33.7236912974
39.5204782 37.1822095 52.9322881145 36.9145241065
39.2919894 41.1868277 48.0910472261 39.9234594576
6.98795707 34.0943178 6.51235663035 38.8170510192
47.6256715 33.575654 38.4908378544 37.4966307473
37.7848233 36.5397094 46.1275546601 37.873176377
26.9837298 34.2421839 26.9931821364 38.4308168971
71.7074595 31.7348342 46.5082799614 33.2429957015
44.3994364 38.2179282 33.4005827036 32.9264422485
23.9288175 45.7002241 23.6822763732 38.3040874632
13.3813598 40.9608533 47.9993673354 35.3423751669
21.7526569 36.0801606 16.6969439954 35.716737702
20.2825807 35.033946 51.9789548173 33.6574900738
53.6414798 24.7489703 36.5699028946 34.751625045
47.8234658 26.5973789 51.3060532069 35.3854890832
53.3675988 31.3763086 42.6059785941 40.9102444499
21.182466 39.3735564 23.787966783 39.8315667017
26.541187 39.2595182 28.4275378122 41.2497712592
28.7621963 40.5112395 21.43779546 36.5394878582
38.8568348 35.5353828 37.5606914201 33.5130663712
37.3662648 33.7420566 47.8871099574 30.7639940139
36.0259402 30.5417898 53.9195098641 31.8202202865
46.9952291 33.5104846 44.4051231297 37.8465289028
17.2608461 37.601293 24.6145013474 41.0420459663
37.9611185 35.301023 31.1572788285 41.6773871437
39.8264018 35.1218797 38.3185401745 40.3967046254
25.6509023 35.6139071 36.63522206 38.4829906688
44.5289467 33.5388996 53.1960249021 35.026133108
40.630571 33.0456431 29.8066739204 36.7843134625
26.0573185 37.7195881 36.1329129872 37.8227479771
33.0401947 35.3388281 37.6188963848 38.8178748088
52.6056868 33.9815866 60.2913822231 38.6779460509
32.9407558 39.3725435 23.9308842274 43.4091780835
57.2752349 37.0549053 46.8767683648 37.5561499486
52.8253656 40.3838381 45.0241431055 40.9701688375
52.8303647 45.7374475 62.4541022872 42.7484148611
57.0259073 49.6954815 49.0529741563 47.7154560416
56.8537726 50.5795256 40.2971517235 45.4677744283
50.6553214 55.362129 28.2866820463 48.7410279275
32.7791455 54.0381463 28.1026812942 45.0230106638
35.8935528 50.0289023 31.2037931488 41.6387183015
40.7313042 46.6415399 38.4108462523 35.3886564738
74.6632647 43.3826193 47.9204535438 33.260230893
34.4725495 46.9445177 63.7522280462 34.7848912571
81.1297395 43.7079633 74.0574703074 41.878000457
48.5198724 53.3780821 42.1840960331 51.0689582597
70.827074 55.903346 66.2270580073 53.2650188366
57.2612868 61.9225 35.0058725386 58.8282611876
8.942328 58.4421044 10.0337030971 56.2453449865
52.9869726 53.3360601 62.205502937 45.5016399967
11.1431974 47.7075068 22.608649174 43.1312465226
26.5694631 40.2321718 45.5725862585 39.2161571508
15.9622389 31.3806496 40.4659697389 35.085262801
23.2641144 23.12084 29.4230632612 36.1772822411
59.3911976 25.9851973 40.8780797584 40.0551542739
27.2660423 35.7896696382
*rk *rl *rm *rn*ro *rp)
Media móvil
150
140
130
120
110
100
90
80
70
Valor

60
50
40
30
20
10
0
12 3 4 56 7 8 91 1 11 11 1 1 1 12 2 2 22 2 2 22 2 33 3 33 3 3 33 3 4 44 4 4 44 4 44 5 55 5 5 55 5 5 56 6 6 66 6 6
0 1 23 45 6 7 8 90 1 2 34 5 6 78 9 01 2 34 5 6 78 9 0 12 3 4 56 7 89 0 12 3 4 56 7 8 90 1 2 34 5 6

Punto de datos

Media móvil
90

80

70

60

50
Valor

40

30

20

10

0
1 2 3 4 5 6 7 8 91 1 1 1 1 11 1 1 1 2 2 2 2 2 2 2 2 22 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6
0 1 2 3 4 56 7 8 9 0 1 2 3 4 5 6 7 89 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7

Punto de datos
10

0
1 2 3 4 5 6 7 8 91 1 1 1 1 11 1 1 1 2 2 2 2 2 2 2 2 22 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6
0 1 2 3 4 56 7 8 9 0 1 2 3 4 5 6 7 89 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7

Punto de datos

Media móvil
80

70

60

50

40
Valor

30

20

10

0
1234567891111111111222222222233333333334444444444555555555566666
0123456789012345678901234567890123456789012345678901234

Punto de datos
a) xi= - 20 *ln (ri*rj)
a móvil

TIEMPOS
MM5

55 5 55 5 5 66 6 6 66 6 6 66 7 77 7 77 7 7 77 8 8 88 8 8 88 8 89 9 99 9 9 99 9 9 1
34 5 67 8 9 01 2 3 45 6 7 89 0 12 3 45 6 7 89 0 1 23 4 5 67 8 90 1 23 4 5 67 8 9 0
0

os

a móvil b) xi = - 10 * ln (ri*rj*rk*

TIEMPOS
MM5

5 5 5 5 5 5 5 6 6 6 6 66 6 6 6 6 7 7 7 7 7 7 7 77 7 8 8 88 8 8 8 8 8 8 9 9 9 9 9 99 9 9 9 1
3 4 5 6 7 8 9 0 1 2 3 45 6 7 8 9 0 1 2 3 4 5 6 78 9 0 1 23 4 5 6 7 8 9 0 1 2 3 4 56 7 8 9 0
0

os
5 5 5 5 5 5 5 6 6 6 6 66 6 6 6 6 7 7 7 7 7 7 7 77 7 8 8 88 8 8 8 8 8 8 9 9 9 9 9 99 9 9 9 1
3 4 5 6 7 8 9 0 1 2 3 45 6 7 8 9 0 1 2 3 4 5 6 78 9 0 1 23 4 5 6 7 8 9 0 1 2 3 4 56 7 8 9 0
0

os

c) xi = - 5 *ln (ri *rj


dia móvil

TIEMPOS
MM5

55555555566666666667777777777888888888899999999991
12345678901234567890123456789012345678901234567890
0

datos
a) xi= - 20 *ln (ri*rj)

i = - 10 * ln (ri*rj*rk*rl)
c) xi = - 5 *ln (ri *rj *rk *rl *rm *rn*ro *rp)

También podría gustarte