XLPack Solver – Univariate Nonlinear Optimization

Minimize the nonlinear function with single variable using Dfmin.

Let’s find the minimum point of the following example equation.

f(x) = x^3 – 2x – 5


The interval and output range (D7:F8 in this case) is the cell range for search interval [a, b] (input) and the minimum point x (output). Input a and b in the first and second columns of each row, and click “Compute”. Then the value of x between a and b minimizing f(x) will be computed and output to the third column of each line. If the row with a blank cell in the first or second column is encountered, the computation will be terminated even within the interval and output range.

The standard value of tolerance is 1.0e-8. The tolerance value will be set to Tol of Dfmin.


Please refer to here for “Save/Restore” button.

