I've looked in every book and .pdf that comes with CB 7 and can't find documentation for CB.xxx functions like CB.custom, CB.Normal etc. If you know the name...
Lee, There is a brief explanation of the CB functions in "CB7 User Manual.pdf" Appendix A "Using probability functions". It mainly refers you to the function...
These functions are described in the Developer Kit User Manual. Depends on the version you have as to which manual you want. To get the developer kit you...
Dear Lee I assume that you are running Crystal Ball professional 7.1. A full description of all the Crystal Ball functions can be found in the CB devkit...
Folks, I am finally getting around to porting spreadsheets which work just fine using CB5.5 to CB7. They contain a significant amount of VBA code which runs...
Matt- I just posted "Macro Syntax.xls" to the files section. The model and macros don't actually do anything other than display a message box, but it does...
I created an application in Visual Basic .NET. It essentially opens an Excel spreadsheet (that contains a model), populates it with the data and then runs the...
I want to use the binomial distribution to describe the likelihood of human cases of disease X can be ascribed to source Y, where the number of human cases is...
Hi Cerigdon, It becomes computationally unwieldy when n gets very large (because the binomial coefficients with large numbers can be huge), but there is no ...
CB probably has some numerical issue for big parameters. Use normal distribution instead with mean np and variance np(1-p) - by the central limit theorem this...
I don't know how the my alternative works with rare events and large samples, however, it is worth investigating. I have looked probabilities in a model and...
Hi Rachael, Even though the Beta distribution may give results that look alright, it is not the right distribution to use in the situation described below....
I've tried to load an evaluation copy of CB Pro on my Win XP x64 Professional machine. .NET 2.0 (x64) is installed, and CBPro won't install. Does it only...
Hello everyone, I've been working on a project that requires me to run CB, using the Macros menu in Run Preferences, and an executable Fortran code (as an...
Thomas, Crystal Ball 7.x is supported only on .NET Framework 1.1 SP 1 and the installer does check for the presence of .NET Framework 1.1 and 1.1 SP 1 at ...
Greeting All, I'm a novice and just found something that I don't understand. Why do I have different percentile results in my Forecast when I run the CB...
Arief, Syamsul
sarief@...
Nov 17, 2005 2:14 pm
1235
The only difference is at 30%. The lability of the value there is probably because the cumulative probability distribution has a stair-step at 30%, and any...
Eric & Martin, Thanks for the kind response. But sorry, for me it is still clear as mud. Either english is not my mother tounge, I must have poor statistic...
Arief, Syamsul
sarief@...
Nov 18, 2005 2:39 am
1237
The 30th percentile is defined to be the value where 30% of the cases are less than it. In your case, 30% of the cases are 0, and 70% of them are up in the...
Hi, I just joined this group, and was hoping that someone could help with a strange error I am seeing. I am trying to use OptQuest to arrive at the best...
All: I need to work with beta distribution, and I have the following question: I am treating a variable on which I know the mean (=20), the coefficient of...
Sanjay, For your first part, my experiences with the same error messages are usually related with errors in the EXCEL calculations: 1 - overflow - some figures...
Hi all, Assume I have a Crystal Ball model which evaluates the profit by a given formula. I can get all kinds of analysis using Crystal Ball. My problem is, I...
Hello Yiannis, Great question! We did the calculations for you and the correspondence between the four parameters you provide (Mean, COV, Min, Max) and Crystal...
Hi, ... Though they are not defined for all (formal) distribution functions, you can usually characterize a distribution function by various statistics like...
Hi, Martin, Thanks a lot for your explanation. Probably I didn't state my question clearly. I'd like to repeat my question here: Assume in my model, the profit...
Hi, ... Ok, you want to perform a sensitivity analysis. You probably have to modify your spreadsheet model slightly. Create separate cells for the parameters...
Hello, I have been a user of 5.2 for some time now, and I have a complex model that calls Solver on multiple worksheets (through a macro that then calls a...
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.
