Assigning Value Ordering

Consider the Candy Bars.jmp sample data table. Of the 18 brands lists under Brand, Hershey and M&M/Mars have the largest numbers of types of candy as listed in the Name column. You want these two brands to appear first in reports.

Select Help > Sample Data Library and open Candy Bars.jmp.

Select the Brand column.

Select Cols > Column Info.

Under Column Properties, select Value Ordering.

In the Value Ordering list, select Hershey.

Click Move Up five times.

Hershey is now first in the Value Ordering list.

In the Value Ordering list, select M&M/Mars.

Click Move Up seven times.

M&M/Mars is now second in the Value Ordering list.

Click OK.

An asterisk indicating the Value Ordering column property appears next to Brand in the columns panel. JMP now lists Hershey and M&M/Mars first in reports involving Brand.

10.

Select Analyze > Distribution.

11.

Select Calories and click Y, Columns.

12.

Select Brand and click By.

13.

Click OK.

14.

While holding down the Ctrl key, from the red triangle next to Calories select Display Options > Horizontal Layout.

Note that the Distribution reports for Hershey and M&M/Mars appear first among the 18 brands.

15.

Close the Candy Bars.jmp sample data table without saving the changes.