3era entrega proyecto de aula (3)

Hoja1Variables CualitativasCuantitativasCategorias Escala V1GneroMaculino1V8Edad en aos cumplidosFemenino2V9Nmero de hijosV10Velocidad PromedioV2Estado CivilCasado 1V11Aos de LicenciaSoltero 2V12Ingresos (Miles de pesos)Separado 3V13Egresos (Miles de pesos)Viudo 4V14Nro de pasajeros Otro5V3Estudios Bachiller1Tecnologo2Profesional3Doctorado4V4Causa ms comn de accidentalidadPeaton1Conductor 2Condicin Climatica 3Sealizacin 4Estado del pavimento5Curvas y pendientes 6Ausencia de zonas de parqueo7Condicin del vehculo8Otra9V5Motivo del viaje Trabajo 1Recreacin 2Compra 3Salud4Estudio5Vivienda6V6Clase de vehcloAutomovil1Colectivo2Camin 3V7Tipo de ServicioParticular1Publico 2

Hoja2Nro. Encuestado GENEROESTADO CIVIL ESTUDIOS CAUSA COMUN DE ACCIDENTE MOTIVO VIAJE CLASE DE VEHICULO TIPO DE SERVICIOEDADNo.HIJOSVELOCIDAD PROMEDIO (Km/h)AOSLICENCIAINGRESOS (Miles de pesos)EGRESOS (Miles de pesos)NUMERO DE PASAJEROSMUNICIPIODPTO.MUNICIPIODPTO11213232322877340020002BTACUNDFUSACUND2124122233190131400110040TUNJA BOYACAMELGARTOLIMA311221323507515200028003BTACUNDCALIVALLE41114122391102201200100045BTACUNDFLANDESTOLIMA5231541140311222130011004BTACUNDNARIOCUND6233341145211615350031004BTACUNDSILVANIACUND7122241148311521450042501BTACUNDMELGARTOLIMA81242122493118234000350010CHIACUNDFUSACUND9244521158212532350032001BTACUNDSILVANIACUND1024452115816532220022004FACACUNDFUSACUND1115312111907319506002BTACUNDMELGARCUND1211342112009028706002BTACUNDNEIVAHUILA132132122292111280075018BTACUNDCHINAUTACUND1411351223019341200120020BTACUNDVILLA RICATOLIMA15112411143010414450035004CHIACUNDMELGARTOLIMA1622414112411195120011004BTACUNDIBAGUETOLIMA1712425112317258508002BTACUNDCHINAUTACUND181424222272627375034008FACACUNDGIRARDOTCUND19242822228211810200016504BTACUNDMELGARTOLIMA201414511291722250022004BTACUNDIBAGUETOLIMA2112385112507239008002BTACUNDTULUAVALLE22111113130092108508003BTACUNDSILVANIACUND2312322223227472400200040BTACUNDMELGARTOLIMA2412131313316313320031002SOACHACUNDFUSACUND25111421135210115500028004BTACUNDMELGARTOLIMA26111141139112920120010002BTACUNDOTOLIMA27131121140310522130011004BTACUNDMELGARTOLIMA281512222452125153500275018BTACUNDMELGARTOLIMA291428422483117213680365040FACACUNDFUSACUND30224341149312523400035002BTACUNDPANDICUND312447222582115322200205040BTACUNDMELGARTOLIMA32244222260168414000350045BTACUNDFUSACUND33213321119012728007501BTACUNDFUSACUND341133211220114465040016BTACUNDCARMEN DE APICALATOLIMA35114321122092412005002BTACUNDMELGARTOLIMA362238211241815120011002BTACUNDMELGARTOLIMA3712111225319654850450010BTACUNDCHAPARRAL TOLIMA3814442112726977504004BTACUNDCARMEN DE APICALATOLIMA3924424112821241010006502BTACUNDFUSACUND401413131291129225002001BTACUNDGIRARDOTCUND4112331222506839008006BTACUNDIBAGUETOLIMA42111851130097108508001BTACUNDGRANADACUND43112841132093117007002BTACUNDGIRARDOTCUND4412244113221304680650BTACUNDFUSACUND4512412113719315400035003BTACUNDSILVANIACUND4612462114047820150014502BTACUNDFUSACUND4712222114218321180015002BTACUNDSILVANIACUND48123663143111217150012001BTACUNDGRANADACUND49121621144212018350030001BTACUNDMELGARTOLIMA50224112250379251600160015BTACUNDCALIVALLE512216211322837240020002BTACUNDNEIVAHUILA5222143113317713320031002BTACUNDSILVANIACUND53212811135012715140015003BTACUNDGIRARDOTCUND54111713139112320120010001BTACUNDESPINALTOLIMA5523121114037722130011003BTACUNDNEIVAHUILA5623342114526415250018002BTACUNDGRANADACUND571227211483912113206503BTACUNDPANDICUND5822484114938023400035002BTACUNDMELGARTOLIMA5924424115821073220008001BTACUNDFUSACUND6024411316019841300030501BTACUNDARBELAEZCUND6112311311906216506002BTACUNDCALIVALLE6211391312009616006002TOCANCIPACUNDPERERIRARISARALDA63213411119012728007502BTACUNDMELGARTOLIMA64113921122012546504002BTACUNDGIRARDOTCUND651141211401764350030001BTACUNDCALIVALLE662244211241695120011002BTACUNDGIRARDOTCUND67124821123111558508001BTACUNDIBAGUETOLIMA6814442116026530600045004BTACUNDIBAGUETOLIMA69244222228211410100065048BTACUNDBOQUERONCUND701419211291127225002004BTACUNDGIRARDOTCUND71123322155310433900350041BTACUNDMELGARTOLIMA72111421130076108508002OANTIOQUIAMELGARTOLIMA7322121223228672400200040BTACUNDMELGARTOLIMA74221321133110013320031001BTACUNDFUSACUND752124222350671580080033BTACUNDGRANADACUND76111321139111020120010007BTACUNDGIRARDOTCUND772313422403128221300110038BTACUNDMELGARCUND782334211452981515007501BTACUNDSILVANIACUND7912232114839721268019005BTACUNDFUSACUND80224222249393234000350040BTACUNDMELGARTOLIMA81213312219075280075028VILLAVICENCIOMETACALIVALLE8211356312208846504003BTACUNDMELGARTOLIMA831148111220104412009002BTACUNDIBAGUETOLIMA842245211241845120011005BTACUNDMELGARTOLIMA85124331123186518508004BTACUNDGIRARDOTCUND86144323127280710004001BTACUNDMELGARTOLIMA872443211282941010006501BTACUNDMELGARTOLIMA8814132212911182250020014BTACUNDGIRARDOTCUND89123311125098312008003BTACUNDGIRARDOTCUND901111211300731010008005BTACUNDSILVANIACUND911124311320125117007006BTACUNDMELGARTOLIMA92122441132268416006504BTACUNDMELGARTOLIMA931242511371691520007004BTACUNDMELGARTOLIMA9412411314041162010004501BTACUNDMELGARTOLIMA95122361142110621180015003CHIACUNDGIRARDOTCUND9612351314318417150012005BTACUNDFUSACUND97151421144213018350030004BTACUNDMELGARTOLIMA9822452225039825120070014BTACUNDMELGARTOLIMA992211212322947240020002BTACUNDMELGARTOLIMA10022132113318413320031004BTACUNDIBAGUETOLIMA10121234213501241520008004BTACUNDGRANADACUND1021112222391119201200100040BTACUNDMELGARTOLIMA103231611240311722130011004BTACUNDMELGARTOLIMA1042338211452116157507504BTACUNDMELGARTOLIMA1051224411483115217206503BTACUNDMELGARTOLIMA10622461314936823400035003CHIACUNDMELGARTOLIMA10724464115821163218008001BTACUNDSILVANIACUND1082543411601129418206502BTACUNDSILVANIACUND1091232131190113113006002BTACUNDSILVANIACUND110113322220070160060025BTACUNDESPINALTOLIMA1112134131190103211007501BTACUNDIBAGUETOLIMA1121138111220116410004002SAMACABOYACAARMENIAQUINDIO11311461312208445005002BTACUNDSILVANIACUND1142242131241745120011002BTACUNDFUSACUND115124313123112658508001BTACUNDIBAGUETOLIMA1161443222272129775040040BTACUNDMELGARTOLIMA11724431112821071010006504BTACUNDGIRARDOTCUND1181413211291122225002002BTACUNDMELGARTOLIMA11912361312508739008002BTACUNDCARMEN DE APICALATOLIMA1201112211300691013008004VILLAVICENCIOMETAFUSACUND12122142223228172400200036BTACUNDIBAGUETOLIMA122221821233111813320031005BTACUNDMELGARTOLIMA1232124211350114158008002BTACUNDGIRARDOTCUND12411124113917620120010003BTACUNDSILVANIACUND125231313240312622130011001BTACUNDFUSACUND1262333131452761512007503BTACUNDFUSACUND1271223122483972178075015BTACUNDPERERIRARISARALDA12822436114936523400035005BTACUNDCHINAUTACUND1292443211582115328008002BTACUNDMELGARTOLIMA130244361160187418005503BTACUNDGIRARDOTCUND13121366321907828007501BTACUNDGIRARDOTCUND1321132622220116465040017TOCANCIPACUNDNEIVAHUILA13311496112208245005002BTACUNDFUSACUND13422441322411245120011003BTACUNDCHINAUTACUND135124312223163585080035BTACUNDGIRARDOTCUND136144741127210077504001BTACUNDGIRARDOTCUND1372443111282971010006503BTACUNDMELGARTOLIMA1381413411291118225002005BTACUNDFUSACUND139123422225074390080015CHIACUNDMELGARTOLIMA1401114211300120108508004BTACUNDGIRARDOTCUND1411123132320106117007002BTACUNDNEIVAHUILA142122751132211049006502BTACUNDGIRARDOTCUND14312431123718515120090010BTACUNDMELGARTOLIMA14412485224046720100080042BTACUNDGIRARDOTCUND145122451142112121180015003MADRIDCUNDFUSACUND146123322243194171500120038BTACUNDMELGARTOLIMA1471214122442122183500300040BTACUNDMELGARTOLIMA1482218222322827240020008BTACUNDMELGARTOLIMA149221213233111713320031002BTACUNDIBAGUETOLIMA1502123511350120158008002BTACUNDMELGARTOLIMA1511114222391120201200100020BTACUNDMELGARTOLIMA152231412240381221300110010BTACUNDMELGARTOLIMA15323365114521041513507504BTACUNDIBAGUETOLIMA154122151148393216806505BTACUNDGIRARDOTCUND15524431325821093212008003BTACUNDARBELAEZCUND15624424116011304111005505YOPALCASANAREPOPAYANCAUCA157123413219013019006002BTACUNDFUSACUND158113311120086110006003BTACUNDFUSACUND15921332221908528007501BTACUNDRICAURTECUND160113321122013046504004BTACUNDMELGARTOLIMA16111445112209245005002BTACUNDFLANDESTOLIMA16222422222416551200110040BTACUNDMELGARTOLIMA16314435112728477504003CHIACUNDCHINAUTACUND16424482112821111010006501BTACUNDGIRARDOTCUND16512363112507839008003BTACUNDFUSACUND1661114611300111108508007BTACUNDGUAMOTOLIMA16722146323221127240020001BTACUNDSILVANIACUND16822126113317013320031002BTACUNDIPIALESNARIO16921242223501051580080015BTACUNDFUSACUND17011162113919420120010002BTACUNDFUSACUND171231321140311322130011004BTACUNDSILVANIACUND17223341324521231512007501BTACUNDMELGARTOLIMA1731223131483722120006502BTACUNDIBAGUETOLIMA17422424114937923400035002BTACUNDSUAREZTOLIMA17524442225829032180080015BTACUNDFUSACUND17624421116011074116005503BTACUNDMELGARTOLIMA177213421119011228007503BTACUNDGIRARDOTCUND17811382112209746504005BTACUNDSILVANIACUND17911462112201214150015002FACACUNDIBAGUETOLIMA18022422112411145120011002BTACUNDSILVANIACUND18112442112316658508001BTACUNDIBAGUETOLIMA182144621127212277504002BTACUNDGIRARDOTCUND18324422222829810100065040BTACUNDSILVANIACUND1841413211291103225002002BTACUNDMELGARTOLIMA185123432225077390080024BTACUNDMELGARTOLIMA1861112511300129108508002BTACUNDGIRARDOTCUND1871128211320119117007007BTACUNDMELGARTOLIMA18812235213226546806509BTACUNDESPINALTOLIMA189124451137172157207005BTACUNDFUSACUND19012425224041152080045045BTACUNDMELGARTOLIMA1911226622421122211800150010BTACUNDBOQUERONCUND192123463143113017150012001BTACUNDICONONZOTOLIMA193121462244262183500300040TOCANCIPACUNDNEIVAHUILA1942243211503108256006005BTACUNDMELGARTOLIMA1952212131322887240020002BTACUNDMELGARTOLIMA196221821133111213320031002BTACUNDVENECIA CUND197212423235093158008001BTACUNDGIRARDOTCUND19811141113919720120010002VILLAVICENCIOMETAIBAGUETOLIMA199231422240387221300110027BTACUNDMELGARTOLIMA2002332221452861575075034BTACUNDMELGARTOLIMA201122213148362216806501BTACUNDMELGARTOLIMA20222424114939023400035002BTACUNDSILVANIACUND2032448222582953280080033CHIACUNDGUAMOTOLIMA204244122160112041100055015BTACUNDFUSACUND20512322111906916506001BTACUNDCHINAUTACUND2061135222200961120060045BTACUNDMELGARTOLIMA20721332121907028007506BTACUNDMELGARTOLIMA20811342112208246504002BTACUNDMELGARTOLIMA209114421122012646005002BTACUNDFUSACUND2102242211241635120011004BTACUNDFUSACUND211124821123112558508002BTACUNDSILVANIACUND212144421127211677504002BTACUNDFUSACUND21324422222821081010006504BTACUNDFUSACUND214141321129185225002005BTACUNDFUSACUND215123411125011339008006BTACUNDFUSACUND216111411130076108508002BTACUNDCHINAUTACUND2172219211322977240020002BTACUNDMELGARTOLIMA218221462233195133200310016BTACUNDFUSACUND219212851135079158008002BTACUNDSAN BERNARDOCUND220111851139112120120010004BTACUNDCHINAUTACUND22123141324036522130011005BTACUNDFLANDESTOLIMA222233441145269157507502BTACUNDARMENIAQUINDIO223122841148391216806502BTACUNDCARMEN DE APICALACUND224224441149312223400035004BTACUNDFUSACUND2252444632582120328008002BTACUNDFUSACUND226244413160181416005501BTACUNDSILVANIACUND22721341321909928007501BTACUNDFUSACUND228113822222066465040013MOSQUERACUNDSILVANIACUND22911482112209847005001BTACUNDPERERIRARISARALDA23022442222419251200110040BTACUNDSILVANIACUND23112481312317258508001BTACUNDMELGARTOLIMA232144412227292775040016FUNZACUNDGRANADACUND23324441122821281010006501BTACUNDGIRARDOTCUND2341414122291842250020019BTACUNDCALIVALLE235123813225011439008001BTACUNDIPIALESHUILA236111811130066108508003BTACUNDFUSACUND2371124121320118117007002BTACUNDIBAGUETOLIMA23812241123226946806504CHIACUNDFUSACUND239124852237193157207004BTACUNDMELGARTOLIMA240124411140480205004503BTACUNDGIRARDOTCUND241122451142112821180015005BTACUNDSILVANIACUND242123851143111217150012003BTACUNDFUSACUND243121321144211518350030001BTACUNDCARMEN DE APICALATOLIMA2442243632503127256006001BTACUNDARMENIAQUINDIO24522186113221147240020002BTACUNDFUSACUND24622196113317313320031001BTACUNDARBELAEZCUND2472124611350118158008003BTACUNDIBAGUETOLIMA2481111422391114201200100015BTACUNDGIRARDOTCUND249231411140310722130011002BTACUNDCARMEN DE APICALATOLIMA250233451145270157507501BTACUNDESPINALTOLIMA251122361148371216806504BTACUNDFUSACUND252224761149312923400035004BTACUNDFUSACUND2532447211582110328008002BTACUNDMELGARTOLIMA254244451160166416005505BTACUNDCARMEN DE APICALATOLIMA255123452219090165060028BTACUNDFUSACUND256113412220062160060034BTACUNDGIRARDOTCUND257213311119010128007502BTACUNDIBAGUETOLIMA2581138522220119465040012BTACUNDSILVANIACUND259114211222012845005004BTACUNDNEIVAHUILA26022432222417351200110040BTACUNDMELGARTOLIMA261124422223180585080021BTACUNDMELGARTOLIMA26214481322729277504001BTACUNDAGUA DE DIOSCUND2632442111282821010006501BTACUNDMANIZALEZCALDAS2641414222291842250020023BTACUNDCARTAGOVALLE26512332112509039008002BTACUNDMELGARTOLIMA2661114221300841085080032BTACUNDMELGARTOLIMA26722142113221177240020002BTACUNDARBELAEZCUND26822121323318713320031004BTACUNDFUSACUND2692124222350781580080021BTACUNDICONONZOTOLIMA270111721139110420120010002BTACUNDARBELAEZCUND27123135114039722130011003CHIACUNDGIRARDOTCUND272233821145262157507505BTACUNDRICAURTECUND2731222211483113216806504BTACUNDGIRARDOTCUND27422435224936823400035007BTACUNDARBELAEZCUND275244411158271328008005BTACUNDIBAGUETOLIMA2762444111601105416005502BTACUNDGIRARDOTCUND2772132122190122280075022BTACUNDGRANADACUND278113411122012746504002BTACUNDCHINAUTACUND2791144122220107490050015BTACUNDFUSACUND2802243511241795120011003BTACUNDCALIVALLE28112481322319158508001BTACUNDSILVANIACUND2821442511272967750400CHIQUINQUIRABOYACAGIRARDOTCUND28324476112821171010006503BTACUNDIBAGUETOLIMA284141451129170225002005BTACUNDIBAGUETOLIMA2851234622250108390080020TOCANCIPACUNDFUSACUND286111311130081108508005BTACUNDIBAGUETOLIMA287112221132093117007003BTACUNDCARMEN DE APICALATOLIMA288122422232265468065036BTACUNDMELGARTOLIMA289124451137195157207004BTACUNDPOMACUND290124463140412720275019804BTACUNDGIRARDOTCUND291122263242110721180015001BTACUNDGRANADACUND2921233122431116171500120016BTACUNDCALIVALLE293121411144210218350030002BTACUNDCHINAUTACUND29422441325036525120012001BTACUNDSILVANIACUND29522135113221307240020001BTACUNDPASTONARIO29622125113317813320031001BTACUNDSILVANIACUND297212351135011615180018002BTACUNDFUSACUND29811131323917820120010002BTACUNDCHINAUTACUND299231321140312322130011004BTACUNDGIRARDOTCUND3002333632452115157507501BTACUNDFUSACUND301122261148374216806507BTACUNDIBAGUETOLIMA30222436114939723400035002BTACUNDFUSACUND303244313258263328008001BTACUNDMELGARTOLIMA30424436226011144160055035TOCANCIPACUNDCALIVALLE30512331111908516506003BTACUNDCARMEN DE APICALACUND306113461120012816006004BTACUNDFUSACUND307213461219011428007504BTACUNDCARMEN DE APICALACUND30811321322207346504001BTACUNDMELGARTOLIMA309114321122012545005003BTACUNDCALIVALLE31022432222417951200110030BTACUNDARMENIAQUINDIO31112481112317358508002BTACUNDIBAGUETOLIMA31214432112729277504003CHIQUINQUIRACUNDCARMEN DE APICALATOLIMA3132443211282941010006503BTACUNDNILOCUND314141321129181225002004BTACUNDMELGARTOLIMA31512332112508839008004CHIACUNDNATAGAIMATOLIMA316111721130076108508004BTACUNDFUSACUND31722132113221227240020004MADRIDCUNDFUSACUND318221321133111613320031003BTACUNDOTOLIMA31921232223501081580080040BTACUNDOCUND32011132113918020120010003BTACUNDMELGARTOLIMA32123112114038822130011002BTACUNDMELGARTOLIMA322233321145289157507503BTACUNDGIRARDOTCUND323122311148397216806502BTACUNDMELGARTOLIMA324224321149312723400035004BTACUNDPERERIRARISARALDA3252449222582713280080045BTACUNDFUSACUND3262443222601954160055026BTACUNDMELGARTOLIMA327213812219089280075040BTACUNDMELGARTOLIMA328113321122010546504004BTACUNDMELGARTOLIMA32915432112208245005003BTACUNDNEIVAHUILA3302243211241875120011004BTACUNDCARMEN DE APICALATOLIMA3311248222231114585080040FACACUNDMELGARTOLIMA33214436322727377504002BTACUNDMELGARTOLIMA33324436322821111010006502BTACUNDCALIVALLE33414132112918129002005BTACUNDOVALLE33512331322506839008002BTACUNDGRANADACUND3361113222300881085080019BTACUNDPITALITOHUILA3371123211320118117007003BTACUNDFUSACUND338122321132296412006501CHIACUNDIBAGUETOLIMA3391248211371125157207004BTACUNDFUSACUND340124313240483208004501BTACUNDSILVANIACUND341122712242186211800150031BTACUNDMELGARTOLIMA34223331224527915150075020BTACUNDMOJARRATOLIMA343122821148310821268019005BTACUNDFUSACUND344224351149310323400035004BTACUNDFUSACUND3452448522582983280080040BTACUNDGIRARDOTCUND34624486316011014112005504BTACUNDPANDICUND347213863219010728007502BTACUNDGIRARDOTCUND34811335112207846504002BTACUNDFUSACUND34915445222201244120090020CHIACUNDCARMEN DE APICALATOLIMA35022431112411135120011005BTACUNDNEIVAHUILA35112482222311095185080020BTACUNDMELGARTOLIMA35214413222721097100040014ZIPAQUIRACUNDFUSACUND35324413112821241010006506BTACUNDGIRARDOTCUND3541419311291105225002003BTACUNDAGUA DE DIOSCUND355123331125065312008002BTACUNDESPINALTOLIMA3561113311300681010008004BTACUNDSILVANIACUND357112121132063117007003BTACUNDIBAGUETOLIMA3581224322322844160065030BTACUNDFUSACUND3591248111371831520007004BTACUNDMELGARTOLIMA3601248211404692010004501CHIACUNDMELGARTOLIMA36112232114216921180015002BTACUNDIBAGUETOLIMA362123421143111517150012005BTACUNDARMENIAQUINDIO36312192114426918350030004BTACUNDGIRARDOTCUND3642243211503109259006005BTACUNDGIRARDOTCUND365221721133111413320031004BTACUNDFUSACUND36615182114428818350030004BTACUNDFUSACUND367231541140312822130011004BTACUNDNARIOCUND368233341145287157507504BTACUNDSILVANIACUND36912431312319558508001BTACUNDIBAGUETOLIMA37012272114831142113206503BTACUNDPANDICUND371224841149310723400035002BTACUNDMELGARTOLIMA37224424115821083220008001BTACUNDFUSACUND373244113160165416005501BTACUNDARBELAEZCUND374123113119011916506002BTACUNDCALIVALLE37511391312008316006002BTACUNDPERERIRARISARALDA37621341111906728007502BTACUNDMELGARTOLIMA37711392112207646504002CHIQUINQUIRACUNDGIRARDOTCUND37811412114011014350030001BTACUNDCALIVALLE379113321122094465040016CHIACUNDCARMEN DE APICALATOLIMA380114321122064412005002BTACUNDMELGARTOLIMA3812238211241805120011002BTACUNDMELGARTOLIMA38212111225316854850450010BTACUNDCHAPARRAL TOLIMA383144421127213077504004BTACUNDCARMEN DE APICALATOLIMA384112213235011515200028003BTACUNDCALIVALLE385111412239187201200100045BTACUNDFLANDESTOLIMA386231541140310022130011004BTACUNDNARIOCUND387233341145211815350031004BTACUNDSILVANIACUND38812224114837921450042501BTACUNDMELGARTOLIMA389124212249376234000350010CHIACUNDFUSACUND39024452115829832350032001BTACUNDSILVANIACUND39124452115819732220022004FACACUNDFUSACUND392153121119011219506002BTACUNDMELGARCUND39311342112009428706002BTACUNDNEIVAHUILA394213212229272280075018BTACUNDCHINAUTACUND39511351223016641200120020BTACUNDVILLA RICATOLIMA39611241114308114450035004CHIACUNDMELGARTOLIMA39722414112411255120011004BTACUNDIBAGUETOLIMA39812425112319358508002BTACUNDCHINAUTACUND399221721133110513320031004BTACUNDFUSACUND400151821144211318350030004BTACUNDFUSACUND40123154114036522130011004BTACUNDNARIOCUND4022333411452125157507504BTACUNDSILVANIACUND40312431312319358508001BTACUNDIBAGUETOLIMA4041227211483922113206503BTACUNDPANDICUND40522484114939423400035002BTACUNDMELGARTOLIMA40624424115821193220008001BTACUNDFUSACUND407244113160193416005501BTACUNDARBELAEZCUND40822436114937623400035005BTACUNDCHINAUTACUND409244321158296328008002BTACUNDMELGARTOLIMA4102443611601116418005503BTACUNDGIRARDOTCUND41121366321906528007501BTACUNDGIRARDOTCUND4121132622220130465040017TOCANCIPACUNDNEIVAHUILA413114961122010145005002BTACUNDFUSACUND4142244132241715120011003BTACUNDCHINAUTACUND415124312223165585080035BTACUNDGIRARDOTCUND4162241411241925120011004BTACUNDIBAGUETOLIMA417124251123111858508002BTACUNDCHINAUTACUND41822172113317413320031004BTACUNDFUSACUND41915182114427618350030004BTACUNDFUSACUND42023154114037822130011004BTACUNDNARIOCUND4212447222582116322200205040BTACUNDMELGARTOLIMA422244222260183414000350045BTACUNDFUSACUND423213321119011128007501BTACUNDFUSACUND424113321122068465040016BTACUNDCARMEN DE APICALATOLIMA425114321122073412005002BTACUNDMELGARTOLIMA426123311125086312008003BTACUNDGIRARDOTCUND4271111211300741010008005BTACUNDSILVANIACUND4281145311320114117007006BTACUNDMELGARTOLIMA429122441132264416006504BTACUNDMELGARTOLIMA4301242511371861520007004BTACUNDMELGARTOLIMA4311241131404972010004501BTACUNDMELGARTOLIMA432122361142112521180015003CHIACUNDGIRARDOTCUND43312351314316517150012005BTACUNDFUSACUND43415142114427918350030004BTACUNDMELGARTOLIMA43522452225036325120070014BTACUNDMELGARTOLIMA4362211212322627240020002BTACUNDMELGARTOLIMA43722132113318813320031004BTACUNDIBAGUETOLIMA4382123421350881520008004BTACUNDGRANADACUND439131222239187201200100040BTACUNDMELGARTOLIMA440231611240311022130011004BTACUNDMELGARTOLIMA441233821145264157507504BTACUNDMELGARTOLIMA442122441148390217206503BTACUNDMELGARTOLIMA44322461314938623400035003CHIACUNDMELGARTOLIMA4442446411582803218008001BTACUNDSILVANIACUND4452543411601109418206502BTACUNDSILVANIACUND4462232131190123113006002BTACUNDSILVANIACUND447213422220095160060025BTACUNDESPINALTOLIMA448213413119076211007501BTACUNDIBAGUETOLIMA4492138111220102410004002SAMACABOYACAARMENIAQUINDIO45021461312208545005002BTACUNDSILVANIACUND4512242131241975120011002BTACUNDFUSACUND45212431312319958508001BTACUNDIBAGUETOLIMA453144322227278775040040BTACUNDMELGARTOLIMA4542443111282981010006504BTACUNDGIRARDOTCUND45522121223226372400200040BTACUNDMELGARTOLIMA456221321133110013320031001BTACUNDFUSACUND4572124222350951580080033BTACUNDGRANADACUND458111321139112820120010007BTACUNDGIRARDOTCUND459231342240371221300110038BTACUNDMELGARCUND46023342114521281515007501BTACUNDSILVANIACUND

