by Kardi Teknomo

Share this: Google+

Finding Zeros Root of non linear equation using Excel

Suppose you want to find the root of this non-linear equation: Microsoft Excel Tutorials: Zeros of Non-Linear Function The graph of the function is exhibit in the figure below

Microsoft Excel Tutorials: Zeros of Non-Linear Function

From the picture above, we can guess that the root of the non-linear equation is between 0 and -2.

You can download free spreadsheet here

The steps by step procedure is as follow

1. Input the value of parameter a = 2 in cell B3. This is useful if you want to check the effect of parameter

2. Input initial value of x (you may guess any number) in cell B4

3. Type the non-linear equation in B5

Microsoft Excel Tutorials: Zeros of Non-Linear Function

4. From the menu of MS Excel, click Tools-Goal Seek and Goal Seek dialog show up.

5. Set cell B5 ( the non-linear equation ) to value 0 ( target value ) by changing cell $B$4 ( initial guess of x ) and click OK button.

Microsoft Excel Tutorials: Zeros of Non-Linear Function

6. The result is shown in the figure below. The root of the non-linear equation is -1.029. Inputting this root to the equation will make the value of f(x) = 0

Microsoft Excel Tutorials: Zeros of Non-Linear Function

See also:
Goal Seek Tutorial , MS Excel Tutorial index , Kardi Teknomo's Tutorial

Send your comments, questions and suggestions

This tutorial is copyrighted .

Preferable reference for this tutorial is

Teknomo, Kardi (2015) Obtaining zeros of non-linear equation using Microsoft Excel. http:\\people.revoledu.com\kardi\ tutorial\Excel\ZerosNonLinearEquation.html