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: Data> EyeOpenR logo. 


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

    • Data Cleaning

      Introduction Following data collection, it's essential to ensure the validity of the collected data and address any instances where participants may have completed the questionnaire without due attention. To tackle this issue, we've introduced a ...

    • How Can I Analyse My Data?

      In EyeQuestion there are multiple options to analyze the project data. When you select the Data tab in your project you will find a dropdown menu Analysis: Auto Reports Via the option for Auto reports EyeQuestion will analyze the data and create the ...

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

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