Sensitivity Analysis to 2 variables
 

Hi All:

I was wondering if someone could help me with this. I created a model that
returns an output- the sum of the profits from 12 months. The profit for
each month depends upon 2 variables which I keep in 2 cells which I have
given names- churn and month_churn_begins. I would like to create a table
which will have on the horizontal "Axis" different churn rates and on the
vertical "axis" different month_churn_begins values. For each combination of
churn rate and month_churn_begins value I would like to put in the sum of the
profits. Is there any way I can plot a formula into the values of this table
so that I don't have to manually change the 2 variables and copy each
sumofprofits output by hand into the table?

Any help would be greatly appreciated.

Sensitivity Analysis to 2 variables
 

You could set it up via the menu: Data Table ..

Try this illustrative sample from my archives:
http://savefile.com/files/46276
2 variable data table example.xls

Keep it all on the same sheet ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"steve-o" wrote:
Hi All:

I was wondering if someone could help me with this. I created a model that
returns an output- the sum of the profits from 12 months. The profit for
each month depends upon 2 variables which I keep in 2 cells which I have
given names- churn and month_churn_begins. I would like to create a table
which will have on the horizontal "Axis" different churn rates and on the
vertical "axis" different month_churn_begins values. For each combination of
churn rate and month_churn_begins value I would like to put in the sum of the
profits. Is there any way I can plot a formula into the values of this table
so that I don't have to manually change the 2 variables and copy each
sumofprofits output by hand into the table?

Any help would be greatly appreciated.