CB.BootstrapND

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 14. CB.BootstrapND Parameters

Parameter

Required?

VBA Data Type

Table

Index

Required

Integer

Table 15

Index2

Optional

Integer

Table 16

Value

Optional

Variant

Table 17

Table 15. CB.BootstrapND Index Parameter –  Required, Integer

Named Constant Value

Index Value

Description

cbBtsChooseTarget

1

Sets the target forecast for the bootstrap operation (operates on the forecast in the currently selected cell)

cbBtsChooseDataRange

2

Selects the data values for the bootstrap operation (operates on the currently selected cell range)

cbBtsMethod

3

Used with Index2 to specify a bootstrap method

cbBtsAnalyze

4

Used with Index2 to set bootstrap analysis options

cbBtsPercent

5

Used with Index2 to specify percentile settings

cbBtsSample

6

Used with Index2 to set sample options

cbBtsForeOption

7

Used with Index2 to set forecast chart window display options

cbBtsRun

8

Runs the Bootstrap tool

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

Integern/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