Share via


PredictCaseLikelihood

Used only with clustering models. This function returns the likelihood that an input case will fit within the existing model.

Syntax

PredictCaseLikelihood([NORMALIZED|NONNORMALIZED])

Applies To

Models that are built by using the Microsoft Clustering and Microsoft Sequence Clustering algorithms.

Return Type

Double-precision floating point number.

Remarks

By default, the result of the PredictCaseLikelihood function is normalized.

Examples

The following example returns the likelihood that the specified case will occur within the clustering model, which is based the Adventure Works DW database.

SELECT

PredictCaseLikelihood()

From

[TM Clustering]

NATURAL PREDICTION JOIN

(SELECT 28 AS [Age],

'2-5 Miles' AS [Commute Distance],

'Graduate Degree' AS [Education],

0 AS [Number Cars Owned],

0 AS [Number Children At Home]) AS t

See Also

Reference

Data Mining Extensions (DMX) Function Reference
Functions (DMX)
Mapping Functions to Query Types (DMX)

Other Resources

Data Mining Algorithms

Help and Information

Getting SQL Server 2005 Assistance