MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Vincent Stone on October 01, 1999 3:34 AM

What would be the best way to find the first derivative of a serie of (X,Y) data in EXCEL: dY/dX? Does it exist an add-in for this purpose?
Thanks in advance for your help.

Posted by Ivan Moala on October 02, 1999 3:43 AM

Try using the solver Addin. The Excel Solver uses the Generalized Reduced Gradient (GRG2) Algorithm for optimizing nonlinear problems. Derivatives (read:gradients as this is the derivitive of the
function dy/dx) play a crucial role in iterative methods in the Excel Solver. They provide clues as to how the adjustable cells should be varied.
Have a look @ it, you will need to set up a table
of values (known) to help it along.