XLSTAT: How to Analyze Filtered Data in Excel

To explain the process, we have provided an example.

 

Background

On the Data tab of your Excel spreadsheet, in the Sort & Filter group, click Filter.

Arrows in the column headers appear.

• Click the arrow next to Age class.

• Click the check box next to >45 in order to deselect this specific age group and click OK. 

  

 

Dataset for Example

The data in this example are the results of a survey on the amount of money people spend on online shopping on a monthly average basis.

• Rows correspond to respondents
• Columns to the amount of money spent and the respondent's age group

Here, we want to compute descriptive statistics for the survey responses. We will focus on the younger population of the respondents thus we will first exclude the age group >45 using the Excel filter option and then carry out the analysis using XLSTAT.

 

Setting Up

• Open XLSTAT.

• Click on the  Describing data menu and select the Descriptive statistics feature.

 

• The Descriptive Statistics dialog box appears.

In the General tab:

• Select column B in the Quantitative data field

• Select column A in the Subsamples field.

 

• Click OK.

• A new window pops up. Click on the 1 button in order to run the calculations.

 

 

Interpreting the Results

The age class >45 is successfully excluded from both tables and graphs of the XLSTAT output.

For more information, go to Mean, median, standard deviation & more.

NOTE: You can perform any data analysis method on a filtered data table by

• selecting the appropriate feature from the XLSTAT menu
• filtering your data
• configuring the dialog box
• starting the computations.

IMPORTANT: The ability of analyzing filtered data is currently available in most of the essential XLSTAT features (e.g. ANOVA, Histograms, Normality tests, PCA, etc) plus a few advanced features (e.g. Conjoint analysis, Mann-Kendall, Random forest, etc).