Score & Average in Matrix.

Average boils your data down to single, central value, making it easier to process for decision makers.

Just like in Choice questions, you can assign a score to each choice in your Matrix question to calculate a combine weighted average for each statement. This is very useful for questions with scales or any set of choices that are ordered and can be scored or valued.  

Example: "How annoying do you find advertisements in the following channels?"

Statements

• Free to air TV
• Broadcast video on demand
• Websites & Apps
• Social media
• Streaming video
• Streaming audio
• Radio
• Cinema
• Print media

Choices (Scorable)

• Not at all = 1
• A little = 2
• Moderately = 3
• Very = 4
• Extremely = 5
• N/A = "excluded"

To score & average matrix questions:

1. Go to a matrix question, i.e. any question where by default, you see...
   1. Statements in the Rows
   2. Choices in the Columns
   3. Values set to Row %
2. click the cog icon next to your Choices to open the config/netting menu

3. assign scores to each of your choices, e.g. 0, 1, 2, 3, 4, 5
4. exclude any choice you don't want to incl. in the average calculation, e.g. "N/A"
5. tick Combine Weighted and give your combined variable a name, e.g. "Average"
6. click Done

6. click the 'Values' dropdown and select "Average"

You can now see how annoying advertisements are on average in the following channels, i.e.

• 3.6 / 5 for Streaming video (Very),
• 3.3 out of 5 for Radio, and
• 2.9 for Outdoor media (Moderately).

To cut across multiple filters

1. click the 'Target' slot and select a statement, e.g. "Free-to-air TV".
2. this will automatically put your Filters into the table Rows.
3. click the '+Filter' button in your table rows (below the "All" filter)
4. select the filters you want to add, e.g. 2 gender, 2 Region, and 2 HHI filters,
5. click Add or Add Global

Your filters will be added to your table rows and chart x-axis so you can compare filter averages side by side and see differences between them, e.g. for Ads on Free-to-air TV, we can see an average "annoying" score of...

• 3.60 / 5 for Regional vs.
• 3.47 / 5 for Metro vs.
• 3.51 / 5 for All.

So, ads on Free-to-air TV were a bit more annoying for Regional compared to Metro respondents.  

To switch statements, click the 'Target' slot again and select another statement, e.g. "Cinema" OR

To see all statements again, select the "-" option in your Target slot.

To change the decimal places, e.g. from 0dp (default) to 1dp or 2dp, go to your dashboard settings (cog icon) at the top left, below the dashboard bar. Note that Decimal Places set in here will be applied to all the views and values in your dashboard, not just the current view.  

Your analysis for Matrix Score & Average is now complete! 🥳