Look at the textbook "Financial Modeling" by Simon Benninga. I understand it is used in some university programs. You can work the exercises at the end of...
In addition, the textbook "The Oxford Guide to Financial Modeling" by Ho and Lee, could be an interesting reference. There are also on-line courses offered by...
Hi, I am a Crystal Ball 2000 user. I had installed Crystal Ball in my Laptop running with Windows XP Home Edition and Office 2000 Premium without any problem. ...
Alejandro, What version of Crystal Ball 2000 do you have? It is possible it is no longer compatible with you system. I will assist you in getting Crystal Ball...
Hello, I have created a model and have specified a LSL & USL for the forecast. My spec limits are x.xxx, 3 decimal places. My forecast rounds it to two...
Hello, Normally Crystal Ball uses your Cell format. You can check this when you have the forecast chart open by going to the Preferences > Chart menu item and...
I am trying to evaluate CB Predictor as a business forecasting tool. Looking at the Predictor options I see confidence intervals but not prediction intervals....
Brian, They are one of the same! Cordially, Heath Dugger Discover innovative applications and learn the latest techniques Attend the Crystal Ball User...
Heath, Thanks for responding. I may be confused but I always understood that confidence intervals pertained to means, while prediction intervals pertained to...
Brian, Could you provide your simulation approach in Splus? Thanks Frank Feuquay Special Valuations FPL Energy 700 Universe Blvd Juno Beach, FL 33408 (561)...
Brian, Your definitions are correct. In CBPredictor there is no setting for prediction intervals. Cordially, Heath Dugger Discover innovative applications and...
Heath, I've been using the HoltWinters and predict functions in the R stats package (I'm cheap). In Minitab I use the Winters' method for time series. Brian ...
Confidence intervals are different from prediction intervals. In a very general sense, and crudely, CI's measure the confidence you may have in measures of...
Heath, What are the chances of getting prediction intervals implemented in CB? Failing that, I suppose we could calculate the intervals if we understood the...
In CB 5.5 Developers' Toolkit, you can use the spreadsheet function =CB.GetForePercentFN( assumption, percentile ) to extract any given percentile of an...
Brian, I will look into it and get back to you next week some time. Cordially, Heath Dugger Discover innovative applications and learn the latest techniques ...
Hi Eric, Thanks. I'll try that. If that doesn't provide prediction intervals I'll try CB.GetForeStat. Should be able to get there one way or another. Brian ...
I have taken this example from Cliff Ragsdale book, on how to use OptQuest. I am not able to run it here, OQ just pops up a message saying that an unexpected...
I am trying to use the 140 demo that comes with Cliff Ragsdale book, using Windows Xp and Excel XP. The problem is that in some computers it doesn't install,...
Brian, I have forwarded this request to our services team for review. I noticed that an answer had come in from another user. Did that answer your question? ...
Ahhh... not quite. What Eric meant to say was CB.GetAssumPercentFN(assumption,percentile) Any formula using CB.GetFore... works on the forecast cells and not ...
Brian, You are correct, Predictor develops confidence intervals around the means of the forecast. I don't know what the chances of having prediction intervals...
Bill, ????? I'm trying to get prediction intervals on the forecasts in CB Predictor. Brian ... a ... implemented ... if ... prediction ... my ... available ......
Does anyone have a document or URL for a straightforward mechanism to calculate the inverse hypergeometric distribution. I'm looking for something similar to...
Jim, If you're looking for an Excel solution try googling "inverse hypergeometric excel". e.g. http://members.aol.com/iandjmsmith/Examples.xls has VBA macros....
Hello, I'm a new member and just started using Crystal Ball for my research. I'm trying to run a simulation but Excel locks up for some reason after a couple...
Hi Jim, Actually, one can fairly easily construct an Inverse Hypergeometric Distributions in Excel and Crystal Ball, using Crystal Ball's Custom distribution. ...
Derek, Crystal Ball will run everything that is open, including multiple workbooks. You can use the freeze feature and disable some of the CB expressions: Go...
I am currently trying to upgrade a model from version 5.5 to version 7.2. The model is 40MB+. I am using the EnumAssum and EnumFore devkit functions to list...