17
Districuión Empírica Continua EJ: El timepo de respuesta (Minutos) del cuerpo de bomberos a las alarmas. 2.76 1.83 0.8 1.45 1.24 i X(i-1) X(i) Intervalo a(i) Min Max 1 0 0.8 0 0.2 4 2 0.8 1.24 0.2 0.4 2.2 3 1.24 1.45 0.4 0.6 1.05 4 1.45 1.83 0.6 0.8 1.9 5 1.83 2.76 0.8 1 4.65 n 5 1/n 0.2

Simulacion_20150307 (1).xlsx

  • Upload
    dprc01

  • View
    49

  • Download
    2

Embed Size (px)

Citation preview

Districuin Emprica ContinuaDistricuin Emprica ContinuaEJ: El timepo de respuesta (Minutos) del cuerpo de bomberos a las alarmas. Simular el timepo de respuestas para las proximas 20 alarmas2.761.830.81.451.24NUiX(i-1)a(i)X10.839599604851.834.652.0141381624iX(i-1)X(i)Intervaloa(i)20.384397588820.82.21.2056746953MinMax30.509231704231.241.051.3546932894100.800.2440.397506138720.82.21.234513505220.81.240.20.42.250.471859986231.241.051.315452985531.241.450.40.61.0560.548706217931.241.051.396141528841.451.830.60.81.970.917691448251.834.652.377265234351.832.760.814.6580.08807172071040.35228688390.345898008320.82.21.1209756183100.782781776241.451.91.7972853748n5110.581360160931.241.051.4304281691/n0.2120.235648558520.82.20.8784268287130.273705968220.82.20.96215313140.985042977351.834.652.6904498444150.05805283741040.2322113498160.216972097820.82.20.8373386152170.07851915941040.3140766376180.783599986741.451.91.7988399747190.448961298231.241.051.2914093631200.567070573331.241.051.415424102

Distribucon TriangularDistribucon TriangularEJEl tiempo de respuesta (Das) a las quejas de los clientes sigue distribucin triangular con parmetrosa2b
Administrador: MODA4c13b'0.1818181818- Tiempo de respuesta para los proximos 10 clientesiUX1X2X10.58157547745.576962468910.290943670610.290943670620.34152851174.74109964377.97634538937.976345389330.14806365633.8048269827ERROR:#NUM!3.804826982740.97679980146.6356871812.871481293412.871481293450.01918487312.6496669986ERROR:#NUM!2.649666998660.36675363044.84052457638.27885608638.278856086370.90743153586.468052572112.475595674812.475595674880.37564348544.87474462848.3804914178.38049141790.73432324096.019342147711.395809681811.3958096818100.88727694926.418154918312.357057973412.3570579734

