Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sensitivity analysis | New Users to Excel | |||
Sensitivity analysis | Excel Worksheet Functions |