25
0.64733346 CONSULTAS E FREC. ABS (D FREC. RELAT FREC. REL. AC 0.25837414 0 10 0.05 0.05 0.61430976 1 20 0.10 0.15 0.2515634 2 40 0.20 0.35 0.20139159 3 60 0.30 0.65 0.33860902 4 40 0.20 0.85 0.79101012 5 30 0.15 1.00 0.2360343 200 1.00 0.39655743 0.47969343 0.04018137 0.83058196 0.55885449 0.26908613 0.36597886 0.54379479 0.31153246 0.72057402 0.71968979 0.10902377 0.39091811 0.87885258 0.13050116 0.32547842 0.97550705 0.27401404 0.22569242 0.87515789 0.039115 0.27232242 0.6367474 0.64854556 0.14246925 0.53545817 0.136086 0.02910133 0.07679679 0.46097608 0.98527515 0.42242634 0.53851206 0.90237807 0.45437565 0.90727475 0.08757302

Ejercicios excel funciones financieras

Embed Size (px)

DESCRIPTION

Muy útil para todo tipo de personas

Citation preview

EJERCICIO 10.912070653752.76CONSULTAS EISFREC. ABS (DIAS)FREC. RELATIVAFREC. REL. AC0.627276558730100.050.050.148944228111200.100.150.604082434332400.200.350.339246395323600.300.650.199467535724400.200.850.077159917915300.151.000.845509616742001.000.051410586810.236699135320.624494094830.342152086820.594986849330.451350912530.527189350430.420722968130.664781089240.428881306830.256156420520.918924634550.244734296520.162896686420.26380755820.662857392540.615316132130.140134778210.318666997620.419887340530.376952939430.880357579550.008181629500.719613869640.429313889630.220337828220.405647496630.360477554930.789177381840.037659598900.491041885430.493040611930.003609679700.7349330540.981226053250.38000146230.567954391630.204508360920.630698741730.939669857550.258625873120.249809726920.168308873120.15582786620.356484962430.362996836430.68820192840.206493763420.246499040420.813605711640.887855644150.559386245730.852592099450.825125373340.910211593650.085553430210.262454639420.150520833820.107664874310.650703923940.235689064420.385874678930.986340009650.90092734150.315137937620.490623837930.553593471330.616550205130.525886468530.061546469710.137063238210.238199251220.115848396110.64075609430.991125813750.315301156420.964716257350.489189247530.242111300720.272485277720.53154859330.059758726910.515729840830.988436440650.116643535310.796381751640.267280840620.123626559710.468576510330.107802071810.649066778930.45969164063

EJERCICIO 2N DE LICENCIASPROBABILIDADPROB.ACUMEXT.INF.INTERVALOEXT.SUP.INTERVALON LICENCIAS VENDIDASN ALEATORIOLIC. VENDIDASLIC.DEVCOSTEINGRESOS VENTAINGRESOS DEVBENEFICIOS1000.300.300.000.301000.187404653100100.0015,000.0010,000.002,500.00-2,500.001500.200.500.300.501500.2757665427100100.0015,000.0010,000.002,500.00-2,500.002000.300.800.500.802000.75827853582000.0015,000.0020,000.000.005,000.002500.150.950.800.952500.0876886731100100.0015,000.0010,000.002,500.00-2,500.003000.051.000.951.003000.50547563472000.0015,000.0020,000.000.005,000.000.1642054896100100.0015,000.0010,000.002,500.00-2,500.000.2982682518100100.0015,000.0010,000.002,500.00-2,500.000.1236861798100100.0015,000.0010,000.002,500.00-2,500.000.98595477942000.0015,000.0020,000.000.005,000.00COSTE X LICENCIA75EUROS0.479852683915050.0015,000.0015,000.001,250.001,250.00INGRESOS X LICENCIA VENDIDA100EUROS0.423070166415050.0015,000.0015,000.001,250.001,250.00INGRESOS X LICENCIA DEVUELTA25EUROS0.86207971892000.0015,000.0020,000.000.005,000.00CANTIDAD DE LIC A COMPRAR200LICENCIAS0.79008388842000.0015,000.0020,000.000.005,000.000.72106844272000.0015,000.0020,000.000.005,000.000.63912644292000.0015,000.0020,000.000.005,000.00VARIABLE BENEFICIO0.386838189715050.0015,000.0015,000.001,250.001,250.00MEDIA MUESTRAL2045.45454545460.420350776315050.0015,000.0015,000.001,250.001,250.00DESVIACION ESTANDAR3136.22751176730.97381824472000.0015,000.0020,000.000.005,000.00VALOR MIN-25000.470189813215050.0015,000.0015,000.001,250.001,250.00VALOR MAX50000.83199218982000.0015,000.0020,000.000.005,000.00NIVEL SIGNIFICATIVO ALPHA0.050.374879252715050.0015,000.0015,000.001,250.001,250.00AMPLITUD INTERVALO DE CONFIANZA617.7859881590.80084508992000.0015,000.0020,000.000.005,000.00IC PARA LA MEDIA A NIVEL (1-ALPHA)%1427.66855729550.451946311515050.0015,000.0015,000.001,250.001,250.000.1554246459100100.0015,000.0010,000.002,500.00-2,500.000.53912199432000.0015,000.0020,000.000.005,000.000.369098630215050.0015,000.0015,000.001,250.001,250.000.5756590372000.0015,000.0020,000.000.005,000.000.415506757815050.0015,000.0015,000.001,250.001,250.000.3715054215050.0015,000.0015,000.001,250.001,250.000.2470242422100100.0015,000.0010,000.002,500.00-2,500.000.87701350152000.0015,000.0020,000.000.005,000.000.451978994215050.0015,000.0015,000.001,250.001,250.000.84118617862000.0015,000.0020,000.000.005,000.000.75996201842000.0015,000.0020,000.000.005,000.000.8013620532000.0015,000.0020,000.000.005,000.000.1960211291100100.0015,000.0010,000.002,500.00-2,500.000.470899797915050.0015,000.0015,000.001,250.001,250.000.434050538115050.0015,000.0015,000.001,250.001,250.000.0582596014100100.0015,000.0010,000.002,500.00-2,500.000.0090764546100100.0015,000.0010,000.002,500.00-2,500.000.1016408492100100.0015,000.0010,000.002,500.00-2,500.000.332021254415050.0015,000.0015,000.001,250.001,250.000.71057607592000.0015,000.0020,000.000.005,000.000.482799722615050.0015,000.0015,000.001,250.001,250.000.83917994572000.0015,000.0020,000.000.005,000.000.435120599915050.0015,000.0015,000.001,250.001,250.000.1225324431100100.0015,000.0010,000.002,500.00-2,500.000.1539218296100100.0015,000.0010,000.002,500.00-2,500.000.93518289562000.0015,000.0020,000.000.005,000.000.0674967276100100.0015,000.0010,000.002,500.00-2,500.000.7788888082000.0015,000.0020,000.000.005,000.000.77949285422000.0015,000.0020,000.000.005,000.000.56283334272000.0015,000.0020,000.000.005,000.000.452739151215050.0015,000.0015,000.001,250.001,250.000.63245546022000.0015,000.0020,000.000.005,000.000.436686577715050.0015,000.0015,000.001,250.001,250.000.372344810215050.0015,000.0015,000.001,250.001,250.000.70650360942000.0015,000.0020,000.000.005,000.000.1746681521100100.0015,000.0010,000.002,500.00-2,500.000.0315682024100100.0015,000.0010,000.002,500.00-2,500.000.2105242884100100.0015,000.0010,000.002,500.00-2,500.000.8258293972000.0015,000.0020,000.000.005,000.000.460564255315050.0015,000.0015,000.001,250.001,250.000.9912538212000.0015,000.0020,000.000.005,000.000.2226882318100100.0015,000.0010,000.002,500.00-2,500.000.358324885915050.0015,000.0015,000.001,250.001,250.000.87211710632000.0015,000.0020,000.000.005,000.000.75212649832000.0015,000.0020,000.000.005,000.000.351487539315050.0015,000.0015,000.001,250.001,250.000.82504675672000.0015,000.0020,000.000.005,000.000.69408405172000.0015,000.0020,000.000.005,000.000.73467587272000.0015,000.0020,000.000.005,000.000.51284563112000.0015,000.0020,000.000.005,000.000.81587196972000.0015,000.0020,000.000.005,000.000.367653827915050.0015,000.0015,000.001,250.001,250.000.1468297209100100.0015,000.0010,000.002,500.00-2,500.000.54091664792000.0015,000.0020,000.000.005,000.000.1700310662100100.0015,000.0010,000.002,500.00-2,500.000.76956945282000.0015,000.0020,000.000.005,000.000.903336782000.0015,000.0020,000.000.005,000.000.1497530529100100.0015,000.0010,000.002,500.00-2,500.000.54699848462000.0015,000.0020,000.000.005,000.000.363696311515050.0015,000.0015,000.001,250.001,250.000.1701063232100100.0015,000.0010,000.002,500.00-2,500.000.72711581242000.0015,000.0020,000.000.005,000.000.9541002862000.0015,000.0020,000.000.005,000.000.0728711963100100.0015,000.0010,000.002,500.00-2,500.000.428672212515050.0015,000.0015,000.001,250.001,250.000.84420364842000.0015,000.0020,000.000.005,000.000.1350637213100100.0015,000.0010,000.002,500.00-2,500.000.62057275942000.0015,000.0020,000.000.005,000.000.65178630842000.0015,000.0020,000.000.005,000.000.76878653372000.0015,000.0020,000.000.005,000.000.92538246122000.0015,000.0020,000.000.005,000.000.94719701372000.0015,000.0020,000.000.005,000.000.344273999715050.0015,000.0015,000.001,250.001,250.000.1013521714100100.0015,000.0010,000.002,500.00-2,500.000.61558288462000.0015,000.0020,000.000.005,000.000.8535578732000.0015,000.0020,000.000.005,000.00

EJERCICIO 3DistribucionMedia (min)Desv. Est. (min)Servidor 1Servidor 2Totalservidor mas rapidoServidor 1Normal203.422.220.522.22Servidor 2Normal222.621.218.221.2220.920.620.92FrecuenciaPorcentaje25.818.925.82Total iteraciones98100.00%19.018.319.02S1 + rapido5657.14%22.425.425.41S2 + rapido4242.86%24.121.124.1213.820.120.11Tiempo Medio23.0Minutos24.920.124.92Desv. Est.2.5Minutos11.314.814.8195% para total esperado22.623.525.325.425.4126.623.026.6218.523.023.0121.222.322.3124.820.024.8218.920.720.7119.920.020.0122.021.622.0214.326.826.8126.123.426.1220.321.621.6124.219.624.2215.618.818.8118.521.021.0122.121.222.1216.125.125.1124.722.724.7225.521.425.5221.319.721.3216.823.923.9114.826.726.7118.324.424.4122.220.122.2221.620.121.6224.625.625.6117.820.220.2124.123.624.1220.225.025.0116.622.522.5126.720.426.7220.720.120.7219.221.021.0122.422.422.4123.125.225.2115.323.523.5123.218.723.2218.125.525.5124.423.524.4215.221.221.2118.520.220.2114.320.720.7117.524.124.1121.517.121.5220.719.720.7223.926.426.4123.222.623.2220.919.920.9219.124.224.2122.916.922.9214.423.223.2120.221.521.5114.321.021.0117.226.526.5126.220.926.2225.424.225.4217.223.723.7123.825.025.0131.917.331.9224.223.124.2218.317.618.3220.022.022.0122.119.622.1215.421.921.9116.622.122.1122.421.122.4214.622.722.7122.720.522.7221.124.724.7115.818.118.1122.615.722.6213.626.126.1118.723.723.7121.921.221.9218.423.223.2119.021.521.5119.621.421.4116.624.824.8122.917.122.9221.323.123.1114.423.823.8114.222.322.3121.522.822.8120.824.624.6116.018.618.6119.819.619.8220.428.228.2123.120.523.1223.521.023.52

EJERCICIO 4Flujo EneroFlujo FebreroFlujo MarzoCapital inicial250EurosEntrantesalienteNetoEntrantesalienteNetoEntrantesalienteNeto518.50494.77273.73526.01490.44309.30567.76399.92477.14Flujo de caja EneroDistribucionMediaDesv. Est.376.75393.68233.07251.55131.75352.87372.45104.01621.31EntranteNormal500125502.02500.93251.09856.67501.02606.741,245.44460.181,392.01SalienteNormal400100449.36373.37325.99455.76468.28313.47493.63423.90383.20449.15561.37137.78381.96506.5113.23340.04414.67-61.40336.49463.14123.35267.44391.97-1.17254.05406.24-153.37419.07455.48213.59288.08268.06233.62207.45267.64173.42Iteraciones98570.86357.71463.15538.01261.78739.38619.57293.641,065.31Flujo final Max1,861.77Euros457.81409.89297.92386.11626.5357.49242.001,032.03-732.54Flujo final Min-760.54Euros483.62430.10303.52422.56399.55326.53375.88299.66402.75Capital final esperado518.69Euros475.13476.16248.97647.82338.81557.99655.80471.44742.35IC 95%410.31301.16379.76171.41381.22448.94103.68366.00404.5465.14452.10453.15248.95588.21639.46197.70529.82596.96130.57515.38630.52134.87368.46705.07-201.74287.59766.58-680.72575.85442.70383.15729.38365.48747.04401.58382.24766.38600.60338.41512.18741.44353.81899.81760.85336.341,324.32461.43466.74244.69310.22430.61124.30353.17578.10-100.62498.02540.86207.16595.99580.85222.31608.78603.24227.84622.16376.31495.85447.23455.34487.74419.94616.47291.20525.96534.01241.95748.33463.81526.48837.62723.69640.41503.49527.56225.92413.67561.9377.67285.29362.600.36550.97196.76604.21753.33167.891,189.65584.05217.681,556.02433.71460.73222.98506.22431.18298.02571.86574.98294.90189.28363.1576.12192.93392.85-123.79233.09351.47-242.18682.55579.18353.37630.98693.49290.86590.17565.40315.63431.96422.28259.68614.01474.88398.81645.22233.24810.79410.00156.27503.73244.46189.37558.82264.17122.49700.50632.59447.04435.54573.65440.01569.18509.08399.97678.29508.62501.11257.51454.45638.9173.05443.27545.58-29.26516.02364.06401.96583.39324.71660.64636.04242.861,053.82534.06380.46403.59662.35383.39682.55518.29247.01953.84660.07422.38487.68847.11426.17908.62978.13344.751,542.00513.80317.36446.44507.52444.87509.10462.02441.51529.61407.49284.21373.28469.64365.56477.37507.13319.24665.25529.53523.24256.29412.89586.8182.38537.94665.90-45.58234.90356.75128.15273.87224.79177.23362.77191.19348.81471.39482.25239.14448.33466.16221.30459.53255.53425.30506.82372.10384.72543.94620.56308.10557.35659.79205.66373.60313.57310.04486.62253.35543.31446.76257.41732.66390.26412.00228.26261.50363.32126.45288.94293.91121.47682.41392.50539.90337.97528.22349.66330.88414.16266.38500.00330.93419.07505.92253.74671.26593.60259.401,005.45560.01487.97322.04492.46572.84241.67741.51601.60381.58494.93350.71394.22543.61329.43608.40450.06322.90735.56352.42427.19175.24291.47451.2915.41261.67586.12-309.04571.68373.40448.28566.25506.97507.56469.57663.60313.53412.47399.43263.04441.86356.56348.34356.24319.83384.75549.86441.47358.391,030.12493.54894.97870.68516.121,249.53527.34312.17465.16333.52245.73552.96487.33187.89852.40434.14522.13162.01376.43619.97-81.53393.951,072.96-760.54442.42104.53587.88192.5386.46693.95174.7980.71788.03465.49381.68333.81426.97249.52511.26466.17341.24636.19542.41513.96278.44576.06288.42566.09811.75224.761,153.07487.62350.02387.60315.89368.93334.57319.49662.34-8.28697.05440.74506.32710.24386.80829.76848.33539.231,138.86728.58471.68506.90739.53493.78752.65680.59574.69858.56415.21442.21223.00487.56603.50107.06326.43778.14-344.65361.75438.52173.23402.60415.20160.63303.73208.63255.73287.80605.97-68.17460.64533.80-141.33468.88389.86-62.32554.77260.93543.84625.13291.40877.56173.06381.97668.64401.83413.38238.45493.64415.54316.56433.37678.7971.14416.19383.25282.94430.00201.45511.49342.24227.12626.60516.48431.95334.53417.94284.12468.35444.65346.89566.11484.31375.69358.62717.78210.44865.95894.69272.731,487.92723.69532.32441.37827.42642.74626.05746.69505.15867.59721.75436.99534.76782.14397.60919.30235.15375.82778.62543.13489.42303.70467.35531.66239.40555.14543.14251.40710.93424.20536.74516.63393.43659.94574.26359.14875.07316.09322.16243.93248.10424.7467.30209.92440.92-163.71528.99559.82219.17471.17483.09207.25422.82597.9332.15553.35399.18404.17645.37305.61743.94610.40293.691,060.65421.22368.18303.03526.11383.11446.03616.54508.21554.36634.77418.60466.16370.40451.91384.66434.44435.79383.31619.43393.89475.54837.09533.36779.27725.49579.95924.81459.93288.57421.36425.17283.47563.06191.05264.85489.26525.31523.58251.73531.30399.97383.06513.50512.17384.38548.16487.15311.01482.01413.88379.13446.11407.34417.90555.67213.03592.64690.66126.161,157.14662.71143.221,676.63377.75375.30252.45423.14394.28281.32502.85575.87208.30362.34475.53136.81358.70359.41136.10604.15319.09421.15491.50512.60228.90410.53576.4263.01388.35625.14-173.79425.78330.27345.51449.91353.46441.96325.20344.72422.44463.98256.76457.23388.17195.53649.86570.68116.051,104.49337.59519.9267.68503.84461.76109.75606.15534.91180.99387.80518.27119.53442.45499.8462.15326.98725.82-336.69612.43410.84451.59765.31237.79979.10777.80173.221,583.69498.48521.43227.06597.43691.46133.02627.82654.69106.16731.39402.80578.59688.23498.14768.68967.05247.241,488.49464.44364.82349.62473.85390.79432.69673.92412.63693.98713.37365.40597.97860.81306.981,151.80900.40190.431,861.77422.33153.46518.86510.36177.07852.15521.29153.591,219.86538.64645.49143.14857.56577.66423.05711.00492.00642.05559.98403.83406.15626.45639.90392.71617.31547.30462.72652.11455.68446.43842.83290.79998.46797.37281.341,514.49559.09491.10317.99650.78372.63596.13455.74517.15534.72735.53496.44489.09669.35567.66590.78643.81588.87645.72312.32466.6595.67402.10330.27167.51438.74359.18247.07406.85293.02363.83277.65354.11287.38283.60647.31-76.34