Sensitivity Analysis--Help

WYTT · Mar 7th, 2002, 01:07 PM

Question is: If there are 50 parameters( e.g. from 1 to 50), every paremeter will generate a different output, and I want to see the 50 different outputs in one worksheet. One way to solve the problem is to plug in the 50 paramenters one by one, run the equation one by one, and write down the output one by one. But I feel it is too tedious, Is there another way to do it?
Thanks a lot!

lenze · Mar 7th, 2002, 01:22 PM

Yes there is. You can use a Data Table. See help for Data Table. Select the topic "Create a one variable data table"

Mark W. · Mar 7th, 2002, 01:22 PM

See the Help Index topic for "Create a one-variable data table".

Mark W. · Mar 7th, 2002, 01:23 PM

Wooo! It's a tie

WYTT · Mar 11th, 2002, 07:37 AM

Sorry, Don't understand! Still have no idea how to generate a row or column oriented output. Also, because the output that I want is not only a simply formula, I used 10 worksheets for one output. Right now my question is there are 50 assumptions , one assumptions will generate one output, How can i do it easily? Thanks a lot

Mark W. · Mar 11th, 2002, 07:54 AM

Can you provide a sample of your data and formula(s)?

WYTT · Mar 11th, 2002, 08:34 AM

My input data is from "1% to 50% by 1% increment", also the output is supported by over ten worksheets(e.g, from A -B , then from B-C, .......From Y-Z, the output that I want is Z). Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 01:07 PM	#1
WYTT New Member Join Date: Mar 2002 Posts: 13	Question is: If there are 50 parameters( e.g. from 1 to 50), every paremeter will generate a different output, and I want to see the 50 different outputs in one worksheet. One way to solve the problem is to plug in the 50 paramenters one by one, run the equation one by one, and write down the output one by one. But I feel it is too tedious, Is there another way to do it? Thanks a lot!

Mar 7th, 2002, 01:22 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Yes there is. You can use a Data Table. See help for Data Table. Select the topic "Create a one variable data table"

Mar 7th, 2002, 01:22 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	See the Help Index topic for "Create a one-variable data table".

Mar 7th, 2002, 01:23 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Wooo! It's a tie

Mar 11th, 2002, 07:37 AM	#5
WYTT New Member Join Date: Mar 2002 Posts: 13	Sorry, Don't understand! Still have no idea how to generate a row or column oriented output. Also, because the output that I want is not only a simply formula, I used 10 worksheets for one output. Right now my question is there are 50 assumptions , one assumptions will generate one output, How can i do it easily? Thanks a lot

Mar 11th, 2002, 07:54 AM	#6
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Can you provide a sample of your data and formula(s)?

Mar 11th, 2002, 08:34 AM	#7
WYTT New Member Join Date: Mar 2002 Posts: 13	My input data is from "1% to 50% by 1% increment", also the output is supported by over ten worksheets(e.g, from A -B , then from B-C, .......From Y-Z, the output that I want is Z). Thanks.