+0  
 
0
1
1380
4
avatar+564 

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

Best Answer 

 #2
avatar+128408 
+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.

 

 

cool cool cool

 Oct 27, 2015
edited by CPhill  Oct 27, 2015
edited by CPhill  Oct 27, 2015
 #1
avatar
0

No earthly idea!!!!

 Oct 27, 2015
 #2
avatar+128408 
+10
Best Answer

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.

 

 

cool cool cool

CPhill Oct 27, 2015
edited by CPhill  Oct 27, 2015
edited by CPhill  Oct 27, 2015
 #3
avatar+564 
+5

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

.__.

 Oct 27, 2015
 #4
avatar+118608 
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

3 Online Users

avatar
avatar