diagramade caja y tendencias

Base 1. CompaiaNumero de empleadoCargoTiene asig. FamSueldoHoras extrasCosto por horaHoras extras al 25%BonosTotal de ImgresoSistema de pensiones1Contador generalNo$ 1,550.0012.00$ 6.46$ 96.88$ 54.25$ 1,701.130Profuturo2Asistente logsticoSi$ 1,500.0010.00$ 6.25$ 78.13$ 52.50$ 1,630.630Integra3SoldadorNo$ 1,239.008.00$ 5.16$ 51.63$ 43.37$ 1,333.995Integra4SoldadorNo$ 2,700.0015.00$ 11.25$ 210.94$ 94.50$ 3,005.440Horizonte5TorneroSi$ 1,300.008.00$ 5.42$ 54.17$ 45.50$ 1,399.670Integra6Contador generalSi$ 1,000.005.00$ 4.17$ 26.04$ 35.00$ 1,061.040Integra7Asistente logsticoSi$ 1,038.003.00$ 4.33$ 16.20$ 36.33$ 1,090.530Horizonte8SoldadorNo$ 1,000.005.00$ 4.17$ 26.04$ 35.00$ 1,061.040Integra9SoldadorNo$ 800.002.00$ 3.33$ 8.33$ 28.00$ 836.330Prima10TorneroSi$ 1,000.006.00$ 4.17$ 31.25$ 35.00$ 1,066.250Integra11Contador generalNo$ 900.004.00$ 3.75$ 18.75$ 31.50$ 950.250Prima12Asistente logsticoNo$ 1,260.005.00$ 5.25$ 32.81$ 44.10$ 1,336.910Integra13TorneroNo$ 1,495.0012.00$ 6.23$ 93.44$ 52.33$ 1,640.765Integra14TorneroSi$ 2,100.0010.00$ 8.75$ 109.38$ 73.50$ 2,282.880Prima15TorneroSi$ 1,836.0010.00$ 7.65$ 95.63$ 64.26$ 1,995.890Prima16Asistente logsticoNo$ 1,300.008.00$ 5.00$ 50.00$ 42.00$ 1,392.000Integra17Asistente logsticoNo$ 900.006.00$ 8.75$ 28.18$ 33.50$ 961.680Integra18TorneroSi$ 1,400.0014.00$ 5.83$ 102.08$ 49.00$ 1,551.080Integra19Contador generalNo$ 1,500.004.00$ 5.25$ 31.25$ 52.50$ 1,583.750Integra20Contador generalSi$ 1,200.004.00$ 4.58$ 22.92$ 38.50$ 1,261.420Integra21Asistente logsticoSi$ 1,000.004.00$ 4.17$ 20.83$ 35.00$ 1,055.830Horizonte22SoldadorSi$ 845.000.00$ 3.52$ 0.00$ 29.58$ 874.575Prima23SoldadorSi$ 1,100.004.00$ 4.58$ 22.92$ 38.50$ 1,161.420Integra24TorneroNo$ 1,436.006.00$ 5.98$ 44.88$ 50.26$ 1,531.140Profuturo25Contador generalNo$ 2,000.0015.00$ 8.33$ 156.25$ 70.00$ 2,226.250Integra26Asistente logsticoNo$ 2,500.006.00$ 10.42$ 78.13$ 87.50$ 2,665.630Prima27SoldadorSi$ 1,000.008.00$ 4.17$ 41.67$ 35.00$ 1,076.670Prima28SoldadorNo$ 1,724.009.00$ 7.18$ 80.81$ 60.34$ 1,865.150Prima29TorneroSi$ 1,300.0011.00$ 5.42$ 74.48$ 45.50$ 1,419.980Profuturo30Contador generalNo$ 1,724.008.00$ 7.18$ 71.83$ 60.34$ 1,856.170Prima31Asistente logsticoSi$ 1,489.009.00$ 6.20$ 69.80$ 52.12$ 1,610.915Horizonte32SoldadorSi$ 1,836.007.00$ 7.65$ 64.94$ 64.26$ 1,965.200Horizonte33Asistente logsticoNo$ 1,375.007.00$ 5.73$ 50.13$ 48.13$ 1,473.255Onp34Contador generalNo$ 2,634.007.00$ 10.98$ 96.03$ 92.19$ 2,822.220Prima35Asistente logsticoNo$ 1,494.007.00$ 6.23$ 54.47$ 52.29$ 1,600.760Prima36SoldadorNo$ 1,100.0016.00$ 4.58$ 91.67$ 58.50$ 1,250.170Horizonte37Asistente logsticoNo$ 1,200.004.00$ 5.00$ 25.00$ 42.00$ 1,267.000Prima38TorneroSi$ 1,400.006.00$ 5.83$ 43.75$ 49.00$ 1,492.750Prima39Contador generalSi$ 1,456.007.00$ 5.98$ 52.35$ 50.26$ 1,558.610Prima

Resultado del examen de salud

