How to Apply an LDA Typing Tool in Q
26 June 2019 | by Tim Ali

After running a market segmentation, one problem many researchers commonly face is how to go about assigning respondents in subsequent surveys to the existing s...

Continue reading

How to Identify Duplicates in Q Using Code
25 June 2019 | by Oliver Harrison

In market research, you may end up with a data file that contains duplicate records. This post will show you how to identify and remove duplicates in your surve...

Continue reading

How to compare previous periods using an unequal categorical variable
20 June 2019 | by Kris Tonthat

Sometimes researchers don’t have a time-date variable, but rather, just an indication of the period in a categorical variable. This can be problematic if ther...

Continue reading

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

Testing Whether an Attribute Should be Numeric or Categorical in Conjoint Analysis
11 March 2019 | by Tim Bock

Choice-based conjoint (CBC) studies usually specify a fixed number of levels for each attribute. The resulting attribute then becomes categorical. But that doesn’t mean you

Continue reading

Using Substitution Maps to Understand Preferences in Conjoint Analysis
10 March 2019 | by Tim Bock

Modern tools for analyzing conjoint analysis, such as hierarchical Bayes, produce rich data showing preferences for each person in a market. The main deliverable from

Continue reading

Using Indifference Curves to Understand Trade-offs in Conjoint Analysis
10 March 2019 | by Tim Bock

Indifference curves are a way of showing relative preferences for quantities of two things (e.g., preferences for price versus delivery times for fast food). This

Continue reading

close-link