Newton Raphson Method in Excel and VBA | NMS Video 09

This video is about the solution of the Newton-Raphson Method in excel and visual basic (VBA) to find the root of the non-linear equation. The tutorial consists of:

1. Theory of Newton Raphson Method
2. Solution of Newton Raphson Method in Excel
3. Solution of Newton Raphson Method in VBA

Download starter file

The final expression of the Newton-Raphson method can be written as:

The solution steps can be summarized as:

1. Choose a guess value x.
2. Find the value of f(x) and f’(x).
3. Estimate the next value of x using the given equation and calculate the function value.
4. If x is not the root of f(x) then repeat steps 2 & 3 until f(xi) = 0 within specified accuracy.

Please like and follow us on:

• Facebook: https://www.facebook.com/Chemiopedia
• Instagram: https://www.instagram.com/chemiopedia
• LinkedIn: https://www.linkedin.com/company/chemiopedia

Join the Facebook group for interactive learning: https://www.facebook.com/groups/363925814761994

For any queries please write: Support@chemiopedia.com