# Blog

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

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

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

Running a survey can be expensive and time-consuming. Luckily you can use simulated data to check and compare your survey design, saving you time and

How to do NPS Recoding in Q
17 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. It is defined as

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.

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

Data stacking is a data preparation step where a data set is split into subsets, and the subsets are merged by case (or stacked on

How to Create a Pyramid Chart in Q
11 September 2018 | by Chris Facer

A Pyramid chart is a bar chart where the bars grow out from the center, rather than from the left or right. Pyramid charts are

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

The traditional means for outputting categorical data is with percentages representing each category’s share of the total sample. However, there are a range of cases

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

Sorting data can assist you to understand, analyze, and visualize it. In Q, sorting is most often done to improve the way tables or charts

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

A correlation matrix is a table of correlation coefficients for a set of variables. They are often used to determine if a relationship exists between

How to Automatically Update think-cell Charts in PowerPoint
28 August 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.

How to Create a Top 2 Box Score in Q
15 August 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.

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

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

How to Compute Moving Averages in Q
07 August 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.

Approaches to Smoothing Time Series in Q
06 August 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.

How to add Trend Lines to Visualizations in Q
05 August 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).

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.

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.

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.

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.

Tutorial: Creating and Working with JavaScript Variables in Q
31 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.

How to Do Simple Table Manipulations With R in Q
03 April 2018 | by Matt Steele

R is not just a tool for the data science elite. It is an immensely powerful tool that can be used by market researchers in

How to Save a Modified Copy of an SPSS Data File
19 February 2018 | by Tim Ali

When working in Q, there are situations in which you may want to save a new copy of your data file. Some examples include: Removing