Filtering data for analysis

When exploring data it can be useful to analyse a subset of the cases from the dataset, for example to see summary statistics for just Male or Female subjects.

To allow analysis of just a subset of cases Analyse-it only analyses the cases that are visible on the worksheet. Observations on hidden rows will not be included in the analysis. Rows can be manually hidden to exclude them from analysis, or Excel's AutoFilter or Advanced Filter can be used to hide rows based on conditions:

A specific value or category, e.g. filter by Sex to just show Female cases.
A range of the highest or lowest values of the variable. The number of values to show, e.g. 10, or a percentage of the total number of values, e.g. show 10% of the top values, can be chosen.
A boolean condition using operators such as <, >, <=, >= and using boolean AND or OR to combine up to two conditions.

IMPORTANT When Analyse-it updates a report it will analyse the cases that are currently visible in the dataset, rather than the cases that were visible when the analysis was first performed.

To use AutoFilter to limit analysis to a subset of the dataset:

Select a cell in range containing a List dataset.
Click Filter on the Analyse-it tab/toolbar.
Excel shows drop-down arrows alongside the names of the variables of the dataset. Click the drop-down arrow then click the value to filter to, Top 10... to filter to a range of values, or Custom... to use a boolean condition.
Analyse-it will now analyse just the subset of the dataset.

Part of the Analyse-it for Microsoft Excel user guide. For more information about Analyse-it, the statistics add-in for Microsoft Excel, or to download a free 30-day trial please visit http://www.analyse-it.com/. © Analyse-it Software, Ltd. Analyse-it® is a registered trademark. Microsoft® Excel® is a registered trademark of Microsoft.