CB.DataAnalysisND Example

This example resets the Crystal Ball simulation and fits all distributions to a columnar data set in cells B1 through D100 (including a header row). Forecast charts automatically appear when the simulation runs. They are fitted to a distribution. The selected ranking method is Chi-square. The last line of code runs the Data Analysis tool.

CB.ResetND
' Select data in cells B1 through D100
CB.DataAnalysisND cbDataAnalysisSelectData, "B1:D100"
' Set input range orientation (data in columns)
CB.DataAnalysisND cbDataAnalysisDataOrientation, cbDataAnalysisDataInColumns
' Input range has headers
CB.DataAnalysisND cbDataAnalysisSelectHeaders, True
' Automatically open forecast charts
CB.DataAnalysisND cbDataAnalysisAutoOpenCharts, True
' Fit to distribution
CB.DataAnalysisND cbDataAnalysisFitToDistribution, True
' Select the Chi-square ranking method
CB.DataAnalysisND cbDataAnalysisRankingMethod, cbFitChiSquare
' Run tool
CB.DataAnalysisND cbDataAnalysisRun