Your Guide to Using Built-in Mathematical Functions in Q
17 June 2019 | by Tim Ali

Q contains several useful built-in mathematical functions that make it easy to do calculations on your existing data without having to write JavaScript, Excel formulas

Continue reading

Understanding the Sample Size in Multiple Response Questions
05 June 2019 | by Chris Facer

When analyzing multiple response questions in Q, it's important to understand the sample your numbers are based on.

Continue reading

How to Merge SPSS Files in Q
05 June 2019 | by Chris Facer

Merging SPSS files is simple with Q. Here's how to guide on merging data by cases and variables.

Continue reading

How to Build Tables that Automatically Show Results from the Latest Period
30 May 2019 | by Chris Facer

If you are running a tracking study you may want to have tables which focus on results just from the latest month or quarter. A

Continue reading

How to Get your Data Sparkling Clean – Fast!
24 May 2019 | by Lucy Li

Do you despise data cleaning? You’re not alone. Too many researchers find data cleaning to be time-consuming, tedious, and tiring. However, starting your analysis with

Continue reading

How to Make an Importance/Performance Scatterplot in Q
23 May 2019 | by Matt Steele

Popular amongst researchers is the importance vs. performance scatterplot. This is where you have a series of items that you place in a grid, where

Continue reading

How to Make a Snake Plot in Q and Export it to PowerPoint
23 May 2019 | by Matt Steele

Snake plot is the term used to describe a line chart on its side. So rather than the lines running left-right (x-axis) they run up-down

Continue reading

How to Convert Dates into Different Time Zones in Q
23 May 2019 | by Oliver Harrison

Working with dates and times can be challenging at the best of times, let alone when they are in the wrong time zone or format,

Continue reading

How to Extract Column Comparison Letters into a Table Automatically in Q using R
22 May 2019 | by Matt Steele

In recent posts we’ve discussed how you can reference source tables using R in Q to manipulate the statistics into a new custom table. In

Continue reading

How to Blank and Cap Cells of Tables Using R in Q
22 May 2019 | by Matt Steele

After you make a table, you might like to modify the contents of the cells. Perhaps you want to make the table easier to read

Continue reading

How to Blank Cells with Small Sample Sizes using R in Q
22 May 2019 | by Matt Steele

Many researchers like to suppress statistics that have small sample sizes. This often prevents clients from making false interpretations from the data. In this post,

Continue reading

How to Build a Brand Funnel in Q using R
22 May 2019 | by Matt Steele

Have you been in a situation where you need to update a KPI summary, and you want everything within the one table? This is particularly

Continue reading

Calculating the Duration Between Two Dates
06 May 2019 | by Mattias Engdahl

It can sometimes be useful to calculate the amount of time, be it in minutes, hours, or even seconds, between two points in time.  In

Continue reading

3 Ways to Quickly Sift Through 3,050 Crosstabs and Find the Magic One
02 May 2019 | by Tim Bock

Most market researchers know the pain of having to hunt through huge numbers of crosstabs to find the interesting ones. In my younger days (shhh…),

Continue reading

Tips for Merging Questions in Q Without Writing Syntax
02 May 2019 | by Oliver Harrison

There are often occasions in market research when you look at your survey data and find that in order to analyse certain questions properly, you’ll

Continue reading

How to Quickly Sift Through 3,050 Crosstabs and Find the Important Ones in Q
01 May 2019 | by Tim Bock

Want to save a heap of time narrowing down thousands of crosstabs to just the ones you need? This post describes which buttons to push

Continue reading

Tips for Rebasing and Filtering Data in Q
29 April 2019 | by Chris Facer

Q users are used to setting the base of their tables by applying filters. However, there are other handy ways to rebase data that you

Continue reading

Guide for Working with Excel Files in Q
28 April 2019 | by Chris Facer

If you can get an SPSS file for your study then Q will usually be able to set up all the data for you. However,

Continue reading

How to Identify Relevant Variables for Market Segmentation
05 February 2019 | by Tim Bock

This page lists the key frameworks and processes for identifying relevant variables to use when segmenting a market. The best way to identify relevant segmentation

Continue reading

How to Write “Golden Questions” for Market Segmentation
05 February 2019 | by Tim Bock

Golden questions are questions used to allocate people to segments. They are also known as self-selection questions. The main applications of golden questions are: As discovery

Continue reading

How to Work Out the Number of Segments For a Market Segmentation
05 February 2019 | by Tim Bock

When segmenting a market, a practical challenge is to work out the number of segments. There are eight approaches to choosing the number of segments:

Continue reading

How to Reuse Code Frames in Q
22 January 2019 | by Oliver Harrison

Coding open-ended and ‘other/specify’ responses can often be a tedious task for market researchers. In this post I will instead show you how to reuse

Continue reading

How to Code Other/Specify Responses in Q
22 January 2019 | by Oliver Harrison

Coding open-ended responses can often be a tedious and time-consuming task for market researchers, especially when you include an ‘Other/specify’ option and then need to

Continue reading

How to Code an Open-Ended Question into a Single Response Question in Q
22 January 2019 | by Oliver Harrison

Coding open-ended responses can often be a tedious task for market researchers. In this post I will show you how to easily code a single

Continue reading

Keep updated with the lastest in market research

* indicates required