Print PDF
Favorite
Email
Step 3Let excel do the work
We're going to let excel take care of all the guesswork for us. In your spreadsheet you're going to need 3 columns. One for your x-values, one for your function, and one for its derivative.
In cell A1 put in your guess for one of the zeroes. In cell B2 put in your equation as a function of cell A1 (shown in the picture.) In cell C1 put in your derivative as a function of A1.
In cell A2 type in "=A1-B1/C1" this is the equation I showed you a couple steps earlier. Now drag all three cells down 10 or so spaces. The last cell in column A should be your root. To check your answer, make sure that the last cell in column A matches the next to last cell. If any of the numbers are different, drag all three cells down even further. Congrats, there's the first root.
In cell A1 put in your guess for one of the zeroes. In cell B2 put in your equation as a function of cell A1 (shown in the picture.) In cell C1 put in your derivative as a function of A1.
In cell A2 type in "=A1-B1/C1" this is the equation I showed you a couple steps earlier. Now drag all three cells down 10 or so spaces. The last cell in column A should be your root. To check your answer, make sure that the last cell in column A matches the next to last cell. If any of the numbers are different, drag all three cells down even further. Congrats, there's the first root.
| « Previous Step | Download PDFView All Steps | Next Step » |
 |
Add Comment
|
