Set up a spreadsheet that implements the secant method and thensolves each of the problems. Use the graph of each function toselect an initial guess. Recall the iteration formula for thesecant method: X^k+1=x^k-[f(x^k)/f(x^k)-f(x^k-1)](x^k-x^k-1)
Put the formula for the function under the heading f(xk-1) andf(xk). In the cell under xk+1, put the secant method iterationformula. In the second row, replace the previous xk-1 with xk andthen xk with xk+1. Now copy the two formulas down one row. At thispoint, one iteration of the secant method is displayed. To see moreiterations, just copy the second row down for as many iterations asdesired. If too many iterations are copied and the functiondifference becomes exactly zero, a divide by zero error willappear.
a. f(x) x-x^1/3-2
b.f(x)=xtanx-1
c.f(x)=x^4-e^x+1
d.f(x)x^2e^x-1
