mÉtodo de bisecciÓn en excel
TRANSCRIPT
8/16/2019 MÉTODO DE BISECCIÓN EN EXCEL
http://slidepdf.com/reader/full/metodo-de-biseccion-en-excel 1/2
MÉTODO DE BISECCION
A B pm f(a) f(b)1 1 4 2.5 -2 642 1 2.5 1.75 -2 14.1253 1 1.75 1.375 -2 3.109375
4 1.375 1.75 1.5625 -0.02539063 3.1093755 1.375 1.5625 1.4675 -0.02539063 1.377197276 1.375 1.4675 1.42175 -0.02539063 0.637176517 1.375 1.42175 1.394375 -0.02539063 0.29652023 1.375 1.394375 1.367175 -0.02539063 0.133260259 1.375 1.367175 1.30593 -0.02539063 0.0533635
10 1.375 1.30593 1.37792969 -0.02539063 0.013442111 1.37792969 1.30593 1.37939453 -0.005069 0.013442112 1.37792969 1.37939453 1.3766211 -0.005069 0.0040013 1.3766211 1.37939453 1.3790232 -0.00090212 0.00400
14 1.3766211 1.3790232 1.374521 -0.00090212 0.001552315 1.3766211 1.374521 1.3775366 -0.00090212 0.0003252216 1.3775366 1.374521 1.3779944 -0.000249 0.00032522
8/16/2019 MÉTODO DE BISECCIÓN EN EXCEL
http://slidepdf.com/reader/full/metodo-de-biseccion-en-excel 2/2
f(pm) f(a)!f(pm) f(pm)!f(b)14.125 -2.25 904
3.109375 -6.2175 43.9199219-0.02539063 0.0507125 -0.079497
1.37719727 -0.0349679 4.22222750.63717651 -0.0161731 0.77517750.29652023 -0.007523 0.1935730.13326025 -0.0033356 0.039514360.0533635 -0.00135493 0.00711123
0.0134421 -0.00035151 0.000737-0.005069 0.00014749 -.042E-0050.00400 -2.329E-005 5.5500E-005
-0.00090212 5.2401E-006 -3.616E-0060.0015523 -1.401E-006 6.2251E-006
0.00032522 -2.934E-007 5.0500E-007-0.000249 2.6025E-007 -9.32E-001.356E-005 -5.295E-009 5.9696E-009