punto 11. La distribucin de probabilidad Binomial para la variable Nro. de hombres seleccionadas en una muestra de tamao 30. Calcule la probabilidad de encontrar por lo menos la mitad de los hombres en la muestra de 30 conductores.

Etiquetas de filaCuenta de ESTADO CIVIL PROBABILIDAD HOMBRE 253MUJER207HOMBRE MUJERTotal general4600.550.45

XITO =Que sea hombre FRACASO =Que no sea hombre X=probabilidad de encontrar por lo menos la mitad de los hombres en la muestra de 30 conductores.xB(x,30,0,55)00.0000000000394810.0000000014475915-16-17-18-19-20-21-22-23-24-25-26-27-28-29-3020.00000002565459x=B(15)+30.00000029265232x=0.124247855540.000002414381650.769091445377950.0000153447367460.0000781444926570.0003274626358980.0011506673177690.00343779618393B(16)+B(17)+B(18)+B(19)+B(20)+B(21)+100.008823676872100.14236733450.143297839918000.12649130310.09764240940.06563739750.0382016599110.01960817082689B(22)+B(23)+B(24)+B(25)+B(26)+B(27)+120.037945441692770.01910082990.00812015960.00289468650.0008491080.00019957670.0000361373130.06421536286469B(28)+B(29)+B(30)=140.095303752823000.00000473230.00000039890.0000000163150.12424785553220160.14236733446398170.14329783991800180.12649130313749190.09764240943947200.06563739745653210.03820165989534220.01910082994767230.00812015959128240.00289468652097250.00084910804615260.00019957667751270.00003613734078280.00000473227082290.00000039888873300.00000001625102

