Publication date: 04/12/2021

Example of Stacking Counts in Multiple Columns

When data that are frequencies (counts) are listed in several columns of your data table, you must transform the data into the form that you need for logistic regression. For example, the data table (Figure 11.12) has columns Nready and Nnotready. These columns give the number of ingots that are ready to roll and ingots that are not ready to roll for each combination of Heat and Soak values.

Figure 11.12 Sample Data Table Sample Data Table

Before fitting a logistic regression model, use the following steps to stack the Nready and Nnotready columns into a single column:

1. Select Help > Sample Data Library and open

2. Select Tables > Stack.

3. Select Nready and NNotReady from the Select Columns list and click Stack Columns.

4. Click OK.

This creates the new table in Figure 11.13. Label is the response (Y) column and Data is the frequency column.

This stacked data table is equivalent to the sample data table used in Example of Nominal Logistic Regression.

Figure 11.13 Stacked Data Table 

Stacked Data Table

Want more information? Have questions? Get answers in the JMP User Community (