Export (0) Print
Expand All

PredictCaseLikelihood

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


PredictCaseLikelihood([NORMALIZED|NONNORMALIZED])

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

Double-precision floating point number.

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

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

Community Additions

ADD
Show:
© 2014 Microsoft