---
Created: 2024/07/13 21:06
---
# Using calculator

Perform calculations of bisection method with calculator:

1. Use table to find $x_0$ for $f(x) \lt 0$ and $x_1$  for $f(x) \gt 0$: 
   `MENU` > `9` > f(x) = \<equation\> > Set appropriate range
2. Open spreadsheet:
   `MENU` > `8`
3. Fill `A1` with $x_0$ and `B1` with $x_1$
4. Fill `C1` with the average of `A1` and `B1`. You should use formula:
   `OPTN` > `1` > `(A1+B1)/2`
5. Fill `D1` by evaluating f(`C1`)
6. For `E1`, produce $0$ if `D1` $\lt 0$ and produce 1 if `D1` $\ge 0$:
   `((D1/Abs(D1))+1)/2`
7. For `A2`, produce `C1` if `E1` is $0$, otherwise produce $A1$:
   `(1-E1)C1+E1A1`
8. For `B2`, produce `C1` if `E1` is 1, otherwise produce `B1`:
   `E1C1+(1-E1)B1`

Note: For step 4, 6, 7, and 8, consider providing an appropriate range as well. E.g., up-to 13th row.
Note 2: To view values of arbitrary significant digits, update `Number Format` to `Fix`, and `Spreadsheet` > `Show Cell` to `Value`.

---

References:

-