EdadEstaturaPesoCinturaPulsoPresin SistlicaColesterolndice de masa corporal5870.8169.190.66812552223.82266.2144.278.16410712723.2EdadAos3271.7179.396.58812674024.6EstaturaPulgadas3168.7175.887.7721104926.2PesoLibras2867.6152.687.16411023023.5CinturaCentmetros4669.2166.892.47210731624.5PulsoLatidos por minuto4166.5135.278.86011359021.5Presi SistlicammHg5667.2201.5103.38812646631.4ColesterolMiligramos2068.3175.289.17613712126.4ndice de masa corporalAdimensional5465.6139.182.56011057822.71763.1156.386.7961097827.87368.3186.6103.37215326528.15273.1191.191.85611225025.22567.6151.375.66411926523.32968.1209.4105.56011327331.91771.1237.1108.76412527233.14161.3176.7104.18413197233.25276.2220.6103.1761217526.73266.3166.191.38413213826.62069.7137.475.28811213919.92065.4164.287.77212163827.12970.1162.477.15611661323.41862.9151.885.16895762272668.5144.179.66411030321.63368.3204.6103.86011069030.95569.4193.8103681253128.35369.2172.997.16012418925.52868161.986.96013195724.62871.9174.8885610933923.83766.1169.891.58411241627.4a) La tabla estadistica sin clase para las variables "Peso" y "Colesterol"PesoFrecuecia AbsolutaFrecuencia Absoluta AcumuladaFrecuencia Relativa Frecuencia Relativa AcumuladaFrecuencia PorcentualFrecuencia Porcentual Acumulada 135.2110.030.033.333.33137.4120.030.073.336.67139.1130.030.103.3310.00144.1140.030.133.3313.33144.2150.030.173.3316.67151.3160.030.203.3320.00151.8170.030.233.3323.33152.6180.030.273.3326.67156.3190.030.303.3330.00161.91100.030.333.3333.33162.41110.030.373.3336.67164.21120.030.403.3340.00166.11130.030.433.3343.33166.81140.030.473.3346.67169.11150.030.503.3350.00169.81160.030.533.3353.33172.91170.030.573.3356.67174.81180.030.603.3360.00175.21190.030.633.3363.33175.81200.030.673.3366.67176.71210.030.703.3370.00179.31220.030.733.3373.33186.61230.030.773.3376.67191.11240.030.803.3380.00193.81250.030.833.3383.33201.51260.030.873.3386.67204.61270.030.903.3390.00209.41280.030.933.3393.33220.61290.030.973.3396.67237.11300.031.003.33100.00N =301.00100.00ColesterolFrecuecia AbsolutaFrecuencia Absoluta AcumuladaFrecuencia Relativa Frecuencia Relativa AcumuladaFrecuencia PorcentualFrecuencia Porcentual Acumulada 31110.030.033.333.3349120.030.073.336.6775130.030.103.3310.0078140.030.133.3313.33121150.030.173.3316.67127160.030.203.3320.00138170.030.233.3323.33139180.030.273.3326.67189190.030.303.3330.002301100.030.333.3333.332501110.030.373.3336.672651120.030.403.3340.002651130.030.433.3343.332721140.030.473.3346.672731150.030.503.3350.003031160.030.533.3353.333161170.030.573.3356.673391180.030.603.3360.004161190.030.633.3363.334661200.030.673.3366.675221210.030.703.3370.005781220.030.733.3373.335901230.030.773.3376.676131240.030.803.3380.006381250.030.833.3383.336901260.030.873.3386.677401270.030.903.3390.007621280.030.933.3393.339571290.030.973.3396.679721300.031.003.33100.00N =301.00100.00b) Qu porcentaje de hombres, tienen una presin sistlica superior a 119?Presin SistlicaPresin SistlicaFrecuencia AbsolutaFrecuencia Porcentual959513.3310710726.6710710926.67109110516.67109112310.0011011326.6711011613.3311011913.3311012126.6711012413.33112125310.0011212626.6711213126.6711313213.3311313713.3311615313.3311930100121121PORCENTAJE124RESPUESTA43.33125125Adems se lo puede realizar con una regla de tres1251263010012613x131131Despejando X tenemos el siguiente resultado:13213743.33153c) Cuntos hombres tienen una edad inferior a 25 aos?EdadEdadFrecuencia Absoluta1717217181182032022120251202612228325292263112832228331283712941229461315223253132541335513756141581417314630525253RESPUESTA7HOMBRES5455565873d) Qu proporcin de hombres tienen al menos 64 pulsaciones?PulsoPulsoFrecuencia AbsolutaFrecuencia Relativa565630.10566060.20566450.17606830.10607240.13607620.07608430.10608830.10609610.0364301.006464RESPUESTA0.70HOMBRES646468686872727272767684848488888896e) Qu proporcin de personas tienen una presin sistlica entre 95 y 112?Presin SistlicaPresin SistlicaFrecuencia AbsolutaFrecuencia Relativa959510.0310710720.0710710920.0710911050.1710911230.1011011320.0711011610.0311011910.0311012120.0711012410.0311212530.1011212620.0711213120.0711313210.0311313710.0311615310.03119301121121PERSONAS124RESPUESTA0.43125125125126126131131132137153f) Qu porcentaje de personas tienen una edad menor a 31 aos o a lo menos de 46 aos?EdadEdadFrecuencia AbsolutaFrecuencia RelativaFrecuencia Porcentual171720.06676.67171810.03333.33182030.100010.00202210.03333.33202510.03333.33202610.03333.33222830.100010.00252920.06676.67263110.03333.33283220.06676.67283310.03333.33283710.03333.33294120.06676.67294610.03333.33315220.06676.67325310.03333.33325410.03333.33335510.03333.33375610.03333.33415810.03333.33417310.03333.3346N =301.00100.005252RESPUESTAS:PORCENTAJE53PORCENTAJE MENOR A 31 AOS46.6754PORCENTAJE AL MENOS DE 46 AOS30.0055TOTAL76.67565873g) Cuntas personas tienen un colesterol de al menos 522?ColesterolColesterolFrecuencia Absoluta313114949175751787811211211127127113813811391391189189123023012502501265265226527212722731273303130331613163391339416141646614665221522578157859015906131613638163869016907401740762176295719579721972N =30PERSONASRESPUESTA 10H) Qu proporcin de hombres tienen una cintura cuya medida es inferior a 78,8 cm o superior a 88,0 cmCinturaCinturaFrecuencia AbsolutaFrecuencia Relativa75.275.210.03375.675.610.03377.177.110.03378.178.110.03378.878.810.03379.679.610.03382.582.510.03385.185.110.03386.786.710.03386.986.910.03387.187.110.03387.787.720.06787.78810.0338889.110.03389.190.610.03390.691.310.03391.391.510.03391.591.810.03391.892.410.03392.496.510.03396.597.110.03397.110310.033103103.110.033103.1103.320.067103.3103.810.033103.3104.110.033103.8105.510.033104.1108.710.033105.5N =301.00108.7RESPUESTAS:PROPORCIONINFERIOR A 78,8 CM =0.133SUPERIOR A 88 CM =0.533TOTAL PROPORCION0.667i) Qu proporcin de las personas tienen un pulso mayor a 60 pero menor a 84?PulsoPulsoFrecuencia AbsolutaFrecuencia Relativa565630.10566060.20566450.17606830.10607240.13607620.07608430.10608830.10609610.0364306464PROPORCION64RESPUESTA0.476468686872727272767684848488888896J) Cuntos hombres tienen un indice corporal como mximo de 23,5 o como mnimo de 27,0.ndice de masa corporalndice de masa corporalFrecuencia Absoluta19.919.9121.521.5121.621.6122.722.7123.223.2123.323.3123.423.4123.523.5123.823.8223.824.5124.524.6224.625.2124.625.5125.226.2125.526.4126.226.6126.426.7126.627126.727.112727.4127.127.8127.428.1127.828.3128.130.9128.331.4130.931.9131.433.1131.933.2133.1N =3033.2RESPUESTAS:No. HOMBRESCOMO MAXIMO DE 23,5 =8COMO MINIMOS DE 27 =11TOTAL HOMBRES19k) Para cada variable determine las medidas de tendencia central, la variabilidad y de formaEdadEstaturaPesoCinturaPulsoPresin SistlicaColesterolndice de masa corporal1761.3135.275.256953119.91762.9137.475.6561074921.5101.5251863.1139.177.1561077521.62065.4144.178.1601097822.72065.6144.278.86010912123.22066.1151.379.66011012723.32266.2151.882.56011013823.42566.3152.685.16011013923.52666.5156.386.76011018923.82867.2161.986.96411023023.82867.6162.487.16411225024.52867.6164.287.76411226524.62968166.187.76411226524.62968.1166.8886411327225.23168.3169.189.16811327325.53268.3169.890.66811630326.23268.3172.991.36811931626.43368.5174.891.57212133926.63768.7175.291.87212141626.74169.2175.892.472124466274169.2176.796.57212552227.14669.4179.397.17612557827.45269.7186.61037612559027.85270.1191.1103.18412661328.15370.8193.8103.38412663828.35471.1201.5103.38413169030.95571.7204.6103.88813174031.45671.9209.4104.18813276231.95873.1220.6105.58813795733.17376.2237.1108.79615397233.2Sumatoria=10732046.45171.72731.22104355111404783.2EDADEdad (X)Frecuencia Absoluta (fi)Frecuencia Acumulada (FI) (F * X) Posicin172234-18.77352.31MODO O MODA181318-17.77315.77LA MODA O MODO DE ESTE EJERCICIO ES BIMODAL PORQUE EXISTEN DOS VALORES203660-15.77248.69QUE SE REPITEN Y SON LAS FRECUENCIAS MAS ALTA.221722-13.77189.61251825-10.77115.99261926-9.7795.452831284-7.7760.372921458-6.7745.83311153115-4.7722.75MEDIANA3221764-3.7714.21DESPUES DEL ORDENAMIENTO PRIMERO SE CALCULA 331183335.77-2.777.67 LA POSICION (N/2) 37119371.231.5141221825.2327.35461224610.23104.655222410416.23263.41531255317.23296.87541265418.23332.33551275519.23369.79561285620.23409.25MEDIA ARITMETICA581295822.23494.17731307337.231386.07N =3010735154.11

ASIMETRIA POSITIVASESGO A LA DERECHA (+)

VARIANZA

DESVIACION TIPICA

COEFICIENTE DE VARIACION

ESTATURAESTATURA (X)Frecuencia Absoluta (fi)Frecuencia Acumulada (FI) (F * X) Posicin61.31161.3-6.9147.75MODO O MODA62.91262.9-5.3128.20LA MODA O MODO DE ESTE EJERCICIO ES UNIMODAL PORQUE EXISTE UN SOLO VALOR63.11363.1-5.1126.1165.41465.4-2.817.9065.61565.6-2.616.8166.11666.1-2.114.4566.21766.2-2.014.0466.31866.3-1.913.6566.51966.5-1.712.92MEDIANA67.211067.2-1.011.02DESPUES DEL ORDENAMIENTO PRIMERO SE CALCULA 67.6212135.2-0.610.37 LA POSICION (N/2) 6811368-0.210.0468.111468.11568.21-0.110.0168.3317204.90.090.0168.511868.50.290.0868.711968.70.490.2469.2221138.40.990.9869.412269.41.191.4269.712369.71.492.22MEDIA ARITMETICA70.112470.11.893.5770.812570.82.596.7171.112671.12.898.3571.712771.73.4912.1871.912871.93.6913.6273.112973.14.8923.9176.213076.27.9963.84N =302046.4270.41

