18
 Probabilidad Prob. Acum  Inter. Infer. 50-55 0.15 0.15 0 55-60 0.1 0.25 0.15 60-65 0.35 0.6 0.25 65-70 0.3 0.9 0.6 70-75 0.08 0.98 0.9 75-80 0.02 1 0.98 Produccion Minima = 50 Produccion Maxima= 80 Produccion de 1 año= 15576.25 Produccion diaria(toneada!"

Ejercicio Montecarlo

Embed Size (px)

DESCRIPTION

Ejercicio Montecarlo en Excel

Citation preview

  • 5/19/2018 Ejercicio Montecarlo

    1/18

    ProbabilidadProb. Acum Inter. Infer.50-55 0.15 0.15 0

    55-60 0.1 0.25 0.15

    60-65 0.35 0.6 0.25

    65-70 0.3 0.9 0.6

    70-75 0.08 0.98 0.9

    75-80 0.02 1 0.98

    Produccion Minima = 50

    Produccion Maxima= 80

    Produccion de 1 ao= 15576.25

    Produccion diaria(toneada!"

  • 5/19/2018 Ejercicio Montecarlo

    2/18

  • 5/19/2018 Ejercicio Montecarlo

    3/18

  • 5/19/2018 Ejercicio Montecarlo

    4/18

  • 5/19/2018 Ejercicio Montecarlo

    5/18

  • 5/19/2018 Ejercicio Montecarlo

    6/18

  • 5/19/2018 Ejercicio Montecarlo

    7/18

    Inter. #u$. Produccion %eatoria0.15 51.09

    0.25 59.93

    0.6 60.96

    0.9 66.62

    0.98 70.95 Dia # &aor %eatorio

    1 76.02 1 0.59560177 60.96

    2 0.762'82'7 66.62

    3 0.99208823 76.02

    ' 0.1978'187 59.93

    5 0.1961869 59.936 0.9'0052'8 70.95

    7 0.281006'9 60.96

    8 0.55'75186 60.96

    9 0.5170'572 60.96

    10 0.2'591991 59.93

    11 0.5781358' 60.96

    12 0.15225619 59.93

    13 0.667793'7 66.62

    1' 0.2'93'882 59.93

    15 0.0371102' 51.0916 0.60923358 66.62

    17 0.08860952 51.09

    18 0.652679'6 66.62

    19 0.0'192758 51.09

    20 0.1523919' 59.93

    21 0.17205597 59.93

    22 0.7908276 66.62

    23 0.2062'5'2 59.93

    2' 0.78315233 66.62

    25 0.73772777 66.62

    26 0.63'135 66.62

    27 0.83'8'15 66.62

    28 0.28836953 60.96

    29 0.0619775 51.09

    30 0.3398101' 60.96

    31 0.17393788 59.93

    32 0.166'8016 59.93

    33 0.93016718 70.95

  • 5/19/2018 Ejercicio Montecarlo

    8/18

    3' 0.27096227 60.96

    35 0.93169992 70.95

    36 0.27266281 60.96

    37 0.71971''3 66.62

    38 0.937'9233 70.95

    39 0.112'251' 51.09

    '0 0.77372206 66.62'1 0.95968067 70.95

    '2 0.2'55'065 59.93

    '3 0.76181581 66.62

    '' 0.2216259' 59.93

    '5 0.81876163 66.62

    '6 0.57560'16 60.96

    '7 0.6'066'17 66.62

    '8 0.2'300082 59.93

    '9 0.'33228'2 60.96

    50 0.6798'72' 66.6251 0.208516'' 59.93

    52 0.97305112 70.95

    53 0.8'3'657' 66.62

    5' 0.80'7165 66.62

    55 0.9'656'65 70.95

    56 0.1001'0'8 51.09

    57 0.67919382 66.62

    58 0.28580656 60.96

    59 0.57868393 60.96

    60 0.36236203 60.9661 0.207598'7 59.93

    62 0.18123188 59.93

    63 0.576'538' 60.96

    6' 0.03061965 51.09

    65 0.07502963 51.09

    66 0.17'30911 59.93

    67 0.0279'755 51.09

    68 0.9'866558 70.95

    69 0.9390'053 70.95

    70 0.0'8262'5 51.09

    71 0.86708175 66.62

    72 0.9293'838 70.95

    73 0.02303209 51.09

    7' 0.87561378 66.62

    75 0.16931073 59.93

    76 0.95110601 70.95

    77 0.6879'588 66.62

    78 0.75'5017 66.62

  • 5/19/2018 Ejercicio Montecarlo

    9/18

    79 0.0'692112 51.09

    80 0.35196118 60.96

    81 0.''967308 60.96

    82 0.80787052 66.62

    83 0.3399'016 60.96

    8' 0.69738876 66.62

    85 0.786827'8 66.6286 0.70116681 66.62

    87 0.'0816252 60.96

    88 0.'6872905 60.96

    89 0.6507965' 66.62

    90 0.98326937 76.02

    91 0.571'0'1' 60.96

    92 0.20587681 59.93

    93 0.88028'73 66.62

    9' 0.8621'552 66.62

    95 0.1087'986 51.0996 0.'375'666 60.96

    97 0.5695082' 60.96

    98 0.7372002' 66.62

    99 0.1306131 51.09

    100 0.89668783 66.62

    101 0.72709903 66.62

    102 0.1021'91' 51.09

    103 0.3180322 60.96

    10' 0.627'3685 66.62

    105 0.7'799879 66.62106 0.72650925 66.62

    107 0.3631868' 60.96

    108 0.71776162 66.62

    109 0.6260035' 66.62

    110 0.90680929 70.95

    111 0.28'50'28 60.96

    112 0.79850583 66.62

    113 0.15129768 59.93

    11' 0.97958355 70.95

    115 0.30909027 60.96

    116 0.03'59923 51.09

    117 0.97087609 70.95

    118 0.63130883 66.62

    119 0.70559193 66.62

    120 0.5'392'07 60.96

    121 0.3570'29 60.96

    122 0.'69''37 60.96

    123 0.9796'073 70.95

  • 5/19/2018 Ejercicio Montecarlo

    10/18

    12' 0.5'567701 60.96

    125 0.36'1'0'5 60.96

    126 0.60096''1 66.62

    127 0.96722022 70.95

    128 0.83198575 66.62

    129 0.98822216 76.02

    130 0.1376778' 51.09131 0.29887833 60.96

    132 0.7797716 66.62

    133 0.9769929 70.95

    13' 0.'1573987 60.96

    135 0.10655556 51.09

    136 0.''896829 60.96

    137 0.60533113 66.62

    138 0.12106918 51.09

    139 0.38033733 60.96

    1'0 0.12968588 51.091'1 0.637'''55 66.62

    1'2 0.738'901 66.62

    1'3 0.08079168 51.09

    1'' 0.18223317 59.93

    1'5 0.92962773 70.95

    1'6 0.20293'73 59.93

    1'7 0.'8367955 60.96

    1'8 0.962'00' 70.95

    1'9 0.57665689 60.96

    150 0.99793196 76.02151 0.0825'558 51.09

    152 0.50007789 60.96

    153 0.2'558603 59.93

    15' 0.8950072 66.62

    155 0.56983'12 60.96

    156 0.26177978 60.96

    157 0.883'2163 66.62

    158 0.210'3389 59.93

    159 0.759'2895 66.62

    160 0.25851007 60.96

    161 0.'1705055 60.96

    162 0.23788386 59.93

    163 0.05710965 51.09

    16' 0.06035336 51.09

    165 0.18582527 59.93

    166 0.12'197'2 51.09

    167 0.'67'3535 60.96

    168 0.'0813739 60.96

  • 5/19/2018 Ejercicio Montecarlo

    11/18

    169 0.1032'9'5 51.09

    170 0.03957982 51.09

    171 0.97296''3 70.95

    172 0.'6789925 60.96

    173 0.2'823'62 59.93

    17' 0.77'86952 66.62

    175 0.075'7902 51.09176 0.313311'8 60.96

    177 0.192960'7 59.93

    178 0.22933268 59.93

    179 0.'1152755 60.96

    180 0.797773'2 66.62

    181 0.010'8'78 51.09

    182 0.10172778 51.09

    183 0.01172855 51.09

    18' 0.907627'2 70.95

    185 0.'93089'2 60.96186 0.62'78757 66.62

    187 0.33788301 60.96

    188 0.7676'522 66.62

    189 0.77389226 66.62

    190 0.5011'159 60.96

    191 0.706'1767 66.62

    192 0.26116586 60.96

    193 0.57887172 60.96

    19' 0.101'6701 51.09

    195 0.98330997 76.02196 0.19162028 59.93

    197 0.09658025 51.09

    198 0.61262796 66.62

    199 0.1059891 51.09

    200 0.13829999 51.09

    201 0.96262688 70.95

    202 0.03322527 51.09

    203 0.37605808 60.96

    20' 0.103535'8 51.09

    205 0.87150873 66.62

    206 0.27525626 60.96

    207 0.5060261' 60.96

    208 0.39597221 60.96

    209 0.78028679 66.62

    210 0.'36'1503 60.96

    211 0.81159785 66.62

    212 0.71'903'1 66.62

    213 0.79528182 66.62

  • 5/19/2018 Ejercicio Montecarlo

    12/18

    21' 0.21983851 59.93

    215 0.3537'2' 60.96

    216 0.768'736 66.62

    217 0.6281'6'9 66.62

    218 0.1205'696 51.09

    219 0.95702'22 70.95

    220 0.00381566 51.09221 0.19182285 59.93

    222 0.'917267' 60.96

    223 0.83076773 66.62

    22' 0.52950368 60.96

    225 0.8097219' 66.62

    226 0.51987'1' 60.96

    227 0.2'66'096 59.93

    228 0.10151266 51.09

    229 0.39353818 60.96

    230 0.0'01908 51.09231 0.7911025' 66.62

    232 0.'3691976 60.96

    233 0.98372553 76.02

    23' 0.21665732 59.93

    235 0.73256896 66.62

    236 0.83628978 66.62

    237 0.13215899 51.09

    238 0.785'7658 66.62

    239 0.1'2'7658 51.09

    2'0 0.06110608 51.092'1 0.155772'8 59.93

    2'2 0.08200759 51.09

    2'3 0.'62'3365 60.96

    2'' 0.13688088 51.09

    2'5 0.35985317 60.96

    2'6 0.53237393 60.96

    2'7 0.2338962 59.93

    2'8 0.39233229 60.96

    2'9 0.'2739975 60.96

    250 0.01881'39 51.09

    251 0.63206068 66.62

    252 0.15961235 59.93

  • 5/19/2018 Ejercicio Montecarlo

    13/18

    Proaiidad

    50 0.1

    55 0.15

    6' 0.35

    68 0.3

  • 5/19/2018 Ejercicio Montecarlo

    14/18

  • 5/19/2018 Ejercicio Montecarlo

    15/18

  • 5/19/2018 Ejercicio Montecarlo

    16/18

  • 5/19/2018 Ejercicio Montecarlo

    17/18

  • 5/19/2018 Ejercicio Montecarlo

    18/18