Bisection Method Calculator in Excel

The setup of the bisection method is about doing a specific task in Excel. With the bisection method, we are going to find the root of a given function.

The bisection method allows you to find the root of any function in a given search interval. In this Excel tutorial you will calculate guesses, middle point and error.

Finding roots

They present the function and two possible roots.

two possible roots

Make some assumptions.

assumptions

Place three different roots beside the guesses.

three roots

In addition to F(c), enter Error.

error

Decide the value that should be accurate besides the error.

value

Calculating bisection method

In the cell under f(a) (1), type in =2*exp(a6)-5*a6+2 (2).

formula

Note: The 2 in front of the formula in this step is the one we placed at the beginning.

Drag the small square from f(a) to f(c).

drag square

Click on the cell below the error, type =ABS(B6), and then hit enter.

abs function

Click under the cell with 3 in it (1), and type in =IF (G6=3;1(true);0(false)) (2), and then press enter.

if function

Mark the row with values in it.

mark row

Click on the small square showing on the right lower corner, and keep dragging it down until the value under 3 stably shows 1.

drag down

The bisection method is set up. I hope you like this Bisection method example.