Examples of how to use chi2-test functions in the data load script
The chi2-test functions are used to find values associated with chi squared statistical analysis. This section describes how to use the chi-squared distribution test functions available in Qlik Sense in the data load script. Please refer to the individual chi2-test script function topics for descriptions of syntax and arguments.
This example uses a table containing the number of students achieving a grade (A-F) for two groups of students (I and II).
Group | A | B | C | D | E | F |
---|---|---|---|---|---|---|
I | 15 | 7 | 9 | 20 | 26 | 19 |
II | 10 | 11 | 7 | 15 | 21 | 16 |
Loading the sample data
Do the following:
- Create a new app.
-
In the data load editor, enter the following:
// Sample_1 data is pre-aggregated... Note: make sure you set your DecimalSep='.' at the top of the script.
Sample_1:
LOAD * inline [
Grp,Grade,Count
I,A,15
I,B,7
I,C,9
I,D,20
I,E,26
I,F,19
II,A,10
II,B,11
II,C,7
II,D,15
II,E,21
II,F,16
];
- Click to load data.
You have now loaded the sample data.
Loading the chi2-test function values
Now we will load the chi2-test values based on the sample data in a new table, grouped by Grp.
Do the following:
-
In the data load editor, add the following at the end of the script:
// Sample_1 data is pre-aggregated... Note: make sure you set your DecimalSep='.' at the top of the script.
Chi2_table:
LOAD Grp,
Chi2Test_chi2(Grp, Grade, Count) as chi2,
Chi2Test_df(Grp, Grade, Count) as df,
Chi2Test_p(Grp, Grade, Count) as p
resident Sample_1 group by Grp;
- Click to load data.
You have now loaded the chi2-test values in a table named Chi2_table.
Results
You can view the resulting chi2-test values in the data model viewer under Preview, they should look like this:
Grp | chi2 | df | p |
---|---|---|---|
I | 16.00 | 5 | 0.007 |
II | 9.40 | 5 | 0.094 |