________ is a decision support tool, often based on an Excel model, in which the user sets a target value for a particular variable, such as profit/ loss, and tells the program which variable to change to try to reach the goal.
A) Goal seeking analysis
B) Data harvesting
C) Market basket analysis
D) Data aggregation

Question

Quizplus · Accepted Answer

Goal seeking analysis is a decision support tool that helps in achieving a particular target value by changing the input variables of a model. The user sets a target value for a specific variable, and the program determines the input variables' values needed to reach that goal. This is often done using an Excel model or spreadsheet, and it is commonly used in finance and accounting to calculate the required inputs or actions to achieve a specific outcome, such as reaching a certain profit/loss target. Data harvesting, market basket analysis, or data aggregation are not similar to goal-seeking analysis and do not fit the given definition.

________ Is a Decision Support Tool, Often Based on an Excel