Using Q.

Using Q
How to Extract Column Comparison Letters into a Table Automatically in Q using R
02 November 2018 | 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

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

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

In survey analysis, sometimes you need to include missing values as part of your base. There are several ways of recoding missing values in Q.

Continue reading

Using Q to Make a Snake Plot in PowerPoint
31 October 2018 | by Matt Steele

A snake plot is similar to a line chart, but which runs vertically. They're fiddly to make in PowerPoint, but you can use Q to make it easier!

Continue reading

How to Make a Histogram in Q
26 October 2018 | by Daren Jackson

Histograms may look like bar charts but they actually plot data differently - showing the distribution of numerical data. Find out how to create one.

Continue reading

How to Create a Heatmap in Q
23 October 2018 | by Daren Jackson

Heatmaps are a powerful visualization tool - laid out like crosstabs with a range of different colors representing a range of values. Find out how to make one.

Continue reading

Using Q
How to Make a Column Chart in Q
22 October 2018 | by Daren Jackson

The Chart menu You can generate standard charts like the column chart in Q based on tables or crosstabs that you have already built through a

Continue reading

density plot example
How to Create a Density Plot in Q
22 October 2018 | by Chris Facer

A density plot is a smoothed histogram. However, they can be a lot more visually appealing than a histogram. I'll show you how to make a density plot in Q.

Continue reading

Using Q
How to Calculate Sentiment Scores for Open-Ended Responses in Q
18 October 2018 | by Matt Steele

Nothing is ever as accurate as a researcher manually coding text variables, one case at a time. But in the case of a large survey sample

Continue reading

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

Creating dynamic text You can format and prepare text in Q using an R Output. Q’s integration with the R language allows you to connect

Continue reading

Using Q
How to do Traditional Correspondence Analysis in Q
16 October 2018 | by Chris Facer

There are a few variations on the technique of correspondence analysis (like correspondence analysis of square tables, multiple correspondence analysis, and correspondence of multiple tables),

Continue reading

How to Create a Pie Chart in Q
14 October 2018 | by Tim Ali

There a two different methods of creating a pie chart in Q - using the built in chart options or the visualization menu. I'll show you both.

Continue reading

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

Learn how to use web scraping in Q to add web-based data to your report. You can use the rvest package in R to extract data from a web page.

Continue reading

How to Make a Radar Chart in Q
11 October 2018 | by Mattias Engdahl

Radar charts are a great way to visualize two-dimensional data and show differences in sub-groups. I'll show you an easy way to create them in Q.

Continue reading

Geocoding IP addresses in Q
08 October 2018 | by Jake Hoare

Geocoding is the process of translating an IP address to a physical location. In this post I describe how to geocode IPs in Q.

Continue reading

Using Q
How to Create a Pictograph Bar Chart in Q
07 October 2018 | by Carmen Chan

A pictograph bar chart uses multiple icons to show the represent the values in each bar. This can make a visualization more recognizable and interesting.

Continue reading

How to Make an Area Chart in Q
06 October 2018 | by Tim Ali

In this post, I'll show you how you can easily create a basic as well as stacked area chart in Q.

Continue reading

How to Create a Palm Tree Chart in Q
02 October 2018 | by Carmen Chan

Palm trees are great at showing multivariate performance data. The height of the tree reflects average performance while frond lengths show specific scores.

Continue reading

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

One way of measuring the overlap or similarity between the data in two binary variables is to use a Jaccard coefficient. The coefficient ranges between 0

Continue reading

Using Q
How to do Choice Modeling in Q
01 October 2018 | by Justin Yap

Selecting a choice model The first step is to choose the method used to analyse the choice data. The choice is between latent class analysis or

Continue reading

How to Create a Streamgraph in Q
30 September 2018 | by Carmen Chan

The streamgraph is a type of stacked area chart. It is modified so that the streams are centered around the y-axis and often has a flowing organic shape.

Continue reading

3D Correspondence Analysis Plots in Q
27 September 2018 | by Tim Bock

The default correspondence analysis charts in Q are two-dimensional scatterplots. You can create a three-dimensional plot by writing a small amount of code.

Continue reading

How to Create a Time Series Graph in Q
27 September 2018 | by Carmen Chan

A time series graph has the ability to zoom in or out. It allows viewers to explore the time series at a range of time scales.

Continue reading

How to Combine Complicated Tables in Q Using R
25 September 2018 | by Chris Facer

Q’s integration with the R language makes it possible to splice and dice tables and to combine results that you can’t otherwise show on the

Continue reading

How to Filter Data in Q
21 September 2018 | by Chris Facer

Applying filters to tables and outputs You can filter most items in the Outputs tab using the Filter menu at the bottom of the screen. When

Continue reading

Using Q
How to Compute D-Error for a Choice Experiment Using Q
20 September 2018 | by Justin Yap

In other articles I provide the mathematical definitions of D-error and worked examples of how to calculate D-error; but in the real world, most people

Continue reading

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

Splitting text strings can be a pain sometimes. This post shows you how to split text strings in Q with a minimum of fuss.

Continue reading

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

Timestamps are common in survey data. Sometimes we need calculate the difference between two timestamps. You can convert and analyze them in Q.

Continue reading

