• Author / Uploaded
• Joe

Citation preview

ejercicio numero 2 generar en una hoja de calculo 100 numeros que se obtienen con la funcion Xi=5+10ri donde ri es un numero pseudoaleatorio, comprendido entre 0 y1 , obtenido utilizando la funcion interna que viene incluida en el generador de hoja electronica; ALEATORIO(). Suponer que estos valores representan los tiempos de atencion a los clientes en un banco. Determinar un promedio movil de estos valores conforme se va realizando la atencion a clientes, y graficar ese promedio. El tiempo promedio de atencion a clientes es estable?

m 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

Valor pseudoaleatorio Tiempo de atencion al cliente Acumulado ri Xi 0.564929099 10.64929099 10.64929099 0.092759846 5.927598457 16.57688944 0.171049775 6.710497747 23.28738719 0.780415306 12.80415306 36.09154025 0.521480365 10.21480365 46.30634391 0.786061895 12.86061895 59.16696285 0.044787521 5.447875209 64.61483806 0.270557196 7.70557196 72.32041002 0.640037225 11.40037225 83.72078227 0.77076882 12.7076882 96.42847047 0.463148674 9.631486743 106.0599572 0.455267841 9.552678414 115.6126356 0.773602951 12.73602951 128.3486651 0.320007723 8.20007723 136.5487424 0.265604775 7.656047755 144.2047901 0.016187464 5.161874643 149.3666648 0.13192021 6.319202096 155.6858669 0.050207135 5.50207135 161.1879382 0.291423614 7.914236139 169.1021744 0.895870979 13.95870979 183.0608841 0.293557365 7.935573655 190.9964578 0.836368322 13.36368322 204.360141 0.654822434 11.54822434 215.9083654 0.930025623 14.30025623 230.2086216 0.096489468 5.964894683 236.1735163 0.91742397 14.1742397 250.347756 0.915011731 14.15011731 264.4978733 0.406315368 9.063153676 273.561027 0.15376105 6.537610497 280.0986375 0.320054481 8.200544815 288.2991823 0.746068342 12.46068342 300.7598657 0.36514943 8.651494301 309.41136 0.413442116 9.134421161 318.5457812 0.303505832 8.035058318 326.5808395

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

0.045901913 0.358371224 0.922381502 0.494905775 0.60431726 0.82766708 0.982922161 0.263038705 0.233818891 0.502285619 0.653447868 0.116824485 0.561290038 0.319516055 0.817606824 0.469643624 0.448444205 0.083519966 0.692716848 0.311644078 0.714876498 0.430923866 0.793948497 0.866459168 0.733104271 0.036980569 0.615415655 0.017229456 0.336287653 0.055933831 0.896864105 0.064647565 0.164545609 0.783710675 0.480731781 0.585519932 0.310641888 0.645971773 0.593960758 0.356898745 0.985100263 0.645113485 0.085655857 0.792588957 0.335223722 0.762799757 0.959148295

5.459019134 8.583712239 14.22381502 9.949057749 11.0431726 13.2766708 14.82922161 7.630387045 7.33818891 10.02285619 11.53447868 6.16824485 10.61290038 8.195160551 13.17606824 9.696436239 9.484442047 5.835199661 11.92716848 8.11644078 12.14876498 9.309238659 12.93948497 13.66459168 12.33104271 5.36980569 11.15415655 5.17229456 8.362876525 5.559338314 13.96864105 5.646475655 6.64545609 12.83710675 9.807317815 10.85519932 8.106418879 11.45971773 10.93960758 8.568987453 14.85100263 11.45113485 5.856558566 12.92588957 8.352237221 12.62799757 14.59148295

332.0398586 340.6235709 354.8473859 364.7964436 375.8396162 389.116287 403.9455086 411.5758957 418.9140846 428.9369408 440.4714195 446.6396643 457.2525647 465.4477252 478.6237935 488.3202297 497.8046718 503.6398714 515.5670399 523.6834807 535.8322457 545.1414843 558.0809693 571.745561 584.0766037 589.4464094 600.6005659 605.7728605 614.135737 619.6950753 633.6637164 639.310192 645.9556481 658.7927548 668.6000727 679.455272 687.5616909 699.0214086 709.9610162 718.5300036 733.3810063 744.8321411 750.6886997 763.6145892 771.9668265 784.594824 799.186307

82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100

0.100039126 0.465254983 0.321374868 0.926998309 0.863462008 0.760789102 0.839271849 0.331597721 0.832938023 0.082510081 0.811016654 0.31421417 0.67430045 0.292808486 0.090764048 0.266494498 0.386755242 0.126579571 0.258576236

6.000391261 9.652549831 8.213748676 14.26998309 13.63462008 12.60789102 13.39271849 8.315977208 13.32938023 5.825100815 13.11016654 8.142141701 11.7430045 7.928084863 5.907640482 7.664944979 8.867552421 6.265795707 7.585762364

805.1866982 814.8392481 823.0529967 837.3229798 850.9575999 863.5654909 876.9582094 885.2741866 898.6035669 904.4286677 917.5388342 925.6809759 937.4239804 945.3520653 951.2597057 958.9246507 967.7922031 974.0579989 981.6437612

Promedio movil Ri 12 10 8 6 4 2 0 1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52

10.64929099 8.288444722 7.762462397 9.022885063 9.261268781 9.861160476 9.230691152 9.040051253 9.302309141 9.642847047 9.641814292 9.634386303 9.872974242 9.753481598 9.613652675 9.335416548 9.157992169 8.954885456 8.90011444 9.153044207 9.095069419 9.289097319 9.387320233 9.5920259 9.446940651 9.628759846 9.796217529 9.770036678 9.658573706 9.609972743 9.701931152 9.669105 9.65290246 9.605318808

9.486853103 9.461765857 9.590469889 9.599906411 9.636913237 9.727907176 9.852329479 9.799426088 9.742188014 9.748566836 9.788253766 9.70955792 9.728777972 9.696827609 9.76783252 9.766404594 9.760875917 9.685382143 9.727679998 9.697842235 9.742404467 9.734669363 9.790894198 9.857682086 9.899603452 9.824106823 9.845910917 9.770530008 9.748186302 9.682735552 9.748672559 9.686518061 9.641129076 9.688128748 9.689856126 9.706503885 9.683967477 9.708630675 9.725493372 9.709864914 9.778413417 9.800422909 9.749203892 9.789930631 9.77173198 9.8074353 9.866497617

9.819349978 9.817340338 9.798249961 9.850858586 9.894855813 9.926040126 9.965434198 9.946900973 9.984484076 9.938776568 9.973248198 9.953558881 9.972595536 9.951074371 9.908955268 9.885821141 9.875430644 9.838969685 9.816437612

52 55 58 61 64 67 70 73 76 79 82 85 88 91 94 97 100

Series1