Knowledge base updates

Below a quick introduction to the latest articles added to our Knowledge base by our tech support team.

Significance Testing for Overlapping & Independent Samples

This article gives more information on the situations in which overlapping samples can be sig tested in askiaanalyse. This KB article explains the correct tests to use when testing for significance in independent or overlapping samples.

Significance testing diagram

If you are sig testing columns and it’s the case that a respondent belongs to more than one column (e.g. in a multi-coded question or loop summary table) then the most statistically accurate tests to use are the paired tests. Otherwise, it’s the independent tests.

Check out the knowledge base article for the detailed version.

Clean up your askiafield environment

As with many server applications, we, as users, tend to let our askiafield server environment clutter with files, leftover metadata other useless tidbits. These can slow down the host environment and even impact production performance.
We have added a complete guide to get rid of this unused data, free up some space on your askiafield server.

From freeing up memory to speed up application responsiveness to backing up your SQL data and askiafield data to save storage space.

More information in the full article.

Programming Column Significance

This 3-part article details the use of Student Test column significance calculations in askiaanalyse. Each part of this article concentrates on specific aspect of these calculations:

1. Classical Student Test

This article demonstrates a scenario in which which we would need to script the formula for Classical student test on closed question. It shows the formula and gives two examples on how to program it with a few tips on how to refine the syntax and mirror settings in the pre-set col sig calculation.

2. Student test using estimator

This article demonstrates how to script the formula for Student Test using estimator on closed questions. Formula and syntax are shown along with tips on how to mirror particular settings in the pre-set col sig calculation.

3. Student test using efficiency coefficient

This article demonstrates how to script the formula for Student Test using efficiency coefficient on closed questions. Formula and syntax are shown. There is also a demonstration of calculating Effective base manually.

Read this 3-part article:

Significance and Count Threshold

Why does significance change when I switch level or add waves of data in Askia Analyse?

This post explains which count is considered for the ‘Count threshold’ setting in Col sig advanced options. There is detail on how to calculate ‘Counts when independent’ and why this can change sig testing when the total base grows.


From time to time clients will raise a query regarding sig testing (Column significativity on closed) for a particular cell changing when the total base of their table grows, even though the count and % for cells in the table remains the same. E.g. this can happen when new waves of data are added or the level has been changed to show the response counts rather than respondent counts.

The reason for this is almost certainly the Count threshold setting in the col sig advanced options; it has been left as the default value, 5.

Column significativity advanced options in askiaanalyse

The Count threshold does not use the counts you would normally see in your tables but, instead, it uses the counts from the calculation Counts when independent.

You need to use the count when independent rather than the actual count because the usual count in the cell (crossed count) can still carry importance at low or zero counts.

Below is an example of when the the sig testing changes even though the count and % have remained the same (see column G)

Example of sig test change in askiaanalyse

5 is the default because this doesn’t bring to your attention differences which are not statistically important. The side effect is that you can have changes as the total base grows over time (and hence changes the count when independent). If this behaviour is not in line with requirements, the Count threshold can be changed to 0.

This applies to Column significativity on closed but you cannot perform the same calculation for Column significativity on numeric. The Count threshold setting exists in its advanced settings but it is not applicable and has no effect.

Link to this knowledge base article in our help centre