About Statistics Tables
Statistics Tables help you see multiple aggregate metrics for your chosen data source. This visualization evaluates all of the responses collected for that data source and displays calculated results such as mean and standard deviation.
For basic visualization instructions and customization, visit the Visualizations Overview support page. Continue reading for visualization-specific customization.
Metrics & Breakouts
You can customize the columns you want to include in your Statistics Table.
- Metrics: The various statistical metrics available to display. Your options include:
- Min: The lowest value collected.
- Max: The highest value collected.
- Mean: The average of all values collected.
- Median: The median of your data set is the exact midpoint. When all of your collected values as organized from smallest to largest, this value is right in the middle.
Qtip: Qualtrics calculates the median using a non-deterministic percentiles aggregation to approximate the desired percentage counts at scale. The median, or 50th percentile, is accurate at about 99.9% on average.
- Standard Deviation: The standard deviation across all values collected.
- Variance: The variance across all values collected.
- Responses: The total number of responses collected that contribute to the statistics.
- Sum: The values of all the responses added together.
- Click and type in the metric’s label box to change the label.
- Drag the metrics to change the order they’re displayed in the table.
- Uncheck the box next to a metric to hide it from your table.
- Use the Breakout field to add another layer of analysis to your table by breaking out your data by another field.
- Choose how many decimal places are shown in your data.
- Field: Adds a label to the first column in your table.
- Sort: Determines how the table sorts your data. Your options include:
- Default: The table’s default sorting.
- Custom: Allows you to determine the table’s sorting by choosing which order to present your data. You can change your custom sorting by dragging and dropping your column and row values in the editing window. See Column & Row Values below for more information.
- Value: Sorts by your data values in ascending or descending order.
- Type in the field to rename the value. This does not affect the question as it appears in the survey, just the visualization.
- Click and drag to change the order of the columns and rows.
- Deselect the checkbox to hide the value from the visualization.
Select the Styles tab to modify table header and body fonts, as well as other visual aspects of your table.
- Determine the font, size, and color of the table’s Response Count.
- Determine the font, size, and color of the Table Header.
- Determine the font, size, and color of the Table Body.
- Select Alternate Row Colors to shade every other row and make them easier to read.
- Select Repeat Table Header will make sure that the header row (not the title) will repeat as the table gets much larger and has many rows.
- Use Table Density to choose how spaced out or compact your table is.
- Use Margin to adjust the table’s margins.
The Statistics Table is only compatible with variables that can come in numeric formats.
- Single-Answer Multiple Choice
- Single-Answer Matrix Table
- Text Entry with Numeric Validation
- Side by Side
Qtip: There should be multiple-choice single-answer fields, or a text entry field with numeric validation.
- Rank Order
- Constant Sum
- Pick, Group, and Rank
- Number and Number Set Embedded Data
- Numeric manual variables
- Scoring Categories