Good day everyone! I was wondering if anyone has been running CB on a Mac, specifically OSX. I am currently using MS Excel for Mac, but I don't know if CB...
While we know that we could run CB5 and CB7 on the same machine, has anyone been successful at running CB7 with both Excel 2003 and 2007 on the the same...
Bill, We test Crystal Ball in environments in which multiple versions of Microsoft Excel are installed and have not seen any problems that should impact your...
Hello I've done a Monte Carlo simulation which gives a non-normal distribution (beta distribution). I would assume that this means that the capability metrics...
You can control how CB calculates the capability metrics for non- normal distributions through the run preferences. The options are available on the...
Hi all, I'm not very Excel-conversant and need your help on a (probably stupid) question... I'm using the old CB 2000 and am now trying to run a macro during ...
Donna, What is the exact name of the macro that you're entering into the Run Preferences dialog? If you have any spaces in the workbook or worksheet names,...
I am trying to find the parameters of a truncated (or bound) distribution. I am running CB 11.1.1..I truncate my distribution bygoing to Preferences --- then...
Hi Eric W. and all, Thanks very much! By trial and error (and trying to decipher the macro's syntax), I finally discovered 2 reasons I could not get the macro...
Hello, Couple of things: 1. What you are doing right now (Preferences -> Chart -> Axis etc.), does not truncate the distribution. It just truncates the graph...
I would like to amend the question. The route I previously wrote Preferences -- Chart -- Axis -- Scale -- Fixed only deals with the formatting the x-axis, not...
Hi Serap, With regards to your question on how to get the parameters of the truncated distribution, the following: When you fit a Weibull distribution to your...
Not sure if you have noticed the previous email, but here are some inputs: 1. CB distribution fitting does not fit to truncated distributions. Huybert's...
Hi Guys, I'm using the CB Predictor for predicting Weekly Revenue based on 9 Years historical weekly revenue data. Until Q3-2008 I had great accuracy in terms...
Using past data to project future results only works if you have reason to believe that the future will be like the past. If you think we are in different...
Hi Milos: Eric has a good point... I would add that you may have to build an econometric model to figure out what your upcoming demand will be based on what is...
I think this is a good time for researching on a good econometric model, as Eric suggests. You might want to consider a few macroeconomic industry-specific...
I have been wondering what types of statistical distributions this group is using in their simulations... It seems that I tend to use the triangular...
JCR, Great questions. A common way we tend to explain distributions is that there are distributions that are typically used to (1) model 'expert opinion' and ...
Those that know me will have wondered why it has taken me so long to respond to this. The basic philosophy I use is to use the "simplest" distribution that ...
To Bill's arguments I would add one test that I've used many times when a subject-matter-expert tells me, "We have no idea other than the endpoints; therefore,...
Uniform distribution does has its function in real physical situation. Suppose you need to model the imbalance force of a rotating fan which is a vector...
First and foremost, many thanks to all of you for your responses! Bill's answer got me thinking, and I must confess I never really gave a deep, hard thought...
This seems like a simple question but I cant find the answer: How do you enter a custom continuous distribution, such as f(x) = 3x^2 for 0<x<1? Thanks...
Jeffrey, Although it indeed sounds like a simple question, the answer is not that easy to find (you have to use the Custom Distribution in a very special way)....
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 ...
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.
