• Author / Uploaded
• petroljose

Citation preview

CONSULTAS EIS (x)

FREC. ABS. (DÍAS) 0 1 2 3 4 5

Total

FREC. RELATIVAS o PROBABILIDAD DE QUE OCURRA EL SUCESO x 10 20 40 60 40 30 200

0.05 0.1 0.2 0.3 0.2 0.15 1

FRE. RELAT. ACUM 0.05 0.15 0.35 0.65 0.85 1

ASIGNACIÓN DE PESOS PARA OBTENER EL VALOR REAL MEDIO PROBABILÍSTICO ESTIMACIÓN DE LOS PARÁMETROS ESTADÍSTICOS A PARTIR DE MUESTRAS ALEATORIAS (CUANDO MAYOR ES NÚMERO

xi*prob (xi) 0 0.1 0.4 0.9 0.8 0.75 2.95

f(x) seudoaleatoria 0.994898509 0.10676529 0.777959317 0.952451671 0.539479337 0.777062874 0.394149331 0.820702901 0.533127028 0.362697606 0.316826838 0.235832977 0.911350898 0.445376265 0.340360277 0.473976869 0.654732512 0.827517795 0.780367446 0.122953705 0.796655686 0.005185622 0.525395765 0.947292278 0.613123273 0.639220136 0.14820321 0.707951485 0.988249604 0.46280486 0.443804568 0.229168965 0.866646485 0.734455668 0.139482574 0.570869001 0.613023731 0.55366327 0.858742907

Asignación de x condicional (alternativa 1) 1 1 4 1 3 4 3 4 3 3 2 2 1 3 2 3 4 4 4 1 4 0 3 1 3 3 1 4 1 3 3 2 1 4 1 3 3 3 1

0.651093197 0.877559967 0.899518436 0.854665363 0.248573956 0.813960573 0.773518557 0.387972429 0.312892183 0.315204261 0.186886792 0.333374435 0.655004059 0.038114558 0.089815508 0.121512254 0.264183168 0.654844352 0.032997819 0.289974115 0.142272725 0.180375676 0.636518188 0.885640694 0.141736908 0.379346718 0.368916684 0.495472983 0.940054606 0.719224764 0.575254424 0.187800434 0.685301517 0.865417189 0.864631484 0.276240364 0.749826323 0.391849449 0.692115175 0.951563905 0.18162022 0.569917153 0.254247848 0.75013383 0.144972049 0.23641372 0.003455607 0.78577694 0.009287072 0.76300335

4 1 1 1 2 4 4 3 2 2 2 2 4 0 1 1 2 4 0 2 1 2 3 1 1 3 3 3 1 4 3 2 4 1 1 2 4 3 4 1 2 3 2 4 1 2 0 4 0 4

0.182331713 0.517228535 0.476615703 0.850260672 0.596157602 0.585467123 0.725169763 0.777631209 0.48890349 0.941131983 0.851982959

2 3 3 1 3 3 4 4 3 1 1

RTIR DE MUESTRAS ALEATORIAS (CUANDO MAYOR ES NÚMERO DE ENSAYOS n MEJOR ES EL ESTIMADOR) ESTIMADOR DE LA MEDIA DEL EXPERIMENTO ALEATORIO (PUEDE COINCIDIR CON E1 O NO, YA QUE AL IGUAL QUE LA MUESTRA ALEATORIA SE Asignación de x con BUSCARV CONVIERTE EN OTRA VAR. (alternativa 2) ALEATORIA) 2.36

SUCESO xi 0 1 2 3 4 5

0.35

Probabilidad

0.3 0.25 0.2

0.15 0.1

0.05

0.05 0 0

Esto significa que, al generar un número pseudo-aleatorio c distribución uniforme entre 0 y 1), estaremos llevando a cab obtenido de forma aleatoria y según la distribución de prob suceso. Así por ejemplo, si el ordenador nos proporciona el n podremos suponer que ese día se han producido 2 consulta Es decir, si el eje Y es el resultado seudo-aleatorio, el corresp que se le asignará a ese valor de la distribución de probabilid

X es el nº de consultas diarias

Distribución de probabilidad de la variable aleatoria discreta dada por la frec. Relativa de cada x. Esperanza:

Cuando no es posible determinar el nº exacto esperado de consultas diarias por la teoría de la probabilidad se puede usar el Método de Monte Carlo: Extremo abierto del intervalo del número aleatorio para cada x: Extremo abierto del intervalo del núm 0 0.05 0.05 0.15 0.15 0.35 0.35 0.65 0.65 0.85 0.85 1

Nº CONSULTAS EIS 0.3 0.2

0.2 0.15

0.1

1

2

3

4

5

Nº CONSULTAS

ue, al generar un número pseudo-aleatorio con el ordenador (proveniente de una iforme entre 0 y 1), estaremos llevando a cabo un experimento cuyo resultado, rma aleatoria y según la distribución de probabilidad anterior, estará asociado a un ejemplo, si el ordenador nos proporciona el número pseudo-aleatorio 0,2567, oner que ese día se han producido 2 consultas al EIS. e Y es el resultado seudo-aleatorio, el correspondiente valor de x es el tipo de suceso (nº de consultas) ará a ese valor de la distribución de probabilidad.

El gráfico siguiente nos muestra cada una de las probabilidad

él, se aprecia claramente la relación existente entre probabil éste ocupa.

oría de la probabilidad se Extremo abierto del intervalo del número aleatorio para cada x:

ente nos muestra cada una de las probabilidades sobre el número de consultas. En

laramente la relación existente entre probabilidad de cada suceso y el área que

Supongamos que trabajamos en un gran almacén informático, y que nos piden consejo para decidir sobre el número de licencias de un determinado sistema operativo que conviene adquirir – las licencias se suministrarán con los ordenadores que se vendan durante el próximo trimestre, y es lógico pensar que en pocos meses habrá un nuevo sistema operativo en el mercado de características superiores. Cada licencia de sistema operativo le cuesta al almacén un total de 75 Euros, mientras que el precio al que la vende es de 100 Euros. Cuando salga al mercado la nueva versión del sistema operativo, el almacén podrá devolver al distribuidor las licencias sobrantes, obteniendo a cambio un total del 25 Euros por cada una. Basándose en los datos históricos de los últimos meses, los responsables del almacén han sido capaces de determinar la siguiente distribución de probabilidades por lo que a las ventas de licencias del nuevo sistema operativo se refiere:

nº Lic. Vendidas Probabilidad Prob. Acum. Ext. Inf. Intervalo Ext. Sup. Interval. 100 0.3 0.3 0 0.3 150 0.2 0.5 0.3 0.5 200 0.3 0.8 0.5 0.8 250 0.15 0.95 0.8 0.95 300 0.05 1 0.95 1

os piden consejo para ativo que conviene adquirir – nte el próximo trimestre, y al almacén un total de 75

Coste de licencia Ingresos por licencia vendida Ingresos por licencia devuelta Cantidad licencias disponibles a comprar o adquiridas cada mes, o CANTIDAD DE PEDIDO

75 100 25 300

ribuidor las licencias asándose en los datos capaces de determinar la ncias del nuevo sistema

