Skip to content

predictstdev-dmx.md

Latest commit

 

History

History
53 lines (41 loc) · 1.52 KB

predictstdev-dmx.md

File metadata and controls

53 lines (41 loc) · 1.52 KB
title PredictStdev (DMX)
description PredictStdev (DMX)
ms.date 02/17/2022
ms.service sql
ms.subservice analysis-services
ms.topic reference
ms.custom dmx

PredictStdev (DMX)

[!INCLUDEssas]

Returns the predicted standard deviation for the specified column.

Syntax

  
PredictStdev(<scalar column reference>)

Applies To

A scalar column.

Return Type

A scalar value of the type that is specified by <scalar column reference>.

Remarks

If the column reference is discrete, PredictStdev returns 0 because the standard deviation cannot be calculated from discrete values.

Examples

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

See Also

Data Mining Extensions (DMX) Function Reference
Functions (DMX)
General Prediction Functions (DMX)