ASIMETRIA NEGATIVAVARIANZA

DESVIACION TIPICAEL MODO Y MEDIANA COINCIDEN


PESOPESO (X)Frecuencia Absoluta (fi)Frecuencia Acumulada (FI) (F * X) Posicin135.211135.2-37.191383.10MODO O MODA137.412137.4-34.991224.30139.113139.1-33.291108.22NO EXISTE MODO PORQUE NINGUN DATO SE REPITE 144.114144.1-28.29800.32144.215144.2-28.19794.68151.316151.3-21.09444.79151.817151.8-20.59423.95152.618152.6-19.79391.64156.319156.3-16.09258.89MEDIANA161.9110161.9-10.49110.04DESPUES DEL ORDENAMIENTO PRIMERO SE CALCULA 162.4111162.4-9.9999.80 LA POSICION (N+1/2) 164.2112164.2-8.1967.08166.1113166.1-6.2939.56166.8114166.8-5.5931.25169.1115169.115-3.2910.82169.8116169.8172.39-2.596.71172.9117172.90.510.26174.8118174.82.415.81175.2119175.22.817.90MEDIA ARITMETICA175.8120175.83.4111.63176.7121176.74.3118.58179.3122179.36.9147.75186.6123186.614.21201.92191.1124191.118.71350.06193.8125193.821.41458.39201.5126201.529.11847.39204.6127204.632.211037.48209.4128209.437.011369.74220.6129220.648.212324.20237.1130237.164.714187.38N =305171.718063.65

NO EXISTE ASIMETRIA VARIANZA

DESVIACION TIPICA


CINTURACINTURA (X)Frecuencia Absoluta (fi)Frecuencia Acumulada (FI) (F * X) Posicin75.21175.2-15.84250.91MODO O MODA75.61275.6-15.44238.3977.11377.1-13.94194.32EXISTEN 2 VALORES QUE MAS SE REPITE Y EXISTE UNA BIMODAL78.11478.1-12.94167.4478.81578.8-12.24149.8279.61679.6-11.44130.8782.51782.5-8.5472.9385.11885.1-5.9435.2886.71986.7-4.3418.84MEDIANA86.911086.9-4.1417.14DESPUES DEL ORDENAMIENTO PRIMERO SE CALCULA 87.111187.1-3.9415.52 LA POSICION (N/2) 87.7213175.4-3.3411.168811488-3.049.2489.111589.115-1.943.7690.611690.691.04-0.440.1991.311791.30.260.0791.511891.50.460.2191.811991.80.760.5892.412092.41.361.85MEDIA ARITMETICA96.512196.55.4629.8197.112297.16.0636.7210312310311.96143.04103.1124103.112.06145.44103.3226206.612.26150.31103.8127103.812.76162.82104.1128104.113.06170.56105.5129105.514.46209.09108.7130108.717.66311.88N =302731.22678.21

ASIMETRIA POSITIVASESGO A LA DERECHA (+)POSICION =30/2VARIANZA15

DESVIACION TIPICA


