How To Filter Your Data Before The Analysis

How To Filter Your Data Before The Analysis

Imagine you have collected some data, but you only want to analyze a subset of those. For example, you have conducted a consumer test and you want to keep only the consumers that scored higher than four in the hedonic question. It is possible to filter your data once before the analysis by using the function "Data Query" in EyeOpenR.

1. Open EyeOpenR: Export - Analysis - EyeOpenR


2. Choose a method and click the arrow on the right to move forward until the Visualization & Selection section.


3. In the Visualization & Selection section, you can filter your data based on the criteria that you want.
You can do that by clicking on Data Query. Select the question that you want to filter (e.g. Q3) and apply the criteria that you want (e.g. >4). 


Here you find some example Querys:
Select only the data where the selected attribute is equal to 1  ==1
Select only the data where the selected attribute is equal to "Demo Text"  =="Demo Text"
Select only the data where the selected attribute is greater than 10   >10
Select only the data where the selected attribute is smaller than 10  <10
Select only the data where the selected attribute is greater than 10 and smaller than 90  >10, AND <90
Select only the data where the selected attribute is greater than 10 or 5  >10, OR ==5

NOTE: When you combine queries on multiple attributes these are combined as 'OR'. They are not combined as 'AND'.
For example, if you select the following queries:
- Q1 == 1
- Q2 >10
Only the data is selected where Q1 is equal to 1 OR Q2 is greater than 10.

4. You can then run the analysis based on your needs. If you want to have the filtered data on an Excel file you can download it in the Results section by clicking on the Excel icon on the right. The filtered dataset can be found in the Data_Query Excel sheet. 





    • Related Articles

    • How Can I Analyse My Data?

      In EyeQuestion there are multiple options to analyse the project data. When you go to the export page in the project you will find a dropdown menu called "Analysis". Auto Reports Via the option for Auto reports EyeQuestion will analyse the data and ...

    • Penalty Analysis

      Purpose To provide a penalty analysis of a consumer data set, that is to investigate how liking or acceptability of product decreases when product attributes are not at the optimal intensity. Data Format Consumer.xlsx Note: for EyeOpenR to read your ...

    • Correspondence Analysis (CATA and categorical data)

      Purpose To visualise and summarise analyse tabular data and to highlight the patterns of association in two way tables. It is widely used for mapping pure qualitative variables – e.g cluster by demographic use. This is an example of typical data that ...

    • How to use Live Data Monitor

      The live data monitor tool allows a project manager to quickly view the frequency results of the category questions and means of the linescale questions in a graphical output using a single click. The purpose of this tool is to immediately view the ...

    • Paired Comparison Analysis

      Purpose To analyse the results of a paired comparison test. Data Format paired_comparison.xlsx Datatype for the attribute is pairedcomp. Background A paired comparison test is a directional / specified test. It is used as a difference test with 2 ...