Analyzing a subset of the data

Use an Excel filter to show only the rows that match a value or meet a condition. Rows that do not match the condition are hidden temporarily, and subsequent data analysis excludes them.

Note: Be aware that the active filter is not saved with the analysis. When you recalculate an analysis the rows currently visible are analyzed, regardless of the filter you used when creating the analysis. This feature is extremely useful when you want to see how the analysis changes for a different subset of the data. You can change the filter criteria and then recalculate or clone the analysis to see the impact.
  1. On the Analyse-it ribbon tab, in the Dataset group, click Filter to show filter icons on the active dataset. If a filter is active click Filter to remove the filter and show all rows in the dataset.
  2. Click the drop-down button alongside a variable, and then either select the values to match, or click Number Filters to choose a condition.
  3. Create or recalculate an analysis to see the effect of the filter.


To filter to Female cases only, click the drop-down button alongside Sex, and then select Female in the list of values to match against:

To filter to cases where the subject is older than 40, click the drop-down button alongside Age, and then click Number Filters > Greater Than, and then enter 40 as the cut-off point: