Serving the Quantitative Finance Community

 
User avatar
DanfferNR
Topic Author
Posts: 0
Joined: February 14th, 2002, 2:18 pm

Crystal Ball

February 27th, 2002, 5:32 pm

Hello every one. I am working with this simulation software an d I wonder how can I introduce the correlation in my simulation ?
 
User avatar
makarandb
Posts: 0
Joined: October 24th, 2004, 5:46 am

Crystal Ball

July 8th, 2005, 1:04 pm

can you plz send me some tutorial on crystall ball?
 
User avatar
wbenard
Posts: 1
Joined: April 8th, 2005, 1:17 pm

Crystal Ball

July 8th, 2005, 1:21 pm

when you specify your assumptions (you assign a probability distribution to a variable) there is a button 'correlation' there (or correl), there you can specify correlation, or let crystal ball calculate it.
 
User avatar
gjlipman
Posts: 5
Joined: May 20th, 2002, 9:13 pm

Crystal Ball

July 9th, 2005, 7:26 am

Alternatively, there is a menu item called correlation matrix tool, (on the right-most menu title) that lets you specify a region on your spreadsheet for the correlation matrix.
 
User avatar
wbenard
Posts: 1
Joined: April 8th, 2005, 1:17 pm

Crystal Ball

July 11th, 2005, 8:01 am

another question: when I let Excel calculate the correlations with the Data analysis toolpack, it gives other correlations then when I calculate them with Crystal Ball.Can anyone explain these differences?
 
User avatar
gjlipman
Posts: 5
Joined: May 20th, 2002, 9:13 pm

Crystal Ball

July 12th, 2005, 5:23 am

How are you calculating them with Crystal Ball? I've never calculated correlations using Crystal Ball.