Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

PredictStdev (DMX)

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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.