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 Combine Complicated Tables in Q Using R
05 October 2018 | by Chris Facer

Clients often like to have topline results from the key questions in their survey combined into a single table. This allows for an easy, at-a-glance

Continue reading

How to Split Text Strings in Q
20 September 2018 | by Daren Jackson

String splitting is the process of breaking up a text string in a systematic way, so that the individual parts of the text can be

Continue reading

How to Convert Timestamps into Numerical Values in Q
19 September 2018 | by Daren Jackson

Timestamps are common in survey data. Sometimes we need calculate the difference between two timestamps. To do so, we need to convert them from being

Continue reading

How to Calculate Penalty Analysis in Q
04 August 2018 | by Chris Facer

Knowing how to calculate penalty analysis is an important part of every market researcher's skillset. I'll explain what it is and how to calculate it in Q.

Continue reading

How to Aggregate Data in Q
03 August 2018 | by Jake Hoare

You have a data set and you need to quickly organize it to perform your data analysis. Learn how to aggregate your data in Q with these easy steps.

Continue reading

How to Read Stata DTA Files into Q
02 August 2018 | by Carmen Chan

Survey data is often provided in binary file formats which contain metadata about how the data is structured. A common form is the Stata DTA format.

Continue reading

How to read an Excel file into Q
01 August 2018 | by Carmen Chan

There are three methods of reading Excel files into Q. I'll show you all three and explain when you might one to use each one.

Continue reading

close-link