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)