|
•
|
To use ranges, click Allow Ranges then specify the lower and upper values. If Allow Ranges is selected, Value Labels can be non-integers. Graph Builder can use the Value Labels for the x- and y-axes.
|
Tip: To assign a label to missing values, enter a period (.) for the lower bound and leave the upper bound empty. To assign a label to all other values, enter three periods (...) for the lower bound and leave the upper bound empty.
|
•
|
To turn off value labels in the data table without deleting the value labels that you have set up, in the Column Properties window, deselect Use Value Labels. Or, to quickly show or hide value labels in a data table, right-click on a column and check or uncheck Use Value Labels.
|
|
•
|
When your data table contains value labels, using the Search commands searches for actual values, but does not search for labels.
|
|
•
|
When your data table contains value labels, the Row Editor displays the label, and when the cell is highlighted for editing, it shows the actual value.
|
Use value scores to indicate a value-score pair for categorical data columns. The value is a data value and the score is a number. This property associates a data value with a score (for example, the column’s data value could be “not satisfied”, “satisfied”, “very satisfied”). The user could assign a score of 0 to “not satisfied”, 50 to “satisfied”, and 100 to “very satisfied”. Those scores are then used for computation purposes like computing the mean. See Example of Mean Score with Comparison Letters in Consumer Research for an example.
|
1.
|
|
2.
|
|
5.
|
|
6.
|
Click OK.
|
Tip: You can anonymize Value Ordering so that the Value Ordering properties are renumbered. To do this, highlight the column with the Value Ordering column property and select Tables > Anonymize.
When you construct a design using a DOE platform, the Value Ordering column property is automatically assigned to categorical factors. For examples of assigning and editing the Value Ordering column property, see Value Ordering the Design of Experiments Guide.
The row ordering applies only to the selected column. To apply it to other columns, repeat the above steps for each column, or use the Standardize Attributes command. See Standardize Attributes and Properties Across Columns.
Tip: To show the analyzed row data in another order (besides according to their values or their occurrence in the data table columns) use the Value Ordering property. See Value Ordering. The Value Ordering property overrides the Row Order Levels property when both are evoked.
|
•
|
To use a color theme, click Color Theme below the list of value colors and then select the color.
|
|
•
|
To also color the cells in the data table, select Color Cell by Value.
|
|
1.
|
Click Color Theme below the list of value colors in the column properties.
|
|
3.
|
Click New.
|
|
5.
|
Name the color and click Save.
|
|
6.
|
Click OK.
|
You can access the new custom color in the Color Theme menu the next time you use the Value Colors property. The color is also saved in your preferences. See Create Color Themes in Enter and Edit Data for details about creating color themes.
|
•
|
To also color the cells in the data table, select Color Cell by Value above the list of value colors.
|