• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 15. Data Analysis > What-If Analyses

What-If Analyses

If you're uncertain of some elements in your calculations, Excel provides tools you can use to play “what if?”

  • Data tables are used to calculate an equation with either one or two unknown variables. You provide the test values for each unknown variable. Excel then calculates the result(s) by substituting the test value(s).

  • Scenarios are saved sets of input values for one or more variables that can be substituted into an equation. For example, when calculating profit, you can see what happens if sales exceed expectations or if advertising costs rise dramatically.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint