How to Fit a Structural Equation Model in Q
18 November 2020 | by Tim Bock

In this post I am going to walk through the steps of fitting a structural equation model (SEM) in Q. The post assumes that you

Continue reading

How to find the highest rated item within a set of questions
09 September 2019 | by Kris Tonthat

Determining the highest rated item within a set of questions involves creating a variable that examines the responses of each respondent, and identifies the question

Continue reading

How to create a table of ranks from a crosstab
09 September 2019 | by Kris Tonthat

  Creating a table of ranks from a crosstab is a simple process in Q. All it requires is a little snippet of R code.

Continue reading

How to Remove a Row or Column using R in Q
06 August 2019 | by Matt Steele

You can use R in Q to create bespoke tables and do flexible data manipulations. In doing so, you end up with tables within R

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

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

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

How to Relabel Rows and Columns of Tables using R in Q
21 January 2019 | by Matt Steele

Q enables you to flexibly mix data from different tables. The mixing process creates a new table as an R Output. Consider the example table

Continue reading

How to Sort Your Data using R in Q
02 January 2019 | by Matt Steele

Automatically sorting your tables and charts is a key thing researchers like to do. Q has lots of ways to do this for you automatically

Continue reading

How to Select a Random Sample in Q
02 January 2019 | by Oliver Harrison

There are occasions when you have collected more records than necessary for a survey and you want to randomly remove the surplus or you simply

Continue reading

Tips for Recoding Missing Values in Q
01 November 2018 | by Matt Steele

Missing values in a data set are “blank” values. They are normally associated with survey skips. Those who skip a variable/question receive a missing value.

Continue reading

Comparing your Results to the Previous Period in Q
01 November 2018 | by Matt Steele

Q has a terrific feature whereby it can automatically compare statistics against the previous period (of time). This is great for tracking scenarios, when you

Continue reading

How to Export Updatable Text to PowerPoint from Q
19 October 2018 | by Chris Facer

Most Q users would be familiar with Q’s PowerPoint export options. The normal option allows you to export your tables to PowerPoint and create charts

Continue reading

Simple Web Scraping in Q Using R
15 October 2018 | by Chris Facer

Web scraping (also referred to as web data extraction or web harvesting), is the process of using software to fetch the contents of a web

Continue reading

How to Calculate Jaccard Coefficients in Q Using R
10 October 2018 | by Chris Facer

Jaccard coefficients, also know as Jaccard indexes or Jaccard similarities, are measures of the similarity or overlap between a pair of binary variables. In Q,

Continue reading

Geocoding IP addresses in Q
08 October 2018 | by Kris Tonthat

Most communication between users and websites requires IP addresses. However, when profiling web traffic it is more useful to consider where users are physically located.

Continue reading

How to Show Sentiment in Word Clouds using Q
14 February 2018 | by Tim Bock

The Word Cloud above summarizes some data from tweets by President Trump. The green words are words that are significantly more likely to be used

Continue reading

close-link