Glossary Term | Glossary Definition |
---|---|
A rule that specifies how to solve a particular problem. | |
An estimated value or input to a spreadsheet model. | |
A value cell in a spreadsheet model that has been defined as a probability distribution. | |
The value in a Crystal Ball assumption, decision variable, or forecast cell at the start of a simulation. | |
Cumulative distribution function that represents the probability that a variable will fall at or below a given value. | |
In a trend chart, a graphic depiction of a particular certainty range for each forecast. | |
The percentage of values in the certainty range compared to the number of values in the entire range. | |
The linear distance for the set of values between the certainty grabbers on the forecast chart. | |
A measure of relative variation that relates the standard deviation to the mean. Results can be represented in percentages for comparison purposes. | |
A probability distribution that describes a set of uninterrupted values over a range. In contrast to the discrete distribution, the continuous distribution assumes there is an infinite number of possible values. | |
In Crystal Ball, a dependency that exists between assumption cells. | |
A number between -1 and 1 that specifies mathematically the degree of positive or negative correlation between assumption cells. A correlation of 1 indicates a perfect positive correlation, minus 1 indicates a perfect negative correlation, and 0 indicates there is no correlation. | |
A chart that shows the number or proportion (or percentage) of values less than or equal to a given amount. | |
A Crystal Ball variable in the model that you can control. | |
Cells that contain the values or variables that are within the control to change. The decision variable cells must contain simple numeric values, not formulas or text. | |
Another name for a spreadsheet model which yields single-valued results. | |
A probability distribution that describes distinct values, usually integers, with no intermediate values. In contrast, the continuous distribution assumes there is an infinite number of possible values. | |
The linear distance for the set of values displayed on the forecast chart. | |
A relationship between distributions in which one distribution's values for all percentile levels are higher than another's. See also subordinate. | |
The linear distance from the minimum forecast value to the maximum forecast value. | |
A statistical summary of the assumptions in a spreadsheet model, output graphically or numerically. | |
Cells that contain formulas that refer to one or more assumption and decision variable cells and combine the values in the assumption, decision, and other cells to calculate a result. | |
The forecast name and parameters assigned to a cell in a Crystal Ball dialog. | |
A process by which Crystal Ball discards forecast values outside or inside a specified range. | |
A formula that has been defined as a forecast cell. | |
A value calculated by the forecast formula during an iteration. These values are kept in a list for each forecast, and are summarized graphically in the forecast chart and numerically in the descriptive statistics. | |
A cell that contains a mathematical formula. | |
The number of times a value recurs in a group interval. | |
A chart that graphically summarizes a list of values by subdividing them into groups and displaying their frequency counts. | |
A set of mathematical tests performed to find the best fit between a standard probability distribution and a data set. | |
A control that lets you use the mouse to change values and settings. | |
A subrange of a distribution that allows similar values to be grouped together and given a frequency count. | |
A three-step process in which Crystal Ball generates random numbers for assumption cells, recalculates the spreadsheet model or models, and displays the results in a forecast chart. | |
The measure of the degree of peakedness of a curve. The higher the kurtosis, the closer the points of the curve lie to the mode of the curve. A normal distribution curve has a kurtosis of 3. | |
In Crystal Ball, a sampling method that divides an assumption's probability distribution into intervals of equal probability. The number of intervals corresponds to the Minimum Sample Size option available in the Run Preferences dialog. A random number is then generated for each interval. Compared with conventional Monte Carlo sampling, Latin Hypercube sampling is more precise because the entire range of the distribution is sampled in a more even, consistent manner. The increased accuracy of this method comes at the expense of added memory requirements to hold the full Latin Hypercube sample for each assumption. (See Setting Sampling Preferences.) | |
The familiar arithmetic average of a set of numeric observations: the sum of the observations divided by the number of observations. | |
The Standard Deviation of the distribution of possible sample means. This statistic gives one indication of how accurate the simulation is. | |
The value midway (in terms of order) between the smallest possible value and the largest possible value. | |
That value which, if it exists, occurs most often in a data set. | |
The overall effect that a change in an assumption cell produces in a forecast cell. This effect is solely determined by the formulas in the spreadsheet model. | |
A system which uses random numbers to measure the effects of uncertainty in a spreadsheet model. | |
Values generated during a simulation on the extreme end of a distribution that are excluded from the display range. | |
Probability density function that represents the probability that an infinitely small variable interval will fall at a given value. | |
A system whose output is a distribution of possible values. In Crystal Ball, this system includes a spreadsheet model (containing mathematical relationships), probability distributions, and a mechanism for determining the combined effect of the probability distributions on the model's output (Monte Carlo simulation). | |
(Classical Theory) The likelihood of an event. | |
A set of all possible events and their associated probabilities. | |
A mathematically selected value which is generated (by a formula or selected from a table) to conform to a probability distribution. | |
A method implemented in a computer program that is capable of producing a series of independent, random numbers. | |
The difference between the largest and smallest values in a data set. | |
A method whereby assumption values are replaced with their ranking from lowest value to highest value using the integers 1 to N prior to computing the correlation coefficient. This method allows the distribution types to be ignored when correlating assumptions. | |
A value, not necessarily between 0 and 1, that indicates probability when used in a proportion. | |
A chart that shows the number or proportion (or percentage) of values greater than or equal to a given amount. | |
The uncertainty or variability in the outcome of some event or decision. | |
The first number in a sequence of random numbers. A given seed value produces the same sequence of random numbers every time you run a simulation. | |
The amount of uncertainty in a forecast cell that is a result of both the uncertainty (probability distribution) and model sensitivity of an assumption cell. | |
The computation of a forecast cell's sensitivity with respect to the assumption cells. | |
An asymmetrical distribution. | |
A distribution in which most of the values occur at the upper end of the range. | |
A distribution in which most of the values occur at the lower end of the range. | |
The amount a curve differs from a normal, symmetrical distribution. The greater the degree of skewness, the more points of the curve lie to either side of the peak of the curve. A normal distribution curve, having no skewness, is symmetrical. Skewness is computed by finding the third moment about the mean and dividing by the cube of the standard deviation. | |
Any spreadsheet that represents an actual or hypothetical system or set of relationships. | |
The square root of the variance for a distribution. A measurement of the variability of a distribution, i.e., the dispersion of values around the mean. (See formulas in the discussion of standard deviation in the Oracle Crystal Ball Reference and Examples Guide.) | |
A relationship between distributions in which one distribution's values for all percentile levels are lower than another's. See also dominant. | |
A three-step process in which Oracle Crystal Ball generates random numbers for assumption cells, recalculates the spreadsheet model or models, and displays the results in a forecast chart. | |
The number of times a given experiment is repeated. | |
A cell that contains a simple numeric value. | |
A quantity that can assume any one of a set of values and is usually referenced by a formula. | |
The square of the standard deviation; i.e., the average of the squares of the deviations of a number of observations from their mean value. Variance can also be defined as a measure of the dispersion, or spread, of a set of values about a mean. When values are close to the mean, the variance is small. When values are widely scattered about the mean, the variance is large. (See formulas in the discussion of variance in the Oracle Crystal Ball Reference and Examples Guide.) | |
Memory which uses the hard drive space to store information after you run out of random access memory. Virtual memory supplements the random access memory. | |
a Microsoft Excel file composed of at least one worksheet. | |
a Microsoft Excel file in which you work and store the data. A worksheet is part of a workbook. |