PredictHistogram
The PredictHistogram function returns a table representing a histogram for prediction of the given column.
Syntax
PredictHistogram(<scalar column reference> | <cluster column reference>)
Applies to
A scalar or cluster column reference.
Return Type
Table
Remarks
A histogram generates statistics columns. The column structure of the returned histogram depends on the type of column reference used with the PredictHistogram function.
Scalar Columns
For a <scalar column reference>, the histogram returned by the PredictHistogram function consists of the following seven columns:
- The column being predicted
- $Support
- $Variance
- $Stdev (standard deviation)
- $Probability
- $ProbabilityVariance
Microsoft® SQL Server™ 2000 Analysis Services data mining algorithms do not support $ProbabilityVariance. This column always contains 0.
- $ProbabilityStdev
Analysis Services data mining algorithms do not support $ProbabilityStdev. This column always contains 0.
- $AdjustedProbability
The $AdjustedProbability column is an Analysis Services extension to the OLE DB for Data Mining specification.
Cluster Columns
The histogram returned by the PredictHistogram function for a <cluster column reference> consists of the following columns:
- Cluster (represents the cluster identifier)
- $Distance
- $Probability
- $Support