Metodo de montecarlo.xlsx
8
Estimacion del valor del area del circul Corrida RND1 RND2 √(RND1^2 +RND^2) Evaluación 1 0.4930 0.9888 1.105 0 NO 2 0.5542 0.2437 0.605 1 SI 3 0.1272 0.0452 0.135 1 SI 4 0.1212 0.1819 0.219 1 SI 5 0.1562 0.7616 0.777 1 SI 6 0.4662 0.6095 0.767 1 SI 7 0.4694 0.6037 0.765 1 SI 8 0.9281 0.9384 1.320 0 NO 9 0.0350 0.0844 0.091 1 SI 10 0.8170 0.4556 0.935 1 SI 11 0.8341 0.7383 1.114 0 NO 12 0.9524 0.2821 0.993 1 SI 13 0.9380 0.0192 0.938 1 SI 14 0.4171 0.5571 0.696 1 SI 15 0.7559 0.5095 0.912 1 SI 16 0.9663 0.0598 0.968 1 SI 17 0.3434 0.0199 0.344 1 SI 18 0.6683 0.3391 0.749 1 SI 19 0.6989 0.1307 0.711 1 SI 20 0.5181 0.8502 0.996 1 SI 21 0.0936 0.9904 0.995 1 SI 22 0.0443 0.4639 0.466 1 SI 23 0.5036 0.0782 0.510 1 SI 24 0.3084 0.4156 0.517 1 SI 25 0.2938 0.2068 0.359 1 SI 26 0.2892 0.7987 0.849 1 SI 27 0.3722 0.6752 0.771 1 SI 28 0.3262 0.9422 0.997 1 SI 29 0.7508 0.8025 1.099 0 NO 30 0.0689 0.4555 0.461 1 SI 31 0.4991 0.2427 0.555 1 SI 32 0.0634 0.9143 0.916 1 SI 33 0.0942 0.7533 0.759 1 SI 34 0.7479 0.5119 0.906 1 SI 35 0.8416 0.6782 1.081 0 NO 36 0.6364 0.4177 0.761 1 SI 37 0.5224 0.9202 1.058 0 NO 38 0.1652 0.8691 0.885 1 SI 39 0.0954 0.3385 0.352 1 SI 40 0.8959 0.2173 0.922 1 SI ¿Esta dentro?
-
Upload
paulo-lira -
Category
Documents
-
view
19 -
download
4
Transcript of Metodo de montecarlo.xlsx
Estimacion del valor del area del circulo
Corrida RND1 RND2 √(RND1^2 +RND^2) Evaluación ¿Esta dentro?1 0.4426 0.8571 0.965 1 SI 12 0.6074 0.6211 0.869 1 SI 23 0.1600 0.9750 0.988 1 SI 34 0.9449 0.7159 1.185 0 NO 35 0.8828 0.8061 1.195 0 NO 36 0.0739 0.5645 0.569 1 SI 47 0.6969 0.6824 0.975 1 SI 58 0.9773 0.2102 1.000 1 SI 69 0.8474 0.4805 0.974 1 SI 7
10 0.6194 0.1954 0.649 1 SI 811 0.6992 0.7285 1.010 0 NO 812 0.3497 0.2729 0.444 1 SI 913 0.9387 0.7020 1.172 0 NO 914 0.0345 0.9709 0.972 1 SI 1015 0.0497 0.0038 0.050 1 SI 1116 0.7534 0.3705 0.840 1 SI 1217 0.7814 0.5358 0.947 1 SI 1318 0.0436 0.9316 0.933 1 SI 1419 0.2684 0.9365 0.974 1 SI 1520 0.2263 0.2874 0.366 1 SI 1621 0.9801 0.9283 1.350 0 NO 1622 0.3011 0.4199 0.517 1 SI 1723 0.6438 0.4682 0.796 1 SI 1824 0.9237 0.0232 0.924 1 SI 1925 0.0906 0.7400 0.746 1 SI 2026 0.8852 0.4316 0.985 1 SI 2127 0.9077 0.3373 0.968 1 SI 2228 0.1686 0.3275 0.368 1 SI 2329 0.5393 0.5901 0.799 1 SI 2430 0.0571 0.2403 0.247 1 SI 2531 0.6763 0.3153 0.746 1 SI 2632 0.2037 0.5195 0.558 1 SI 2733 0.2274 0.5891 0.631 1 SI 2834 0.4252 0.4630 0.629 1 SI 2935 0.4408 0.4404 0.623 1 SI 3036 0.1896 0.9588 0.977 1 SI 3137 0.1373 0.2341 0.271 1 SI 3238 0.2810 0.5115 0.584 1 SI 3339 0.5142 0.4327 0.672 1 SI 3440 0.6190 0.2849 0.681 1 SI 3541 0.1863 0.9148 0.934 1 SI 3642 0.7924 0.4709 0.922 1 SI 3743 0.3366 0.1998 0.391 1 SI 38
valor acumulado de x
44 0.0877 0.2987 0.311 1 SI 3945 0.1142 0.6272 0.638 1 SI 4046 0.9967 0.1779 1.012 0 NO 4047 0.3166 0.5891 0.669 1 SI 4148 0.1712 0.7668 0.786 1 SI 4249 0.7270 0.6866 1.000 1 SI 4350 0.0820 0.9228 0.926 1 SI 4451 0.6739 0.5323 0.859 1 SI 4552 0.7620 0.7944 1.101 0 NO 4553 0.0648 0.0937 0.114 1 SI 4654 0.7280 0.7452 1.042 0 NO 4655 0.6856 0.5182 0.859 1 SI 4756 0.7253 0.6494 0.974 1 SI 4857 0.0274 0.0173 0.032 1 SI 4958 0.0058 0.9154 0.915 1 SI 5059 0.9144 0.1868 0.933 1 SI 5160 0.1507 0.5188 0.540 1 SI 5261 0.5395 0.6226 0.824 1 SI 5362 0.7613 0.1694 0.780 1 SI 5463 0.5950 0.1771 0.621 1 SI 5564 0.9821 0.8253 1.283 0 NO 5565 0.4293 0.2006 0.474 1 SI 5666 0.0105 0.5967 0.597 1 SI 5767 0.9194 0.5835 1.089 0 NO 5768 0.4907 0.7183 0.870 1 SI 5869 0.7035 0.0541 0.706 1 SI 5970 0.8197 0.7174 1.089 0 NO 5971 0.4325 0.6747 0.801 1 SI 6072 0.4633 0.3901 0.606 1 SI 6173 0.8625 0.2820 0.907 1 SI 6274 0.0648 0.1580 0.171 1 SI 6375 0.8846 0.9484 1.297 0 NO 6376 0.9395 0.8030 1.236 0 NO 6377 0.9285 0.2742 0.968 1 SI 6478 0.9633 0.6805 1.179 0 NO 6479 0.7294 0.9269 1.180 0 NO 6480 0.0713 0.6445 0.648 1 SI 6581 0.5637 0.1297 0.578 1 SI 6682 0.5473 0.7172 0.902 1 SI 6783 0.7010 0.8033 1.066 0 NO 6784 0.1544 0.5412 0.563 1 SI 6885 0.4723 0.1295 0.490 1 SI 6986 0.4137 0.2307 0.474 1 SI 7087 0.4729 0.1062 0.485 1 SI 7188 0.9715 0.0681 0.974 1 SI 7289 0.7606 0.0267 0.761 1 SI 7390 0.2860 0.5328 0.605 1 SI 7491 0.1974 0.9733 0.993 1 SI 75
92 0.1839 0.1010 0.210 1 SI 7693 0.2130 0.8945 0.920 1 SI 7794 0.4281 0.0693 0.434 1 SI 7895 0.9015 0.3827 0.979 1 SI 7996 0.1577 0.0343 0.161 1 SI 8097 0.6177 0.8860 1.080 0 NO 8098 0.9931 0.3980 1.070 0 NO 8099 0.8767 0.2613 0.915 1 SI 81
100 0.5470 0.0412 0.549 1 SI 82101 0.6100 0.3601 0.708 1 SI 83102 0.4680 0.6430 0.795 1 SI 84103 0.8570 0.7209 1.120 0 NO 84104 0.5592 0.5768 0.803 1 SI 85105 0.6134 0.5219 0.805 1 SI 86106 0.3370 0.1623 0.374 1 SI 87107 0.4845 0.2531 0.547 1 SI 88108 0.8884 0.3524 0.956 1 SI 89109 0.7977 0.2442 0.834 1 SI 90110 0.1761 0.7974 0.817 1 SI 91111 0.6142 0.6326 0.882 1 SI 92112 0.1624 0.3950 0.427 1 SI 93113 0.6269 0.0512 0.629 1 SI 94114 0.9679 0.1908 0.987 1 SI 95115 0.3228 0.5475 0.636 1 SI 96116 0.3145 0.9096 0.962 1 SI 97117 0.5575 0.8321 1.002 0 NO 97118 0.5402 0.0547 0.543 1 SI 98119 0.5563 0.9748 1.122 0 NO 98120 0.1903 0.0131 0.191 1 SI 99121 0.3438 0.5154 0.619 1 SI 100122 0.4605 0.4028 0.612 1 SI 101123 0.8125 0.7490 1.105 0 NO 101124 0.2946 0.3313 0.443 1 SI 102125 0.8787 0.3517 0.946 1 SI 103126 0.0524 0.2590 0.264 1 SI 104127 0.5466 0.2267 0.592 1 SI 105128 0.0537 0.2161 0.223 1 SI 106129 0.3389 0.2748 0.436 1 SI 107130 0.5592 0.7914 0.969 1 SI 108131 0.9644 0.2418 0.994 1 SI 109132 0.2271 0.5219 0.569 1 SI 110133 0.5992 0.5994 0.848 1 SI 111134 0.7287 0.5907 0.938 1 SI 112135 0.6674 0.0104 0.667 1 SI 113136 0.1088 0.3199 0.338 1 SI 114137 0.4069 0.1401 0.430 1 SI 115138 0.1830 0.4417 0.478 1 SI 116139 0.8028 0.7702 1.113 0 NO 116
140 0.8487 0.9784 1.295 0 NO 116141 0.4795 0.2693 0.550 1 SI 117142 0.3470 0.3971 0.527 1 SI 118143 0.3607 0.9304 0.998 1 SI 119144 0.9476 0.1582 0.961 1 SI 120145 0.0846 0.3996 0.408 1 SI 121146 0.5458 0.5665 0.787 1 SI 122147 0.4778 0.2751 0.551 1 SI 123148 0.2730 0.5159 0.584 1 SI 124149 0.1547 0.7773 0.792 1 SI 125150 0.2838 0.9445 0.986 1 SI 126
Estimacion del valor del area del circulo
4443
2.42.666666672.85714286
33.11111111
3.22.90909091
32.769230772.857142862.93333333
33.058823533.111111113.15789474
3.23.047619053.090909093.130434783.16666667
3.23.230769233.259259263.285714293.310344833.333333333.35483871
3.3753.393939393.411764713.428571433.444444443.459459463.473684213.48717949
3.53.512195123.523809523.53488372
Valor aproximado del area del circulo
3.545454553.555555563.478260873.4893617
3.53.51020408
3.523.529411763.461538463.471698113.407407413.418181823.428571433.438596493.448275863.457627123.466666673.475409843.483870973.49206349
3.43753.446153853.454545453.402985073.411764713.420289863.371428573.380281693.388888893.397260273.40540541
3.363.315789473.324675323.282051283.24050633
3.253.259259263.268292683.228915663.238095243.247058823.255813953.264367823.272727273.280898883.288888893.2967033
3.304347833.311827963.319148943.326315793.333333333.298969073.265306123.27272727
3.283.287128713.294117653.262135923.269230773.276190483.283018873.289719633.2962963
3.302752293.309090913.315315323.321428573.327433633.333333333.339130433.344827593.316239323.3220339
3.294117653.3
3.305785123.311475413.284552853.29032258
3.2963.3015873
3.307086613.3125
3.317829463.323076923.328244273.333333333.338345863.343283583.348148153.352941183.357664233.362318843.3381295
3.314285713.319148943.323943663.328671333.333333333.337931033.342465753.346938783.351351353.3557047
3.36
![Metodo [Metodo] Klose - Metodo Completo Para Todos Os Saxofones](https://static.fdocument.pub/doc/165x107/577cc0ab1a28aba71190c01d/metodo-metodo-klose-metodo-completo-para-todos-os-saxofones.jpg)
