Updated: March 2, 2016
Returns the predicted standard deviation for the specified column.
PredictStdev(<scalar column reference>)
A scalar column.
A scalar value of the type that is specified by <scalar column reference>.
If the column reference is discrete, PredictStdev returns 0 because the standard deviation cannot be calculated from discrete values.
The following example uses a natural prediction join to determine whether an individual is likely to be a bike buyer based on the TM Decision Tree mining model, and also determines the standard deviation for the prediction.
SELECT [Bike Buyer], PredictStdev([Bike Buyer]) AS [Standard Deviation] FROM [TM Decision Tree] 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