IntenseDebate - jcmendez

15 years ago @ Product Reviews Net - PlayStation Move Revie... · 0 replies · +4 points

Got mine on Friday after being very disappointed with Amazon Prime pre-ordering. The sports champions games are very engaging and responsive. I'll be buying another 2 controllers soon because the experience is much better. Not cheap, but overall a great platform. For sure we'll see games that were just not possible in the past.

15 years ago @ 8020world | Tools for ... - Tornado Charts in Exce... · 0 replies · +1 points

John - I use the regular text tool on Excel

15 years ago @ 8020world | Tools for ... - Tornado Charts in Exce... · 0 replies · +1 points

Ola Hugo. Obrigado pela messagem.

I'm not sure what you mean by saying that the bar with value 4 is bigger than the one with value 6 (do you mean as "value" the delta?), but I can assure you the example is fully correct as of how a tornado chart for sensitivity analysis of a model should look like.

There are other charts named tornado, and they are used to compare two statistical distributions. You can see examples on Peltier's pages http://peltiertech.com/WordPress/tornado-charts-a... -- from your comment I'm guessing this is what you are trying to do, and in that case, you only invert the category of one axis.

For the type of tornado chart that I'm showing, only one horizontal scale is used and all the values shown by the bars are a comparison against the "base case" (7 in the example). Then you read each bar as the variation versus the base case when a parameter changes.

JCM

15 years ago @ 8020world | Tools for ... - Easy creation of torna... · 0 replies · +1 points

Tony - the tornado chart does not have anything to do with how simple, sophisticated, "hard coded" or flexible is your analysis.

It is more about visualization of your results. Although I've seen tornadoes used in engineering/technical settings, the focus of what is presented here is managerial decision making, so keeping it simple with 4-5 key sensitivities works best *in that context*

In many cases, behind one of these charts there is a deep analysis using large models, and techniques like Monte-Carlo analysis. In others, the key sensitivities are determined by experience with a few subject matter experts. At the end, what is important is to find the appropriate level of analysis to support the required decision.

Hope it helps

15 years ago @ http://mal.isi.ma/ - mal.isi.ma | malisima ... · 0 replies · +1 points

Testing

16 years ago @ 8020world | Tools for ... - Adding a script menu t... · 0 replies · +1 points

I recently uploaded a video on this topic: <a href="http://www.youtube.com/watch?v=fcWhlAYL_Kw" target="_blank">http://www.youtube.com/watch?v=fcWhlAYL_Kw

16 years ago @ 8020world | Tools for ... - Tornado Charts in Exce... · 0 replies · +1 points

@guillaume - You are right - the tornado shows independently the effects of each assumption. Unfortunately there isn't a one-size-fits-all for combining the assumptions. I've used Monte Carlo simulation as an effective way to show these "combined effects". That usually requires your audience to be very familiar with modeling, the particular problem, and you doing a good job at communicating the analysis in a simple way. Usually I try to "peel back" the root-cause analysis when assumptions are not too orthogonal. Conversely, when two assumptions are too coupled, I just show one of them in the tornado and verbally mention the second one, explaining why in fact they are considered together.

16 years ago @ 8020world | Tools for ... - Tornado Charts in Exce... · 0 replies · +1 points

Hi - when you choose "set the Axis Labels menu to Low" (end of step 4) the labels should move to the left

16 years ago @ 8020world | Tools for ... - Adding a script menu t... · 0 replies · +1 points

You are getting this error likely because the location of ascript on my example is different from yours. Try running which ascript on the terminal, so you can see where your ascript is installed.

16 years ago @ 8020world | Tools for ... - Tornado Charts in Exce... · 2 replies · +1 points

Just added them to make clear to the audience the values on the assumptions that change the results

IntenseDebate Comment System

Connect with jcmendez

My blogs/sites

People I'm following

jcmendez