Ejercicios De Numero Aleatorios

Instituto Tecnológico de Estudios
Superiores de Zamora

Ingeniería Industrial

Simulación

Unidad II

Ejercicios de Números Aleatorios.



Zamora, Michoacán a viernes 11 de mayo del 2011.

Ejercicios de Números Aleatorios.
1. Genera una hoja de cálculo en Excel con 200 números aleatorios en una sola columna y usando la función predeterminadaALEATORIO. Copia estos valores y ubícalos en la siguiente columna, pero desfasándolos una posición. Copia el último de los valores en el lugar que quedó vacío al principio y has una gráfica de la relación x=y. ¿Se observa que los datos están distribuidos de forma uniforme?
Columna 1:
0.4328037 | 0.4777945 | 0.0128685 | 0.2488345 | 0.8443597 | 0.6591285 |
0.9951433 | 0.2717069 | 0.8496648 |0.4290082 | 0.9317711 | 0.7201099 |
0.0911665 | 0.4247643 | 0.8356403 | 0.2347494 | 0.4562084 | 0.9076399 |
0.0366135 | 0.3363637 | 0.0542592 | 0.0695558 | 0.8971105 | 0.9870208 |
0.1890348 | 0.5261396 | 0.420149 | 0.5017553 | 0.8864673 | 0.1637278 |
0.1492276 | 0.7900542 | 0.046396 | 0.8476543 | 0.7608991 | 0.762979 |
0.7186119 | 0.1282089 | 0.51789 | 0.9589745 | 0.1349104 | 0.8332623 |0.2529238 | 0.4583613 | 0.666149 | 0.7715892 | 0.9951173 | 0.4021701 |
0.892487 | 0.9192651 | 0.3946308 | 0.9039669 | 0.6258119 | 0.7248769 |
0.4859696 | 0.9970841 | 0.675873 | 0.500284 | 0.9737954 | 0.6403498 |
0.1144392 | 0.9654162 | 0.1665658 | 0.0484293 | 0.7685209 | 0.4492576 |
0.3282817 | 0.8180285 | 0.8964719 | 0.4454418 | 0.5637097 | 0.8092709 |
0.3938722 | 0.2784871 |0.8743317 | 0.4852361 | 0.4030087 | 0.7419999 |
0.7697956 | 0.4652386 | 0.9127851 | 0.2972029 | 0.5011569 | 0.6409222 |
0.3840812 | 0.3491054 | 0.0360908 | 0.1250991 | 0.7464284 | 0.4396236 |
0.3529118 | 0.4478955 | 0.6612538 | 0.1812278 | 0.3580152 |
0.5241646 | 0.2925926 | 0.4994615 | 0.6809487 | 0.3952744 |
0.1089444 | 0.9733789 | 0.4873407 | 0.148518 | 0.553712 |
0.3070036 | 0.7042407 |0.585882 | 0.9003954 | 0.3589605 |
0.7477808 | 0.016162 | 0.6633996 | 0.3317972 | 0.1605087 |
0.7065919 | 0.2961541 | 0.6522573 | 0.3957886 | 0.336127 |
0.1944604 | 0.6489976 | 0.5412928 | 0.9270113 | 0.318564 |
0.1911931 | 0.6468878 | 0.012403 | 0.7363949 | 0.5253445 |
0.0675735 | 0.6731124 | 0.2007697 | 0.7744592 | 0.2228893 |
0.744859 | 0.0379731 | 0.1155927 | 0.9102097 | 0.0957169 |0.9604716 | 0.152866 | 0.2112392 | 0.7525394 | 0.1006347 |
0.4385572 | 0.1800626 | 0.38653 | 0.0003952 | 0.2098521 |
0.7726968 | 0.6519079 | 0.9769639 | 0.2493269 | 0.9443379 |
0.1799 | 0.1498558 | 0.8162521 | 0.5378631 | 0.1376864 |
0.5711192 | 0.1388934 | 0.1349035 | 0.2419046 | 0.4388935 |
0.1808154 | 0.4519105 | 0.6695666 | 0.7530269 | 0.6732821 |
0.9953935 | 0.8806113 |0.2476387 | 0.145116 | 0.3024463 |
0.4106213 | 0.6523891 | 0.3996878 | 0.0636966 | 0.802711 |
0.6568785 | 0.3102402 | 0.6069689 | 0.7996994 | 0.3099851 |
0.0992952 | 0.7140466 | 0.2638855 | 0.5074737 | 0.1478257 |
0.534586 | 0.7150115 | 0.4290617 | 0.8113573 | 0.5516039 |
0.5036179 | 0.5523697 | 0.6472592 | 0.0005771 | 0.9699765 |

Columna 2:
0.4396236 | 0.5036179 | 0.5523697 | 0.6472592 |0.0005771 | 0.9699765 |
0.4328037 | 0.4777945 | 0.0128685 | 0.2488345 | 0.8443597 | 0.6591285 |
0.9951433 | 0.2717069 | 0.8496648 | 0.4290082 | 0.9317711 | 0.7201099 |
0.0911665 | 0.4247643 | 0.8356403 | 0.2347494 | 0.4562084 | 0.9076399 |
0.0366135 | 0.3363637 | 0.0542592 | 0.0695558 | 0.8971105 | 0.9870208 |
0.1890348 | 0.5261396 | 0.420149 | 0.5017553 | 0.8864673 | 0.1637278 |0.1492276 | 0.7900542 | 0.046396 | 0.8476543 | 0.7608991 | 0.762979 |
0.7186119 | 0.1282089 | 0.51789 | 0.9589745 | 0.1349104 | 0.8332623 |
0.2529238 | 0.4583613 | 0.666149 | 0.7715892 | 0.9951173 | 0.4021701 |
0.892487 | 0.9192651 | 0.3946308 | 0.9039669 | 0.6258119 | 0.7248769 |
0.4859696 | 0.9970841 | 0.675873 | 0.500284 | 0.9737954 | 0.6403498 |
0.1144392 | 0.9654162 | 0.1665658 |...