cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
uday_guntupalli
Level VIII

Goal Seek in JMP

Hello All, 

           Is there an explicit function that performs goal seek in JMP similar to Excel ? A previous thread on the community seems to suggest use of Minimize and Maximize function,. Can someone provide an example? 

Best
Uday
1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson
Community Manager Community Manager

Re: Goal Seek in JMP

The desirability functions in the Profiler provide the optimization that you're looking for.

pr_profiler-3.png

 

The Target desirability will allow you try to match a specific value.

Target_NoLoc.gif

 

The optimization routines underlying the profiler are the same ones used in the Maximize and Minimize and LPSolve JSL functions but using the Profiler, even through JSL, may be more straightforward than calling the functions directly. 

-Jeff

View solution in original post

1 REPLY 1
Jeff_Perkinson
Community Manager Community Manager

Re: Goal Seek in JMP

The desirability functions in the Profiler provide the optimization that you're looking for.

pr_profiler-3.png

 

The Target desirability will allow you try to match a specific value.

Target_NoLoc.gif

 

The optimization routines underlying the profiler are the same ones used in the Maximize and Minimize and LPSolve JSL functions but using the Profiler, even through JSL, may be more straightforward than calling the functions directly. 

-Jeff