0
In Excel is Goal Seek usually a faster approach to reach desired data results than a what-if analysis?
Wiki User
∙ 10y ago
They are not really for the same thing. Goal Seek is used to find a specific value that makes a formula give a particular result. It gives just one single result. If you have a formula that you need to give a particular result and a value for another cell used by that formula needs to be changed to get that result, then you use Goal Seek to obtain that value. Goal Seek is used to look for a single result rather than to give many results.
What-If Analysis has a much broader purpose. It is designed to see what results you get when you use different values for the same set of formulas. It could be doing things like seeing how much profit you can make by paying different pay rates and using different amounts of staff and selling different amounts of products at different prices. So it can be used with many values and many formulas. Goal Seek can be used as part of What-If Analysis.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
How is probability represented?
Usually as a fraction or ratio. (desired results) : (all results)
Case study?
Case studies are a type of content that showcases a company’s work with a past customer, usually with a focus on statistics that prove the company achieved the desired results.
What are the advantages of analog system and digital system?
An analog system is usually simple requiring few components and gives results almost instantlyA digital system gives repeatable results with no drift or temperature sensitivity that can be as precise as desired
How do you go about doing decile analysis?
Decile analysis usually groups the customers into 10 percent categories by margin or revenue. Usually the graphs that have the different trends are usually analyzed during the decile analysis.
What is a quantitative analysis approach?
Steps of the Quantitative Analysis Approach Defining the Problem: The First Step in the quantitative approach is to develop a clear, concise statement of problem . this statement will give direction and meaning to the following steps. In many cases defining the problem is most important and most difficult step. Developing a Model: An important part of the quantitative analysis approach is the modeling, model is a representation usually mathematical of the situation. Models can save time and money in decision making and problem solving. Acquiring Input Data: Once we have developed a model we must obtain the data that are used in the model (input data). Obtaining accurate date for the model is essential, improper data will result in misleading results. Collecting accurate data can be one of the most difficult steps in performing quantitative analysis. Developing a Solution: Developing a solution involve manipulating the model to arrive at the best optimal solution to the problem that is practical and can be implemented, this requires that an equation to be solved for the best decision. Solving equations is a common technique. Testing the Solution: Before a solution can be analyzed and implemented it needs to be tested completely because a solution depends on the input data and the model, both requires testing. Testing the input data and the model includes determining the accuracy and completeness of the data used by the model. Analyzing the Results: Analyzing the results starts with determining the implications of the solution. Implementing results often requires change in an organization, the impact of actions or changes needs to be studied and understood before implementation.Implementing the Results: The final step is to implement the results, this is the process of incorporating the solution into the organization. The optimal solution will hundred of Bahraini dinars and it will help the users manage dedicated time more efficiently
What is metallurgical analysis?
Metallurgical analysis is the examination of metal, usually to detect cracks and weaknesses.
What does in Encroach?
Similar to approach but usually refers to vegetation
What is bromatological analysis?
Bromatological analysis is the chemical evaluation of the matter usually concerning nutrients or molecules of nutritional interest.
How a improvisation is usually situation centered?
Approach focusing on a situation
When does the results of Delf A1 usually come?
after 40 days usually
Bulging of exterior wall usually results in?
bulging of exterior walls usuall results in
What is piecemeal approach?
A piecemeal approach is an approach that is used in the problem solving process. Solving problems one piece at a time to come up with a resolution. This approach is usually frowned upon when developing a safety program. Safety professionals tend to recommend converting from a piecemeal approach to a systems approach.
