Spreadsheet.RecodeOutliers

Recode outliers.

Syntax Parameters Return Value 
Function Spreadsheet.RecodeOutliers( _
    Optional InputVariables As Variant, _
    Optional OutputVariables As Variant, _
    Optional VariableTypes As Variant, _
    Optional TestTypes As Variant, _
    Optional Parameters As Variant, _
    Optional RecodeTypes As Variant, _
    Optional Values As Variant, _
    Optional MarkTypes As Variant, _
    Optional Iterations As Integer = 1, _
    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 CopyFormatting As Boolean = False, _
    Optional CreateSpreadsheet As Boolean = True, _
    Optional ByRef Counts As Variant) As Spreadsheet
  • InputVariables [in,optional]

Type: Variant

  • OutputVariables [in,optional]

Type: Variant

  • VariableTypes [in,optional]

Type: Variant

  • TestTypes [in,optional]

Type: Variant

  • Parameters [in,optional]

Type: Variant

  • RecodeTypes [in,optional]

Type: Variant

  • Values [in,optional]

Type: Variant

  • MarkTypes [in,optional]

Type: Variant

  • Iterations [in,optional]

Type: Integer

Default value: 1

  • 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

  • CopyFormatting [in,optional]

Type: Boolean

Default value: False

  • CreateSpreadsheet [in,optional]

Type: Boolean

Default value: True

  • Counts [in,optional]

Type: Variant

Spreadsheet