Numerical Methods - The Newton-Raphson Method to Solve Mechanical Design Problems Part II

In the previous post , we talked about several root finding techniques. In this post, we're going to see how we can use Microsoft Excel VBA to find the roots using Newton-Raphson Method. As we know that Newton-Raphson Method is the most widely used of all root-locating formulas. The Newton-Raphson method uses the slope ( first derivative ) of the function to find the root. That means, in the VBA code, we have to find the first derivative of the function in order to find the root. We already have the VBA code to find the first derivative and we're going to use it again in Newton-Raphson Method. The Newton-Raphson Method uses 2 terms of taylor series to approximate delta x as shown below. f(x) = f(x 0 ) + (x N - x 0 )f'(x 0 ) = 0 (x N - x 0 )f'(x 0 ) = -f(x 0 ) x N - x 0 = -f(x 0 )/f'(x 0 ) delta x = -f(x 0 )/f'(x 0 ) The followings are the procedure to find the root using Newton-Raphson Method. Guess the initial value of the root --> sele...