how to create a two variable data table

Question

Create a two-variable data table that will calculate the average cost per call in the data table for each level of total call minutes logged and at each average cost per minute.

I will put a spreadsheet on 4share if u need to see it but I am unsure what to put in the row input cell and column input cell

Answer 1

Hi,

Follows these steps:

1. In cell D6, type =B14
2. Select D6:G14 and go to Data > Whatif Analysis > Table
3. In the row inout cell, select cell B13
4. In the row inout cell, select cell B9

When you click on OK, the data table will be populated with the average cost per call

Hope this helps.

Answer 2

For a relevant tutorial, download the "Sensitivity Analysis Using Excel" PDF file from the Chapters page at www.TreePlan.com. In that document, refer to the model in section 2.1 and the two-variable data table in section 2.4.

-  Mike Middleton

TreePlan Software, http://www.TreePlan.com

Decision Tree, Sensitivity, and Simulation Add-Ins for Excel

Answer 3

You are welcome.

Answer 4

thank u!!!!!!!!

Answer 5

http://www.4shared.com/file/tMx21G6e/ExcelL2_C5_A4.html