What are Values: Count (n=), Divide (%), Score (x), Sum (+), Average (x̄), and Total (Base n=)?
Values let you count, divide, sum, and score (or average) your answers.
Total (Base n=)
Total values show you how many respondents answered your question AND how many answered each of your choices, filters, statements, ranks, or loops in your rows OR columns.
- Row Total (yellow, far right column) shows you how many answered each of the row variables in total, in this case, your choices with n=2 detractors (0-6), n=8 passives (7-8), and n=3 promoters (9-10)
- Column Total (green, bottom row) shows you how many answered each of the column variables in total, in this case, your filters with n=13 completes, n=8 males, and n=5 females.
- Total [blue, bottom right cell] shows you how many respondents answered this question (n=13): "how likely are you to recommend brand X to your friends or colleagues?"
To show or hide the Total Row or Total Column, click the eye icon.
Count (n=)
Count lets you see how many answered:
- each row variable (e.g. Choice: Promoters)
- in each column variable (e.g. Filter: Females).
- e.g. there are n=2 Female Promoters.
Percentages (%) - Division, Distribution
Row % divides the Count for each cell by the Total value in each Row (Count / Total Row). Example:
- n=2 Female Promoters / Row Base n=3 Total Promoters = 67% of all Promoters are Female.
- n=2 Female Passives / Row Base n=8 Total Passives = 25% of all Passives are Female.
Column % divides the Count for each cell by the Answered value in each Column (Count / Column Answered). Example:
- n=2 Females Promoters / Column Base n= 5 Females = 40% of all Females are Promoters.
- n=1 Male Promoter / Column Base n= 8 Males = 12.5% of all Males are Promoters.
Total % divides the Count for each cell by all respondents who Answered this Question (Count / Total Answered). Example:
- n=2 Female Promoters / Total Base n=13 Brand X customers = 15.4% of Brand X customers are Female Promoters.
- n=1 Male Detractors / Total Base n=13 Brand X customers = 7.7% of Brand X customers are Male Detractors.
Score (x̄)
Score multiplies the choice percentages (%) with the choice scores (x) and sums them together (+) to give you a combined weighted average (x̄) for each question or statement which you can then cut across your filters. For example:
Q6. How likely are you to recommend Brand X to your friends or colleagues?
- Detractors [0-6]: 15% (x-100) = -15 plus
- Passives [7-8]: 62% (x0) = 0 plus
- Promoters [9-10]: 23% (x100) = 23 equals
- Combined Weighted Average (x̄): +8
Note: Scores will replace your Choices in Choice and Matrix questions and your Ranks in Rank questions.
Tip: Choices such as "Don't Know" or "N/A" or "None of the above", i.e. independent choices or exclusive choices, can be excluded from your score and percentage calculations in the Config/Netting feauture.
Sum (Σ)
In this article for Constant Sum (Sum, Sum %, Average) analysis, we'll show you how to sum, average, and crosstab your respondents' NUMERIC answers in constant sum questions.