how to create a two variable data table

Question

how to create a two variable data table

Anonymous

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

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Ashish Mathur 101.9K Volunteer Moderator

Hi,

Follows these steps:

In cell D6, type =B14
Select D6:G14 and go to Data > Whatif Analysis > Table
In the row inout cell, select cell B13
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.

0 comments

Answer accepted by question author

Anonymous

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

0 comments

4 additional answers

Answer 1

Ashish Mathur 101.9K Volunteer Moderator

You are welcome.

0 comments

Answer 2

Anonymous

thank u!!!!!!!!

0 comments

Answer 3

Anonymous

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

0 comments

Share via

how to create a two variable data table

4 additional answers