The next thing we're going to look at is one input, multiple output data tables. Again, we're only sensitizing on one variable. We're only looking at changes in the price. So again, our price is gonna range from 3 dollars 50 to 4 dollars 50, but this time we want to look at how three elements are affected. So we want to see what happens to revenue, so I'm gonna link my revenue in. We've gotta know what happens to the variable cost, so I'm gonna link that in as well.

And we want to know what happens to profit, so I'm also going to link that in also. So for this to work, again, we just need to select a range around the variable prices, the variable inputs and the outputs that we've already calculated. And we're going to use the shortcut. Now, before I used Alt DT, the official shortcut for this is Alt, A for data, W for what if analysis, and then for T table. But I think Alt DT is easier to remember. Okay, now let's look at row inputs and column input cells. Again, we're only sensitizing vertically. We're only sensitizing in this column, so we only need a column input cell. And as with our previous example, it's going to be the price. So hit enter, and you'll see that we get all of our output. So the revenue obviously will increase as we increase the price. The variable cost is gonna stay the same 'cause we haven't sensitized demand at all, and therefore our profit will also increase with price.