Chapter 9

Working with Data Analysis Tools

Create a Data Table

If you want to study the effect that different input values have on a formula, one solution is to set up the worksheet model and then manually change the formula’s input cells. For example, if you are calculating a loan payment, you can enter different interest rate values to see how this affects the payment.

The problem with this method is that you see only a single result at one time. A better solution is to set up a data table, which is a range that consists of the formula you are using and multiple input values for that formula. Excel automatically creates a solution to the formula for each different input value.

Create a Data Table

Type the input values:

To enter the values ...