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 the following:
- It may be necessary to turn off the % signs in your table to make the best use of this script. This is because the script displays the Effective n in a statistic that is already selected in the Statistics - Cells. The script will try to use a non-% statistic (e.g. n or Column n) to display the Effective Column n, but will choose a % statistic (eg % or Column %) if no non-% statistics are selected on the table.
- The Effective Column n will not necessarily 'add up' unless:
- Weights and significance is set to Kish approximation or a specific value, and
- There is no missing data.
- 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 Investigate When The Effective Sample Size Greater Than 100%