which feature more elaborate form of Goal seek
Answers
Answer:
In computing, goal seeking is the ability to calculate backward to obtain an input that would result in a given output. This can also be called what-if analysis or back-solving. It can either be attempted through trial and improvement or more logical means. Basic goal seeking functionality is built into most modern spreadsheet packages such as Microsoft Excel.
According to O'Brien and Marakas,[1] optimization analysis is a more complex extension of goal-seeking analysis. Instead of setting a specific target value for a variable, the goal is to find the optimum value for one or more target variables, given certain constraints. Then one or more other variables are changed repeatedly, subject to the specified constraints, until you discover the best values for the target variables.
The detailed feature of Goal Claim is:
- Solver is a Goal Seek extension tool.
- Solver is a Feasibility tool if you follow the Goal search solution, it is a detailed version of Goal Seek.
- The only difference between Goals and Solver claims is that the Solver interacts with statistics with many unknown values.
- Using the Search Policy option under the Tools menu, you can find out which values will produce the desired result.
- Target seeking is a common term used to describe the process involved in determining the value of your input based on an already known output value.