Spreadsheet.MappedSubset

This property creates a mapped subset.

This property is read only.

Syntax Parameters Return Value 
ReadOnly Property Spreadsheet.MappedSubset( _
    Vars As Variant) As Object
 Vars [in]

The variables to map to the subset.

Type: Variant

Object

SVB Example

Analyzing a mapped subset: 

Option Base 1
Option Explicit
Sub Main
    Dim newanalysis As Analysis
    Set newanalysis = Analysis _
    (scBasicStatistics, ActiveDataSet.MappedSubset("1 6 41-43"))
    With newanalysis.Dialog
        .Statistics = scBasDescriptives
    End With
    newanalysis.Run
    With newanalysis.Dialog
        .Variables = "1"
        .PairwiseDeletionOfMD = True
        .DisplayLongVariableNames = False
        .ExtendedPrecisionCalculations = False
        .PlotMedianQuartileRange = False
        .PlotMeanSEAndSD = False
        .PlotMeanSD196TimesSD = True
        .PlotMeanSE196TimesSE = False
        .UserDefinedPercentiles = False
        .ValidN = True
        .Mean = True
        .Median = False
        .Mode = False
        .GeometricMean = False
        .HarmonicMean = False
        .ConfLimitsForMeans = False
        .Sum = False
        .StandardDeviation = True
        .Variance = False
        .StandardErrorOfMean = False
        .MinimumMaximum = True
        .LowerUpperQuartiles = False
        .Range = False
        .QuartileRange = False
        .Skewness = False
        .Kurtosis = False
        .StandardErrorOfSkewness = False
        .StandardErrorOfKurtosis = False
        .NormalExpectedFrequencies = False
        .KSAndLillieforsTestForNormality = True
        .ShapiroWilkWTest = False
        .UseNumberOfIntervals = True
        .NumberOfIntervals = 10
        .ConfidenceIntervalForMeansPlot = 95.000000
        .CompressedStemAndLeaf = False
    End With
    newanalysis.RouteOutput(newanalysis.Dialog.Summary).Visible = True
End Sub