CONSULTAV(valor_buscado; lookup_value, matriz_buscar_en; indicador_columnas; [ordenado

Si ordenado se omite o es VERDADERO, se devolverá una coincidencia exacta o aproximada. Si n En ese caso los valores de la primera columna de matriz_buscar_en deben estar clasificados seg Si el argumento ordenado es FALSO, CONSULTAV sólo buscará una coincidencia exacta. Si hay d –notar que usamos también la función MIN, ya que en ningún caso podremos vender más licenc nº Lic. Vendidas 100 150 200 250 300

MODELO DE SIMULACIÓN DE VENTAS Num. Aleat. Lic. Vend. Lic. Dev. 0.11262548 100 0.45601776 150 0.33160739 150 0.75846047 200 0.2648266 100 0.19606049 100 0.06486253 100 0.1609528 100 0.07728746 100 0.4072063 150 0.13359873 100 0.1459419 100 0.2418816 100 0.32274624 150 0.93389604 250 0.31545368 150 0.57633788 200 0.22639739 100 0.25413229 100 0.55121035 200 0.44485675 150 0.26149897 100 0.92341235 250 0.55841955 200 0.94738438 250 0.94187509 250 0.56908201 200 0.40149402 150 0.80027594 250 0.2076859 100 0.18266564 100

200 150 150 100 200 200 200 200 200 150 200 200 200 150 50 150 100 200 200 100 150 200 50 100 50 50 100 150 50 200 200

Coste 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.60870669 0.39985904 0.08010569 0.38854792 0.06252702 0.99441722 0.10769336 0.05579121 0.21032153 0.16742827 0.42240217 0.23722764 0.57936175 0.12631273 0.02589216 0.95039904 0.00792481 0.4451851 0.38919685 0.80886945 0.20502143 0.20813478 0.34190715 0.95033176 0.06418663 0.34179322 0.65614445 0.35323035 0.11977276 0.16350361 0.19155378 0.85121637 0.47738778 0.96211091 0.70425747 0.70769825 0.44198276 0.03583198 0.53184434 0.17589361 0.45737506 0.70367958 0.15984391 0.98941341 0.77538301 0.12518186 0.91848789 0.15767355 0.08442847 0.22961927

200 150 100 150 100 300 100 100 100 100 150 100 200 100 100 300 100 150 150 250 100 100 150 300 100 150 200 150 100 100 100 250 150 300 200 200 150 100 200 100 150 200 100 300 200 100 250 100 100 100

100 150 200 150 200 0 200 200 200 200 150 200 100 200 200 0 200 150 150 50 200 200 150 0 200 150 100 150 200 200 200 50 150 0 100 100 150 200 100 200 150 100 200 0 100 200 50 200 200 200

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.20559092 0.27968359 0.56845553 0.99734555 0.44294699 0.77308664 0.50570734 0.64257979 0.48772283 0.01921772 0.26720013 0.92298963 0.58558559 0.4007142 0.09319485 0.42434098 0.8846347 0.77625842 0.32243027 0.02060425 0.45870486 0.76764659 0.18928854 0.71542887 0.6580806 0.51247439 0.04061819 0.93076441 0.14459191 0.76139014 0.29284701 0.4899231 0.82649269 0.06551153 0.44609669 0.61215718 0.19885349 0.61037766 0.62737231 0.83081256 0.58090626 0.7118042 0.53097518 0.63687355 0.85137414 0.85686442 0.45472454 0.36107689 0.7496873 0.11420222

100 100 200 300 150 200 200 200 150 100 100 250 200 150 100 150 250 200 150 100 150 200 100 200 200 200 100 250 100 200 100 150 250 100 150 200 100 200 200 250 200 200 200 200 250 250 150 150 200 100

200 200 100 0 150 100 100 100 150 200 200 50 100 150 200 150 50 100 150 200 150 100 200 100 100 100 200 50 200 100 200 150 50 200 150 100 200 100 100 50 100 100 100 100 50 50 150 150 100 200

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.16151271 0.82909717 0.78044724 0.37193622 0.54172478 0.49852697 0.27339252 0.54091794 0.00214893 0.19913694 0.91583776 0.14145075 0.88011362 0.40655985 0.46745816 0.70045675 0.80628817 0.22247464 0.12370319 0.48543273 0.10182848 0.37884176 0.43632075 0.88851308 0.97162813 0.31406792 0.41331426 0.20240468 0.60824642 0.81783676 0.00086321 0.36707901 0.60748753 0.68745891 0.02281922 0.82253466 0.59942446 0.98143066 0.8592874 0.35157914 0.52934225 0.27168449 0.85965474 0.20636055 0.47359179 0.21274365 0.3772413 0.87202657 0.1193537 0.84049345

100 250 200 150 200 150 100 200 100 100 250 100 250 150 150 200 250 100 100 150 100 150 150 250 300 150 150 100 200 250 100 150 200 200 100 250 200 300 250 150 200 100 250 100 150 100 150 250 100 250

200 50 100 150 100 150 200 100 200 200 50 200 50 150 150 100 50 200 200 150 200 150 150 50 0 150 150 200 100 50 200 150 100 100 200 50 100 0 50 150 100 200 50 200 150 200 150 50 200 50

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.61152432 0.00131441 0.76040874 0.77604047 0.59873532 0.1117819 0.15120947 0.52811399 0.09922031 0.38578303 0.82307838 0.87318325 0.59658145 0.76681904 0.21335259 0.8634178 0.79559642 0.19483216 0.74397878 0.71461595 0.79927366 0.30435702 0.22022584 0.60592434 0.69329296 0.34556894 0.75619212 0.67117481 0.5508059 0.67236201 0.04992895 0.14249941 0.32998924 0.99355702 0.54015396 0.61226845 0.05198926 0.41452173 0.54526789 0.96549533 0.32083239 0.93222289 0.01287273 0.62572307 0.9001694 0.33626601 0.56144124 0.48800624 0.69678259 0.39226334

200 100 200 200 200 100 100 200 100 150 250 250 200 200 100 250 200 100 200 200 200 150 100 200 200 150 200 200 200 200 100 100 150 300 200 200 100 150 200 300 150 250 100 200 250 150 200 150 200 150

100 200 100 100 100 200 200 100 200 150 50 50 100 100 200 50 100 200 100 100 100 150 200 100 100 150 100 100 100 100 200 200 150 0 100 100 200 150 100 0 150 50 200 100 50 150 100 150 100 150

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.94098004 0.19869042 0.38144323 0.03384958 0.75527639 0.35835256 0.58779487 0.89067274 0.62320915 0.98883013 0.22794009 0.90967713 0.73258928 0.37317008 0.20480279 0.14715656 0.72686831 0.72873562 0.20510313 0.69869638 0.79912944 0.94376913 0.47242309 0.16734526 0.94172877 0.00135399 0.24325254 0.87885239 0.4583743 0.93313361 0.50325189 0.46381086 0.36836649 0.08480727 0.93021817 0.07826242 0.71547018 0.42576891 0.19538704 0.45738041 0.51835732 0.92911895 0.28086498 0.28345743 0.96925025 0.54821335 0.88983848 0.34965685 0.79717782 0.11977483

250 100 150 100 200 150 200 250 200 300 100 250 200 150 100 100 200 200 100 200 200 250 150 100 250 100 100 250 150 250 200 150 150 100 250 100 200 150 100 150 200 250 100 100 300 200 250 150 200 100

50 200 150 200 100 150 100 50 100 0 200 50 100 150 200 200 100 100 200 100 100 50 150 200 50 200 200 50 150 50 100 150 150 200 50 200 100 150 200 150 100 50 200 200 0 100 50 150 100 200

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.67322349 0.4831792 0.09944457 0.56973245 0.39481532 0.54992625 0.1182036 0.90336002 0.6858323 0.55666432 0.20944984 0.84761094 0.00129526 0.64935098 0.44434721 0.35266532 0.58406888 0.76721778 0.42246661 0.3474102 0.09092854 0.3864064 0.06262913 0.86921905 0.3937012 0.75680814 0.352776 0.33723606 0.99664885 0.54732161 0.34968172 0.80640852 0.74025337 0.13520483 0.07751135 0.36577019 0.42489779 0.41171078 0.54470793 0.5704074 0.12283605 0.51740363 0.09966621 0.43744807 0.06518649 0.86833111 0.03001259 0.95361189 0.17182831 0.75273844

200 150 100 200 150 200 100 250 200 200 100 250 100 200 150 150 200 200 150 150 100 150 100 250 150 200 150 150 300 200 150 250 200 100 100 150 150 150 200 200 100 200 100 150 100 250 100 300 100 200

100 150 200 100 150 100 200 50 100 100 200 50 200 100 150 150 100 100 150 150 200 150 200 50 150 100 150 150 0 100 150 50 100 200 200 150 150 150 100 100 200 100 200 150 200 50 200 0 200 100

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.59265588 0.66068537 0.62336858 0.87820874 0.28443349 0.63884225 0.34723473 0.10340542 0.98403814 0.78914554 0.13083813 0.04201497 0.41918513 0.98664738 0.74178283 0.01278869 0.36807478 0.16626558 0.29975719 0.38561724 0.62849321 0.2160518 0.8896441 0.03303537 0.20501369 0.9560591 0.7157385 0.98384466 0.88487573 0.50263722 0.22661854 0.3095084 0.95174744 0.20109916 0.17258323 0.33199996 0.18554959 0.19785813 0.13485953 0.28246867 0.67610663 0.14069654 0.66243217 0.40313597 0.72817403 0.22845763 0.88029667 0.78323348 0.74804227 0.72537307

200 200 200 250 100 200 150 100 300 200 100 100 150 300 200 100 150 100 100 150 200 100 250 100 100 300 200 300 250 200 100 150 300 100 100 150 100 100 100 100 200 100 200 150 200 100 250 200 200 200

100 100 100 50 200 100 150 200 0 100 200 200 150 0 100 200 150 200 200 150 100 200 50 200 200 0 100 0 50 100 200 150 0 200 200 150 200 200 200 200 100 200 100 150 100 200 50 100 100 100

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.97626696 0.92445752 0.6990297 0.56328674 0.14756589 0.0564985 0.29295883 0.87136256 0.35461797 0.70067712 0.48749412 0.86846884 0.36819983 0.53158077 0.90708914 0.30771523 0.25867621 0.70701832 0.80912904 0.08305405 0.96741812 0.04251325 0.50631669 0.62475341 0.3357715 0.40475634 0.93152978 0.49413423 0.84611238 0.38605383 0.2065542 0.47991939 0.78129175 0.28568851 0.50539233 0.73571202 0.74486716 0.55189929 0.79025975 0.17509411 0.05339749 0.1749449 0.84201165 0.90495756 0.026181 0.56854323 0.3924708 0.45410987 0.73568316 0.75763568

300 250 200 200 100 100 100 250 150 200 150 250 150 200 250 150 100 200 250 100 300 100 200 200 150 150 250 150 250 150 100 150 200 100 200 200 200 200 200 100 100 100 250 250 100 200 150 150 200 200

0 50 100 100 200 200 200 50 150 100 150 50 150 100 50 150 200 100 50 200 0 200 100 100 150 150 50 150 50 150 200 150 100 200 100 100 100 100 100 200 200 200 50 50 200 100 150 150 100 100

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.13997803 0.65489211 0.658698 0.5119374 0.22073693 0.63498028 0.28254566 0.20141858 0.51304721 0.7501418 0.80529475 0.33045777 0.91133624 0.46374894 0.27847175 0.17187879 0.26480731 0.36851031 0.15736203 0.64857972 0.76558028 0.32273546 0.36529117 0.45643465 0.00893721 0.03625765 0.35374651 0.38642536 0.67426576 0.49406733 0.33618871 0.66840047 0.24842785 0.8145338 0.65936949 0.03229557 0.73656235 0.01346327 0.85409653 0.60187707 0.96159612 0.34391068 0.1969039 0.50806402 0.36101984 0.62367211 0.11615983 0.01213671 0.08016886 0.04247099

100 200 200 200 100 200 100 100 200 200 250 150 250 150 100 100 100 150 100 200 200 150 150 150 100 100 150 150 200 150 150 200 100 250 200 100 200 100 250 200 300 150 100 200 150 200 100 100 100 100

200 100 100 100 200 100 200 200 100 100 50 150 50 150 200 200 200 150 200 100 100 150 150 150 200 200 150 150 100 150 150 100 200 50 100 200 100 200 50 100 0 150 200 100 150 100 200 200 200 200

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.85552761 0.27737299 0.06423642 0.84882883 0.55984273 0.73657278 0.57780282 0.38797331 0.45551396 0.43599294 0.87854787 0.33273781 0.03165815 0.90124358 0.15549757 0.92571347 0.26392535 0.54829728 0.04107174 0.01140179 0.57830856 0.76682909 0.95658547 0.54930551 0.30799708 0.18008499 0.27137486 0.08250492 0.27198822 0.75145612 0.41811259 0.70648904 0.17434588 0.14386437 0.13350587 0.24590789 0.86288091 0.39249528 0.18487349 0.08035021 0.4189558 0.85128604 0.63815351 0.9854151 0.69272643 0.29767831 0.24070666 0.40566221 0.560309 0.25674833

250 100 100 250 200 200 200 150 150 150 250 150 100 250 100 250 100 200 100 100 200 200 300 200 150 100 100 100 100 200 150 200 100 100 100 100 250 150 100 100 150 250 200 300 200 100 100 150 200 100

50 200 200 50 100 100 100 150 150 150 50 150 200 50 200 50 200 100 200 200 100 100 0 100 150 200 200 200 200 100 150 100 200 200 200 200 50 150 200 200 150 50 100 0 100 200 200 150 100 200

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.31498153 0.67522696 0.22338499 0.81690161 0.1687913 0.98023895 0.96119864 0.35421443 0.01614422 0.83019486 0.42180006 0.02169471 0.90378708 0.4675772 0.08896297 0.04524894 0.91832594 0.69559377 0.32153143 0.6755136 0.64988968 0.19848277 0.44739807 0.6334621 0.4830494 0.20949347 0.30180591 0.2680461 0.49491997 0.33479488 0.14756397 0.80420892 0.93245988 0.33802336 0.57933158 0.55583645 0.10128343 0.44333603 0.51011863 0.47496742 0.37427467 0.47677573 0.01351449 0.53320208 0.05307995 0.53706251 0.62121306 0.13683148 0.1991336 0.02985558

150 200 100 250 100 300 300 150 100 250 150 100 250 150 100 100 250 200 150 200 200 100 150 200 150 100 150 100 150 150 100 250 250 150 200 200 100 150 200 150 150 150 100 200 100 200 200 100 100 100

150 100 200 50 200 0 0 150 200 50 150 200 50 150 200 200 50 100 150 100 100 200 150 100 150 200 150 200 150 150 200 50 50 150 100 100 200 150 100 150 150 150 200 100 200 100 100 200 200 200

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.43954321 0.82944681 0.94861638 0.40226252 0.63699042 0.31932003 0.11808815 0.05561587 0.16088588 0.45111197 0.03709628 0.76191374 0.25936654 0.85240796 0.65474604 0.92649403 0.0391765 0.83262141 0.54419477 0.21767068 0.95419689 0.44124433 0.85061437 0.76582338 0.76763852 0.5405126 0.8077523 0.48963089 0.31060985 0.26562665 0.55570302 0.47366701 0.6254975 0.51403942 0.64108349 0.39486455 0.57186821 0.23797654 0.51734972 0.16941824 0.78763103 0.24525764 0.77071707 0.12005418 0.52577114 0.24196285 0.47692649 0.03633627 0.73054208 0.91844502

150 250 250 150 200 150 100 100 100 150 100 200 100 250 200 250 100 250 200 100 300 150 250 200 200 200 250 150 150 100 200 150 200 200 200 150 200 100 200 100 200 100 200 100 200 100 150 100 200 250

150 50 50 150 100 150 200 200 200 150 200 100 200 50 100 50 200 50 100 200 0 150 50 100 100 100 50 150 150 200 100 150 100 100 100 150 100 200 100 200 100 200 100 200 100 200 150 200 100 50

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.90991464 0.61123957 0.46570206 0.04844811 0.25306443 0.13657099 0.07600824 0.54296833 0.64950414 0.46890444 0.40916577 0.44230788 0.54627382 0.04661286 0.04744256 0.01160609 0.22762237 0.59823731 0.99127403 0.58256714 0.85145906 0.47706802 0.39568371 0.08744184 0.10389239 0.89724664 0.20029436 0.38969889 0.04515196 0.22975584 0.99330429 0.92203675 0.24788219 0.8265987 0.66137279 0.80120955 0.14738901 0.88502552 0.51542368 0.95545848 0.94512178 0.1790551 0.27888795 0.63661638 0.27476355 0.61959854 0.5639749 0.61155126 0.01563359 0.38981821

250 200 150 100 100 100 100 200 200 150 150 150 200 100 100 100 100 200 300 200 250 150 150 100 100 250 100 150 100 100 300 250 100 250 200 250 100 250 200 300 250 100 100 200 100 200 200 200 100 150

50 100 150 200 200 200 200 100 100 150 150 150 100 200 200 200 200 100 0 100 50 150 150 200 200 50 200 150 200 200 0 50 200 50 100 50 200 50 100 0 50 200 200 100 200 100 100 100 200 150

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.75407709 0.76298256 0.79916819 0.26996576 0.32693211 0.65225562 0.52332033 0.06396493 0.1998825 0.36551993 0.57643673 0.7983311 0.22267178 0.11172485 0.18197375 0.26360313 0.43516575 0.41244653 0.56911178 0.85620931 0.16159578 0.79869229 0.30669246 0.71202708 0.87999043 0.42682934 0.11570341 0.36865589 0.88770105 0.56698102 0.17766907 0.3744698 0.59761813 0.74053835 0.26130922 0.34335438 0.42735511 0.86492718 0.85954094 0.71621363 0.55774817 0.12113866 0.48266372 0.92355788 0.69369821 0.55859481 0.63630973 0.72881018 0.09155361 0.93257294

200 200 200 100 150 200 200 100 100 150 200 200 100 100 100 100 150 150 200 250 100 200 150 200 250 150 100 150 250 200 100 150 200 200 100 150 150 250 250 200 200 100 150 250 200 200 200 200 100 250

100 100 100 200 150 100 100 200 200 150 100 100 200 200 200 200 150 150 100 50 200 100 150 100 50 150 200 150 50 100 200 150 100 100 200 150 150 50 50 100 100 200 150 50 100 100 100 100 200 50

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.51988144 0.05781623 0.43269143 0.06280393 0.58791793 0.14678955 0.45443814 0.56623646 0.59176192 0.31752127 0.37870756 0.58180788 0.17687917 0.33713217 0.92834708 0.24030379 0.86642684 0.64872329 0.25566328 0.63026631 0.69928146 0.94971584 0.45098329 0.050392 0.91851561 0.38189305 0.18481849 0.48373497 0.63798463 0.50382392 0.90480101 0.64321176 0.19014247 0.80160347 0.36078212 0.05023765 0.2557039 0.95717964 0.08964567 0.73877127 0.060573 0.31157711 0.70158416 0.80075045 0.17520913 0.38387537 0.43653236 0.43163119 0.15776385 0.59197672

200 100 150 100 200 100 150 200 200 150 150 200 100 150 250 100 250 200 100 200 200 250 150 100 250 150 100 150 200 200 250 200 100 250 150 100 100 300 100 200 100 150 200 250 100 150 150 150 100 200

100 200 150 200 100 200 150 100 100 150 150 100 200 150 50 200 50 100 200 100 100 50 150 200 50 150 200 150 100 100 50 100 200 50 150 200 200 0 200 100 200 150 100 50 200 150 150 150 200 100

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.2712388 0.56715834 0.80160624 0.82070982 0.12719253 0.70243236 0.14189872 0.62302955 0.90981878 0.38500907 0.80413087 0.2269378 0.75172629 0.86851966 0.51108378 0.40929512 0.30691205 0.40104852 0.36413848 0.04296047 0.87350023 0.92429944 0.14451467 0.40056379 0.67449595 0.89478881 0.35046725 0.70499313 0.35042557 0.54080759 0.21380069 0.20103386 0.2198743 0.38009894 0.07011206 0.51376783 0.62523395 0.29061641 0.82176449 0.40664489 0.84598216 0.90482646 0.15402236 0.58780823 0.80257413 0.2578593 0.34933846 0.37618289 0.50708448 0.36647019

100 200 250 250 100 200 100 200 250 150 250 100 200 250 200 150 150 150 150 100 250 250 100 150 200 250 150 200 150 200 100 100 100 150 100 200 200 100 250 150 250 250 100 200 250 100 150 150 200 150

200 100 50 50 200 100 200 100 50 150 50 200 100 50 100 150 150 150 150 200 50 50 200 150 100 50 150 100 150 100 200 200 200 150 200 100 100 200 50 150 50 50 200 100 50 200 150 150 100 150

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.98225433 0.83099061 0.32323523 0.05993383 0.48773765 0.07515694 0.87800096 0.98034463 0.84946066 0.10652818 0.14894051 0.13098418 0.20206837 0.31280288 0.11320801 0.64538047 0.56460342 0.67239148 0.46971213 0.62014206 0.51907424 0.33186843 0.32311219 0.79569875 0.83141792 0.8048609 0.27507068 0.92350692 0.87772974 0.40713336 0.86466153 0.57691565 0.46388232 0.35665267 0.93481621 0.48331865 0.45308208 0.33533707 0.31618192 0.51973655 0.07102731 0.60061508 0.70372082 0.89543664 0.49377444 0.84481531 0.68580339 0.0891675 0.03434434 0.36631288

300 250 150 100 150 100 250 300 250 100 100 100 100 150 100 200 200 200 150 200 200 150 150 200 250 250 100 250 250 150 250 200 150 150 250 150 150 150 150 200 100 200 200 250 150 250 200 100 100 150

0 50 150 200 150 200 50 0 50 200 200 200 200 150 200 100 100 100 150 100 100 150 150 100 50 50 200 50 50 150 50 100 150 150 50 150 150 150 150 100 200 100 100 50 150 50 100 200 200 150

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.77834542 0.88891605 0.38802101 0.09683375 0.1534089 0.26299009 0.14202185 0.54692715 0.16688897 0.62427855 0.43001701 0.5254157 0.36428309 0.3967241 0.75075508 0.74665199 0.96464879 0.61304642 0.50650456 0.05499262 0.8663937 0.68115651 0.35141042 0.81341821 0.76336791 0.20109679 0.62023935 0.39087806 0.3041033 0.61405549 0.9383599 0.79829558 0.27434017 0.20928628 0.22964091 0.38562626 0.19791444 0.0111233 0.02128786 0.89893414 0.43847983 0.57833096 0.19554518 0.8885126 0.69345111 0.47624158 0.1178653 0.38583087 0.89623959 0.84272609

200 250 150 100 100 100 100 200 100 200 150 200 150 150 200 200 300 200 200 100 250 200 150 250 200 100 200 150 150 200 250 200 100 100 100 150 100 100 100 250 150 200 100 250 200 150 100 150 250 250

100 50 150 200 200 200 200 100 200 100 150 100 150 150 100 100 0 100 100 200 50 100 150 50 100 200 100 150 150 100 50 100 200 200 200 150 200 200 200 50 150 100 200 50 100 150 200 150 50 50

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.18801924 0.17678228 0.78780996 0.83456972 0.99033457 0.7928511 0.34472852 0.52359208 0.37594229 0.71305867 0.69570347 0.79012096 0.41216377 0.1169991 0.17907489 0.14886041 0.3326007 0.11084515 0.97860142 0.76720187 0.9547463 0.05640934 0.95571297 0.64904997 0.98360256 0.47615246 0.31798594 0.88736198 0.34909691 0.99581049 0.73320794 0.46792163 0.76381025 0.51871265 0.00516117 0.5715993 0.00108455 0.15764667 0.09085182 0.27239778 0.59806014 0.97992347 0.96831915 0.81830092 0.48347002 0.59891112 0.8848335 0.75707462 0.4634354 0.85180296

100 100 200 250 300 200 150 200 150 200 200 200 150 100 100 100 150 100 300 200 300 100 300 200 300 150 150 250 150 300 200 150 200 200 100 200 100 100 100 100 200 300 300 250 150 200 250 200 150 250

200 200 100 50 0 100 150 100 150 100 100 100 150 200 200 200 150 200 0 100 0 200 0 100 0 150 150 50 150 0 100 150 100 100 200 100 200 200 200 200 100 0 0 50 150 100 50 100 150 50

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

0.75301098 0.30165717 0.30915665 0.49927169 0.16266944 0.64766755 0.07552676 0.32412985 0.22745228 0.93839441 0.52566764 0.01244155 0.82509588 0.9053643 0.50186953 0.47248131 0.15285537 0.04567934 0.72841694

200 150 150 150 100 200 100 150 100 250 200 100 250 250 200 150 100 100 200

100 150 150 150 200 100 200 150 200 50 100 200 50 50 100 150 200 200 100

22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500 22500

A partir del modelo anterior es posible también realizar “what-if” análisis (análisis de escenarios o preguntas del tipo “¿qué pasaría si cambiamos tal o cual input?”). Para ello es suficiente con ir cambiando los valores de las celdas con fondo amarillo o rojo (inputs del modelo en este ejemplo). Asimismo, podemos ampliar fácilmente el número de iteraciones (observaciones muestrales) sin más que repetir los procesos de seleccionar y “arrastrar”. En el caso actual, hemos optado por tomar 1.000 iteraciones para cada una de los posibles inputs asociados a la cantidad de pedido (estos posibles inputs son: 100, 150, 200, 250, y 300). Si se realizase el experimento, se obtendrían unos resultados similares a los que se muestran a continuación (ya que 1.000 es un número ya bastante considerable para este ejemplo): A partir de los resultados, parece claro que la decisión óptima es hacer un pedido de 150 unidades, ya que con ello se consigue el beneficio máximo.

ue, matriz_buscar_en; indicador_columnas; [ordenado])

e devolverá una coincidencia exacta o aproximada. Si no encuentra ninguna coincidencia exacta, devolverá el siguiente valor más alto inferior a valor_b mna de matriz_buscar_en deben estar clasificados según un criterio de ordenación ascendente; en caso contrario, es posible que CONSULTAV no devu SULTAV sólo buscará una coincidencia exacta. Si hay dos o más valores en la primera columna de matriz_buscar_en que coinciden con el argumento va IN, ya que en ningún caso podremos vender más licencias que las disponibles

Ingresos Venta Ingresos Dev.Beneficios 10000 5000 -7500 15000 3750 -3750 15000 3750 -3750 20000 2500 0 10000 5000 -7500 10000 5000 -7500 10000 5000 -7500 10000 5000 -7500 10000 5000 -7500 15000 3750 -3750 10000 5000 -7500 10000 5000 -7500 10000 5000 -7500 15000 3750 -3750 25000 1250 3750 15000 3750 -3750 20000 2500 0 10000 5000 -7500 10000 5000 -7500 20000 2500 0 15000 3750 -3750 10000 5000 -7500 25000 1250 3750 20000 2500 0 25000 1250 3750 25000 1250 3750 20000 2500 0 15000 3750 -3750 25000 1250 3750 10000 5000 -7500 10000 5000 -7500

CARACTERIZACIÓN DEL EXPERIMENTO Media esperada (media muestra aleatoria): Desviación estándar: Valor Min: Valor Máx: nivel de significación (alpha): Intervalo de confianza: IC para la media a nivel (1-alpha)%

20000 15000 10000 15000 10000 30000 10000 10000 10000 10000 15000 10000 20000 10000 10000 30000 10000 15000 15000 25000 10000 10000 15000 30000 10000 15000 20000 15000 10000 10000 10000 25000 15000 30000 20000 20000 15000 10000 20000 10000 15000 20000 10000 30000 20000 10000 25000 10000 10000 10000

2500 3750 5000 3750 5000 0 5000 5000 5000 5000 3750 5000 2500 5000 5000 0 5000 3750 3750 1250 5000 5000 3750 0 5000 3750 2500 3750 5000 5000 5000 1250 3750 0 2500 2500 3750 5000 2500 5000 3750 2500 5000 0 2500 5000 1250 5000 5000 5000

0 -3750 -7500 -3750 -7500 7500 -7500 -7500 -7500 -7500 -3750 -7500 0 -7500 -7500 7500 -7500 -3750 -3750 3750 -7500 -7500 -3750 7500 -7500 -3750 0 -3750 -7500 -7500 -7500 3750 -3750 7500 0 0 -3750 -7500 0 -7500 -3750 0 -7500 7500 0 -7500 3750 -7500 -7500 -7500

10000 10000 20000 30000 15000 20000 20000 20000 15000 10000 10000 25000 20000 15000 10000 15000 25000 20000 15000 10000 15000 20000 10000 20000 20000 20000 10000 25000 10000 20000 10000 15000 25000 10000 15000 20000 10000 20000 20000 25000 20000 20000 20000 20000 25000 25000 15000 15000 20000 10000

5000 5000 2500 0 3750 2500 2500 2500 3750 5000 5000 1250 2500 3750 5000 3750 1250 2500 3750 5000 3750 2500 5000 2500 2500 2500 5000 1250 5000 2500 5000 3750 1250 5000 3750 2500 5000 2500 2500 1250 2500 2500 2500 2500 1250 1250 3750 3750 2500 5000

-7500 -7500 0 7500 -3750 0 0 0 -3750 -7500 -7500 3750 0 -3750 -7500 -3750 3750 0 -3750 -7500 -3750 0 -7500 0 0 0 -7500 3750 -7500 0 -7500 -3750 3750 -7500 -3750 0 -7500 0 0 3750 0 0 0 0 3750 3750 -3750 -3750 0 -7500

10000 25000 20000 15000 20000 15000 10000 20000 10000 10000 25000 10000 25000 15000 15000 20000 25000 10000 10000 15000 10000 15000 15000 25000 30000 15000 15000 10000 20000 25000 10000 15000 20000 20000 10000 25000 20000 30000 25000 15000 20000 10000 25000 10000 15000 10000 15000 25000 10000 25000

5000 1250 2500 3750 2500 3750 5000 2500 5000 5000 1250 5000 1250 3750 3750 2500 1250 5000 5000 3750 5000 3750 3750 1250 0 3750 3750 5000 2500 1250 5000 3750 2500 2500 5000 1250 2500 0 1250 3750 2500 5000 1250 5000 3750 5000 3750 1250 5000 1250

-7500 3750 0 -3750 0 -3750 -7500 0 -7500 -7500 3750 -7500 3750 -3750 -3750 0 3750 -7500 -7500 -3750 -7500 -3750 -3750 3750 7500 -3750 -3750 -7500 0 3750 -7500 -3750 0 0 -7500 3750 0 7500 3750 -3750 0 -7500 3750 -7500 -3750 -7500 -3750 3750 -7500 3750

20000 10000 20000 20000 20000 10000 10000 20000 10000 15000 25000 25000 20000 20000 10000 25000 20000 10000 20000 20000 20000 15000 10000 20000 20000 15000 20000 20000 20000 20000 10000 10000 15000 30000 20000 20000 10000 15000 20000 30000 15000 25000 10000 20000 25000 15000 20000 15000 20000 15000

2500 5000 2500 2500 2500 5000 5000 2500 5000 3750 1250 1250 2500 2500 5000 1250 2500 5000 2500 2500 2500 3750 5000 2500 2500 3750 2500 2500 2500 2500 5000 5000 3750 0 2500 2500 5000 3750 2500 0 3750 1250 5000 2500 1250 3750 2500 3750 2500 3750

0 -7500 0 0 0 -7500 -7500 0 -7500 -3750 3750 3750 0 0 -7500 3750 0 -7500 0 0 0 -3750 -7500 0 0 -3750 0 0 0 0 -7500 -7500 -3750 7500 0 0 -7500 -3750 0 7500 -3750 3750 -7500 0 3750 -3750 0 -3750 0 -3750

25000 10000 15000 10000 20000 15000 20000 25000 20000 30000 10000 25000 20000 15000 10000 10000 20000 20000 10000 20000 20000 25000 15000 10000 25000 10000 10000 25000 15000 25000 20000 15000 15000 10000 25000 10000 20000 15000 10000 15000 20000 25000 10000 10000 30000 20000 25000 15000 20000 10000

1250 5000 3750 5000 2500 3750 2500 1250 2500 0 5000 1250 2500 3750 5000 5000 2500 2500 5000 2500 2500 1250 3750 5000 1250 5000 5000 1250 3750 1250 2500 3750 3750 5000 1250 5000 2500 3750 5000 3750 2500 1250 5000 5000 0 2500 1250 3750 2500 5000

3750 -7500 -3750 -7500 0 -3750 0 3750 0 7500 -7500 3750 0 -3750 -7500 -7500 0 0 -7500 0 0 3750 -3750 -7500 3750 -7500 -7500 3750 -3750 3750 0 -3750 -3750 -7500 3750 -7500 0 -3750 -7500 -3750 0 3750 -7500 -7500 7500 0 3750 -3750 0 -7500

20000 15000 10000 20000 15000 20000 10000 25000 20000 20000 10000 25000 10000 20000 15000 15000 20000 20000 15000 15000 10000 15000 10000 25000 15000 20000 15000 15000 30000 20000 15000 25000 20000 10000 10000 15000 15000 15000 20000 20000 10000 20000 10000 15000 10000 25000 10000 30000 10000 20000

2500 3750 5000 2500 3750 2500 5000 1250 2500 2500 5000 1250 5000 2500 3750 3750 2500 2500 3750 3750 5000 3750 5000 1250 3750 2500 3750 3750 0 2500 3750 1250 2500 5000 5000 3750 3750 3750 2500 2500 5000 2500 5000 3750 5000 1250 5000 0 5000 2500

0 -3750 -7500 0 -3750 0 -7500 3750 0 0 -7500 3750 -7500 0 -3750 -3750 0 0 -3750 -3750 -7500 -3750 -7500 3750 -3750 0 -3750 -3750 7500 0 -3750 3750 0 -7500 -7500 -3750 -3750 -3750 0 0 -7500 0 -7500 -3750 -7500 3750 -7500 7500 -7500 0

20000 20000 20000 25000 10000 20000 15000 10000 30000 20000 10000 10000 15000 30000 20000 10000 15000 10000 10000 15000 20000 10000 25000 10000 10000 30000 20000 30000 25000 20000 10000 15000 30000 10000 10000 15000 10000 10000 10000 10000 20000 10000 20000 15000 20000 10000 25000 20000 20000 20000

2500 2500 2500 1250 5000 2500 3750 5000 0 2500 5000 5000 3750 0 2500 5000 3750 5000 5000 3750 2500 5000 1250 5000 5000 0 2500 0 1250 2500 5000 3750 0 5000 5000 3750 5000 5000 5000 5000 2500 5000 2500 3750 2500 5000 1250 2500 2500 2500

0 0 0 3750 -7500 0 -3750 -7500 7500 0 -7500 -7500 -3750 7500 0 -7500 -3750 -7500 -7500 -3750 0 -7500 3750 -7500 -7500 7500 0 7500 3750 0 -7500 -3750 7500 -7500 -7500 -3750 -7500 -7500 -7500 -7500 0 -7500 0 -3750 0 -7500 3750 0 0 0

30000 25000 20000 20000 10000 10000 10000 25000 15000 20000 15000 25000 15000 20000 25000 15000 10000 20000 25000 10000 30000 10000 20000 20000 15000 15000 25000 15000 25000 15000 10000 15000 20000 10000 20000 20000 20000 20000 20000 10000 10000 10000 25000 25000 10000 20000 15000 15000 20000 20000

0 1250 2500 2500 5000 5000 5000 1250 3750 2500 3750 1250 3750 2500 1250 3750 5000 2500 1250 5000 0 5000 2500 2500 3750 3750 1250 3750 1250 3750 5000 3750 2500 5000 2500 2500 2500 2500 2500 5000 5000 5000 1250 1250 5000 2500 3750 3750 2500 2500

7500 3750 0 0 -7500 -7500 -7500 3750 -3750 0 -3750 3750 -3750 0 3750 -3750 -7500 0 3750 -7500 7500 -7500 0 0 -3750 -3750 3750 -3750 3750 -3750 -7500 -3750 0 -7500 0 0 0 0 0 -7500 -7500 -7500 3750 3750 -7500 0 -3750 -3750 0 0

10000 20000 20000 20000 10000 20000 10000 10000 20000 20000 25000 15000 25000 15000 10000 10000 10000 15000 10000 20000 20000 15000 15000 15000 10000 10000 15000 15000 20000 15000 15000 20000 10000 25000 20000 10000 20000 10000 25000 20000 30000 15000 10000 20000 15000 20000 10000 10000 10000 10000

5000 2500 2500 2500 5000 2500 5000 5000 2500 2500 1250 3750 1250 3750 5000 5000 5000 3750 5000 2500 2500 3750 3750 3750 5000 5000 3750 3750 2500 3750 3750 2500 5000 1250 2500 5000 2500 5000 1250 2500 0 3750 5000 2500 3750 2500 5000 5000 5000 5000

-7500 0 0 0 -7500 0 -7500 -7500 0 0 3750 -3750 3750 -3750 -7500 -7500 -7500 -3750 -7500 0 0 -3750 -3750 -3750 -7500 -7500 -3750 -3750 0 -3750 -3750 0 -7500 3750 0 -7500 0 -7500 3750 0 7500 -3750 -7500 0 -3750 0 -7500 -7500 -7500 -7500

25000 10000 10000 25000 20000 20000 20000 15000 15000 15000 25000 15000 10000 25000 10000 25000 10000 20000 10000 10000 20000 20000 30000 20000 15000 10000 10000 10000 10000 20000 15000 20000 10000 10000 10000 10000 25000 15000 10000 10000 15000 25000 20000 30000 20000 10000 10000 15000 20000 10000

1250 5000 5000 1250 2500 2500 2500 3750 3750 3750 1250 3750 5000 1250 5000 1250 5000 2500 5000 5000 2500 2500 0 2500 3750 5000 5000 5000 5000 2500 3750 2500 5000 5000 5000 5000 1250 3750 5000 5000 3750 1250 2500 0 2500 5000 5000 3750 2500 5000

3750 -7500 -7500 3750 0 0 0 -3750 -3750 -3750 3750 -3750 -7500 3750 -7500 3750 -7500 0 -7500 -7500 0 0 7500 0 -3750 -7500 -7500 -7500 -7500 0 -3750 0 -7500 -7500 -7500 -7500 3750 -3750 -7500 -7500 -3750 3750 0 7500 0 -7500 -7500 -3750 0 -7500

15000 20000 10000 25000 10000 30000 30000 15000 10000 25000 15000 10000 25000 15000 10000 10000 25000 20000 15000 20000 20000 10000 15000 20000 15000 10000 15000 10000 15000 15000 10000 25000 25000 15000 20000 20000 10000 15000 20000 15000 15000 15000 10000 20000 10000 20000 20000 10000 10000 10000

3750 2500 5000 1250 5000 0 0 3750 5000 1250 3750 5000 1250 3750 5000 5000 1250 2500 3750 2500 2500 5000 3750 2500 3750 5000 3750 5000 3750 3750 5000 1250 1250 3750 2500 2500 5000 3750 2500 3750 3750 3750 5000 2500 5000 2500 2500 5000 5000 5000

-3750 0 -7500 3750 -7500 7500 7500 -3750 -7500 3750 -3750 -7500 3750 -3750 -7500 -7500 3750 0 -3750 0 0 -7500 -3750 0 -3750 -7500 -3750 -7500 -3750 -3750 -7500 3750 3750 -3750 0 0 -7500 -3750 0 -3750 -3750 -3750 -7500 0 -7500 0 0 -7500 -7500 -7500

15000 25000 25000 15000 20000 15000 10000 10000 10000 15000 10000 20000 10000 25000 20000 25000 10000 25000 20000 10000 30000 15000 25000 20000 20000 20000 25000 15000 15000 10000 20000 15000 20000 20000 20000 15000 20000 10000 20000 10000 20000 10000 20000 10000 20000 10000 15000 10000 20000 25000

3750 1250 1250 3750 2500 3750 5000 5000 5000 3750 5000 2500 5000 1250 2500 1250 5000 1250 2500 5000 0 3750 1250 2500 2500 2500 1250 3750 3750 5000 2500 3750 2500 2500 2500 3750 2500 5000 2500 5000 2500 5000 2500 5000 2500 5000 3750 5000 2500 1250

-3750 3750 3750 -3750 0 -3750 -7500 -7500 -7500 -3750 -7500 0 -7500 3750 0 3750 -7500 3750 0 -7500 7500 -3750 3750 0 0 0 3750 -3750 -3750 -7500 0 -3750 0 0 0 -3750 0 -7500 0 -7500 0 -7500 0 -7500 0 -7500 -3750 -7500 0 3750

25000 20000 15000 10000 10000 10000 10000 20000 20000 15000 15000 15000 20000 10000 10000 10000 10000 20000 30000 20000 25000 15000 15000 10000 10000 25000 10000 15000 10000 10000 30000 25000 10000 25000 20000 25000 10000 25000 20000 30000 25000 10000 10000 20000 10000 20000 20000 20000 10000 15000

1250 2500 3750 5000 5000 5000 5000 2500 2500 3750 3750 3750 2500 5000 5000 5000 5000 2500 0 2500 1250 3750 3750 5000 5000 1250 5000 3750 5000 5000 0 1250 5000 1250 2500 1250 5000 1250 2500 0 1250 5000 5000 2500 5000 2500 2500 2500 5000 3750

3750 0 -3750 -7500 -7500 -7500 -7500 0 0 -3750 -3750 -3750 0 -7500 -7500 -7500 -7500 0 7500 0 3750 -3750 -3750 -7500 -7500 3750 -7500 -3750 -7500 -7500 7500 3750 -7500 3750 0 3750 -7500 3750 0 7500 3750 -7500 -7500 0 -7500 0 0 0 -7500 -3750

20000 20000 20000 10000 15000 20000 20000 10000 10000 15000 20000 20000 10000 10000 10000 10000 15000 15000 20000 25000 10000 20000 15000 20000 25000 15000 10000 15000 25000 20000 10000 15000 20000 20000 10000 15000 15000 25000 25000 20000 20000 10000 15000 25000 20000 20000 20000 20000 10000 25000

2500 2500 2500 5000 3750 2500 2500 5000 5000 3750 2500 2500 5000 5000 5000 5000 3750 3750 2500 1250 5000 2500 3750 2500 1250 3750 5000 3750 1250 2500 5000 3750 2500 2500 5000 3750 3750 1250 1250 2500 2500 5000 3750 1250 2500 2500 2500 2500 5000 1250

0 0 0 -7500 -3750 0 0 -7500 -7500 -3750 0 0 -7500 -7500 -7500 -7500 -3750 -3750 0 3750 -7500 0 -3750 0 3750 -3750 -7500 -3750 3750 0 -7500 -3750 0 0 -7500 -3750 -3750 3750 3750 0 0 -7500 -3750 3750 0 0 0 0 -7500 3750

20000 10000 15000 10000 20000 10000 15000 20000 20000 15000 15000 20000 10000 15000 25000 10000 25000 20000 10000 20000 20000 25000 15000 10000 25000 15000 10000 15000 20000 20000 25000 20000 10000 25000 15000 10000 10000 30000 10000 20000 10000 15000 20000 25000 10000 15000 15000 15000 10000 20000

2500 5000 3750 5000 2500 5000 3750 2500 2500 3750 3750 2500 5000 3750 1250 5000 1250 2500 5000 2500 2500 1250 3750 5000 1250 3750 5000 3750 2500 2500 1250 2500 5000 1250 3750 5000 5000 0 5000 2500 5000 3750 2500 1250 5000 3750 3750 3750 5000 2500

0 -7500 -3750 -7500 0 -7500 -3750 0 0 -3750 -3750 0 -7500 -3750 3750 -7500 3750 0 -7500 0 0 3750 -3750 -7500 3750 -3750 -7500 -3750 0 0 3750 0 -7500 3750 -3750 -7500 -7500 7500 -7500 0 -7500 -3750 0 3750 -7500 -3750 -3750 -3750 -7500 0

10000 20000 25000 25000 10000 20000 10000 20000 25000 15000 25000 10000 20000 25000 20000 15000 15000 15000 15000 10000 25000 25000 10000 15000 20000 25000 15000 20000 15000 20000 10000 10000 10000 15000 10000 20000 20000 10000 25000 15000 25000 25000 10000 20000 25000 10000 15000 15000 20000 15000

5000 2500 1250 1250 5000 2500 5000 2500 1250 3750 1250 5000 2500 1250 2500 3750 3750 3750 3750 5000 1250 1250 5000 3750 2500 1250 3750 2500 3750 2500 5000 5000 5000 3750 5000 2500 2500 5000 1250 3750 1250 1250 5000 2500 1250 5000 3750 3750 2500 3750

-7500 0 3750 3750 -7500 0 -7500 0 3750 -3750 3750 -7500 0 3750 0 -3750 -3750 -3750 -3750 -7500 3750 3750 -7500 -3750 0 3750 -3750 0 -3750 0 -7500 -7500 -7500 -3750 -7500 0 0 -7500 3750 -3750 3750 3750 -7500 0 3750 -7500 -3750 -3750 0 -3750

30000 25000 15000 10000 15000 10000 25000 30000 25000 10000 10000 10000 10000 15000 10000 20000 20000 20000 15000 20000 20000 15000 15000 20000 25000 25000 10000 25000 25000 15000 25000 20000 15000 15000 25000 15000 15000 15000 15000 20000 10000 20000 20000 25000 15000 25000 20000 10000 10000 15000

0 1250 3750 5000 3750 5000 1250 0 1250 5000 5000 5000 5000 3750 5000 2500 2500 2500 3750 2500 2500 3750 3750 2500 1250 1250 5000 1250 1250 3750 1250 2500 3750 3750 1250 3750 3750 3750 3750 2500 5000 2500 2500 1250 3750 1250 2500 5000 5000 3750

7500 3750 -3750 -7500 -3750 -7500 3750 7500 3750 -7500 -7500 -7500 -7500 -3750 -7500 0 0 0 -3750 0 0 -3750 -3750 0 3750 3750 -7500 3750 3750 -3750 3750 0 -3750 -3750 3750 -3750 -3750 -3750 -3750 0 -7500 0 0 3750 -3750 3750 0 -7500 -7500 -3750

20000 25000 15000 10000 10000 10000 10000 20000 10000 20000 15000 20000 15000 15000 20000 20000 30000 20000 20000 10000 25000 20000 15000 25000 20000 10000 20000 15000 15000 20000 25000 20000 10000 10000 10000 15000 10000 10000 10000 25000 15000 20000 10000 25000 20000 15000 10000 15000 25000 25000

2500 1250 3750 5000 5000 5000 5000 2500 5000 2500 3750 2500 3750 3750 2500 2500 0 2500 2500 5000 1250 2500 3750 1250 2500 5000 2500 3750 3750 2500 1250 2500 5000 5000 5000 3750 5000 5000 5000 1250 3750 2500 5000 1250 2500 3750 5000 3750 1250 1250

0 3750 -3750 -7500 -7500 -7500 -7500 0 -7500 0 -3750 0 -3750 -3750 0 0 7500 0 0 -7500 3750 0 -3750 3750 0 -7500 0 -3750 -3750 0 3750 0 -7500 -7500 -7500 -3750 -7500 -7500 -7500 3750 -3750 0 -7500 3750 0 -3750 -7500 -3750 3750 3750

10000 10000 20000 25000 30000 20000 15000 20000 15000 20000 20000 20000 15000 10000 10000 10000 15000 10000 30000 20000 30000 10000 30000 20000 30000 15000 15000 25000 15000 30000 20000 15000 20000 20000 10000 20000 10000 10000 10000 10000 20000 30000 30000 25000 15000 20000 25000 20000 15000 25000

5000 5000 2500 1250 0 2500 3750 2500 3750 2500 2500 2500 3750 5000 5000 5000 3750 5000 0 2500 0 5000 0 2500 0 3750 3750 1250 3750 0 2500 3750 2500 2500 5000 2500 5000 5000 5000 5000 2500 0 0 1250 3750 2500 1250 2500 3750 1250

-7500 -7500 0 3750 7500 0 -3750 0 -3750 0 0 0 -3750 -7500 -7500 -7500 -3750 -7500 7500 0 7500 -7500 7500 0 7500 -3750 -3750 3750 -3750 7500 0 -3750 0 0 -7500 0 -7500 -7500 -7500 -7500 0 7500 7500 3750 -3750 0 3750 0 -3750 3750

20000 15000 15000 15000 10000 20000 10000 15000 10000 25000 20000 10000 25000 25000 20000 15000 10000 10000 20000

2500 3750 3750 3750 5000 2500 5000 3750 5000 1250 2500 5000 1250 1250 2500 3750 5000 5000 2500

0 -3750 -3750 -3750 -7500 0 -7500 -3750 -7500 3750 0 -7500 3750 3750 0 -3750 -7500 -7500 0

(análisis de escenarios o lo es suficiente con ir

na de los posibles inputs 0, 250, y 300). Si se

guiente valor más alto inferior a valor_buscado rio, es posible que CONSULTAV no devuelva el valor correcto r_en que coinciden con el argumento valor_búsqueda, se usará el primer valor encontrado. Si no se encuentra una coincidencia exacta, se devolverá e

-2287.5 4429.598 -7500 7500 0.05 274.5443 -2562.04

entra una coincidencia exacta, se devolverá el valor de error #N/A.

¿QUÉ SERVIDOR RESPONDE MÁS RÁPIDO A SUS CONSULTAS SQL? Supongamos que desde un ordenador cliente se realiza consultas SQL a bases de datos situadas en dos servidores distintos. Nuestro objetivo será estimar el tiempo esperado (tiempo medio) que deberemos esperar para recibir la respuesta de ambos servidores. Dada la complejidad de la consulta que queremos realizar, y basándonos en experiencias anteriores, se calcula que el tiempo necesario para que cada uno de los servidores responda a la misma sigue una distribución normal con los parámetros (media y desviación estándar, en minutos) que se indican a continuación: Dist. Media (min) Desv. Est. (min) Servidor 1 normal 20 3.4 Servidor 2 normal 22 2.6

Total iteraciones: S1+rápido: S2+rápido: Tiempo Medio: Desv. Est: IC 95% para Total Esperado:

Frecuencia Porcentaje 1000 100% 658 66% 341 34% 22.8169253 minutos 2.38355922 minutos 22.6691934 22.96466

Finalmente, las funciones PROMEDIO, DESVEST, e INTERVALO.CONFIANZA nos servirán para obtener, respectivamente, el tiempo muestral medio (esperado) de respuesta, la desviación estándar de la muestra (observaciones que generaremos), y un intervalo de confianza, a un nivel del 95%, para el tiempo medio (este intervalo nos permitirá saber si nuestra estimación es buena o si, por el contrario, necesitaremos más iteraciones). El tiempo medio estimado de respuesta es de: 22.81693 min Se puede asegurar con un nivel de confianza del 95% que dicho tiempo medio estará entre 22.66919 y 22.96466

El servidor 1 ha respuesto más rápido que el servidor 2 en el

66% de las iteraciones.

15.5215003 26.2444768 16.8885611 20.579352 16.9068034 24.390854 20.2027569 15.0896072 23.5225511 15.8479105 27.4270229 24.9019577 22.5657766 22.3068031 17.8827692 16.8723832 20.8976559 14.4712935 21.1077614 19.2961174 18.728826 20.710563 17.0044218 16.2543759 24.790211 16.1989806 22.7285782 19.8782012 25.6703085 20.4426649 18.1351933 22.6236245 20.0730412 26.7002666 23.2254089 15.4442808 21.6934455 18.7874816 14.8683793 24.4902785 20.6486026 17.5282339 24.9016115 25.4174662 18.9598585 21.0492749

21.8706391 24.2467546 23.4876377 20.0451308 17.1649278 20.8693971 23.5257109 21.3313238 18.3240178 22.4846331 20.8695971 20.6370369 19.9996085 15.8299383 15.7409535 21.715898 21.6964666 20.8087271 20.0396641 19.974605 20.796306 19.5817649 19.9068965 26.9942676 19.0912597 20.5221538 22.7573643 25.3660541 19.2530172 22.3477372 18.1420253 23.014265 20.3046524 24.2629704 18.4690448 24.5192789 20.2658445 20.0442372 21.6733485 17.523116 23.2656964 18.3353356 22.3754218 14.4577671 22.4925485 16.3787098 15.3860369

17.8545454 25.111223 17.9983429 14.857598 18.8629563 17.4113148 17.1356784 24.5514436 20.5947477 25.7699365 20.5792082 23.9621932 21.0651411 17.6570985 22.3811818 13.2769608 19.0974918 22.8392955 20.3490096 21.4369567 15.1970249 20.3525852 15.7763079 16.3809419 18.909161 24.15044 14.3773259 22.2959403 24.3732435 21.9762026 17.2481377 14.2633875 14.1546538 23.5569891 19.1573176 19.2769047 17.6985283 18.0095139 20.7014654 17.4700163 25.1270437 23.8947792 17.2913181 13.4536141 19.7100463 23.5259573 18.0334141

22.380671 23.8213932 20.7739313 25.1519447 19.3384216 25.0198734 21.9970917 17.1662924 23.1158517 18.8380054 21.4847867 24.2161998 21.6777205 13.2921188 16.3816367 19.2238072 20.2338038 21.4957937 13.9841764 21.0316973 20.2309265 20.1993963 21.8582181 21.4730722 21.5395279 19.8831858 18.1203975 20.0225745 19.6640198 17.9888989 18.3593761 18.9067039 20.7218353 17.3237364 20.947144 28.4325338 18.4947084 19.5625928 21.6841797 29.1746096 20.4913015 17.0982991 16.4292956 18.5788734 17.7754711 23.9886752 11.1618655

17.1120424 11.5357865 19.661292 19.44356 16.3239275 17.6011805 16.1267067 21.0527575 15.8614632 20.7027751 18.9211186 21.5518099 21.6323062 21.4942064 18.7764173 23.9730742 12.7175583 19.532563 21.4661194 24.6371467 21.2411424 19.5397832 15.100432 18.3018038 21.3134086 16.6489512 21.8424484 26.8334643 21.6609826 24.7642423 21.8311089 17.1699965 22.3340646 27.9653721 19.4243364 19.3111666 27.8465259 23.5230874 22.2887482 20.3919261 18.6481198 25.4516423 18.2864592 13.0549563 19.4612254 16.9690629 20.6318372

16.6674782 24.2514647 19.3697814 23.102909 26.351673 18.1202902 22.6346222 18.3833072 26.2414561 20.6374889 16.0057162 17.7089399 25.6907902 21.681535 16.9579793 20.2372199 14.7393147 24.6672899 20.4640804 19.2664306 17.2586214 21.340563 23.5565641 22.6853529 19.4598015 14.733539 19.0330421 15.9518372 12.5809046 22.7409291 18.1971169 15.8361023 17.4722117 20.6976559 20.1304552 20.8582072 23.7751104 17.8931219 17.0434563 19.0115829 26.6582547 21.4902592 20.6133473 21.5017204 22.2492009 23.5655836 23.8100687

26.2348167 20.2305894 26.4379906 16.8852547 16.4808316 19.7352931 20.7887939 14.5476227 23.5465674 15.6842282 22.9583984 24.0074286 19.9659043 17.196018 17.2860432 17.2819299 18.5199324 21.2401729 18.6970037 23.5867301 16.2849581 18.0405157 18.2809395 17.8085698 21.9913347 20.3979788 17.5678322 21.755803 16.4612801 20.6795006 18.6095106 22.4373563 21.2075521 24.2572813 19.6447754 23.1625553 16.832497 20.4689157 19.5679391 16.9264864 19.4205372 22.3658417 15.3229642 19.0760022 16.0576637 18.8816603 21.2572476

16.1769045 26.0869203 21.3146962 25.0419379 17.4349995 18.9524738 16.4661816 19.7969167 15.6063607 20.9620312 13.8037114 21.3787427 22.9662079 13.4337959 22.140622 21.2152495 14.4601318 24.6791394 18.514967 17.5113513 20.2450052 20.6830635 20.0132583 25.3438167 24.5689078 23.0747281 19.2311403 17.6696527 21.8255987 20.8225697 15.1185304 17.8590977 15.5427247 22.7018503 22.3814148 22.6827057 23.2993639 21.2429261 18.1696871 24.4815713 17.063602 17.0639272 21.445255 20.1389459 21.3370731 19.2976935 20.0399907

17.8877114 19.4852334 16.7188272 26.3528571 18.9833445 22.036859 16.062201 19.4709496 19.5583314 24.4889868 20.2920821 12.2156656 24.467982 22.0388629 17.7505936 23.8156666 14.6548983 13.6955023 15.5535854 18.3780207 18.3236246 21.9502876 23.1758592 16.3777801 18.7926066 13.6967053 16.033172 22.9366024 19.4302401 16.7456146 19.149731 21.3907112 19.4407417 22.9356682 23.7235677 25.5434246 17.054198 17.9220873 19.1324783 19.141279 21.8954849 19.5452445 20.6190844 15.6340251 26.0915595 16.1048437 17.3719028

23.7231186 16.9707209 22.2815489 20.6887529 21.3013739 27.5904269 22.1790958 21.4648217 21.9816694 19.6185033 19.4838792 19.9239754 15.024581 22.0325126 15.4295933 20.5922405 25.0022085 19.9880469 22.8028641 15.3048393 15.3026389 21.3387505 18.299896 18.9511457 20.2758971 21.9173861 13.2114039 22.2535526 19.1906186 27.8300084 23.0778505 16.6984133 14.965818 19.4043012 21.9885173 14.6216134 24.8409172 20.5504754 16.9524318 16.3984725 15.419653 23.5967562 16.8908368 22.5293064 18.0640201 9.92461954 10.9661724

15.6420871 18.0561792 19.3217543 20.8922525 19.0928989 16.0823384 18.1341658 22.544657 17.470773 21.7137144 20.4349522 20.270692 15.637287 18.6967469 21.3189952 22.6204679 21.2459699 27.2596472 21.7521328 20.8292743 12.6235643 16.44045 15.0498548 24.4872923 17.3934962 25.8502647 23.700299 20.0492645 23.8763203 17.0325431 19.8214567 21.7085605 24.7753006 26.6981243 18.3731545 25.1285624 25.5059549 16.2383479 21.3965093 17.3802753 23.039218 20.2757136 18.2985788 22.0560894 17.9331658 23.22398 22.0635253

20.3383153 19.9690522 22.6629593 22.8222325 19.3281829 24.4927812 12.7704933 19.6046103 19.8641834 15.9559104 23.8191422 15.7258903 17.9113348 25.4604906 21.255198 14.8599231 16.638961 24.4890527 17.9026602 20.7922251 25.6147894 20.0161139 21.281853 21.8792405 22.1768772 22.4402455 16.465258 23.5859152 21.608149 14.7009831 23.799502 15.1630152 23.2945149 16.2656828 20.8416448 17.1805955 13.7697465 19.7862148 17.7875302 23.5506847 24.0098113 18.070303 15.9964643 21.6798167 21.2542228 17.7486055 17.9898767

22.8966686 17.999381 19.2723176 24.9983032 25.9411915 15.1737374 17.6894754 19.7670558 24.123386 23.2870496 13.9706936 23.2553836 22.7871253 22.2049595 21.8596432 18.4977283 25.8430715 20.6174512 17.4975778 22.7966866 16.9280309 22.4863776 23.1572317 20.2482547 14.1592338 23.0922662 12.543047 21.6397202 23.8736314 12.0089128 24.3342301 21.2628373 20.8092224 23.0007133 20.3012192 15.7053119 16.6592731 17.9566334 18.3192813 16.217523 15.2359921 17.5226218 15.3291484 18.8633004 15.6230692 18.6194751 22.7981025

18.6063886 21.1285554 20.2511736 22.7875899 24.2432223 28.2258335 23.4555296 29.296058 26.9887618 15.4713142 18.3624964 21.1619748 20.359765 20.8594809 18.6035656 20.3685695 15.6320299 20.7012483 22.2915158 18.5303366 26.2543055 20.3688779 24.5266409 23.4248338 20.2543884 18.8344205 19.7228381 19.8334969 17.7986262 16.9818687 22.2880437 22.7970104 17.880722 13.8226639 21.1995716 23.7819664 15.7793239 16.8727832 20.6471178 20.2799359 21.5145608 11.5133822 22.225214 20.641009 20.1582098 19.4828384 16.017848

19.422481 21.7203 16.0843798 22.8220948 20.806609 22.0286191 17.1960477 18.9602693 15.150362 27.7540522 13.7787259 17.9599769 25.9148199 23.626051 27.7913773 19.0459829 22.9782249 19.9795523 23.7840415 17.5895429 10.3434108 13.5862921 24.3001603 21.3568071 14.5061195 22.8947161 21.206396 21.3015344 19.2789641 23.9203489 20.2741329 19.0377158 22.2189886 19.8009921 20.140926 21.2968935 19.5068194 11.5058204 24.7853967 14.4218717 19.35472 18.8402302 18.3632761 16.8039887 20.4871402 21.8028772 17.7907209

16.3332409 19.3732099 22.5980967 16.7352516 20.4398536 13.2914021 20.4703028 17.029382 20.4372111 27.5633954 18.7055834 18.4841252 19.1795443 17.4234978 22.7139516 17.6645151 19.9775923 16.6733564 19.7174033 21.2199885 25.1878567 19.3405884 19.2385463 22.8836422 18.6296111 16.5360425 21.2021777 22.7060795 20.8661955 24.3021507 21.5176591 22.355323 18.9591761 18.2137666 24.2144866 25.3251868 23.5814869 22.2438732 16.5243191 28.0962391 25.8488085 18.3829616 18.2806149 20.8669689 18.4777866 17.1458595 16.4796743

20.0111744 17.1474102 28.1065193 26.1918994 19.4520378 16.3776633 14.3231455 17.5915686 20.4343615 18.7669897 22.039188 26.2065593 17.645895 22.120049 21.7614719 16.8366089 18.7971759 21.1107815 24.1961533 13.0536786 18.7213784 17.5078633 13.549736 17.9577041 20.9532029 22.9037751 18.0917591 18.4001072 7.8647696 24.7984429 13.8356648 19.3250623 22.053344 18.7791342 21.2282018 20.6319499 22.2267556 22.2807024 17.6034712 22.4447282 17.0533339 19.8209298 20.0873076 19.2384544 23.964112 19.1213165 13.8404816

22.3112786 21.7247965 16.2666246 20.3369136 23.5260426 19.2343006 23.6891893 21.1000307 21.3406336 16.8686108 15.7098112 21.7611322 20.165922 24.250276 24.824183 24.1835262 21.0300155 19.5627612 21.2152548 18.8715483 24.1294223 21.6590743 24.4181582 17.243157 18.5765477 14.3458887 21.1985546 16.5842233 22.0701562 16.9492656 18.8970776 22.3735312 26.997453 27.2292909 16.9609022 23.5740163 20.2390361 17.2054669 21.7248774 22.5053436 16.3470923 14.6794707 23.5834161 18.2264361 18.5641079 22.6960543 18.3602646

17.0011713 22.2569529 27.0389981 25.0219433 18.3284406 22.8392995 15.9647308 26.049675 19.8738319 14.9863824 18.8023354 19.9249297 24.0507129 24.5538686 23.4860524 21.3610039 21.3563488 28.7614699 23.127089 21.3303598 20.9913558 23.6851752 13.607897 17.2297749 21.5200763 17.0502077 22.8478896 22.1440156 24.3456002 22.6528294 19.4331468 18.5478459 21.9551592 19.7320197 21.4623699 19.3992297 18.639667 23.3574669 17.3252857 17.0538067 17.7774715 21.5250751 22.2126934 17.9464184 20.7880998 18.982556 17.1138907

15.0834553 24.4856307 19.0846259 16.3269732 20.0686832 16.8977847 19.5994319 23.574313 23.7329161 19.1006766 21.7629065 17.6284378 22.2189174 25.3266983 27.6054673 26.537304 22.0054578 19.0896025 23.292694 21.972518 21.4126934 21.9974347 22.0491201 23.5678254 18.3453026 20.4437829 20.8444091 14.5194917 21.3454275 24.021472 29.5080807 18.1520433 19.3010569 20.6213719 20.3814771 20.9257025 20.4863983 17.8723193 13.2247108 23.901123 20.9176206 17.7486787 21.7292378 19.5431234 24.0619521 18.3474212 20.8095999

15.1724904 25.6934406 19.2358257 18.5093874 14.6911681 20.9181215 13.644689 13.5857341 23.8698379 21.250574 23.6045401 23.3419667 19.6843729 26.661223 25.1814967 14.0251032 19.5548871 20.5462551 18.0740669 18.970079 23.1659934 15.3810672

Servidor 1 19.5632615 12.4258929 18.3758451 24.6573385 17.2989403 16.3550671 15.9150494 18.1040222 20.8088631 14.5321564 22.3096231 19.887553 19.5258247 25.7828155 22.9749471 21.8489774 20.4318126 27.4242787 21.9557611 20.5724724 27.5633276 18.4926007 23.6087975 17.2255616 23.0622634 19.224992 16.0400642 15.3874238 15.3153123 25.7127942 22.4814072 16.0574278 18.5478625 20.5043268 17.5064657 25.166558 21.1128583 20.6986869

Servidor 2 22.12848 17.66585 20.57163 21.40177 19.73112 23.39478 20.14934 22.33254 18.95652 25.9516 23.20399 23.0085 18.70835 23.6304 21.83938 20.36247 22.71815 19.80051 21.52609 22.54323 26.07235 24.2744 22.2989 19.57272 29.16946 19.31101 20.91018 22.6024 19.70347 26.47659 27.17363 22.69763 20.33594 24.72733 21.33236 23.26717 21.31819 23.55353

Total Servidor más rápido 22.12848 1 17.66585 1 20.57163 1 24.65734 2 19.73112 1 23.39478 1 20.14934 1 22.33254 1 20.80886 2 25.9516 1 23.20399 1 23.0085 1 19.52582 2 25.78282 2 22.97495 2 21.84898 2 22.71815 1 27.42428 2 21.95576 2 22.54323 1 27.56333 2 24.2744 1 23.6088 2 19.57272 1 29.16946 1 19.31101 1 20.91018 1 22.6024 1 19.70347 1 26.47659 1 27.17363 1 22.69763 1 20.33594 1 24.72733 1 21.33236 1 25.16656 2 21.31819 1 23.55353 1

21.7762978 15.5215003 26.2444768 16.8885611 20.579352 16.9068034 24.390854 20.2027569 15.0896072 23.5225511 15.8479105 27.4270229 24.9019577 22.5657766 22.3068031 17.8827692 16.8723832 20.8976559 14.4712935 21.1077614 19.2961174 18.728826 20.710563 17.0044218 16.2543759 24.790211 16.1989806 22.7285782 19.8782012 25.6703085 20.4426649 18.1351933 22.6236245 20.0730412 26.7002666 23.2254089 15.4442808 21.6934455 18.7874816 14.8683793 24.4902785 20.6486026 17.5282339 24.9016115 25.4174662 18.9598585 21.0492749

18.5374 21.96876 18.07715 20.65405 21.40898 19.17958 22.01169 19.15037 20.99093 23.39813 18.07509 21.4036 19.22394 24.88451 18.35892 26.78872 22.22843 26.93368 17.96578 23.58476 23.74734 21.85029 21.70397 21.5798 25.83467 22.5603 24.9264 22.63003 25.60178 20.66351 23.64356 20.6337 20.21768 24.79064 22.11691 24.4026 21.5664 17.15911 23.19669 22.32308 19.38743 26.3413 24.97579 24.8396 23.42371 21.76064 22.38123

21.7763 21.96876 26.24448 20.65405 21.40898 19.17958 24.39085 20.20276 20.99093 23.52255 18.07509 27.42702 24.90196 24.88451 22.3068 26.78872 22.22843 26.93368 17.96578 23.58476 23.74734 21.85029 21.70397 21.5798 25.83467 24.79021 24.9264 22.72858 25.60178 25.67031 23.64356 20.6337 22.62362 24.79064 26.70027 24.4026 21.5664 21.69345 23.19669 22.32308 24.49028 26.3413 24.97579 24.90161 25.41747 21.76064 22.38123

2 1 2 1 1 1 2 2 1 2 1 2 2 1 2 1 1 1 1 1 1 1 1 1 1 2 1 2 1 2 1 1 2 1 2 1 1 2 1 1 2 1 1 2 2 1 1

21.8706391 24.2467546 23.4876377 20.0451308 17.1649278 20.8693971 23.5257109 21.3313238 18.3240178 22.4846331 20.8695971 20.6370369 19.9996085 15.8299383 15.7409535 21.715898 21.6964666 20.8087271 20.0396641 19.974605 20.796306 19.5817649 19.9068965 26.9942676 19.0912597 20.5221538 22.7573643 25.3660541 19.2530172 22.3477372 18.1420253 23.014265 20.3046524 24.2629704 18.4690448 24.5192789 20.2658445 20.0442372 21.6733485 17.523116 23.2656964 18.3353356 22.3754218 14.4577671 22.4925485 16.3787098 15.3860369

21.79098 21.373 24.27785 21.19036 19.59938 23.95548 25.30553 22.41576 19.57915 21.98952 24.9455 22.34556 24.62258 27.88598 19.95274 15.58885 24.67471 23.2033 22.74572 22.52874 12.9962 16.49458 18.96584 17.87929 20.59177 23.99121 15.21251 22.86851 19.99009 23.75393 22.84325 20.79774 22.81244 24.39042 22.70498 19.88792 19.01411 21.02903 21.31459 23.85592 22.4925 19.91819 21.16415 24.96981 21.89006 20.72978 25.35145

21.87064 24.24675 24.27785 21.19036 19.59938 23.95548 25.30553 22.41576 19.57915 22.48463 24.9455 22.34556 24.62258 27.88598 19.95274 21.7159 24.67471 23.2033 22.74572 22.52874 20.79631 19.58176 19.9069 26.99427 20.59177 23.99121 22.75736 25.36605 19.99009 23.75393 22.84325 23.01427 22.81244 24.39042 22.70498 24.51928 20.26584 21.02903 21.67335 23.85592 23.2657 19.91819 22.37542 24.96981 22.49255 20.72978 25.35145

2 2 1 1 1 1 1 1 1 2 1 1 1 1 1 2 1 1 1 1 2 2 2 2 1 1 2 2 1 1 1 2 1 1 1 2 2 1 2 1 2 1 2 1 2 1 1

17.8545454 25.111223 17.9983429 14.857598 18.8629563 17.4113148 17.1356784 24.5514436 20.5947477 25.7699365 20.5792082 23.9621932 21.0651411 17.6570985 22.3811818 13.2769608 19.0974918 22.8392955 20.3490096 21.4369567 15.1970249 20.3525852 15.7763079 16.3809419 18.909161 24.15044 14.3773259 22.2959403 24.3732435 21.9762026 17.2481377 14.2633875 14.1546538 23.5569891 19.1573176 19.2769047 17.6985283 18.0095139 20.7014654 17.4700163 25.1270437 23.8947792 17.2913181 13.4536141 19.7100463 23.5259573 18.0334141

22.59327 21.69645 17.97125 19.21156 19.74682 24.8752 18.31306 23.15767 22.62464 21.03055 21.46997 24.25227 26.0917 23.22408 19.09912 21.08552 21.24343 17.08375 22.73712 22.19726 21.01006 20.84934 19.75279 21.99877 25.1393 21.70422 25.82631 21.89858 21.62757 21.4763 26.35911 19.64048 22.48601 15.952 22.91671 23.35231 22.04166 21.64072 21.12816 21.16751 22.78115 21.0498 22.29231 19.63334 23.32137 23.4335 23.81348

22.59327 25.11122 17.99834 19.21156 19.74682 24.8752 18.31306 24.55144 22.62464 25.76994 21.46997 24.25227 26.0917 23.22408 22.38118 21.08552 21.24343 22.8393 22.73712 22.19726 21.01006 20.84934 19.75279 21.99877 25.1393 24.15044 25.82631 22.29594 24.37324 21.9762 26.35911 19.64048 22.48601 23.55699 22.91671 23.35231 22.04166 21.64072 21.12816 21.16751 25.12704 23.89478 22.29231 19.63334 23.32137 23.52596 23.81348

1 2 2 1 1 1 1 2 1 2 1 1 1 1 2 1 1 2 1 1 1 1 1 1 1 2 1 2 2 2 1 1 1 2 1 1 1 1 1 1 2 2 1 1 1 2 1

22.380671 23.8213932 20.7739313 25.1519447 19.3384216 25.0198734 21.9970917 17.1662924 23.1158517 18.8380054 21.4847867 24.2161998 21.6777205 13.2921188 16.3816367 19.2238072 20.2338038 21.4957937 13.9841764 21.0316973 20.2309265 20.1993963 21.8582181 21.4730722 21.5395279 19.8831858 18.1203975 20.0225745 19.6640198 17.9888989 18.3593761 18.9067039 20.7218353 17.3237364 20.947144 28.4325338 18.4947084 19.5625928 21.6841797 29.1746096 20.4913015 17.0982991 16.4292956 18.5788734 17.7754711 23.9886752 11.1618655

19.78903 19.36866 17.13171 22.03592 19.7188 22.6002 20.73089 18.47801 21.0581 22.03755 21.49387 20.33437 18.50273 19.15826 23.86194 20.1841 26.41928 21.43037 26.05811 20.56854 19.60886 23.95383 22.09168 23.35872 24.84074 18.19306 22.25873 24.78334 22.88863 20.1001 25.62387 24.21826 17.95398 22.65317 21.49133 23.86214 23.11007 24.00788 24.47773 26.39685 24.79509 24.2358 25.27074 22.30194 19.48642 22.39614 24.72662

22.38067 23.82139 20.77393 25.15194 19.7188 25.01987 21.99709 18.47801 23.11585 22.03755 21.49387 24.2162 21.67772 19.15826 23.86194 20.1841 26.41928 21.49579 26.05811 21.0317 20.23093 23.95383 22.09168 23.35872 24.84074 19.88319 22.25873 24.78334 22.88863 20.1001 25.62387 24.21826 20.72184 22.65317 21.49133 28.43253 23.11007 24.00788 24.47773 29.17461 24.79509 24.2358 25.27074 22.30194 19.48642 23.98868 24.72662

2 2 2 2 1 2 2 1 2 1 1 2 2 1 1 1 1 2 1 2 2 1 1 1 1 2 1 1 1 1 1 1 2 1 1 2 1 1 1 2 1 1 1 1 1 2 1

17.1120424 11.5357865 19.661292 19.44356 16.3239275 17.6011805 16.1267067 21.0527575 15.8614632 20.7027751 18.9211186 21.5518099 21.6323062 21.4942064 18.7764173 23.9730742 12.7175583 19.532563 21.4661194 24.6371467 21.2411424 19.5397832 15.100432 18.3018038 21.3134086 16.6489512 21.8424484 26.8334643 21.6609826 24.7642423 21.8311089 17.1699965 22.3340646 27.9653721 19.4243364 19.3111666 27.8465259 23.5230874 22.2887482 20.3919261 18.6481198 25.4516423 18.2864592 13.0549563 19.4612254 16.9690629 20.6318372

24.88923 26.3189 23.78216 24.61789 15.4631 19.11207 19.11644 24.96406 19.82452 22.88857 27.19188 20.40426 20.44788 21.49137 16.96823 25.28365 19.70981 18.13663 24.72289 20.37749 24.15707 20.7476 28.89837 22.75471 17.65442 23.98879 17.24395 19.76353 19.83855 19.69549 19.51074 20.74499 21.03212 22.5397 23.89693 18.11753 22.71719 25.31107 23.11348 17.71017 20.04483 23.39497 18.99762 20.01117 20.60039 23.57827 23.68767

24.88923 26.3189 23.78216 24.61789 16.32393 19.11207 19.11644 24.96406 19.82452 22.88857 27.19188 21.55181 21.63231 21.49421 18.77642 25.28365 19.70981 19.53256 24.72289 24.63715 24.15707 20.7476 28.89837 22.75471 21.31341 23.98879 21.84245 26.83346 21.66098 24.76424 21.83111 20.74499 22.33406 27.96537 23.89693 19.31117 27.84653 25.31107 23.11348 20.39193 20.04483 25.45164 18.99762 20.01117 20.60039 23.57827 23.68767

1 1 1 1 2 1 1 1 1 1 1 2 2 2 2 1 1 2 1 2 1 1 1 1 2 1 2 2 2 2 2 1 2 2 1 2 2 1 1 2 1 2 1 1 1 1 1

16.6674782 24.2514647 19.3697814 23.102909 26.351673 18.1202902 22.6346222 18.3833072 26.2414561 20.6374889 16.0057162 17.7089399 25.6907902 21.681535 16.9579793 20.2372199 14.7393147 24.6672899 20.4640804 19.2664306 17.2586214 21.340563 23.5565641 22.6853529 19.4598015 14.733539 19.0330421 15.9518372 12.5809046 22.7409291 18.1971169 15.8361023 17.4722117 20.6976559 20.1304552 20.8582072 23.7751104 17.8931219 17.0434563 19.0115829 26.6582547 21.4902592 20.6133473 21.5017204 22.2492009 23.5655836 23.8100687

21.57396 24.37362 22.52351 18.79828 18.85029 20.72576 22.08409 26.33262 17.37152 21.34844 20.28671 26.08899 25.26703 21.79004 22.08744 27.63227 24.31311 24.39622 18.28234 18.8352 23.14986 26.15779 23.66363 18.03824 26.99743 20.73181 17.52177 23.60034 26.73031 25.02543 20.97295 24.01406 21.25693 21.34186 22.56879 23.97838 22.04931 19.84906 19.29308 21.68936 22.02908 23.9773 18.26124 20.79676 24.45859 22.43244 25.97849

21.57396 24.37362 22.52351 23.10291 26.35167 20.72576 22.63462 26.33262 26.24146 21.34844 20.28671 26.08899 25.69079 21.79004 22.08744 27.63227 24.31311 24.66729 20.46408 19.26643 23.14986 26.15779 23.66363 22.68535 26.99743 20.73181 19.03304 23.60034 26.73031 25.02543 20.97295 24.01406 21.25693 21.34186 22.56879 23.97838 23.77511 19.84906 19.29308 21.68936 26.65825 23.9773 20.61335 21.50172 24.45859 23.56558 25.97849

1 1 1 2 2 1 2 1 2 1 1 1 2 1 1 1 1 2 2 2 1 1 1 2 1 1 2 1 1 1 1 1 1 1 1 1 2 1 1 1 2 1 2 2 1 2 1

26.2348167 20.2305894 26.4379906 16.8852547 16.4808316 19.7352931 20.7887939 14.5476227 23.5465674 15.6842282 22.9583984 24.0074286 19.9659043 17.196018 17.2860432 17.2819299 18.5199324 21.2401729 18.6970037 23.5867301 16.2849581 18.0405157 18.2809395 17.8085698 21.9913347 20.3979788 17.5678322 21.755803 16.4612801 20.6795006 18.6095106 22.4373563 21.2075521 24.2572813 19.6447754 23.1625553 16.832497 20.4689157 19.5679391 16.9264864 19.4205372 22.3658417 15.3229642 19.0760022 16.0576637 18.8816603 21.2572476

21.39278 18.08565 15.55004 21.52243 19.93399 24.01252 20.66328 22.18098 24.42923 20.34661 21.53499 20.37437 20.59414 20.48105 23.00573 22.31039 21.49367 21.89909 23.5524 17.6917 25.6383 25.60226 26.5501 20.17079 22.04187 20.4237 27.28616 26.74674 22.49436 19.33946 19.21391 25.87508 20.45775 25.69905 14.79038 20.93899 22.02803 24.3322 22.68576 24.30065 24.1899 19.78691 26.40477 22.6708 21.68853 19.80857 19.34848

26.23482 20.23059 26.43799 21.52243 19.93399 24.01252 20.78879 22.18098 24.42923 20.34661 22.9584 24.00743 20.59414 20.48105 23.00573 22.31039 21.49367 21.89909 23.5524 23.58673 25.6383 25.60226 26.5501 20.17079 22.04187 20.4237 27.28616 26.74674 22.49436 20.6795 19.21391 25.87508 21.20755 25.69905 19.64478 23.16256 22.02803 24.3322 22.68576 24.30065 24.1899 22.36584 26.40477 22.6708 21.68853 19.80857 21.25725

2 2 2 1 1 1 2 1 1 1 2 2 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 2 1 1 2 1 2 2 1 1 1 1 1 2 1 1 1 1 2

16.1769045 26.0869203 21.3146962 25.0419379 17.4349995 18.9524738 16.4661816 19.7969167 15.6063607 20.9620312 13.8037114 21.3787427 22.9662079 13.4337959 22.140622 21.2152495 14.4601318 24.6791394 18.514967 17.5113513 20.2450052 20.6830635 20.0132583 25.3438167 24.5689078 23.0747281 19.2311403 17.6696527 21.8255987 20.8225697 15.1185304 17.8590977 15.5427247 22.7018503 22.3814148 22.6827057 23.2993639 21.2429261 18.1696871 24.4815713 17.063602 17.0639272 21.445255 20.1389459 21.3370731 19.2976935 20.0399907

23.38035 20.34111 19.16054 25.00626 22.11197 26.57083 20.79111 25.90334 21.10945 23.63579 23.27722 25.70646 15.49324 19.86027 22.17392 19.7979 23.39534 19.651 22.455 24.2878 21.39731 23.28255 24.63544 16.74416 23.21043 20.57839 21.31128 19.95089 20.53522 23.04358 20.75884 21.30678 21.32661 21.77694 22.96671 17.80593 22.55319 24.56072 22.44836 25.26471 22.00969 23.21935 24.32237 22.4905 23.01691 25.14865 23.46299

23.38035 26.08692 21.3147 25.04194 22.11197 26.57083 20.79111 25.90334 21.10945 23.63579 23.27722 25.70646 22.96621 19.86027 22.17392 21.21525 23.39534 24.67914 22.455 24.2878 21.39731 23.28255 24.63544 25.34382 24.56891 23.07473 21.31128 19.95089 21.8256 23.04358 20.75884 21.30678 21.32661 22.70185 22.96671 22.68271 23.29936 24.56072 22.44836 25.26471 22.00969 23.21935 24.32237 22.4905 23.01691 25.14865 23.46299

1 2 2 2 1 1 1 1 1 1 1 1 2 1 1 2 1 2 1 1 1 1 1 2 2 2 1 1 2 1 1 1 1 2 1 2 2 1 1 1 1 1 1 1 1 1 1

17.8877114 19.4852334 16.7188272 26.3528571 18.9833445 22.036859 16.062201 19.4709496 19.5583314 24.4889868 20.2920821 12.2156656 24.467982 22.0388629 17.7505936 23.8156666 14.6548983 13.6955023 15.5535854 18.3780207 18.3236246 21.9502876 23.1758592 16.3777801 18.7926066 13.6967053 16.033172 22.9366024 19.4302401 16.7456146 19.149731 21.3907112 19.4407417 22.9356682 23.7235677 25.5434246 17.054198 17.9220873 19.1324783 19.141279 21.8954849 19.5452445 20.6190844 15.6340251 26.0915595 16.1048437 17.3719028

22.32294 19.37644 21.21019 19.60768 19.61449 20.27651 19.28885 20.07484 23.92745 22.73456 21.99145 22.33234 23.74771 21.64245 20.24016 18.97325 22.02683 22.54121 22.17161 18.59081 23.21219 22.22074 20.86733 18.81915 22.86876 18.81088 25.28949 23.05922 22.68903 23.21385 21.49063 20.29092 26.07679 17.60562 16.56519 23.5524 19.54746 19.10409 24.84168 18.12778 22.67764 17.80098 24.27811 24.85631 21.88315 20.63019 24.60334

22.32294 19.48523 21.21019 26.35286 19.61449 22.03686 19.28885 20.07484 23.92745 24.48899 21.99145 22.33234 24.46798 22.03886 20.24016 23.81567 22.02683 22.54121 22.17161 18.59081 23.21219 22.22074 23.17586 18.81915 22.86876 18.81088 25.28949 23.05922 22.68903 23.21385 21.49063 21.39071 26.07679 22.93567 23.72357 25.54342 19.54746 19.10409 24.84168 19.14128 22.67764 19.54524 24.27811 24.85631 26.09156 20.63019 24.60334

1 2 1 2 1 2 1 1 1 2 1 1 2 2 1 2 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 2 1 2 2 2 1 1 1 2 1 2 1 1 2 1 1

23.7231186 16.9707209 22.2815489 20.6887529 21.3013739 27.5904269 22.1790958 21.4648217 21.9816694 19.6185033 19.4838792 19.9239754 15.024581 22.0325126 15.4295933 20.5922405 25.0022085 19.9880469 22.8028641 15.3048393 15.3026389 21.3387505 18.299896 18.9511457 20.2758971 21.9173861 13.2114039 22.2535526 19.1906186 27.8300084 23.0778505 16.6984133 14.965818 19.4043012 21.9885173 14.6216134 24.8409172 20.5504754 16.9524318 16.3984725 15.419653 23.5967562 16.8908368 22.5293064 18.0640201 9.92461954 10.9661724

23.91865 21.25214 20.93839 21.92003 24.24266 24.13175 26.87288 24.00421 26.67496 16.94273 21.96179 22.22279 15.04056 22.96694 18.55533 22.49015 22.18451 18.70867 20.01646 20.08779 23.24466 24.95127 17.89736 21.37892 17.66103 19.87694 17.51555 16.29506 22.69382 22.59617 23.08211 16.4126 19.95591 18.9196 21.00805 21.49111 22.61315 22.44225 23.3154 19.23926 23.79986 17.3424 21.60207 21.16988 24.05144 19.87134 20.71664

23.91865 21.25214 22.28155 21.92003 24.24266 27.59043 26.87288 24.00421 26.67496 19.6185 21.96179 22.22279 15.04056 22.96694 18.55533 22.49015 25.00221 19.98805 22.80286 20.08779 23.24466 24.95127 18.2999 21.37892 20.2759 21.91739 17.51555 22.25355 22.69382 27.83001 23.08211 16.69841 19.95591 19.4043 21.98852 21.49111 24.84092 22.44225 23.3154 19.23926 23.79986 23.59676 21.60207 22.52931 24.05144 19.87134 20.71664

1 1 2 1 1 2 1 1 1 2 1 1 1 1 1 1 2 2 2 1 1 1 2 1 2 2 1 2 1 2 1 2 1 2 2 1 2 1 1 1 1 2 1 2 1 1 1

15.6420871 18.0561792 19.3217543 20.8922525 19.0928989 16.0823384 18.1341658 22.544657 17.470773 21.7137144 20.4349522 20.270692 15.637287 18.6967469 21.3189952 22.6204679 21.2459699 27.2596472 21.7521328 20.8292743 12.6235643 16.44045 15.0498548 24.4872923 17.3934962 25.8502647 23.700299 20.0492645 23.8763203 17.0325431 19.8214567 21.7085605 24.7753006 26.6981243 18.3731545 25.1285624 25.5059549 16.2383479 21.3965093 17.3802753 23.039218 20.2757136 18.2985788 22.0560894 17.9331658 23.22398 22.0635253

15.8618 21.84257 21.26758 25.31433 17.28347 25.23853 23.13524 20.70974 22.31462 23.58959 22.47008 22.4673 18.08866 25.23241 20.14421 15.91397 21.83883 24.1988 24.35831 19.29525 23.83841 23.32176 23.39428 20.43956 21.78448 23.86013 17.46909 22.10786 21.02659 22.40377 24.21616 21.84851 21.81628 22.65037 24.49942 21.43436 21.12158 21.38677 24.93209 20.53397 24.92245 19.3678 21.03465 23.89014 18.75102 23.08684 23.83201

15.8618 21.84257 21.26758 25.31433 19.0929 25.23853 23.13524 22.54466 22.31462 23.58959 22.47008 22.4673 18.08866 25.23241 21.319 22.62047 21.83883 27.25965 24.35831 20.82927 23.83841 23.32176 23.39428 24.48729 21.78448 25.85026 23.7003 22.10786 23.87632 22.40377 24.21616 21.84851 24.7753 26.69812 24.49942 25.12856 25.50595 21.38677 24.93209 20.53397 24.92245 20.27571 21.03465 23.89014 18.75102 23.22398 23.83201

1 1 1 1 2 1 1 2 1 1 1 1 1 1 2 2 1 2 1 2 1 1 1 2 1 2 2 1 2 1 1 1 2 2 1 2 2 1 1 1 1 2 1 1 1 2 1

20.3383153 19.9690522 22.6629593 22.8222325 19.3281829 24.4927812 12.7704933 19.6046103 19.8641834 15.9559104 23.8191422 15.7258903 17.9113348 25.4604906 21.255198 14.8599231 16.638961 24.4890527 17.9026602 20.7922251 25.6147894 20.0161139 21.281853 21.8792405 22.1768772 22.4402455 16.465258 23.5859152 21.608149 14.7009831 23.799502 15.1630152 23.2945149 16.2656828 20.8416448 17.1805955 13.7697465 19.7862148 17.7875302 23.5506847 24.0098113 18.070303 15.9964643 21.6798167 21.2542228 17.7486055 17.9898767

18.9851 17.18598 20.95605 19.03094 24.23851 22.74193 21.76192 22.52454 22.61735 22.35233 21.07153 25.58748 22.24371 21.84715 22.49993 21.37882 23.16018 22.22262 19.3437 21.04942 24.19261 23.49291 20.4048 23.0206 26.12214 19.8208 20.94275 17.98992 26.51592 20.34767 20.6145 24.074 19.63733 24.11951 22.99841 16.60487 24.32439 21.7534 21.80747 21.03569 18.59746 16.38453 14.9616 18.10391 20.67477 20.61863 21.67847

20.33832 19.96905 22.66296 22.82223 24.23851 24.49278 21.76192 22.52454 22.61735 22.35233 23.81914 25.58748 22.24371 25.46049 22.49993 21.37882 23.16018 24.48905 19.3437 21.04942 25.61479 23.49291 21.28185 23.0206 26.12214 22.44025 20.94275 23.58592 26.51592 20.34767 23.7995 24.074 23.29451 24.11951 22.99841 17.1806 24.32439 21.7534 21.80747 23.55068 24.00981 18.0703 15.99646 21.67982 21.25422 20.61863 21.67847

2 2 2 2 1 2 1 1 1 1 2 1 1 2 1 1 1 2 1 1 2 1 2 1 1 2 1 2 1 1 2 1 2 1 1 2 1 1 1 2 2 2 2 2 2 1 1

22.8966686 17.999381 19.2723176 24.9983032 25.9411915 15.1737374 17.6894754 19.7670558 24.123386 23.2870496 13.9706936 23.2553836 22.7871253 22.2049595 21.8596432 18.4977283 25.8430715 20.6174512 17.4975778 22.7966866 16.9280309 22.4863776 23.1572317 20.2482547 14.1592338 23.0922662 12.543047 21.6397202 23.8736314 12.0089128 24.3342301 21.2628373 20.8092224 23.0007133 20.3012192 15.7053119 16.6592731 17.9566334 18.3192813 16.217523 15.2359921 17.5226218 15.3291484 18.8633004 15.6230692 18.6194751 22.7981025

23.44523 27.36041 27.65754 25.1263 23.63092 24.48467 22.50253 22.11687 19.78579 22.59435 20.52088 19.72178 21.97703 21.92202 23.79322 22.51515 22.4327 22.20489 16.66742 19.20802 20.1508 24.57655 16.10422 18.7927 19.99448 22.58926 20.60177 24.46305 20.24283 26.61356 25.32518 18.19341 20.88461 25.97431 23.60478 19.11013 22.9237 23.5923 24.99963 19.11867 20.49921 22.24195 22.558 18.43721 25.41268 22.2582 16.2793

23.44523 27.36041 27.65754 25.1263 25.94119 24.48467 22.50253 22.11687 24.12339 23.28705 20.52088 23.25538 22.78713 22.20496 23.79322 22.51515 25.84307 22.20489 17.49758 22.79669 20.1508 24.57655 23.15723 20.24825 19.99448 23.09227 20.60177 24.46305 23.87363 26.61356 25.32518 21.26284 20.88461 25.97431 23.60478 19.11013 22.9237 23.5923 24.99963 19.11867 20.49921 22.24195 22.558 18.8633 25.41268 22.2582 22.7981

1 1 1 1 2 1 1 1 2 2 1 2 2 2 1 1 2 1 2 2 1 1 2 2 1 2 1 1 2 1 1 2 1 1 1 1 1 1 1 1 1 1 1 2 1 1 2

18.6063886 21.1285554 20.2511736 22.7875899 24.2432223 28.2258335 23.4555296 29.296058 26.9887618 15.4713142 18.3624964 21.1619748 20.359765 20.8594809 18.6035656 20.3685695 15.6320299 20.7012483 22.2915158 18.5303366 26.2543055 20.3688779 24.5266409 23.4248338 20.2543884 18.8344205 19.7228381 19.8334969 17.7986262 16.9818687 22.2880437 22.7970104 17.880722 13.8226639 21.1995716 23.7819664 15.7793239 16.8727832 20.6471178 20.2799359 21.5145608 11.5133822 22.225214 20.641009 20.1582098 19.4828384 16.017848

21.87183 19.48467 20.80743 19.94025 21.20209 22.25116 21.7529 21.84316 20.28853 18.44155 21.50394 18.51813 25.81439 19.87559 21.9204 23.97936 18.9616 17.91233 23.06376 21.84664 17.74415 25.13759 18.56812 22.57286 16.72378 21.55349 19.34896 17.5586 20.54697 23.96954 25.46133 22.5171 20.02145 19.99932 17.9588 25.29976 21.43133 22.69614 18.40871 22.90343 25.84208 19.23312 18.80881 22.49935 19.81897 22.60313 22.41348

21.87183 21.12856 20.80743 22.78759 24.24322 28.22583 23.45553 29.29606 26.98876 18.44155 21.50394 21.16197 25.81439 20.85948 21.9204 23.97936 18.9616 20.70125 23.06376 21.84664 26.25431 25.13759 24.52664 23.42483 20.25439 21.55349 19.72284 19.8335 20.54697 23.96954 25.46133 22.79701 20.02145 19.99932 21.19957 25.29976 21.43133 22.69614 20.64712 22.90343 25.84208 19.23312 22.22521 22.49935 20.15821 22.60313 22.41348

1 2 1 2 2 2 2 2 2 1 1 2 1 2 1 1 1 2 1 1 2 1 2 2 2 1 2 2 1 1 1 2 1 1 2 1 1 1 2 1 1 1 2 1 2 1 1

19.422481 21.7203 16.0843798 22.8220948 20.806609 22.0286191 17.1960477 18.9602693 15.150362 27.7540522 13.7787259 17.9599769 25.9148199 23.626051 27.7913773 19.0459829 22.9782249 19.9795523 23.7840415 17.5895429 10.3434108 13.5862921 24.3001603 21.3568071 14.5061195 22.8947161 21.206396 21.3015344 19.2789641 23.9203489 20.2741329 19.0377158 22.2189886 19.8009921 20.140926 21.2968935 19.5068194 11.5058204 24.7853967 14.4218717 19.35472 18.8402302 18.3632761 16.8039887 20.4871402 21.8028772 17.7907209

18.75029 21.8017 20.68751 19.37688 18.4217 22.80706 27.34529 23.02179 21.0133 22.20551 22.76003 19.43514 17.24997 24.2332 20.1849 22.87701 18.93977 25.21266 18.96617 20.28575 23.43064 23.8027 25.5774 23.70199 19.30067 21.50226 22.73761 24.18389 19.54556 24.63871 23.7759 25.33181 22.65825 15.77732 24.40552 21.54278 20.44058 24.98903 25.21024 22.95592 22.23968 22.04991 17.75238 24.08797 18.63611 21.71923 22.58163

19.42248 21.8017 20.68751 22.82209 20.80661 22.80706 27.34529 23.02179 21.0133 27.75405 22.76003 19.43514 25.91482 24.2332 27.79138 22.87701 22.97822 25.21266 23.78404 20.28575 23.43064 23.8027 25.5774 23.70199 19.30067 22.89472 22.73761 24.18389 19.54556 24.63871 23.7759 25.33181 22.65825 19.80099 24.40552 21.54278 20.44058 24.98903 25.21024 22.95592 22.23968 22.04991 18.36328 24.08797 20.48714 21.80288 22.58163

2 1 1 2 2 1 1 1 1 2 1 1 2 1 2 1 2 1 2 1 1 1 1 1 1 2 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 2 1 2 2 1

16.3332409 19.3732099 22.5980967 16.7352516 20.4398536 13.2914021 20.4703028 17.029382 20.4372111 27.5633954 18.7055834 18.4841252 19.1795443 17.4234978 22.7139516 17.6645151 19.9775923 16.6733564 19.7174033 21.2199885 25.1878567 19.3405884 19.2385463 22.8836422 18.6296111 16.5360425 21.2021777 22.7060795 20.8661955 24.3021507 21.5176591 22.355323 18.9591761 18.2137666 24.2144866 25.3251868 23.5814869 22.2438732 16.5243191 28.0962391 25.8488085 18.3829616 18.2806149 20.8669689 18.4777866 17.1458595 16.4796743

20.40303 20.4274 22.28189 22.33616 22.68909 17.63229 17.82381 24.49693 15.28243 23.2645 24.26843 25.32886 23.21416 20.45202 24.5264 24.31984 17.75941 23.50632 21.15954 17.71064 21.4138 24.32064 18.11052 14.5558 22.7656 23.47135 19.28948 20.07082 27.68994 16.98912 26.21877 21.42402 19.21318 22.72893 27.10584 17.59951 21.86594 18.53191 26.42844 21.82175 21.99882 21.11223 26.50368 16.80334 19.79359 24.87208 20.77886

20.40303 20.4274 22.5981 22.33616 22.68909 17.63229 20.4703 24.49693 20.43721 27.5634 24.26843 25.32886 23.21416 20.45202 24.5264 24.31984 19.97759 23.50632 21.15954 21.21999 25.18786 24.32064 19.23855 22.88364 22.7656 23.47135 21.20218 22.70608 27.68994 24.30215 26.21877 22.35532 19.21318 22.72893 27.10584 25.32519 23.58149 22.24387 26.42844 28.09624 25.84881 21.11223 26.50368 20.86697 19.79359 24.87208 20.77886

1 1 2 1 1 1 2 1 2 2 1 1 1 1 1 1 2 1 1 2 2 1 2 2 1 1 2 2 1 2 1 2 1 1 1 2 2 2 1 2 2 1 1 2 1 1 1

20.0111744 17.1474102 28.1065193 26.1918994 19.4520378 16.3776633 14.3231455 17.5915686 20.4343615 18.7669897 22.039188 26.2065593 17.645895 22.120049 21.7614719 16.8366089 18.7971759 21.1107815 24.1961533 13.0536786 18.7213784 17.5078633 13.549736 17.9577041 20.9532029 22.9037751 18.0917591 18.4001072 7.8647696 24.7984429 13.8356648 19.3250623 22.053344 18.7791342 21.2282018 20.6319499 22.2267556 22.2807024 17.6034712 22.4447282 17.0533339 19.8209298 20.0873076 19.2384544 23.964112 19.1213165 13.8404816

23.31119 19.06646 23.18682 22.98857 21.00064 18.29998 26.48059 17.8466 29.17318 21.61687 24.30398 20.84542 22.79959 21.8115 27.85879 20.36258 22.84728 21.76015 18.83166 16.37776 17.49551 26.24006 22.50357 19.46813 23.58657 22.93888 23.2203 22.78666 21.44461 20.47219 16.9545 22.68218 25.96456 20.93136 20.69292 21.39718 21.7691 23.11563 19.79395 24.19387 22.35761 16.87884 23.89222 22.75456 24.80343 21.00801 20.85339

23.31119 19.06646 28.10652 26.1919 21.00064 18.29998 26.48059 17.8466 29.17318 21.61687 24.30398 26.20656 22.79959 22.12005 27.85879 20.36258 22.84728 21.76015 24.19615 16.37776 18.72138 26.24006 22.50357 19.46813 23.58657 22.93888 23.2203 22.78666 21.44461 24.79844 16.9545 22.68218 25.96456 20.93136 21.2282 21.39718 22.22676 23.11563 19.79395 24.19387 22.35761 19.82093 23.89222 22.75456 24.80343 21.00801 20.85339

1 1 2 2 1 1 1 1 1 1 1 2 1 2 1 1 1 1 2 1 2 1 1 1 1 1 1 1 1 2 1 1 1 1 2 1 2 1 1 1 1 2 1 1 1 1 1

22.3112786 21.7247965 16.2666246 20.3369136 23.5260426 19.2343006 23.6891893 21.1000307 21.3406336 16.8686108 15.7098112 21.7611322 20.165922 24.250276 24.824183 24.1835262 21.0300155 19.5627612 21.2152548 18.8715483 24.1294223 21.6590743 24.4181582 17.243157 18.5765477 14.3458887 21.1985546 16.5842233 22.0701562 16.9492656 18.8970776 22.3735312 26.997453 27.2292909 16.9609022 23.5740163 20.2390361 17.2054669 21.7248774 22.5053436 16.3470923 14.6794707 23.5834161 18.2264361 18.5641079 22.6960543 18.3602646

21.50796 21.82691 28.86129 20.89822 18.94976 23.12401 22.53864 23.98021 24.18939 21.72195 20.5266 20.02816 20.31166 25.19099 18.85645 20.46785 27.11915 18.9496 22.43438 21.33259 24.73993 21.59433 22.98979 20.99052 16.96776 21.03023 15.0189 22.81252 24.2687 23.45312 21.38173 21.29548 25.90912 19.12478 16.94334 21.10257 19.08878 18.73901 25.19894 18.58065 23.46483 27.13901 24.33295 23.15091 21.51503 17.12556 25.81563

22.31128 21.82691 28.86129 20.89822 23.52604 23.12401 23.68919 23.98021 24.18939 21.72195 20.5266 21.76113 20.31166 25.19099 24.82418 24.18353 27.11915 19.56276 22.43438 21.33259 24.73993 21.65907 24.41816 20.99052 18.57655 21.03023 21.19855 22.81252 24.2687 23.45312 21.38173 22.37353 26.99745 27.22929 16.9609 23.57402 20.23904 18.73901 25.19894 22.50534 23.46483 27.13901 24.33295 23.15091 21.51503 22.69605 25.81563

2 1 1 1 2 1 2 1 1 1 1 2 1 1 2 2 1 2 1 1 1 2 2 1 2 1 2 1 1 1 1 2 2 2 2 2 2 1 1 2 1 1 1 1 1 2 1

17.0011713 22.2569529 27.0389981 25.0219433 18.3284406 22.8392995 15.9647308 26.049675 19.8738319 14.9863824 18.8023354 19.9249297 24.0507129 24.5538686 23.4860524 21.3610039 21.3563488 28.7614699 23.127089 21.3303598 20.9913558 23.6851752 13.607897 17.2297749 21.5200763 17.0502077 22.8478896 22.1440156 24.3456002 22.6528294 19.4331468 18.5478459 21.9551592 19.7320197 21.4623699 19.3992297 18.639667 23.3574669 17.3252857 17.0538067 17.7774715 21.5250751 22.2126934 17.9464184 20.7880998 18.982556 17.1138907

26.59682 18.63424 23.88447 19.15754 18.43187 22.9788 22.28631 20.16339 23.11353 22.52827 23.61304 18.28918 24.24444 22.99765 21.1187 26.49877 21.65732 23.16244 25.8499 22.88345 23.33657 19.00401 18.41132 23.6151 24.85242 23.93839 23.95166 20.2135 21.44251 14.97192 20.20452 21.00911 19.50706 24.83666 23.03696 29.01864 20.56129 25.65963 19.32123 27.44302 28.48399 21.72241 20.97715 19.54766 21.97489 19.04266 24.62738

26.59682 22.25695 27.039 25.02194 18.43187 22.9788 22.28631 26.04968 23.11353 22.52827 23.61304 19.92493 24.24444 24.55387 23.48605 26.49877 21.65732 28.76147 25.8499 22.88345 23.33657 23.68518 18.41132 23.6151 24.85242 23.93839 23.95166 22.14402 24.3456 22.65283 20.20452 21.00911 21.95516 24.83666 23.03696 29.01864 20.56129 25.65963 19.32123 27.44302 28.48399 21.72241 22.21269 19.54766 21.97489 19.04266 24.62738

1 2 2 2 1 1 1 2 1 1 1 2 1 2 2 1 1 2 1 1 1 2 1 1 1 1 1 2 2 2 1 1 2 1 1 1 1 1 1 1 1 1 2 1 1 1 1

15.0834553 24.4856307 19.0846259 16.3269732 20.0686832 16.8977847 19.5994319 23.574313 23.7329161 19.1006766 21.7629065 17.6284378 22.2189174 25.3266983 27.6054673 26.537304 22.0054578 19.0896025 23.292694 21.972518 21.4126934 21.9974347 22.0491201 23.5678254 18.3453026 20.4437829 20.8444091 14.5194917 21.3454275 24.021472 29.5080807 18.1520433 19.3010569 20.6213719 20.3814771 20.9257025 20.4863983 17.8723193 13.2247108 23.901123 20.9176206 17.7486787 21.7292378 19.5431234 24.0619521 18.3474212 20.8095999

19.34808 18.62918 19.60184 16.71113 16.64775 20.88284 17.11273 20.22264 22.78195 24.51361 22.31216 21.6719 24.41126 25.56414 22.25528 17.20484 22.48692 21.26385 22.0572 23.28628 18.30267 26.01972 17.25356 25.56262 20.09661 17.08946 18.11973 21.15385 21.9325 22.9182 20.46661 23.36146 24.60848 26.74026 21.95495 21.27691 20.6446 22.16438 21.02085 22.8176 24.93972 23.17228 23.56836 19.95687 17.12139 21.3092 22.09515

19.34808 24.48563 19.60184 16.71113 20.06868 20.88284 19.59943 23.57431 23.73292 24.51361 22.31216 21.6719 24.41126 25.56414 27.60547 26.5373 22.48692 21.26385 23.29269 23.28628 21.41269 26.01972 22.04912 25.56262 20.09661 20.44378 20.84441 21.15385 21.9325 24.02147 29.50808 23.36146 24.60848 26.74026 21.95495 21.27691 20.6446 22.16438 21.02085 23.90112 24.93972 23.17228 23.56836 19.95687 24.06195 21.3092 22.09515

1 2 1 1 2 1 2 2 2 1 1 1 1 1 2 2 1 1 2 1 2 1 2 1 1 2 2 1 1 2 2 1 1 1 1 1 1 1 1 2 1 1 1 1 2 1 1

15.1724904 25.6934406 19.2358257 18.5093874 14.6911681 20.9181215 13.644689 13.5857341 23.8698379 21.250574 23.6045401 23.3419667 19.6843729 26.661223 25.1814967 14.0251032 19.5548871 20.5462551 18.0740669 18.970079 23.1659934 15.3810672

24.59248 18.27313 20.12258 20.7188 22.64786 20.3622 20.04621 19.2045 18.53556 26.58401 23.20316 23.98204 18.6108 23.7489 16.90296 17.09228 23.41587 23.7914 24.74687 18.9581 25.63808 22.36763

24.59248 25.69344 20.12258 20.7188 22.64786 20.91812 20.04621 19.2045 23.86984 26.58401 23.60454 23.98204 19.68437 26.66122 25.1815 17.09228 23.41587 23.7914 24.74687 18.97008 25.63808 22.36763

1 2 1 1 1 2 1 1 2 1 2 1 2 2 2 1 1 1 1 2 1 1

Se desea invertir en una empresa un capital inicial de 250. En la empresa los flujos de caja de entrada y salida siguen la siguie Capital inicial: Flujo de caja Enero Entrante Saliente

250 Eur Distr. Normal NOrmal

Media

Desv. Est 500 400

125 100

a de entrada y salida siguen la siguiente distribución normal: