+0

# Newton Method excel sheet?

0
854
4

Hey guys.. I just finished doing this project for my calculus class where I had to use excell to create an algorithm that found iterations of a function until its zero was found. I figured out the algorithm and how to input it in excell. The only problem I have now is that there is a second part of the assignment where I have to "Explain approximating zeros using tangent iterations and the connection of computer algorithm algebraically and graphically".

I have no idea what to write, could someone guide me into the right direction please?

Oct 27, 2015
edited by chilledz3non  Oct 27, 2015
edited by chilledz3non  Oct 27, 2015

#2
+10

Here's a good explanation of this.......http://tutorial.math.lamar.edu/Classes/CalcI/NewtonsMethod.aspx

Basically, we're picking [ guessing] some point on a curve, drawing a tangent line to the curve at that point, and then using the coordinate  of the x intercept of this tangent line as our next "guess."  Then, we repeat the process to get the next x-intercept point, etc. As long as the derivative exists in each case [ and is non-zero ], we should arrive at a pretty good approximation of the solution to our function  after several iterations.   Oct 27, 2015
edited by CPhill  Oct 27, 2015
edited by CPhill  Oct 27, 2015

#2
+10

Here's a good explanation of this.......http://tutorial.math.lamar.edu/Classes/CalcI/NewtonsMethod.aspx

Basically, we're picking [ guessing] some point on a curve, drawing a tangent line to the curve at that point, and then using the coordinate  of the x intercept of this tangent line as our next "guess."  Then, we repeat the process to get the next x-intercept point, etc. As long as the derivative exists in each case [ and is non-zero ], we should arrive at a pretty good approximation of the solution to our function  after several iterations.   CPhill Oct 27, 2015
edited by CPhill  Oct 27, 2015
edited by CPhill  Oct 27, 2015
#3
+5

Omg.. thank you so much CPhill, you're a lifesaver

.__.

Oct 27, 2015
#4
0

Hi chilledz3non,

I am interested in how you did your excel.  Did you do it over a number of cells down the page. Each one referencing the one before and preceeded by an if statement?

Oct 27, 2015