It's documented on pages 157-158 of the Developer Kit manual. I'm not sure that it's what you want since it appears to return the correlation coefficient that...
Jim is correct. I was just about to say the same thing. If you want to run correlations on forecast data sets, extract the forecast data and use the Excel...
In fact, I need to get the correlation between two forecast cells ( a way to force Crystal Ball to memorize the data), each forecast cell is the result of a...
I have a system of non-linear equations that I need to solve to generate the result (y). I can set up the system of equations and solve using excel's solver...
hi all members i am a new member in this group. i hope to be in contact wih all of u. i am an instractor at the faculity of engineering. my master interested...
I am trying to set a forecast cell's Display Range Preferences via VBA code to define the display range for the forecast in cell "C7" to use the fixed...
I think you need to make the range preferences one line: cb.RangePrefsND cbRngUseFixed, 0, 100, True should work. Jim McBurney mcburnjc@... ... From:...
I installed student version of CB on XP office 2003. CB tool bar is grayed out. The only two items not grayed out on the Crystal Ball tool bar are Run...
Tim, Not sure what the problem with office 97 is but I think I can explain the behavior in office 2003. Specifically, I believe you need to check your ...
It must be there somewhere, but am dammed if I can find it. Can anyone point me as to where I can find help/descriptions of the Crystal Ball functions you can...
Hello Paul, I use the Developer Kit manual which came with my Crystal Ball 2000 documentation. There are a large number of CB.Functions described in this ...
I attended a CB user conference this summer put on by Decisioneering at which they presented a preview of version 7.0 (there will be no version 6.x). The...
... spreadsheet ... I have done the same thing with a "Goal Seek" macro (haven't tried it yet with a solver macro) and the one thing I found is that you have ...
Since your macro works fine by itself, this may not be the problem, but one possiblity is that you need to recompile Solver in your macro. Choose Tools>...
Hi All, I'm interested to know the feature difference between Crystal Ball and ProcessModel. Please share the information. Thanks in Advance. Best Regards, ...
Bikash Jain
bjain@...
Sep 28, 2004 12:43 pm
950
I am trying to make a correlation matrix , but all I get are ampty cells. Even using the demo file give me same results. Any coments ? Jorge Degetau...
If I'm understanding the problem correctly, you're getting a matrix but all the cells are blank. If so, this is as it should be. You must populate the matrix...
Jorge, Nick is correct. Once you manually enter the coefficients into the matrix, they are automatically entered into the correlation dialog for the given...
I would throw out one caution to what Nick wrote: be careful about entering zeroes in correlation matrices (and definitely do not fill the matrix with zeroes...
Thank you for you advice, now i understand what I was doing wrong. Jorge ... <http://us.ard.yahoo.com/SIG=129rt26dc/M=298184.5285298.6392945.3001176/D=gr ... ...
Patrick, ... The latter is in general wrong. The following 3x3 correlation matrix provides an example with B correlated to A and C correlated to A, while B and...
I stand corrected. If the correlation coefficients are weak enough, everything Arcady says is true - it is entirely possible for CB to arrange the selected...
Hi all! I am currently trying to define assumptions for my spreadsheet in VBA. The problem I face is that I obviously can't use the macros since Excel doesn't...
Hi Jamie, thank you for your help. Unfortunately, I have already tried it. Somehow I can't establish the reference to the crystal ball module. It is not...
A quick way to set a reference to CB is to do the following: 1) Mark the CB in the Add-Ins 2) Goto the VBA Editor 3) Select the Project Explorer 4) You should...
Hi, my name is Rurik Magos, I'm trying to forecast interest rates and other economic variables using CB Predictor. But I'm getting very "sine-like" projected...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