PULSOPULSO (X)Frecuencia Absoluta (fi)Frecuencia Acumulada (FI) (F * X) Posicin5633168-14.13199.66MODO O MODA6069360-10.13102.626451432015-6.1337.58EXISTE 1 VALOR QUE MAS SE REPITE Y ES UNIMODAL6831720470.13-2.134.54724212881.873.50762231525.8734.468432625213.87192.388832926417.87319.34961309625.87669.26MEDIANAN =3021041563.31DESPUES DEL ORDENAMIENTO PRIMERO SE CALCULA LA POSICION (N/2)


MEDIA ARITMETICA

VARIANZA

DESVIACION TIPICA


PRESION SISTOLICAPRESION SISTOLICA (X)Frecuencia Absoluta (fi)Frecuencia Acumulada (FI) (F * X) Posicin951195-23.37546.16MODO O MODA10723214-11.37129.2810925218-9.3787.80EXISTE 1 VALOR QUE MAS SE REPITE Y ES UNIMODAL110510550-8.3770.06112313336-6.3740.5811321522615-5.3728.84116116116118.37-2.375.621191171190.630.401212192422.636.921241201245.6331.70MEDIANA1253233756.6343.96DESPUES DEL ORDENAMIENTO PRIMERO SE CALCULA 1262252527.6358.22 LA POSICION (N/2) 13122726212.63159.5213212813213.63185.7813712913718.63347.0815313015334.631199.24

N =3035512941.11

MEDIA ARITMETICA


VARIANZA

DESVIACION TIPICA


COLESTEROLCOLESTEROL (X)Frecuencia Absoluta (fi)Frecuencia Acumulada (FI) (F * X) Posicin311131-349.13121891.76MODO O MODA491249-331.13109647.08751375-305.1393104.32EXISTE 1 VALOR QUE MAS SE REPITE Y ES UNIMODAL781478-302.1391282.5412115121-259.1367148.3612716127-253.1364074.8013817138-242.1358626.9413918139-241.1358143.6818919189-191.1336530.68230110230-150.1322539.02MEDIANA250111250-130.1316933.82DESPUES DEL ORDENAMIENTO SE OBTUVO 21 DATOS, EN DONDE PRIMERO SE CALCULA 265213530-115.1313254.92 LA POSICION (N/2) 272114272-108.1311692.1027311527315-107.1311476.84303116303-77.135949.04316117316-64.134112.66339118339380.13-41.131691.6841611941635.871286.6646612046685.877373.66522121522141.8720127.10578122578197.8739152.54MEDIA ARITMETICA590123590209.8744045.42613124613232.8754228.44638125638257.8766496.94690126690309.8796019.42740127740359.87129506.42762128762381.87145824.70957129957576.87332779.00972130972591.87350310.10N =30114042075250.55

VARIANZA


DESVIACION TIPICA


INDICE DE MASA CORPORALINDICE DE MASA CORPORAL (X)Frecuencia Absoluta (fi)Frecuencia Acumulada (FI) (F * X) Posicin19.91119.9-6.2138.56MODO O MODA21.51221.5-4.6121.2521.61321.6-4.5120.34VALOR QUE MAS SE REPITE Y EXISTE UNA BIMODAL22.71422.7-3.4111.6323.21523.2-2.918.4723.31623.3-2.817.9023.41723.4-2.717.3423.51823.5-2.616.8123.821047.6-2.315.3424.511124.5-1.612.59MEDIANA24.621349.2-1.512.28DESPUES DEL ORDENAMIENTO PRIMERO SE CALCULA 25.211425.2-0.910.83 LA POSICION (N/2) 25.511525.51526.11-0.610.3726.211626.20.090.0126.411726.40.290.0826.611826.60.490.2426.711926.70.590.3527120270.890.7927.112127.10.990.9827.412227.41.291.6627.812327.81.692.86MEDIA ARITMETICA28.112428.11.993.9628.312528.32.194.8030.912630.94.7922.9431.412731.45.2927.9831.912831.95.7933.5233.112933.16.9948.8633.213033.27.0950.27

N =30783.2333.02

VARIANZA


DESVIACION TIPICA


L) Cul de las tiene un menor grado de homogeneidad? ExpliqueDe los datos de las variables como son la Edad, Estatura, Peso, Cintura, Pulso, Presion Sistlica, Colesterol, Indice de masa corporal , al momento de aplicar el coeficiente de variacion el cual nos permitir medir el porcentaje de variacin; se obtuvo que el 69,19% corresponde a la variable del colesterol y es la menoshomogenia por tener un resultado demasiado alto , a continuacion se detalla los resultados obtenidos:

VARIABLESCOEF. VARIACEdad36.62Estatura4.4Peso14.24Cintura10.38Pulso10.3Presin Sisitlica8.36Colesterol69.19Indice masa corporal12.75

m) Dibuje el diagrama de cajas para las variables cintura y pulso

CINTURA

