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 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 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

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 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

Assigning Respondents to Clusters/Segments in New Data Files in Q
30 March 2017 | by Tim Bock

Once you have created segments or clusters, you may find it useful to assign people in other data sets to the segments (a process also known as

Continue reading

close-link