Expand a Spreadsheet using a Weight Column

This menu can be used to create spreadsheets where the rows in the current spreadsheet are replicated the number of times specified in a weight column. If values within the weight column are not integers the values will be rounded to the nearest integer. If a weight value is less than zero or a missing value then no copies of that row will appear in the new spreadsheet. If a weight value is zero, then rows will only be copied in the Keep rows with Zero weight option is selected. This menu is useful for when an analysis does not have a WEIGHTS option, and the data have been supplied in a weighted format. You can then use the expanded spreadsheet to perform the equivalent of the weighted analysis.
The CALCULATE function NEXPAND can be used to expand a data column in command mode. However, this function can only be used with numerical columns, and factors are converted to variates.
The menu will produce a warning if the weights seem excessively large. The new spreadsheet will not contain the original weights column.

Use Weights from Column

Specifies the column in the spreadsheet that contains the weights to be used in the expansion. Each row is repeated the number of times specified by the values in this column. If the column is a factor, then the levels values of the factor will be used, and if these are not defined, then the ordinal values will be used.

Keep rows with Zero weight

When selected, a row with a weight of zero will be copied once into the new spreadsheet, otherwise no copies will be made. Rows with negative or missing weights will not be copied to the new spreadsheet.

Create Unique Column Names

When selected, the column names in the new spreadsheet will be created with unique names so that they are different to the existing column names.

Set as Active Sheet

Sets the newly created spreadsheet to be the active spreadsheet. Click here for more details about active spreadsheets.

Add to Book

This provides a list of books that the new spreadsheet can be added to. The default book that spreadsheets are added to can be specified using the Spreadsheet Options - Books tab menu.

Action Buttons