Distrubucin UniformeDistrubucin UniformeEJ La demanada diaria de un producto sigue distribucin uniforme entre 50 y 70 unidades. Simular la demanda en el proximo ao i50j70j-i-119NUX
Administrador: Administrador:MULTIPLO.INFERIORX
Administrador: Administrador:REDONDEAR.MENOSmin5010.77077206436464max6820.6892960149636330.739887845646440.0789635631515150.9515801774686860.8450519032666670.94597238026767ClaseValorFrecuencia80.237094532754541501790.0583395842515125120100.3670554477565635218110.1797496608535345316120.1199332111525255412130.8063890363656565515140.7483783247646475617150.4869490577595985713160.4212963867585895820170.64639007566262105918180.87614975196666116021190.06394405965151126111200.45720669295858136223210.08532923135151146324220.68124018886262156423230.3554114345656166516240.99519368336868176622250.72836144976363186726260.08338555345151196833270.78896078466464280.00001909075050290.86446393166666300.89241847136666310.6890418016363320.99225664746868330.61243654676161340.68511885146363350.28392965355555360.8943333876666370.66751674926262380.34443596845656390.34593205135656400.72352451056363410.52730587436060420.86957429116666430.1643914425353440.88282457746666450.98852260716868460.29393741175555470.82939848666565480.91804904146767490.0432527155050500.47960270065959510.56123490026060520.03463061145050530.16862084675353540.50904941365959550.13170305195252560.40754204715757570.0296739335050580.4550191595858590.61515128436161600.35796093435656610.37160675825757620.3087656425555630.92002242826767640.54696279356060650.61274735646161660.94088119386767670.97212268376868680.04949307955050690.63825570516262700.14979266635252710.63576896696262720.17119212975353730.52535268255959740.01957226455050750.54278597776060760.59377094116161770.99845775426868780.19000271915353790.73908274166464800.65258477496262810.28597703845555820.48738023725959830.96101260246868840.5575427936060850.67803412456262860.92320370766767870.92227251936767880.92602740656767890.96155492726868900.87436211536666910.36763586725656920.31432599035555930.47867814815959940.00044201355050950.57535772366060960.73351265916363970.42749411665858980.69899827166363990.813745062465651000.45678998658581010.050810541150501020.452453027758581030.721905513163631040.863710067266661050.305487447555551060.662896939462621070.937721273567671080.959792518668681090.838621073465651100.658087858462621110.775189693564641120.35382618256561130.984248992568681140.021502548550501150.665248929662621160.076123288951511170.357955036756561180.488584520859591190.804181204365651200.126771880152521210.787428281864641220.874724184466661230.926970854967671240.468327617758581250.435931152658581260.42902671158581270.978095601768681280.141183749752521290.852936086866661300.382504503657571310.77245250664641320.063443819351511330.472667288758581340.130377158852521350.12572419452521360.464547016658581370.55109558360601380.002058035950501390.690833185463631400.944596329567671410.28481538755551420.862480140166661430.669920090762621440.758859849764641450.740063373364641460.498438777459591470.321760004756561480.944853339567671490.319173327356561500.528021974660601510.083485465451511520.869840507666661530.250262223554541540.059755950651511550.963081803168681560.829146603765651570.702148397963631580.687959384663631590.892789426266661600.374026472257571610.456592926158581620.99122694768681630.031588874950501640.133396597452521650.849748119766661660.937764889867671670.535097401360601680.204653446253531690.727718008263631700.819610055165651710.188818202553531720.942167581267671730.519369896459591740.051708019150501750.664182887362621760.063607724351511770.884658030866661780.08136588851511790.060570375751511800.7634831964641810.827949819665651820.012890184750501830.112131324852521840.480726082159591850.774258133464641860.0799847551511870.496009500859591880.753455324264641890.676316663262621900.5764050260601910.810739208565651920.017505525950501930.19311995853531940.647515209362621950.545037623960601960.056673370851511970.070872265651511980.239698026454541990.309517306855552000.221569384354542010.334253734656562020.380916053257572030.705941645163632040.720888783663632050.148473533352522060.949201723368682070.261967637354542080.00170160550502090.621652493761612100.742678451864642110.397660096257572120.739741281964642130.784336299964642140.242702380654542150.53295697960602160.620215766761612170.987716959768682180.939419457567672190.965997399668682200.183090838253532210.523111284859592220.335330892956562230.159099787253532240.954207952668682250.259178772354542260.969608903968682270.770655490364642280.471861696958582290.713929448163632300.744656103964642310.305134371655552320.886205921366662330.519278863559592340.957082620368682350.555532104160602360.750046278364642370.621148533361612380.433612525958582390.150035547252522400.208542967853532410.905628432567672420.264087889755552430.275790922555552440.901711064967672450.078498435651512460.655498855662622470.988557207168682480.31881990756562490.21594853554542500.016298670650502510.599079305761612520.794070699965652530.144814867752522540.918353708967672550.612970677261612560.398795037257572570.059732686251512580.651901198962622590.664102464962622600.685923988863632610.414239791557572620.128173575452522630.258374074854542640.542860280160602650.727523126163632660.319703580556562670.669418132962622680.13330041652522690.212747771354542700.879119226166662710.491783528759592720.505405798359592730.1125120552522740.474904188759592750.653133627162622760.528623304160602770.1965142953532780.139978940752522790.967802502268682800.295669888555552810.86899066466662820.863388709766662830.620554857461612840.441060464958582850.422740958258582860.657372462762622870.294502403855552880.674847554362622890.942810595267672900.412469658257572910.670772912762622920.964918696368682930.875987793366662940.918571722967672950.904152007967672960.547986885760602970.038514206350502980.594149969761612990.342749223556563000.91420674867673010.783097671964643020.45576962158583030.433201134758583040.95313548368683050.073506590551513060.376870154757573070.706083817263633080.34680218456563090.83148666865653100.057317890551513110.164001367453533120.710696110863633130.885057867266663140.254216509654543150.973261188368683160.573067755460603170.092827553151513180.812979034265653190.939821764967673200.938387485267673210.488759445259593220.484059594959593230.903950862867673240.39184751957573250.999796141268683260.107092147852523270.900674724467673280.684937182263633290.53046449860603300.979985535568683310.638478816662623320.245164434754543330.812195990265653340.716893779863633350.282709803955553360.386130245957573370.737301606864643380.985539003868683390.957463822868683400.394068008757573410.158846883253533420.765213276464643430.191007100753533440.540560268360603450.422273656858583460.961084143868683470.45515565258583480.983491235268683490.947197694267673500.994822330168683510.789209482964643520.169909897553533530.269748117455553540.576885690460603550.151852686952523560.347080736556563570.812157081465653580.992969421668683590.819833686365653600.836375787365653610.686641527363633620.997799381968683630.685164062363633640.574849928660603650.73066519886363

POISSONDEF: Modela cantidad de eventos por unidad de tiempo

Empirica Discreta