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 solver program will write the value of x into the variable value cell (B6 in this case). The function value cell (B7 in this case) must contain the formula to compute f(x) from x. To solve this example, the formula is =B6^3-2*B6-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.
The cell ranges can be specified as larger than required. In that case, only the necessary range will be used from left upper corner.
Please refer to here for “Save/Restore” button.
When “Help” button is clicked, this page will be displayed if the network connection is available.
The “?” button of right upper corner will not work correctly. Please use “Help” button.