UPCOMING WEBINAR: The Roadmap for Market Researchers in the Age of AI 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:
Requirements
A table with multiple rows and columns.
Method
1. Select your table.
2. Go to Data > Rules on the object inspector .
3. Click Plus (+) > Calculation > Add Rows: Effective Column Sample Size > 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 Sample Size, Sample Size, or Effective Sample Size, minimum and maximum range values are shown.
Effective Column Sample size is computed using:
Effective Column Sample Size = Column Sample Size / Sample Size * Effective Sample Size
5. OPTIONAL: If you only have a percentage-based statistic displayed in your table, you will need to turn off the % signs via Appearance > %.
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 Sample Size in a statistic that is already selected in the Statistics - Cells. The script will try to use a non-% statistic (e.g., Count or Column Sample Size) to display the Effective Column Sample Size, but will choose a % statistic (e.g., % or Column %) if no non-% statistics are selected on the table.
- The Effective Column Sample Size will not necessarily 'add up' unless:
- Weights and significance is set to Kish's 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.