CinturaFrecuencia Absoluta (fi)Frecuencia Acumulada (FI)CUARTIL 1N = 3075.21175.612N/4 7.577.1137.578.11478.81579.61682.517Q185.118CUARTIL 286.719Es la mediana86.91101587.111187.72138811489.1115Q2 = Me90.611691.311791.511891.8119CUARTIL 3N = 3092.412022.596.5121(3*N)/497.112222.5Q3103123103.1124103.3226103.8127104.1128DATOS105.5129Valor Mnimo75.2108.7130Q185.1404550556065707580859095100105N= 30Q2 = Me89.85Q3103Me= 68Valor Mximo108.7XminXmax56Q1 = 60Q3=769625%50%75%PULSOPULSO (X)Frecuencia Absoluta (fi)Frecuencia Acumulada (FI)5633CUARTIL 1N = 30Q1606964514N/4 7.5Q2=Me683177.572421Q376223843268832996130CUARTIL 2N =30Es la mediana1515

CUARTIL 3N = 3022.5(3*N)/422.5

DATOSValor Mnimo56Q160Q2 = Me68Q376Valor Mximo96

MODO1MODO 2MEDIANAMEDIANAMODOMEDIAMEDIANAMEDIAMEDIANAMODAMODAMEDIAMEDIANAMODAMEDIAMEDIANAMODAMEDIAMEDIANAMEDIAMODOMEDIANAMEDIAMODO1MODO2MEDIA

Hoja2

EdadEstaturaPesoCinturaPulsoPresin SistlicaColesterolndice de masa corporal5870.8169.190.66812552223.82266.2144.278.16410712723.23271.7179.396.58812674024.63168.7175.887.7721104926.22867.6152.687.16411023023.54669.2166.892.47210731624.54166.5135.278.86011359021.55667.2201.5103.38812646631.42068.3175.289.17613712126.45465.6139.182.56011057822.71763.1156.386.7961097827.87368.3186.6103.37215326528.15273.1191.191.85611225025.22567.6151.375.66411926523.32968.1209.4105.56011327331.91771.1237.1108.76412527233.14161.3176.7104.18413197233.25276.2220.6103.1761217526.73266.3166.191.38413213826.62069.7137.475.28811213919.92065.4164.287.77212163827.12970.1162.477.15611661323.41862.9151.885.16895762272668.5144.179.66411030321.63368.3204.6103.86011069030.95569.4193.8103681253128.35369.2172.997.16012418925.52868161.986.96013195724.62871.9174.8885610933923.83766.1169.891.58411241627.4EdadAosEstaturaPulgadasPesoLibrasCinturaCentmetrosPulsoLatidos por minutoPresi SistlicammHgColesterolMiligramosndice de masa corporalAdimensionala) La tabla estadistica sin clase para las variables "Peso" y "Colesterol"PesoFrecuecia AbsolutaFrecuencia Absoluta AcumuladaFrecuencia Relativa Frecuencia Relativa AcumuladaFrecuencia PorcentualFrecuencia Porcentual Acumulada 135.2110.010.010.540.54137.4120.010.010.541.07139.1130.010.020.541.61144.1140.010.020.542.14144.2150.010.030.542.68151.3160.010.030.543.22151.8170.010.040.543.75152.6180.010.040.544.29156.3190.010.050.544.82161.91100.010.050.545.36162.41110.010.060.545.89164.21120.010.060.546.43166.11130.010.070.546.97166.81140.010.080.547.50169.11150.010.080.548.04169.81160.010.090.548.57172.91170.010.090.549.11174.81180.010.100.549.65175.21190.010.100.5410.18175.81200.010.110.5410.72176.71210.010.110.5411.25179.31220.010.120.5411.79186.61230.010.120.5412.33191.11240.010.130.5412.86193.81250.010.130.5413.40201.51260.010.140.5413.93204.61270.010.140.5414.47209.41280.010.150.5415.01220.61290.010.160.5415.54237.11300.010.160.5416.08N =300.1616.08ColesterolFrecuecia AbsolutaFrecuencia Absoluta AcumuladaFrecuencia Relativa Frecuencia Relativa AcumuladaFrecuencia PorcentualFrecuencia Porcentual Acumulada 31110.010.010.540.5449120.010.010.541.0775130.010.020.541.6178140.010.020.542.14121150.010.030.542.68127160.010.030.543.22138170.010.040.543.75139180.010.040.544.29189190.010.050.544.822301100.010.050.545.362501110.010.060.545.892651120.010.060.546.432651130.010.070.546.972721140.010.080.547.502731150.010.080.548.043031160.010.090.548.573161170.010.090.549.113391180.010.100.549.654161190.010.100.5410.184661200.010.110.5410.725221210.010.110.5411.255781220.010.120.5411.795901230.010.120.5412.336131240.010.130.5412.866381250.010.130.5413.406901260.010.140.5413.937401270.010.140.5414.477621280.010.150.5415.019571290.010.160.5415.549721300.010.160.5416.08N =300.1616.08b) Qu porcentaje de hombres, tienen una presin sistlica superior a 119?Presin SistlicaPresin SistlicaFrecuencia AbsolutaFrecuencia Porcentual95951ERROR:#DIV/0!1071072ERROR:#DIV/0!1071092ERROR:#DIV/0!1091105ERROR:#DIV/0!1091123ERROR:#DIV/0!1101132ERROR:#DIV/0!1101161ERROR:#DIV/0!1101191ERROR:#DIV/0!1101212ERROR:#DIV/0!1101241ERROR:#DIV/0!1121253ERROR:#DIV/0!1121262ERROR:#DIV/0!1121312ERROR:#DIV/0!1131321ERROR:#DIV/0!1131371ERROR:#DIV/0!1161531ERROR:#DIV/0!11930ERROR:#DIV/0!121121PORCENTAJE124RESPUESTAERROR:#DIV/0!125125Adems se lo puede realizar con una regla de tres1251263010012613x131131Despejando X tenemos el siguiente resultado:13213743.33153c) Cuntos hombres tienen una edad inferior a 25 aos?EdadEdadFrecuencia Absoluta1717217181182032022120251202612228325292263112832228331283712941229461315223253132541335513756141581417314630525253RESPUESTA7HOMBRES5455565873d) Qu proporcin de hombres tienen al menos 64 pulsaciones?PulsoPulsoFrecuencia AbsolutaFrecuencia Relativa565630.06566060.11566450.09606830.06607240.08607620.04608430.06608830.06609610.0264300.576464RESPUESTA0.40HOMBRES646468686872727272767684848488888896J) Cuntos hombres tienen un indice corporal como mximo de 23,5 o como mnimo de 27,0.ndice de masa corporalndice de masa corporalFrecuencia Absoluta19.919.9121.521.5121.621.6122.722.7123.223.2123.323.3123.423.4123.523.5123.823.8223.824.5124.524.6224.625.2124.625.5125.226.2125.526.4126.226.6126.426.7126.627126.727.112727.4127.127.8127.428.1127.828.3128.130.9128.331.4130.931.9131.433.1131.933.2133.1N =3033.2RESPUESTAS:No. HOMBRESCOMO MAXIMO DE 23,5 =8COMO MINIMOS DE 27 =11TOTAL HOMBRES19

