**Select menu: Spread | Calculate | Random Subset**

Use this to create new spreadsheets based on a random subset/sample of rows from a spreadsheet.

- After you have imported your data, from the menu select

**Spread | Calculate | Random Subset**.

## Number of samples

Specify the number of random samples to be used. Alternatively, you can provide a percentage of the number of rows to be used by selecting the % option. Note that if **Sample with replacement** option is selected, then the number of samples must be less than the number or rows in the spreadsheet (or 100 %).

## Sample with replacement

When selected, sampling with replacement will be used when forming the subset. That is at each random selection of a row, all the available rows are eligible for selection. If this option is not selected then only the rows that have not been previously selected are eligible for selection.

## Weighting

If a column in the dropdown list is selected, then the values in the selected column will be used in a weighted random sample. The default is the setting, where all rows have equal chance of being selected. Rows with a weight value ≤ 0 will not be included in the random sample.

## Seed

The Seed option is used to specify an integer value that will be used to start the randomization. If a value of * is given for the seed, a value from the computer’s clock will be used.

## Create unique column names

When selected, columns in the spreadsheet will have new names generated for them so that they are unique, otherwise the columns will have the same names as the original spreadsheet.

## Randomize rows

When selected, rows in the resulting spreadsheet will be sorted into a random order.

## Add to book

This lists all open books within Genstat. Select the book that the new sheet will

be added to. If the data are to appear in a new book then select the New Book setting.

## See also

Split or Subset a Spreadsheet

Randomize Rows in a Spreadsheet

Duplicate a Spreadsheet

Spreadsheet Manipulate Menu

Spreadsheet Calculate Menu

The SUBSET procedure can be used in conjunction with the

GRUNIFORM function of

CALCULATE command in the command language to do sampling

with or without replacement.

To sample without replacement P rows out of N, the following commands could be

used:

SORT [INDEX=GRUNIFORM(N;0;1)] !(1…N); Pos

SUBSET [Pos <= P] X,Y; Sample_X,Sample_Y

To sample with replacement P rows out of N, the following commands could be used:

CALC Row = INT(N*GRUNIFORM(P;0;1)) + 1

VARIATE Sample_X,Sample_Y; (X,Y)$[Row]