Programming Col Sig (proportions): Part 2 - Student Test using estimator
| Summary | 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. |
| Applies to | AskiaAnalyse |
| Written for | Researchers, Developers, Data Processors. |
| Keywords | Table arithmetic, Forloops, Coordinates, data, Calculation arithmetic, Bespoke calculation, Filtered, Multiplication table, Classical Student Test, Estimator, Sigma2, Z-test, Pooled variance, Confidence interval, 95%, FilterBy, GetColSigLetter. |
The QES file and portfolio containing the examples discussed is attached: Table Arithmetic Examples 11 & 12.rar.
Student Test using estimator (Sigma2)
In this demonstration I will create a table which shows the pre-set col sig calculation side by side with the programmed calculation for the same test. First, let's review the formula:
The pre-set calculation looks like this in AskiaAnalyse:
Calc: ColSig
In the syntax below I show how to achieve these settings. Notice that 'Test against total column' is not ticked - this setting is dealt with by the parts of the syntax highlighted in yellow.
Also, 'Display minus if under' is ticked. This dealt with by the parts of the syntax highlighted in green.
Calc: #ColSig
You can see the result of this by running tab definition: Sigma2 in the example portfolio:
