How to Add Rows to a Table to Display Effective Column Sample Size

Introduction

This article describes how to go from a standard table...

...to a table with an additional row or rows that show the Effective Column Sample Size:

Method

1. Select your table.

2. In the toolbar go to Automate > Browse Online Library > Table Computations > Add Rows to Display Effective Column Sample Size.

3. Press OK.

4. This rule then computes an estimate of Effective Column Sample Size for each column and displays it on the table. Where the cells in the column have different values of Column n, Base n or Effective Base n, minimum and maximum range values are shown.

Effective Column Sample size is computed using:

Effective Column Sample Size = Column n / Base n * Effective Base n

5. OPTIONAL: If you only have a percentage-based statistic displayed in your table, you will need to turn off the % signs via the toolbar. 

Note, if you select Switch rows and columns on your table, the rule will no longer work due to the table dimensions changing.

Next

How to Use Rules in Q

How to Investigate When The Effective Sample Size Greater Than 100%