Hoja1b) Qu porcentaje de hombres, tienen una presin sistlica superior a 119?Presin SistlicadatosFRECUENCIAFREC. RELATFREC. PORCENTUAL959510.033.3310710720.076.6710710920.076.6710911050.1716.6710911230.1010.00LA INVESTIGACION REALIZADA CONLLEVA A QUE DEL 100% DE LOS11011320.076.67DATOS ANALIZADOS EL 43,33% CORRESPONDE A LAS PERSONAS 11011610.033.33QUE TIENEN UNA PRESION CISTOLICA SUPERIOR A LOS 119, DANDO UNA ESTIMACION PROMEDIO DEL TOTAL DE LA POBLACION ANALIZADA 11011910.033.3311012120.076.6711012410.033.3311212530.1010.0011212620.076.6711213120.076.6711313210.033.3311313710.033.3311615310.033.33119N301100121RTA43.33%121124125125125126126131131132137153

Flujo de caja

Valor$ 4,000,000.00Vida til10aosCompaa AMtodo de depreciacinMtodo lnea rectaAo012345678910Utilidad Antes de Impuesto UAI$ 550,000.00$ 700,000.00$ 1,050,000.00$ 1,350,000.00$ 2,410,000.00$ 2,200,000.00$ 2,600,000.00$ 3,100,000.00$ 3,500,000.00$ 3,700,000.00Depreciacion$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00Utilizad antes de intereses e impuestos final$ 150,000.00$ 300,000.00$ 650,000.00$ 950,000.00$ 2,010,000.00$ 1,800,000.00$ 2,200,000.00$ 2,700,000.00$ 3,100,000.00$ 3,300,000.00(-)Impuesto 50%$ 75,000.00$ 325,000.00$ 475,000.00$ 1,005,000.00$ 900,000.00$ 1,100,000.00$ 1,350,000.00$ 1,550,000.00$ 1,650,000.00Utilidad despues de impuesto$ 75,000.00$ 300,000.00$ 325,000.00$ 475,000.00$ 1,005,000.00$ 900,000.00$ 1,100,000.00$ 1,350,000.00$ 1,550,000.00$ 1,650,000.00(+) Depreciacion$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00$ 400,000.00(-) Amortizacion$ 1,400,000.00$ 1,400,000.00Inversion$ (4,500,000.00)Provision$ (2,000,000.00)FLUJO DE CAJA$ (6,500,000.00)$ 475,000.00$ 700,000.00$ 725,000.00$ 875,000.00$ 5,000.00$ 1,300,000.00$ 1,500,000.00$ 1,750,000.00$ 1,950,000.00$ 650,000.00TIR7.08%

