Blog

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…

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

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…

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

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

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…

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…

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

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…

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…

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…

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…

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…

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…

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…

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

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

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…

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…

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…

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.

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.

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.

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.