The Crosstab applet's Nets & Metrics tool enables you to add rows that provide calculated information from the survey data. This includes nets, such as Top 2 Box scores, and summary statistics with metrics, such as median or standard deviation, among many others.
Tip! Nets and metrics added through the source code will automatically display in the relevant table rows.
Standard nets
Nets (also called groups or buckets) combine the highest or lowest options from a rating scale. The following pre-defined nets are available:
- Top 2 Box combines the results from the highest two points on a scale (e.g., a top 2 box net on a 1 to 5 scale combines the '4' and '5' responses).
- Top 3 Box combines the results from the highest three points.
- Bottom 2 Box combines the results from the lowest two points on a scale (e.g., a bottom 2 box net on a 1 to 5 scale combines the '1' and '2' responses).
- Bottom 3 Box combines the results from the lowest three points.
You can also create custom nets, discussed further below.
Standard metrics
In addition to nets, the following metrics are available for Crosstab reports.
Metric | Description |
Max | The highest or maximum selected value in a numeric question. |
Min | The lowest or minimum selected value in a numeric question. |
Mean | Also known as the average, this is calculated by summing all the values and dividing by the number of values. |
Median | The value that would be in the middle if all values were in an ordered list. |
Std. Dev. | Standard deviation, also known as standard error, indicates how widely values vary from the group mean. If individual values vary considerably from the group mean, the standard deviation is large; conversely, if individual values do not vary much from the group mean, the standard deviation is small. |
Range |
The percentage of data that falls between the smallest and largest values specified. |
Percentile | Uses the Nth percentile of a data set as the value at which N percent of the data is below it (e.g., 90th percentile displays the value at which 90% of the data is below it). |
Adding predefined nets and metrics
Both parent and child tables have an actions menu on the left side of the table. Click this menu to add a net or metric.
The Add Nets & Metrics pop-up displays a default net or metric based on the question type (e.g., closed-ended vs. open-ended). To change it, expand the menu and make a new selection.
If a net or metric is added to a parent table, it will apply to child tables, and vice versa. If multiple survey fields share the same answer options, you can add those fields at the same time when creating a single net or metric.
Click Apply to exit the pop-up or Apply & Add Another to save the first net or metric and continue adding more.
Nets
When you select a predefined net, such as Top 2 Box, the software automatically selects the appropriate options for the net grouping. These selections are not editable.
Metrics
Most predefined metrics require no additional setup, except for Percentile and Range.
- When applying Percentile, enter a number to specify the Nth percentile, where N% of the data falls below it.
- When applying Range, enter the starting option ID or value in the From field and the ending option ID or value in the To field. You can include multiple ranges on the same question by clicking the
plus sign next to the Description field.
Enter text in the Description field when adding a range to activate the Apply buttons.
To activate the Apply buttons when adding a range, enter text in the Description field.
Adding custom nets
Adding a custom net is similar to adding a predefined net or metric. Select Custom Net from the dropdown. Then, click within the Options field to choose one or more answer options for the net grouping.
Custom nets also support multiple groupings — click the plus sign to the left to add more. Once all groupings are set, add a description, and click Apply or Apply & Add Another.
Editing or deleting a net or metric
To edit an existing net or metric, click on the actions menu and select Edit Nets & Metrics. In the pop-up, you can choose to edit or delete the selected net or metric.
Note: If a net or metric has been added directly in the survey code, it will not be editable.
Comments
0 comments
Please sign in to leave a comment.