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