Hi Huybert- What do you think about this alternative solution: Set one cell up as U(0,1) and another has a formula based on setting U = F(x) and solving for X....
Hi Jeff, Thanks for the email - that would indeed work very well in this situation. This is in fact the way that CB generates random numbers from most of its ...
How do I get Crystal Ball to provide the mode of the forecast distributions? In the summary statistics the mode is shown as "-". Greg Greg Pelletier Department...
Hi Greg, Crystal Ball doesn't provide the mode of the forecast distributions if the forecasts are continuous because the estimate of the mode is quite...
If you had any continuous distributions on the input side, the probability of getting the exact same output value more than once is essentially nil. Since the...
Am I correct in assuming that the input parameters for the "Define Assumptions" for a Lognormal distribution are the arithmetic mean and standard deviation...
The default options are arithmetic, although the inputs can be changed to either geometric or log via the Parameters menu in the distribution window when...
Hi, Greg, It is true that the mode of data has little use and can be ambiguous or misleading. Further, we know that outputs of simulation models are presented...
Can someone provide an explanation of how Crystal Ball is calculating the "contribution to variance in the sensitivity charts? The CB help and also model...
Hi Greg, Great question. You are right, that is indeed the way that Crystal Ball calculated the Contribution to Variance. To make it easier to understand/see,...
I have two columns of data. The leftmost column is my variable of interest which is continuous (e.g., income), the other is the weight to be given to the...
I am trying to perform a Crystal Ball simulation that models a securities portfolio's performance over a 30-year period. The portfolio contains 7 asset...
Hi Amy, Thank you for the email. If you follow the exact procedure you described below, the mean of the Custom Distribution (with the two columns) should be ...
Hi Huybert, Thank you for your reply. The sum of the weights is 1 and I have been running 50,000 iterations. So I'm at a loss. I am using CB 7.0 on Excel...
Your question is not very clear. Expected value for each assumption is given my the mean of the assumptions you have defined. Expected value of the forecast...
Hi Bolowu, I think what you mean was "how do I calculate the mean, given the min, ML and max?" That's not very hard, and the formula's are as follows (see...
Hi everyone, I'm glad to be a member of the group. I have a problem with the sensitivity analysis of my landfill carbon footprint model. I have a macro that...
Is there any documentation of the algorithm that CB uses to generate random values from bounded or truncated normal or lognormal distributions? Does CB simply...
It would be an interesting compromise between practicality and "correctness" if CB does as you say. I would refer to your algorithm as "imposing a limit"....
Hi Greg, Eric J. gave a good description between the two possible approaches. CB uses the second approach to sample the underlying distribution conditionally...
My colleagues and I are experiencing somewhat erratic behavior with the extreme speed setting in Crystal Ball: the run speeds seem to vary dramatically at...
Yup, I have a macro that I want to do the same as you with called do_max_volume ... I used a legacy function (used to be in an older version of Crystal Ball)...
Jim, Others may come in with more technical advice, and I hope they do, but generally I advise people to stick with normal mode if they have look-ups or tables...
Thanks Bill ... I like the joke: CB never says Extreme Speed is extremely fast. I hope our students like that as well ... there are about 375 in our class...
Hi Jim, Thanks for uploading the CB model, that helps. I had a look at the model and agree with Jim - I would recommend running the model in Normal Speed,...
Hi Jim, I also took a look at your retirement model. The Data Table function was a fairly recent addition to Extreme Speed in CB 7.3. Due to the way Extreme...
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.
