Consider the data from Daganzo, found in Daganzo Trip.jmp. This data set contains the travel time for three transportation alternatives and the preferred transportation alternative for each subject.
1.
Select Help > Sample Data Library and open the Daganzo Trip.jmp data table.
Partial Daganzo Travel Time Table for Three Alternatives
Each Choice number listed must first be converted to one of the travel mode names. This transformation is easily done by using the Choose function in the formula editor, as follows.
2.
Select Cols > New Column.
3.
Specify the Column Name as Choice Mode and the modeling type as Nominal.
4.
Click the Column Properties and select Formula.
5.
Click Conditional under the Functions (grouped) command, select Choose, and press the comma key twice to obtain additional arguments for the function.
6.
Click Choice for the Choose expression (expr), and double click each clause entry box to enter “Subway”, “Bus”, and “Car (with the quotation marks) as shown in Choose Function for Choice Mode Column of Daganzo Data.
Choose Function for Choice Mode Column of Daganzo Data
7.
Click OK in the Formula Editor window.
8.
Click OK in the New Column window.
The new Choice Mode column appears in the data table. Because each row contains a choice made by each subject, another column containing a sequence of numbers should be created to identify the subjects.
9.
Select Cols > New Column.
11.
Click Missing/Empty next to Initialize Data and select Sequence Data.
12.
Daganzo Data with New Choice Mode and Subject Columns
1.
Selecting Tables > Stack.
2.
Select the columns Subway, Bus, and Car and click Stack Columns.
3.
For the Output table name, type Stacked Daganzo. Type Travel Time for the Stacked Data Column and Mode for the Source Label Column.
Stack Operation for Daganzo Data
4.
Partial Stacked Daganzo Table
For the Profile Data Table, you need the Subject, Mode, and Travel Time columns.
1.
Select the Subject, Mode, and Travel Time columns and select Tables > Subset.
2.
Select All Rows and Selected Columns and click OK.
A partial data table is shown in Partial Subset Table of Stacked Daganzo Data. Note the default table name is Subset of Stacked Daganzo.
Partial Subset Table of Stacked Daganzo Data
For the Response Data Table, you need the Subject and Choice Mode columns, but you also need a column for each possible choice.
3.
With the original data table open, select the Subject and Choice Mode columns.
4.
Select Tables > Subset.
5.
Select All Rows and Selected Columns and click OK.
6.
Select Cols > Add Multiple Columns.
7.
For the Column prefix, type Choice. Type 3 next to How many columns to add. Click Numeric and select Character.
8.
The columns Choice 1, Choice 2, and Choice 3 have been added.
9.
Type “Bus” (without quotation marks) in the first row of Choice 1. Right-click the cell and select Fill > Fill to end of table.
10.
Type “Subway” (without quotation marks) in the first row of Choice 2. Right-click the cell and select Fill > Fill to end of table.
11.
Type “Car” (without quotation marks) in the first row of Choice 3. Right-click the cell and select Fill > Fill to end of table.
Partial Subset Table of Daganzo Data with Choice Set
Now that you have separated the original Daganzo Trip.jmp table into two separate tables, you can run the Choice Platform.
1.
Select Analyze > Consumer Research > Choice.
Choice Dialog Box for Subset of Daganzo Data
3.
Click Run Model.
Parameter Estimate for Travel Time of Daganzo Data
2.
Select Cols > New Column.
3.
Type Response as the Column Name.
4.
Click Column Properties and select Formula.
5.
Select Conditional under the Functions (grouped) command and select If from the formula editor.
6.
Select the column Choice Mode for the expression (expr).
8.
Type 1 for the Then Clause and 0 for the Else Clause.
9.
Click OK in the Formula Editor window. Click OK in the New Column window.
Formula for Response Indicator for Stacked Daganzo Data
10.
Select the Subject, Travel Time, and Response columns and then select Tables > Subset.
11.
Select All Rows and Selected Columns and click OK.
Partial Table of Stacked Daganzo Data Subset
12.
Select Analyze > Consumer Research > Choice to open the launch window and specify the model as shown in Choice Dialog Box for Subset of Stacked Daganzo Data for One-Table Analysis.
Choice Dialog Box for Subset of Stacked Daganzo Data for One-Table Analysis
13.
Click Run Model.
14.
Select Yes to obtain the parameter estimate expressing the utility Travel Time coefficient, shown in Parameter Estimate for Travel Time of Daganzo Data from One-Table Analysis.
Parameter Estimate for Travel Time of Daganzo Data from One-Table Analysis