Spreadsheet.SubsetSystematicRandomSampling

This property creates a new spreadsheet containing the specified subset of the current spreadsheet using Systematic Random Sampling.

This property is read only.

Syntax Parameters Return Value 
ReadOnly Property Spreadsheet.SubsetSystematicRandomSampling( _
    Variables As Variant, _
    sampleSize As Integer) As Spreadsheet
  • Variables [in]

Which variables to subset.

Type: Variant

  • sampleSize [in]

Type: Integer

Spreadsheet

SVB Example

Creating a (systematic) random sample: 

Option Base 1
Option Explicit
Sub Main
    Dim spr As Spreadsheet
    'assigns the active spreadsheet to the object spr
    Set spr = ActiveSpreadsheet
    'Create a new spreadsheet to hold the subset
    'Returns the subset of vars 7-10, with about every 8th case
    Dim S2 As New Spreadsheet
    Set S2 = spr.SubsetSystematicRandomSampling("7-10", 8)
    s2.Visible = True
End Sub