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:
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:
We've been developing intuitive high-quality statistical software at an affordable price, backed up by fast friendly customer service for over 25 years...
Office hours: 9am-5pm GMT Mon-Fri
It's Tuesday 5:02 PM and the office is closed - e-mail us and we'll get back to you as soon as possible.