Valor$ 5,000,000.00Vida til10aosCompaa BMtodo de depreciacinMtodo lnea rectaAo012345678910Utilidad Antes de Impuesto UAI$ 450,000.00$ 650,000.00$ 1,250,000.00$ 1,800,000.00$ 2,150,000.00$ 1,900,000.00$ 2,100,000.00$ 2,800,000.00$ 3,600,000.00$ 3,800,000.00Depreciacion$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00Utilizad antes de intereses e impuestos final$ (50,000.00)$ 150,000.00$ 750,000.00$ 1,300,000.00$ 1,650,000.00$ 1,400,000.00$ 1,600,000.00$ 2,300,000.00$ 3,100,000.00$ 3,300,000.00(-)Impuesto 50%$ (25,000.00)$ 375,000.00$ 650,000.00$ 825,000.00$ 700,000.00$ 800,000.00$ 1,150,000.00$ 1,550,000.00$ 1,650,000.00Utilidad despues de impuesto$ (25,000.00)$ 150,000.00$ 375,000.00$ 650,000.00$ 825,000.00$ 700,000.00$ 800,000.00$ 1,150,000.00$ 1,550,000.00$ 1,650,000.00(+) Depreciacion$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00$ 500,000.00(-) Amortizacion$ 1,050,000.00$ 1,050,000.00Inversion$ (3,500,000.00)Provision$ (3,000,000.00)FLUJO DE CAJA$ (6,500,000.00)$ 475,000.00$ 650,000.00$ 875,000.00$ 1,150,000.00$ 275,000.00$ 1,200,000.00$ 1,300,000.00$ 600,000.00$ 2,050,000.00$ 1,100,000.00TIR6.81%LITERAL C: DIAGRAMA DE CAJAFLUJO DE CAJA COMPAA BfiFI275,000.0011DATOS475,000.0012Valor Mnimo275,000.00Q1600,000.0013Q1600,000.00650,000.0014Q2 = Me987,500.00Q2 = Me875,000.0015Q31,200,000.001,100,000.0016Valor Mximo2,050,000.001,150,000.0017Q31,200,000.0018CUARTIL 1N = 101,300,000.00192,050,000.00110N/4 2.5

CUARTIL 2N = 10Es la mediana

5

CUARTIL 3N = 10

(3*N)/47.5

Tasa de inflacin-2006 a 2014Inflacin annual20062.87%20073.32%20088.83%20062007200820092010201120122013201420094.31%fechainflacionfechainflacionfechainflacionfechainflacionfechainflacionfechainflacionfechainflacionfechainflacionfechainflacion20103.33%1/31/063.371/31/072.681/31/084.191/31/098.361/31/104.441/31/113.171/31/125.291/31/134.101/31/142.9220115.41%2/28/063.822/28/072.032/29/085.102/28/097.852/28/104.312/28/113.392/29/125.532/28/133.482/28/142.8520124.16%3/31/064.233/31/071.473/31/086.563/31/097.443/31/103.353/31/113.573/31/126.123/31/133.013/31/143.1120132.70%4/30/063.434/30/071.394/30/088.184/30/096.524/30/103.214/30/113.884/30/125.424/30/133.034/30/143.235/31/063.115/31/071.565/31/089.295/31/095.415/31/103.245/31/114.235/31/124.855/31/133.015/31/143.416/30/062.806/30/072.196/30/089.696/30/094.546/30/103.306/30/114.286/30/125.006/30/132.686/30/143.677/31/062.997/31/072.587/31/089.877/31/093.857/31/103.407/31/114.447/31/125.097/31/132.397/31/144.118/31/063.368/31/072.448/31/0810.028/31/093.338/31/103.828/31/114.848/31/124.888/31/132.278/31/144.159/30/063.219/30/072.589/30/089.979/30/093.299/30/103.449/30/115.399/30/125.229/30/131.719/30/144.1910/31/063.2110/31/072.3610/31/089.8510/31/093.5010/31/103.4610/31/115.5010/31/124.9410/31/132.0410/31/143.9811/30/063.2111/30/072.7011/30/089.1311/30/094.0211/30/103.3911/30/115.5311/30/124.7711/30/132.3011/30/143.7612/31/062.8712/31/073.3212/31/088.8312/31/094.3112/31/103.3312/31/115.4112/31/124.1612/31/132.7012/31/143.67LITERAL F2007DATOS ORDENADOSfiFIfechainflacionDATOS1/31/072.681.3911Valor Mnimo1.392/28/072.031.4712Q11.563/31/071.47Q11.5613Q2 = Me2.404/30/071.392.0314Q32.585/31/071.562.1915Valor Mximo3.326/30/072.192.36167/31/072.58Q2=Me = 2,402.4417CUARTIL 1N = 128/31/072.44Q32.58299/30/072.582.68110N/4 10/31/072.362.70111311/30/072.703.3211212/31/073.32

CUARTIL 2N = 12Es la mediana

6

CUARTIL 3N = 12

(3*N)/49

Fuente de informacin: Inflacin Anual - Banco Central del Ecuadorcontenido.bce.fin.ec/resumen_ticker.php?ticker_value=inflacion

diagramade caja y tendencias

Documents