Part IV: Managing and Analyzing Data
FIGURE 31.8
Preparing to create a two-input data table
- Specify B5 as the Row input cell (the response rate) and B4 as the Column
input (the number mailed).
- Click OK. Excel fills in the data table.
Figure 31.9 shows the result. As you can see, quite a few of the combinations of response
rate and quantity mailed result in a loss rather than a profit.
FIGURE 31.9
The result of the two-input data table
As with the one-input data table, this data table is dynamic. You can change the formula in
cell E4 to refer to another cell (such as gross profit), or you can enter some different values
for Response Rate and Number Mailed.
