Generación y Análisis de Tiempos de Proceso
Generación y Análisis de Tiempos de Proceso
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
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)
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
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)