Politecnico GrancolombianoEstadstica II

punto 22. Enuncie un problema en que su variable de estudio presente una distribucin de Poisson. Formule una pregunta y calcule su probabilidad. Referencie el parmetro de estudio, teniendo en cuenta el entorno de la base de datos.

si un conductor viaja en promedio 6 veces por dia Cul es la probabilidad de que a) que realice 10 viajes en cualquiera de dos dias consecutivosproblema:

x= variable que nos define numero de viajes que se realizan en dos dias consecutivos = 0,1,2,3 = 6 * 2 = 12 viajes en promedio que se realizan en dos dias consecutivos.P( X = 10, = 12 ) = (12)10 (2,718)-1210!6.1917364* 0,000061510.10495336288800


punto 33. Presente la distribucin de probabilidad para que al tomar una muestra aleatoria sin reposicin de 50 personas, por lo menos las tres cuartas partes de ellas presenten conductores que manejan automvil.

|Cuenta de GENEROPROBABILIDAD Automovil275Colectivo109AUTOMOVILCamin760.597826087Total general460N=0.59782608759.7826086957n=50K= 37,538x=

xh(x,N,n,K)X > 38=09.2838E-1615.2441E-143.4843E+0621.4421E-1232.5725E-1143.3459E-1053.3821E-0962.7651E-0871.8790E-0781.0823E-0695.3628E-06102.3118E-05118.7474E-05122.9257E-04138.6979E-04142.3088E-03155.4912E-03161.1734E-02172.2572E-02183.9145E-02196.1252E-02208.6497E-02211.1021E-01221.2659E-01231.3091E-01241.2162E-01251.0124E-01267.5245E-02274.9711E-02282.9030E-02291.4880E-02306.6359E-03312.5456E-03328.2774E-04332.2371E-04344.8904E-05358.3080E-06361.0291E-06378.2693E-08383.2348E-09


