Question

Describe a time you have performed a what if-analysis.

Describe a time you have performed a what if-analysis.

Homework Answers

Answer #1

By using What if tool in Excel, you can use several different sets of values in one or more formulas to explore all the various results.

For Example, you can do what if analysis to build two budgets that each assumes a certain level of revenue. or you can specify a result that you want a formula to produce, and then determine what sets of values will produce that result. Excel provides several different tools to help you perform the type of analysis that fits your needs.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
4. What role can Excel play in decision making? 5. Describe a time you have performed...
4. What role can Excel play in decision making? 5. Describe a time you have performed a what-if analysis. 13. What are some of the file types that Excel supports?
Describe either: (1) a breach you have performed or (2) you have witnessed. What social norm...
Describe either: (1) a breach you have performed or (2) you have witnessed. What social norm was broken, and how did others react? (*You do not have to breach a social norm specifically for this paper, but you may. If so, make sure that it is legal and is not harmful to yourself and others. For example, you may attempt the breach from the book of challenging someone to a game of tic-tac-toe and then playing it incorrectly).
Describe what you would expect to observe in the lab if you performed Tollen’s tests on...
Describe what you would expect to observe in the lab if you performed Tollen’s tests on glucose and sucrose.
Think of three specific data analysis applications that deal with time series data and describe what...
Think of three specific data analysis applications that deal with time series data and describe what type of information could be learned by performing time series analysis on them.
The purpose of a sensitivity analysis performed on a cost effectiveness analysis is             A. to determine...
The purpose of a sensitivity analysis performed on a cost effectiveness analysis is             A. to determine the appropriate perspective of the study             B. to gauge the reliability of the study             C. to correct for inflation             D. to correct for time preference
Describe in one a few sentences one of the spiritual activities you performed and how it...
Describe in one a few sentences one of the spiritual activities you performed and how it made you feel—both during the activity and after. Describe in a few sentences details about the writings you chose or the acts of kindness or community service you performed (wellness)
Describe & discuss two items/concepts you have learned about impression evidence analysis?
Describe & discuss two items/concepts you have learned about impression evidence analysis?
What type of analysis is being performed if the following formula is used: [(Current Year -...
What type of analysis is being performed if the following formula is used: [(Current Year - Previous Year)/Previous Year] * 100 Horizontal Analysis Net Present Value Analysis Break-even analysis Vertical Analysis
Uses for Time Series Based on what you have learned, think of a use for time...
Uses for Time Series Based on what you have learned, think of a use for time series analysis and share it with the class.
Describe mobile marketing in detail. Discuss and describe a time where you have been reached by...
Describe mobile marketing in detail. Discuss and describe a time where you have been reached by mobile marketing and how it affected your behavior towards buying that product.