8/19/2019 2B_4_TAREA1_U2

1/20

8/19/2019 2B_4_TAREA1_U2

2/20

8/19/2019 2B_4_TAREA1_U2

3/20

Un paracaidista con masa de 68.1m kg salta desde un globo aeroestatico fj

#atos de entrada t f(t)m$ 68kg 16.%&%'8&8&'

c$ 13kg"s % (.(6''1%63'

g$ '.8&m"s) 6 3!.6%1(!1!631

*$ 8 %1.&'!83!8

1& %%.8(313(!(13

1 %(.%'&1'&'%86

1% %'.3&3116%!

16 !&.!!8''%&%!

18 !1.%8'8%'11

& !.&316!836(1

!.%%'1!1!'%%

% !.(38363'!

6 !.'38(11!3''

8 !3.&((%''%16

3& !3.1(36%6'('

3 !3.%&%%!%(3

3% !3.8638&&!

36 !3.3183%3&!%%

38 !3.3%&%836&%

%& !3.3!!811%6%

% !3.366%%6&&%6

%% !3.3(38&61'8

%6 !3.3(8'&%'&13%8 !3.38%36'38%

!& !3.38%883(&!!

! !3.386!(866(6

!% !3.38((!8(8

!6 !3.388!661&

!8 !3.38'1'668'

6& !3.38'!1'''6(

6 !3.38'('&3'&6

6% !3.38''(((&

66 !3.3'&1&(%!'68 !3.3'&1'(3%6(

(& !3.3'&!'61%'

( !3.3'&3&(!&

(% !3.3'&33631(

(6 !3.3'&3!33316

(8 !3.3'&36(6(11

8& !3.3'&3((6&%6

8 !3.3'&38%%8!'

8% !3.3'&38'!'

86 !3.3'&3'!!!188 !3.3'&3'%8%6

'& !3 3'&3'6%(3

8/19/2019 2B_4_TAREA1_U2

4/20

' !3.3'&3'(!!1

'% !3.3'&3'88!!

'6 !3.3'&3'8813

'8 !3.3'&3''1((3

1&& !3.3'&3''%3&1

1& !3.3'&3''6&!

1&% !3.3'&3''(6!1&6 !3.3'&3''81&!

1&8 !3.3'&3''868(

11& !3.3'&3'''&'1

11 !3.3'&3'''3(

11% !3.3'&3'''!6%

116 !3.3'&3'''6'8

118 !3.3'&3'''('1

1& !3.3'&3'''8!!

1 !3.3'&3''''

1% !3.3'&3''''3

16 !3.3'&3''''!

18 !3.3'&3''''6(

13& !3.3'&3''''((

13 !3.3'&3''''8%

8/19/2019 2B_4_TAREA1_U2

5/20

  o. Apliquese la ecuacion 1.3 para calcular la velocidad antes de abrir el paracaidas. El c

f(t)(Num) Et Ea1'.6 1'.%8+ ,A

3.&&%6'8'(1 1!.!+ 38.(6+

3'.8!!!%36'6 11.8+ 1'.(&+

%%.8%86836 '.&(+ 11.&8+

%(.'68'68611 6.'&+ 6.!6+

%'.'!'1!&83% !.&+ 3.'8+

!1.188((!%( 3.8'+ .%6+

!.&16&(!!11 .88+ 1.!3+

!.!&!6'!661 .1+ &.'6+

!.83'8'&!((1 1.!!+ &.6&+

!3.&%1'86!%(3 1.13+ &.38+

!3.16'8'163( &.8+ &.%+

!3.!&8%18%1 &.!'+ &.1!+

!3.3&&(%6%!3 &.%+ &.1&+

!3.33%%''!186 &.3&+ &.&6+

!3.3!!&&'8(! &.+ &.&%+

!3.368&&88((6 &.1!+ &.&+

!3.3(6881'( &.11+ &.&+

!3.381%3116 &.&8+ &.&1+

!3.38%(3686' &.&!+ &.&1+

!3.3868&(!&3 &.&%+ &.&&+

!3.3881633%1 &.&3+ &.&&+

!3.388'61&13 &.&+ &.&&+!3.38'%8'(!6 &.&1+ &.&&+

!3.38'836&'1 &.&1+ &.&&+

!3.3'&&3!&63 &.&1+ &.&&+

!3.3'&16'1%( &.&&+ &.&&+

!3.3'&!388&( &.&&+ &.&&+

!3.3'&3&(!1 &.&&+ &.&&+

!3.3'&3%1%(1% &.&&+ &.&&+

!3.3'&36'!(( &.&&+ &.&&+

!3.3'&3(6!!6 &.&&+ &.&&+

!3.3'&38!166 &.&&+ &.&&+!3.3'&3'&6&'! &.&&+ &.&&+

!3.3'&3'%&!68 &.&&+ &.&&+

!3.3'&3'6386 &.&&+ &.&&+

!3.3'&3'(61'% &.&&+ &.&&+

!3.3'&3'8%'3% &.&&+ &.&&+

!3.3'&3''&%6! &.&&+ &.&&+

!3.3'&3''3'6! &.&&+ &.&&+

!3.3'&3''6181 &.&&+ &.&&+

!3.3'&3''(!83 &.&&+ &.&&+

!3.3'&3''8%( &.&&+ &.&&+!3.3'&3'''&3 &.&&+ &.&&+

!3 3'&3'''38( & &&+ & &&+

&

&

1&

&

3&

%&

!&

6&

8/19/2019 2B_4_TAREA1_U2

6/20

!3.3'&3'''61 &.&&+ &.&&+

!3.3'&3'''(!! &.&&+ &.&&+

!3.3'&3'''8%! &.&&+ &.&&+

!3.3'&3''''& &.&&+ &.&&+

!3.3'&3''''38 &.&&+ &.&&+

!3.3'&3''''61 &.&&+ &.&&+

!3.3'&3''''(! &.&&+ &.&&+!3.3'&3''''8% &.&&+ &.&&+

!3.3'&3''''' &.&&+ &.&&+

!3.3'&3'''''% &.&&+ &.&&+

!3.3'&3'''''6 &.&&+ &.&&+

!3.3'&3'''''( &.&&+ &.&&+

!3.3'&3'''''8 &.&&+ &.&&+

!3.3'&3'''''' &.&&+ &.&&+

!3.3'&3'''''' &.&&+ &.&&+

!3.3'&% &.&&+ &.&&+

!3.3'&% &.&&+ &.&&+

!3.3'&% &.&&+ &.&&+

!3.3'&% &.&&+ &.&&+

!3.3'&% &.&&+ &.&&+

!3.3'&% &.&&+ &.&&+

8/19/2019 2B_4_TAREA1_U2

7/20

  efciente de resistencia es aproximadamente de 1.! kg"s

! 1& 1! & !

#atos de entrada m$

Et 1'.%8+

Ea ,A

-olumn #

8/19/2019 2B_4_TAREA1_U2

8/20

8/19/2019 2B_4_TAREA1_U2

9/20

#atos de entrada

m$ 8&.! it$ 16 1

g$ '.8

v$ %8 3

%

!

6

(

8

'

1&11

1

13

1%

1!

16

1(

18

1'

&1

3

%

!

6

(

8

'

3&

31

3

33

3%

3!

36

3(

38

Utilice el metodo de biseccion para deterrminatenga una velocidad de %& m"s despues de una

8/19/2019 2B_4_TAREA1_U2

10/20

3'

%&

%1

%

%3

%%

%!%6

%(

%8

%'

!&

8/19/2019 2B_4_TAREA1_U2

11/20

Xi f(Xi) Xf f(Xf)1& &.&(''%3(6 & 0'.'!63%!33

1! 1.'!616(&'( & 0'.'!63%!33

1! 1.'!616(&'( 1(.! 0%.3111!%'1'

1! 1.'!616(&'( 16.! 01.3(3&'&8%8!

1!.6! &.((63&&!' 16.! 01.3(3&'&8%8!

1!.6! &.((63&&!' 1!.'3(! 0&.!8%33(%(33

1!.6! &.((63&&!' 1!.(81! 0&.1816&!3!!

1!.(&31! &.&!&&'1!8 1!.(81! 0&.1816&!3!!

1!.(&31! &.&!&&'1!8 1!.(%18(! 0&.&('!66!&'6

1!.(&31! &.&!&&'1!8 1!.(6!6! 0&.&8!('!81!1!.(&31! &.&!&&'1!8 1!.(18'&6! 0&.&&3&!1&%(

1!.(&8&&(81! &.&&'(&&(3 1!.(18'&6! 0&.&&3&!1&%(

1!.(1&%%'188 &.&&333%(!& 1!.(18'&6! 0&.&&3&!1&%(

1!.(1166''1' &.&&&1%16(&( 1!.(18'&6! 0&.&&3&!1&%(

1!.(1166''1' &.&&&1%16(&( 1!.(18&(3% 0&.&&1%!%(31(

1!.(1166''1' &.&&&1%16(&( 1!.(11'(!&'(( 0&.&&&6!6!%1'

1!.(1166''1' &.&&&1%16(&( 1!.(118!&'8 0&.&&&!(%38!

1!.(1166''1' &.&&&1%16(&( 1!.(11(%61!8 0!.(88%!(%3E0&&!

1!.(11(&8&688 %.18''&%E0&&! 1!.(11(%61!8 0!.(88%!(%3E0&&!

1!.(11(&8&688 %.18''&%E0&&! 1!.(11((1%3 0(.''!8('(!E0&&61!.(11(1(6&!6 1.6'%8!&1&E0&&! 1!.(11((1%3 0(.''!8('(!E0&&6

1!.(11(3(% %.%(63&(8!E0&&6 1!.(11((1%3 0(.''!8('(!E0&&6

1!.(11(3(% %.%(63&(8!E0&&6 1!.(11(%(!81 01.(!'(866!E0&&6

1!.(11(3!661 1.3!86&%3E0&&6 1!.(11(%(!81 01.(!'(866!E0&&6

1!.(11(3!661 1.3!86&%3E0&&6 1!.(11(%161 0.&&(631!%E0&&(

1!.(11(386%1 !.(8(%866E0&&( 1!.(11(%161 0.&&(631!%E0&&(

1!.(11(%&131 &.&&&&&&18' 1!.(11(%161 0.&&(631!%E0&&(

1!.(11(%&131 &.&&&&&&18' 1!.(11(%&8(6 0!.88!13E0&&'

1!.(11(%&!&3 '.1!!3(!8%E0&&8 1!.(11(%&8(6 0!.88!13E0&&'

1!.(11(%&6' %.83%(3&E0&&8 1!.(11(%&8(6 0!.88!13E0&&'

1!.(11(%&(83 1.8%(%!3&3E0&&8 1!.(11(%&8(6 0!.88!13E0&&'

1!.(11(%&8' 6.'%66!(E0&&' 1!.(11(%&8(6 0!.88!13E0&&'

1!.(11(%&8!3 .&%(86(8E0&1& 1!.(11(%&8(6 0!.88!13E0&&'

1!.(11(%&8!3 .&%(86(8E0&1& 1!.(11(%&86% 0.8%&%!3(E0&&'

1!.(11(%&8!3 .&%(86(8E0&1& 1!.(11(%&8!8 01.31((!83!E0&&'

1!.(11(%&8!3 .&%(86(8E0&1& 1!.(11(%&8!6 0!.!6!1838(E0&1&

1!.(11(%&8!3 .&%(86(8E0&1& 1!.(11(%&8!% 01.(!8'%8!%E0&1&

1!.(11(%&8!3 1.%%16'11E0&11 1!.(11(%&8!% 01.(!8'%8!%E0&1&

 el coefciente de arrastre c necesario para que un paracaidista de macaida libre de t$ 1&s. ,ota /a aceleracion de la gravedad es de '.8

en esta celdaindicamos quellegamos a la

respuesta Desea  

8/19/2019 2B_4_TAREA1_U2

12/20

1!.(11(%&8!3 1.%%16'11E0&11 1!.(11(%&8!% 08.&(38'(11E0&11

1!.(11(%&8!3 1.%%16'11E0&11 1!.(11(%&8!% 03.3161&'!E0&11

1!.(11(%&8!3 1.%%16'11E0&11 1!.(11(%&8!3 0'.3('16%11E0&1

1!.(11(%&8!3 .!%6(1E0&1 1!.(11(%&8!3 0'.3('16%11E0&1

1!.(11(%&8!3 .!%6(1E0&1 1!.(11(%&8!3 03.%%81!''E0&1

1!.(11(%&8!3 .!%6(1E0&1 1!.(11(%&8!3 0%.!%(%(3!1E0&13

1!.(11(%&8!3 1.&3&86'(E0&1 1!.(11(%&8!3 0%.!%(%(3!1E0&131!.(11(%&8!3 .'13!E0&13 1!.(11(%&8!3 0%.!%(%(3!1E0&13

1!.(11(%&8!3 .'13!E0&13 1!.(11(%&8!3 0%.!%(%(3!1E0&13

1!.(11(%&8!3 .'13!E0&13 1!.(11(%&8!3 0%.!%(%(3!1E0&13

1!.(11(%&8!3 .'13!E0&13 1!.(11(%&8!3 0%.!%(%(3!1E0&13

1!.(11(%&8!3 .'13!E0&13 1!.(11(%&8!3 0%.!%(%(3!1E0&13

8/19/2019 2B_4_TAREA1_U2

13/20

Xm f(Xm) f(Xi)f(Xf) f(Xi)f(Xm)1! 1.'!616(&'( 0186.6!!8183! 38.666(!16'!

1(.! 0%.3111!%'1' 01(.8''8'18%6 08.3&1(%8!'&%

16.! 01.3(3&'&8%8! 08.3&1(%8!'&% 0.6%%&%6681'

1!.6! &.((63&&!' 0.6%%&%6681' &.%38!8%!

1!.'3(! 0&.!8%33(%(33 0&.31(3''' 0&.133&'&%!'%

1!.(81! 0&.1816&!3!! 0&.133&'&%!'% 0&.&%18%%%%%

1!.(&31! &.&!&&'1!8 0&.&%18%%%%% &.&&!1%8(6

1!.(%18(! 0&.&('!66!&'6 0&.&&%&(8!8 0&.&&1('&31'3

1!.(6!6! 0&.&8!('!81! 0&.&&1('&31'3 0&.&&&6%3&668

1!.(18'&6! 0&.&&3&!1&%( 0&.&&&6%3&668 06.86!1!!(%E0&&!1!.(&8&&(81! &.&&'(&&(3 06.86!1!6E0&&! &.&&&18(!%1

1!.(1&%%'188 &.&&333%(!& 0.'666&E0&&! 3.%&%6!'6E0&&!

1!.(1166''1' &.&&&1%16(&( 01.&1(%%6!E0&&! %.(%36!''E0&&(

1!.(18&(3% 0&.&&1%!%(31( 0%.3%3%8E0&&( 0.&6&''3&E0&&(

1!.(11'(!&'(( 0&.&&&6!6!%1' 0.&6&''E0&&( 0&.&&&&&&&'3

1!.(118!&'8 0&.&&&!(%38! 0&.&&&&&&&'3 03.6%(1%'(&&E0&&8

1!.(11(%61!8 0!.(88%!(%3&E0&&! 03.6%(1%'(E0&&8 08.&&!!&%(8E0&&'

1!.(11(&8&688 %.18''&%1!(E0&&! 08.&&!!&!E0&&' !.'3%''8(3%E0&&'

1!.(11((1%3 0(.''!8('(%'E0&&6 0.%%'!'E0&&' 03.3%'(&6%&E0&1&

1!.(11(1(6&!6 1.6'%8!&1&3!E0&&! 03.3%'(&6E0&1& (.1&&1''!E0&1&1!.(11(3(% %.%(63&(8!&6E0&&6 01.3!!1818E0&1& (.!866(&8%E0&11

1!.(11(%(!81 01.(!'(866%'E0&&6 03.!('&1'E0&11 0(.8((3%6('E0&1

1!.(11(3!661 1.3!86&%68E0&&6 0(.8((3%68E0&1 6.&('''181E0&1

1!.(11(%161 0.&&(631!3(E0&&( 0.3'&%86E0&1 0.(6886%68E0&13

1!.(11(386%1 !.(8(%86!'1E0&&( 0.(6886!E0&13 (.86&'13!!6E0&13

1!.(11(%&131 &.&&&&&&18' 01.161'1%&E0&13 1.&'3('863E0&13

1!.(11(%&8(6 0!.88!131(E0&&' 03.('%((8E0&1% 01.1163('E0&1!

1!.(11(%&!&3 '.1!!3(!83!E0&&8 01.116%E0&1! 1.(3&''!'E0&1%

1!.(11(%&6' %.83%(3&1(E0&&8 0!.3881331E0&16 3.'1638681E0&1!

1!.(11(%&(83 1.8%(%!3&3!&E0&&8 0.!&88('E0&16 (.'13%3&(6'E0&16

1!.(11(%&8' 6.'%66!6'&E0&&' 01.&8(6!3E0&16 1.16'&'3%(E0&16

1!.(11(%&8!3 .&%(86(8%!E0&1& 03.(&%!%6E0&1( 1.886'('%'E0&18

1!.(11(%&86% 0.8%&%!3(E0&&' 01.&%8(1(E0&18 0!.81%('681!E0&1'

1!.(11(%&8!8 01.31((!83%(E0&&' 0!.81%('68E0&1' 0.6'(8'%'E0&1'

1!.(11(%&8!6 0!.!6!18386'E0&1& 0.6'(8'E0&1' 01.13'3!(3'E0&1'

1!.(11(%&8!% 01.(!8'%8!%E0&1& 01.13'3!(E0&1' 03.6&1&(1&!E0&&

1!.(11(%&8!3 1.%%16'11&'E0&11 03.6&1&(1E0&& .'!1!!!363E0&1

1!.(11(%&8!% 08.&(38'(1&6E0&11 0.!3!86&(E0&1 01.16%&&66!&E0&1

a m$ 68.1 kg"s

 

a.

8/19/2019 2B_4_TAREA1_U2

14/20

1!.(11(%&8!% 03.3161&'%8E0&11 01.16%&&66E0&1 0%.(8&('6%(%E0&

1!.(11(%&8!3 0'.3('16%11E0&1 0%.(8&('6!E0& 01.3!18!8%(E0&

1!.(11(%&8!3 .!%6(11'E0&1 01.3!18!8E0& 3.636!6&%1E0&3

1!.(11(%&8!3 03.%%81!'86E0&1 0.36!8!%E0&3 08.6388%(38E0&%

1!.(11(%&8!3 0%.!%(%(3!&'E0&13 08.6388%(3E0&% 01.1%(&6686!E0&%

1!.(11(%&8!3 1.&3&86'66'E0&1 01.1%(&66'E0&% .!'883366E0&%

1!.(11(%&8!3 .'13!166E0&13 0%.68!&(E0&! 3.&&1%!('(E0&!1!.(11(%&8!3 & 01.3%(81%E0&! &

1!.(11(%&8!3 & 01.3%(81%E0&! &

1!.(11(%&8!3 & 01.3%(81%E0&! &

1!.(11(%&8!3 & 01.3%(81%E0&! &

1!.(11(%&8!3 & 01.3%(81%E0&! &

8/19/2019 2B_4_TAREA1_U2

15/20

f(xf)f(Xm) Ea01(.8''8'18%6 1%.'+

%&.&(!%836&61 (.6'+

!.'1'6'&!3(8 %.&&+

0&.31(3''' 1.'6+

&.8&3%8%3( &.''+

&.1&!'1(333 &.!&+

0&.&&%&(8!8 &.!+

&.&1%%681 &.1+

&.&&(3'((! &.&6+

8.(1'(!!E0&&! &.&3+0.'666E0&&! &.&+

01.&1(%%(E0&&! &.&1+

0%.3%3!E0&&( &.&&+

%.%38%%8(E0&&6 &.&&+

'.!!&'%&E0&&( &.&&+

&.&&&&&&16' &.&&+

1.%'&1(16E0&&8 &.&&+

0.%%'!3E0&&' &.&&+

%.68381&E0&1& &.&&+

01.3!!18E0&1& &.&&+03.!('&E0&11 &.&&+

1.%&(1&%E0&11 &.&&+

0.3'&%'E0&1 &.&&+

3.!33&&3E0&13 &.&&+

01.161'1%E0&13 &.&&+

03.('%(8E0&1% &.&&+

1.181!338E0&1! &.&&+

0!.388133E0&16 &.&&+

0.!&888E0&16 &.&&+

01.&8(6!E0&16 &.&&+

03.(&%!%3E0&1( &.&&+

01.&%8(E0&18 &.&&+

1.6(1!%%(E0&1( &.&&+

3.(%(!(&E0&18 &.&&+

(.333!6(!E0&1' &.&&+

'.(888(1E0&& &.&&+

0.!3!861E0&1 &.&&+

1.%&1!(&E0&& &.&&+

Este es nuestro criterio de paro eindicamos que 2emos llegado a el.

8/19/2019 2B_4_TAREA1_U2

16/20

8/19/2019 2B_4_TAREA1_U2

17/20

Venegas Vera Rigoberto 14400485 en esta ocasin nos tocotrabajar con el metodo de 4iseccion que seg5n lo que estube

investigando es el metodo numerico mas sencillo tambien conocido

como etodo de intervalo medio. 7a que en varias ocasionesestablecimos esa condicion $9:;88? /a cual nos dice talcondicion si la columna 8 es menos que cero entonces usa ota columna@ sino regresa a la siguiente. ambien establecimos un criterio de paro

del &.&1+ el cual nos indicaba que 2asta ese valor debemos de obtenerel mejor resultado.

DANIEL R!ER "ERRERA

4Bsicamente el EC#C #E 49E--9C, nos dice que todaDuncin contnua en un intervalo cerrado una veF que alcanFciertos valores en los extremos del intervalo entonces debealcanFar todos los valores intermedios.

8/19/2019 2B_4_TAREA1_U2

18/20

#omentario$ %e&ro Arman&o %aniagua 'rausto$140015

-mo @a lo 2emos visto anteriormente los mGtodosnumGricos deben ser precisos @ lo mas exacto posible con el

paso del tiempo se 2a logrado perDeccionar este objetivodebido a la avanFada tecnologa la cual con el uso de unatabla @ algoritmos que insertamos Drmulas @ datos de

entrada podemos realiFar de una manera realmente mu@rBpida. -omo en el caso de este ejercicio en el cual a base de

una tabla anterior aligeramos lo que sera la tabla deresultados.

  IRVIN ERARD RA!IRE* RDRI+E*

unabuena aproximacion intermedia puede serdesec2ada sin que nos demos cuenta. in embargoel metodo tiene la propiedad importantede que converge siempre a una solucion @ por estaraFon se usa Drecuentemente paraHponer en marc2aI a los metodos mas efcientes

8/19/2019 2B_4_TAREA1_U2

19/20

*A!,RAN !AR-INE* A."LE/ -reo que el gran diseJo de soDtKare como lo es en este

caso el Excell a llevado a los mGtodos n5mericos aperDeccionar tanto en velocidad como en precisin @ sonde gran a@uda para agiliFar el calculo de problemas

cotidianos o matematicos complejos.

INDIRA "ERNANDE* #RNA -uando se plantean problemas @ de ellos se sabe elnumero de multiplicidad si este n5mero es impar no esdiDcil de resolver @ podra resolverse con diDerentesmGtodos mientras que si el numero de multiplicidad espar es necesario el uso de mGtodos mBs complejos @ suanBlisis es mBs diDcil.

8/19/2019 2B_4_TAREA1_U2

20/20

  DAVID A+RE+I !EDELLIN El

mGtodo de la 4iseccin convergelentamente lo que genera lapropagacin de error por la cantidad deoperaciones e iteraciones necesariapara que el mGtodo converja.