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

Using Data Tables

A data table, or sensitivity table, summarizes the impact of one or two variables on formulas that use those variables. You can choose Data, Table to create two kinds of data tables: a table based on a single input variable that tests the variable's impact on more than one formula, or a table based on two input variables that tests their impact on a single formula.

Data Tables Based on One Input Variable

Suppose you're considering buying a house that requires you to take on a 30-year, $200,000 mortgage, and you need to calculate monthly payments on the loan for several interest rates. A one-variable data table, such as the one shown in Figure 18-1, can give you the information you need.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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