Spreadsheet.ReplaceMDusingKNearestNeighborEx

This function replaces MD using k nearest neighbor method.

Syntax Parameters Return Value 
Function Spreadsheet.ReplaceMDusingKNearestNeighborEx( _
    CategoricalTargetVariables As Variant, _
    ContinuousTargetVariables As Variant, _
    CategoricalInputVariables As Variant, _
    ContinuousInputVariables As Variant, _
    KValue As Variant, _
    NumberOfExemplars As Variant, _
    Optional UseCaseWeights As Boolean = True, _
    Optional UseSpreadsheetSelCond As Boolean = True, _
    Optional selectionIncludeExpression As String, _
    Optional selectionIncludeList As String, _
    Optional selectionExcludeExpression As String, _
    Optional selectionExcludeList As String, _
    Optional CreateSpreadsheet As Boolean, _
    Optional Counts As Variant = -1) As Spreadsheet
  • CategoricalTargetVariables [in]

Type: Variant

  • ContinuousTargetVariables [in]

Type: Variant

  • CategoricalInputVariables [in]

Type: Variant

  • ContinuousInputVariables [in]

Type: Variant

  • KValue [in]

Type: Variant

  • NumberOfExemplars [in]

Type: Variant

  • UseCaseWeights [in,optional]

Type: Boolean

Default value: True

  • UseSpreadsheetSelCond [in,optional]

Type: Boolean

Default value: True

  • selectionIncludeExpression [in,optional]

Type: String

  • selectionIncludeList [in,optional]

Type: String

  • selectionExcludeExpression [in,optional]

Type: String

  • selectionExcludeList [in,optional]

Type: String

  • CreateSpreadsheet [in,optional]

Type: Boolean

  • Counts [in,optional]

Type: Variant

Default value: -1

Spreadsheet