Values: Count, Sum, Average, Column %, Row %, Total %

Statistics are useful for making evidence-based decisions, understanding complex issues, and making predictions across many fields like science, business, and government

They transform raw data into meaningful information by revealing patterns, trends, and relationships that help individuals and organizations solve problems, evaluate outcomes, and manage risks.

Basic statistics is just counting, totaling, and dividing.

Advanced stats use scoring, summing, and averaging.

Your Glow Tables and the Values slot above your tables let you...

Count,
Total,
Divide (i.e. percentages),
- Column %,
- Row %,
- Total %,
Score,
Sum, &
Average

Let's see how!

Counts & Totals

Count (grey cells) shows you how many respondents answered each choice (in each statement / loop where applicable) in this question after filters applied. E.g. n=242 Males were "Somewhat satisfied" with their checkout experience.

Column Total (blue bottom row) shows how many respondents answered any row variable in each column. E.g. n=464 in the "Male" column answered at least 1 of the choices in the rows.

Row Total (yellow far-right column) reveals how many respondents answered any column variable in each row. E.g. n=414 in the "Somewhat satisfied" row qualified for at least 1 of the filters in the columns.

Total Total (green bottom-right cell) is how many respondents answered any row variable in any column variable (i.e. the intersection of rows and columns). E.g. n=825 answered any choice in the rows and qualified for any filter in the columns.

Percentages

Percentages standardise numbers to a base of 100, making it easier to understand statistics and comparing parts of a whole. E.g. 242 out of 464 Males vs. 172 out of 361 Females saying they were "Somewhat satisfied" with their checkout experience are easier to compare when both are converted to percentages, i.e. 52% of Males vs. 48% of Females.

Column % is Count / Column Total, e.g. 242 / 464 = 52% of Males were "Somewhat satisfied" with their checkout experience. This is the default value for Choice questions

Row % is Count / Row Total, e.g. 242 / 414 = 58% of those who were "Somewhat satisfied" with their checkout experience qualified for the "Male" filter. This is the default value for Matrix questions.

Total % is Count / Total Total, e.g. 242 / 825 = 29% of all / total respondents were "Male" and "Somewhat satisfied" with their checkout experience. This is the default value for Rank questions.

Score, Sum, & Average

Score: allows you to assign a value to each choice in your question. To do this:

Click the Choices Config (Cog) icon above your table to the right.
Score each choice in the blank box provided, e.g. Very dissatisfied = 1 while Very satisfied = 5.
Tick "Combine Weighted" and give your combined variable a name, e.g. "Avg. Satisfaction".

Click "Done", then pick between Sum or Average Values.

Sum: multiplies the choice counts with the choice scores and sums them into a single value for each filter. E.g.

Very dissatisfied Males: 7 x 1 = 7
Dissatisfied Males: 25 x 2 = 50
Undecided Males: 44 x 3 = 132
Satisfied Males = 242 x 4 = 968
Very satisfied Males = 146 x 5 = 730

Combined Male Sum = 1887

Average: creates a single, central value and is just the Sum / Total, e.g.

Male Sum: 1887 / Male Total: 464 = Male Avg: 4.07
Female Sum: 1516 / Female Total: 361 = Female Avg: 4.20