Please enable JavaScript to view this site.

Navigation: Analyzing data with Prism > Transforming, normalizing, etc.

Extract and rearrange from multiple variable tables

Scroll Prev Top Next More

This analysis takes as input a multiple variable table, and creates another table of a different type (XY, Column, Grouped or Contingency) from a subset of data. If you want to create another multiple variable table, this is the wrong analysis to use. Use this one instead.

The dialog has two tabs:

Format of results table

On the first tab, decide which kind of table you want to create.

Extract and Rearrange - Format Tab

Options

In addition to selecting the table type, there are two additional options available:

Include variable names as prefixes for Column/Row titles in results sheet - When checked, this option adds the variable name as a prefix to column titles in the output. For example, if "Sex" is the variable name with levels "Female" and "Male", the output column titles would be Sex = "Female" and Sex = "Male".

Only include complete rows - This option determines whether "empty" rows in the output should be retained or not. Another way to think about this is whether to maintain the original data row order in the structure of the results. Based on the design of the extract and rearrange variables used to determine the output data structure, some rows/combinations may not exist in the data.

oWhen checked: The placement of data in the output may not totally reflect the arrangement of data from the input. The data will be condensed to eliminate unnecessary empty space in the output table.

oWhen unchecked: For Column tables and XY tables without replicates, the data in the output will be placed on the same row as the corresponding value in the input (barring information about replicates/subjects), maintaining the original row structure. For tables with replicates (XY or Grouped), the effects will be similar, shifting data where possible within subcolumns of the appropriate row/column to eliminate empty cells.

Data arrangement

On the second tab, define which variables to use to re-structure your data into the chosen table format.

Extract and Rearrange - Data Tab

XY Table

For creating an XY table, define:

Independent (X) variable - The column that becomes the X values

Response (Y) variable - The column containing the Y values

Grouping variable - Defines which data set the Y values go into (integers only)

Subject/replicate variable - Identifies replicates or subjects, and will determine which subcolumn the response values will be placed into

Row titles - Optional column to provide row labels

Column Table

For creating a Column table, define:

Response variable - The column with all the values that will go into the new column

Grouping variable - Defines the data sets (integers only)

Subject variable - Identifies replicates or subjects, and will determine which subcolumn the response values will be placed into

Row titles - Optional column to provide row labels

Grouped Table

For creating a Grouped table, define:

Response variable - The column with all the values that will go into the new table

Row factor variable - Defines which row each value goes into (integers only)

Column factor variable - Defines which data set each value goes into (integers only)

Subject variable - Identifies replicates or subjects, and will determine which subcolumn the response values will be placed into

Contingency Table

For creating a Contingency table, define:

Column (outcome) variable - Defines the outcomes (columns). Each unique level (or value) will become a column that is incremented

Row (treatment) variable - Defines the exposure or treatment (rows). Each unique level (or value) will become a row that is incremented

Count variable - Optional column that defines how large an increment to make for each cell. Negative or non-integer values in this variable will not be used to tabulate the count results

None of the values in the input table go directly into the new contingency table. Rather, the new table is a cross-tabulation table. Normally each row in the input table will increment one particular cell (defined by row and column) in the created table. Optionally, you can define the count variable that specifies the increment amount.

Swapping X and Y variables

Note: If your goal is to swap X and Y values on a XY table, this analysis won't let you do it. Use the Transform analysis instead. It has a choice to swap X and Y.

© 1995-2019 GraphPad Software, LLC. All rights reserved.