Hi there, I would like to capture in a forecast the result that generates my spreadsheet after running 100 trials. I thought that I could use the filter...
Hi Daniel, Your question is not totally clear, but I think a useful way for you to better understand your forecasts (for example the first 100 trials or the ...
Hi Huybert, I think you gave me a VERY GOOD IDEA!. In my model I have many forecast. I need to capture some of them at every trial while others, I just need to...
Huybert, In your reply to Daniel, you mentioned Bayesian Inference and it would be great if you could give me some guidance on how I could use CB to do...
Hi Marcelo, Just a quick intro to Bayesian inference before answering your question; Bayesian Inference is an extremely powerful statistical technique, based...
Hi all, i am working on a risk optimization project for a process where 10,000 transactions are processed in a day and i have aroung 20 risks...the occurence...
Sampling without replacement adds a lot of complexity, and, offhand, it's not clear that this truly represents your situation. If you can define a set of...
Just to add to Eric's comment - sampling without replacement is represented by the Hypergeometric process, instead of the Binomial process. In other words, the...
Just to add to Eric's comment - sampling without replacement is represented by the Hypergeometric process, instead of the Binomial process. In other words, the...
thanks eric and huybert, i agree to you that the risks would follow a binomial distribution. however, the problem is there are 10-15 diff. types of risks which...
Hi Vibdor, Thanks for clarifying your question - your question is about "adding a random number of random variables". First, the number of transaction is ...
I am using CB5.2 with EXCEL 2002. I would like to execute some macros while the similation is running with the option "EXCEL minimized" enabled. It appears to...
Hi, I just started using CB and I have CB.7. premium edition. Since I am brand new to this list I apologize in advance if the following question has already...
Nezih Altay, I assume you mean that you have thousands of time-series and you like to forecast demand for spare parts, is this correct? If my assumption is not...
Huybert, thank you very much for your reply. I am not trying to forecast demand but trying to understand which distribution or distributions would represent...
Hi Nezik, Automatic distribution fitting is certainly possible with CB. If you go to Run >> Tools >> Batch Fit, an easy to follow 3-step wizard will guide you ...
Hi *Huybert ,* I have a related question. Do you know how to use weights in distribution fitting in Crystal Ball? For example, if I have two variables, one is...
Hi Younping, To my knowledge, you can not use the Crystal Ball distribution fitting wizard (either for one dataset or the Batch-fit for several datasets at ...
Hi *Huybert ,* ** Thank you so much for your reply. I studied the example "Weibull complete with weights.xls" and believe this is exactly what I want. However,...
Hi Yongping, Glad it helped and was what you were looking for. I hope others find it useful too. To use the names "Data" and "Weight" in a formula, you...
Hello, I've been trying to develop a model in Crystal Ball for the past few months and as I've added more complexity to the model it has become more unwieldy...
Huybert, thank you so much. The "Batch Fit" wizard was exactly what I was looking for. You made my day... Nezih ... you go to ... guide you ... will ... of fit...
I am using the crystal ball to analysis the design capability, and I am trouble to define the distribution of the parameter. For example: I am trouble to find...
Is there a way to do a goodnes of fit using a custom distribution and model data ?. Also , I am defining a Benford distribution as a custom one, can I include...
I want to use the Crystal ball result data, How to find out the result data when I completed the simulation. I mean the result should be generated by the data...
Hi I'm a french new user of CB 7. I have to apply an internship in a lab for my school of engineering. My work is about ecotoxicity and I have to test...
Good Afternoon All I have a query about the use of precision control in determining the nubmer of trials I need to run in a simulation. I have set the ...
Bonjou Julien, Je pense que I should continue in English. I believe what you have is an Excel problem not a CB, but you will certainly use CB to obtain the...
I know the function SMALL in Excel but I don't know how to perform a randomization with CB. The 4th smallest data must be randomized many times for 14 data out...