Using Q
How to Use Simulated Data to Check Choice Model Experimental Designs Using Q
14 September 2018 | by Justin Yap

Why use simulated data to check your choice model? You can generate choice model designs by using numerous methods with different specifications. Likewise, there are

Continue reading

Using Q
How to do NPS Recoding in Q
13 September 2018 | by Daren Jackson

The Net Promoter Score (NPS) is a method for indexing a person's willingness to recommend a product or service to others.

Continue reading

Using Q
How to Create a Bar Chart in Q
12 September 2018 | by Tim Ali

There a two different methods of creating a bar chart in Q - using the built in chart options or R visualizations. I'll show you both.

Continue reading

Stacked Data example
How to Stack Data in Q?
11 September 2018 | by Chris Facer

This article describes how to stack a data set in Q. There are two approaches that you can take: Use Tools > Stack SPSS .sav

Continue reading

pyramid chart example
How to Create a Pyramid Chart in Q
10 September 2018 | by Chris Facer

Pyramid charts are a cool alternative to bar charts and are especially popular for representing data from brand funnels. I'll show you how to create one.

Continue reading

Using Q
How to Calculate an Average Value from Categorical Data in Q
07 September 2018 | by Daren Jackson

Most researchers output categorical data with percentages. However, sometimes it is useful to calculate an average value based on categories. Find out how.

Continue reading

Using Q
How to Sort Data in Q
06 September 2018 | by Tim Ali

Everyone has to sort their data before using it for any kind of analysis. But it can take forever. Not anymore, we'll show you how to automate it.

Continue reading

Using Q
How to Create a Correlation Matrix in Q
04 September 2018 | by Tim Ali

A correlation matrix is often used to determine if a relationship exists between variables. It indicates the strength of the relationship. Find out how to creat...

Continue reading

man looking at papers on wall
How to Create Alternative-Specific Choice Model Designs in Q
23 August 2018 | by Jake Hoare

Alternative-specific choice model designs are used where alternatives are described by different qualities, rather than all attributes being the same.

Continue reading

Top 2 Box Score
How to Create a Top 2 Box Score in Q
31 July 2018 | by Daren Jackson

Every market researcher needs to know how to create a top 2 box score. Today, I'll show you how to easily create and present one in Q.

Continue reading

How to Automatically Update think-cell Charts in PowerPoint
28 July 2018 | by Tim Bock

You can use Q to create automatically updating think-cell charts in Powerpoint, making it easier than ever to present your data.

Continue reading

How to Compute Moving Averages in Q
25 July 2018 | by Carmen Chan

Q can compute moving averages from variables or tables. These can be displayed as trends in a chart or as a table of values for downstream analysis.

Continue reading

Approaches to Smoothing Time Series in Q
22 July 2018 | by Carmen Chan

You can use Q to smooth time series data in two ways: by adding a trend line to a Visualization chart, or by using Time Series charts.

Continue reading

linear trend line
How to add Trend Lines to Visualizations in Q
21 July 2018 | by Carmen Chan

In Q, trend lines can easily be added to many Visualizations. Trend lines can be linear or non-parametric (cubic splines, Friedman’s super smoother, LOESS).

Continue reading

How to Calculate Penalty Analysis in Q
19 July 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

data aggregation
How to Aggregate Data in Q
18 July 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
17 July 2018 | by Carmen Chan

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

Continue reading

How to read an Excel file into Q
16 July 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

Using Q
Tutorial: Creating and Working with JavaScript Variables in Q
12 July 2018 | by Matt Steele

It's easier than you think to create new variables with JavaScript. We'll show you how to create, combine, split and transform your data into new variables.

Continue reading

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

Using Q
Using Hierarchical Bayes for MaxDiff in Q
16 January 2018 | by Justin Yap

Getting started Your MaxDiff data needs to be in the same format as the technology companies dataset used in previous blog posts on MaxDiff such

Continue reading

Labelled Van Westendorp
How to Create a Price Sensitivity Meter in Q
20 December 2017 | by Mattias Engdahl

Van Westendorp analysis, common in market research, aims to find the optimal price point at which to sell a good or service. You find this

Continue reading

How to Export LDA Functions from Q into Excel
14 December 2017 | by Chris Facer

When using linear discriminant analysis (LDA) in market research, a common need is to obtain what are known as discriminant functions. These allow the analysis

Continue reading

Colourful funnel
How to Build a Brand Funnel in Q using R
08 December 2017 | 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 Q
Using R to Extract Information From an Object in Q
30 November 2017 | by Tim Bock

Sometimes it is useful to extract a particular bit of information from an object. An object could be a table or R Output. For example, you may want

Continue reading

Using Q
How to Analyze MaxDiff Data in Q
23 May 2017 | by Chris Facer

This post discusses a number of options that are available in Q for analyzing data from MaxDiff experiments. For a more detailed explanation of how to

Continue reading

Easily Add Logos to a Correspondence Analysis Map in Q
17 May 2017 | by Tim Bock

You can take your correspondence analysis plots to the next level by including images. Here is a guide to creating them in Q.

Continue reading

Using Q
How to Create a MaxDiff Experimental Design in Q
10 May 2017 | by Tim Bock

This post describes how to create and check a MaxDiff experimental design. If you are not sure what this is, best to read An introduction

Continue reading

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