+0

Newton Method excel sheet?

0
387
4
+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?

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

#2
+78618
+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
Sort:

#1
0

No earthly idea!!!!

Guest Oct 27, 2015
#2
+78618
+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
+564
+5

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

.__.

chilledz3non  Oct 27, 2015
#4
+91001
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?

Melody  Oct 27, 2015

7 Online Users

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.  See details