punto 44. Estime la probabilidad que al seleccionar un conductor al azar registre una velocidad promedio de por lo menos 90 k/h, si se considera que la variable tiene comportamiento normal.

Etiquetas de filaCuenta de GENEROPROBABILIDAD 907913AUTOMOVIL9290.773913043593119489579669713989992100410151023103310451056106210781086109511041115112711361141311510116121175118101196120612131227123412451251112631278128812961309Total general270


punto 55. Si se toma una muestra aleatoria de 10 conductores, calcule la probabilidad que mximo 4 de ellos registren una velocidad mxima de 90 k/h

Etiquetas de filaCuenta de GENEROPROBABILIDAD 907913AUTOMOVIL9290.58695652179311948957966XITO =registren una velocidad mxima de 90 k/h9713FRACASO =no registren una velocidad mxima de 90 k/h989X=probabilidad que mximo 4 de ellos registren una velocidad mxima de 90 k/h99210041015xB(x,10,0,58)x=5-6-7-8-9-10102300.00014452989685x=B(5)+B(6)+B(7)+B(8)+B(9)+B(10)=103310.00205384590254x=0.21106151420.24994126680.20295982570.10815622290.03415459670.004853548104520.01313380406100x=0.8111269742366105630.04977020486274106240.12377064104024107850.21106151419494108660.24994126680979109570.20295982568013110480.10815622289533111590.034154596703791127100.0048535479526411361141311510116121175118101196120612131227123412451251112631278128812961309Total general270


3era entrega proyecto de aula (3)

Documents