Perform calculations of bisection method with calculator:
MENU > 9 > f(x) = <equation> > Set appropriate rangeMENU > 8A1 with and B1 with C1 with the average of A1 and B1. You should use formula:
OPTN > 1 > (A1+B1)/2D1 by evaluating f(C1)E1, produce if D1 and produce 1 if D1 :
((D1/Abs(D1))+1)/2A2, produce C1 if E1 is , otherwise produce :
(1-E1)C1+E1A1B2, produce C1 if E1 is 1, otherwise produce B1:
E1C1+(1-E1)B1Note: 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: