The Bootstrap tool estimates the reliability (accuracy) of forecast statistics, process capability metrics, percentiles, and other sample data. This call runs the Bootstrap tool and displays results without using a dialog.
Note: | Before calling CB.BootstrapND, reset the Crystal Ball simulation. |
Table 15. CB.BootstrapND Index Parameter – Required, Integer
Table 16. CB.BootstrapND Index2 Parameter – Optional, Integer
Related Value | Named Constant Value | Index Value | Description |
---|---|---|---|
For Index = 3, cbBtsMethod: Integer | cbBtsMethodResample | 1 | Runs one simulation and resamples the data (faster but less accurate) |
For Index = 3, cbBtsMethod: Integer | cbBtsMethodMultiSim | 2 | Runs multiple simulations and creates diverse data (slower but more accurate) |
For Index = 4, cbBtsAnalyze: Integer | cbBtsAnalyzeStat | 1 | Analyzes distributions of statistics |
For Index = 4, cbBtsAnalyze: Integer | cbBtsAnalyzePercent | 2 | Analyzes distributions of percentiles |
For Index = 4, cbBtsAnalyze: Integer | cbBtsAnalyzeCapMetrics | 3 | Analyzes distributions of process capability metrics (only available if process capability metrics are activated on the Statistics tab of the Crystal Ball Run Preferences dialog or using the CB.RunPrefsND call |
For Index = 5, cbBtsPercent: Integer | cbBtsPercentTenNinety | 1 | Specifies the 10th and 90th percentiles |
For Index = 5, cbBtsPercent: Integer | cbBtsPercentFiveNinetyFive | 2 | Specifies the 5th and 95th percentiles |
For Index = 5, cbBtsPercent: Integer | cbBtsPercentQuartiles | 3 | Specifies quartiles (25%-ile increments from 0 to 100, inclusive) |
For Index = 5, cbBtsPercent: Integer | cbBtsPercentQuintiles | 4 | Specifies quintiles (20%-ile increments from 0 to 100, inclusive) |
For Index = 5, cbBtsPercent: Integer | cbBtsPercentDeciles | 5 | Specifies deciles (10%-ile increments from 0 to 100, inclusive) |
For Index = 5, cbBtsPercent: Integer | cbBtsPercentIcosatiles | 6 | Specifies icosatiles (5%-ile increments from 0 to 100, inclusive) |
For Index = 5, cbBtsPercent: Integer | cbBtsPercentCustom | 7 | Defines custom percentiles, supplied by an optional Value entry (a one-dimensional cell range containing percentiles). If Value is omitted, the default percentiles are 2.5, 5, 50, 95, 97.5. |
For Index = 6, cbBtsSample: Integer | cbBtsNumberSamples | 1 | Used with a Value entry to specify the number of bootstrap samples to use |
For Index = 6, cbBtsSample: Integer | cbBtsTrialsPerSample | 2 | Used with a Value entry to specify the number of trials to run for each bootstrap sample |
For Index = 7, cbBtsForeOption: Integer | cbBtsShowDefinedFore | 1 | Uses display settings for each forecast chart; the equivalent of the Show Forecasts As Defined dialog setting |
For Index = 7, cbBtsForeOption: Integer | cbBtsShowTargetFore | 2 | Shows only the target forecast; the equivalent of the Show Only Target Forecast dialog setting |
For Index = 7, cbBtsForeOption: Integer | cbBtsHideFore | 3 | Hides all forecasts; the equivalent of the Hide All Forecasts dialog setting |
Table 17. CB.BootstrapND Value Parameter – Optional, Variant
Related Value | Named Constant Value | VBA Data Type | Index Value | Description |
---|---|---|---|---|
For Index2 = cbBtsPercentCustom | A string containing a Microsoft Excel range that holds desired percentile values. The values must be entered into Microsoft Excel as numbers, not formatted as percentages; can be decimals. | String | n/a | Specifies custom percentile values to analyze |
For Index2 = cbBtsNumberSamples | A positive whole number | Integer | n/a | Number of bootstrap samples to use |
For Index2 = cbBtsTrialsPerSample | A positive whole number | Long Integer | n/a | Number of trials to run for each bootstrap sample |