2) ejercicios tablafreq

21
En minutos 1 3 2 10 3 5 4 9 5 2 6 6 7 3 8 9 9 7 10 9 11 6 # INTERVALOS 12 2 1 13 9 2 14 7 3 15 1 4 16 10 5 17 4 6 18 10 7 19 10 8 20 8 9 21 7 22 4 23 5 24 10 25 8 26 7 27 6 28 2 29 4 30 4 31 6 32 2 33 6 34 5 35 3 36 8 37 3 38 10 39 5 40 9 41 9 42 6 43 6 44 8

Upload: carla-yauris-solano

Post on 15-Nov-2015

238 views

Category:

Documents


0 download

DESCRIPTION

excel, modelos ciencia 2

TRANSCRIPT

tiempo entre arribosEn minutosPreguntas13N 2001Qu distribucin de probabilidad tiene la variable? 210MAX =10.002Es continua o discreta?35MIN =1.03Relacin entre la media y la desviacin estndar49MEDIA =652DESV STAN =366RANGO73N STURGES89AMPLITUD9.0097109116# INTERVALOSDESDE HASTAFREC ACUMULADAFREC ABSOLUTA12211.010.0200200139210.019.02000147319.028.02000151428.037.020001610537.046.02000174646.055.020001810755.064.020001910864.073.02000208973.082.020002172242352410Total2002582672762822943043163223363453533683733810395409419426436448453464474488499506513526533549552564576581059560561662106376456586610678682697707715726739744753767775781797801081582583284685886787688108929089110924938949951096497109899981001010131024103710431055106810791089109311010111411241135114811521164117211821199120312171229123101241012591266127412821291013091311013251335134913531361137413841399140414110142101432144101458146414741485149115081513152715391544155715661576158515971604161216210163816421658166616751683169317091716172617341746175917611779178101799180518171823183818491854186418781885189219031911019210193119441953196219771981019942005

tiempo de servicioEn minutosPreguntas123.6N 1801Qu distribucin de probabilidad tiene la variable? 22.5MAX =2Es continua o discreta?316MIN =3Relacin entre la media y la desviacin estndar40.8MEDIA =59.2DESV STAN =613.1RANGO731.8N STURGES8.49881.2AMPLITUD91.110101138.2# INTERVALOSDESDE HASTAFREC ACUMULADAFREC ABSOLUTA125.710.00.000135.220.00.0001472.330.00.0001532.140.00.00016850.00.000179.460.00.0001829.770.00.000191680.00.0002068.42143.22292359.62427.8Total02525.82620278288.62924.63040.7312.23243.7336.9341.4352.7367.73735.8384.4395.7408.24133.7421.1432.94410.4459.24612.74710.44824925.45054.5513.45217.95355.7541.75523.15615.2577.95812.2599.36033.96111.5621.86316.16412.56518.96621.7671.1689.36949.6703.87121.4727.7739.7747.37511.67631.1771.57861.8796.8804.5816.88210830.58411.1852.5860.28718.5882.78932.5902914.8923.49313.9948.9951.5962.89727.2985.7995.710011.81013.510216.2103171047.410547106610714.410822.310970.511035.211145.51126.311330.51145.911522.911611.411714.81183211922.712054.51210.51221.612317.112464.112517.21264.11274.71280.212927.51302.71316.2132111333.413414.21353.313618.313710.513843.713964.514030.41418.814214.214334.914416.61458.31469.414719.414854.314914.115020.91514.515256.415315.615422.8155291567.315719.315823.91590.51600.916146.116215.6163116422.91656.116634.616723.816817.216915.41702.417128.117218.417314.71743.317526.317626.917728.31781.117919.71802417.740555555616.5277038364

leche deslactosadaLa demanda de cajas de leche deslactosada en las ltimas 100 semanas es la siguienteIdentificar su distribucin de probabilidad semanademandaN 1956MAX =2828MIN =31063MEDIA =4983DESV STAN =5817RANGO6750N STURGESentero7763AMPLITUD8724987210756# INTERVALOSDESDE HASTAFREC ACUMULADAFREC ABSOLUTAAcum en [0-1]1171211272821359831474641573151659861793171871481978220828219852270723800Total0248232583026799277072863329812308300.136317693276833650347893584436581378403876039986406514183242923437904469145817467114789148835498595076051925526455379954845557305677457762586665981660790616076278963794646816587366800677366880769883706687164172788736397480475815768727784378760799048077081956826748377784700855378672287954888068985990775918399276993955947349582396781977999895199700100848