The Statistics chart wizard provides guidance for those who want to apply common statistical tests on data in QlikView.
Starting the Statistics Chart Wizard
Start the statistics chart wizard by choosing Statistics Chart Wizard from the Tools menu. The first page offers a choice of statistical tests. Select the appropriate type of test and then click Next to continue.
Please note that QlikView supports more types of tests than those covered in the wizard. For further information about statistical tests and their uses, please refer to a statistics text book.
Chi2-Test
This option generates a straight table with values returned from a Chi2-test. A Chi2-test is often used to compare two sets of values and determine the probability that the two sets come from the same statistical distribution. To obtain the Chi2-test chart, you must specify the following:
- Column: Specify a field or expression returning column headers for the test data sample.
- Row: Specify a field or expression returning row headers for the test data sample.
- Value: Specify a field or expression returning test value data.
- Expected Value: Mark this check box if you want to test against expected value. Enter a field name or an expression returning expected value in the edit box below. If expected values are not specified, the test will be made for variations within the rows/columns.
- p (Show p-value / Significance): Mark this check box to include the p value (significance) in the resulting chart.
- df (Show Degrees of Freedom): Mark this check box to include the df value (degrees of freedom) in the resulting chart.
- Chi2 (Show Chi2 Value): Mark this check box to include the test value in the resulting chart.
Click Finish to finalize the chart and return to the layout. Return to the chart at any time via the regular Chart Properties dialog to make further adjustments.
Paired T-Test
This option generates a straight table with values returned from a paired student's t-test.
To obtain the t-test chart, you must specify the following:
- Value Field / Expression: Specify a field or expression returning test value data series.
- Test Value: Specify a field or expression returning a test value.
- t (Show t-value): Mark this check box to include the t-value in the resulting chart.
- df (Show Degrees of Freedom): Mark this check box to include the df value (degrees of freedom) in the resulting chart.
- p (Show p-value / Significance (2-tailed)): Mark this check box to include the p-value (significance, 2-tailed) in the resulting chart.
- Mean difference: Mark this check box to include the mean difference value in the resulting chart.
- Lower (CL %): Mark this check box to include the lower limit of the confidence interval (as specified in Confidence Level below) in the resulting chart.
- Upper (CL %): Mark this check box to include the upper limit of the confidence interval (as specified in Confidence Level below) in the resulting chart.
- Confidence Level: Specify a percentage for the level of confidence.
Click Finish to finalize the chart and return to the layout. Return to the chart at any time via the regular Chart Properties dialog to make further adjustments.
Independent Samples T-Test
This option generates a straight table with values returned from a two-sample unpaired student's t-test.
To obtain the t-test chart, you must specify the following:
- Grouping Field/Expression: Specify a field or expression returning test grouping data series. Exactly two values must be returned.
- Test Field/Expression: Specify a field or expression returning the test value data series.
- t (Show t Value): Mark this check box to include the t value in the resulting chart.
- df (Show Degrees of Freedom): Mark this check box to include the df value (degrees of freedom) in the resulting chart.
- p (Show p-value / Significance (2-tailed)): Mark this check box to include the p-value (significance, 2-tailed) in the resulting chart.
- Mean difference: Mark this check box to include the mean difference value in the resulting chart.
- Lower (CL %): Mark this check box to include the lower limit of the confidence interval (as specified in Confidence Level below) in the resulting chart.
- Upper (CL %): Mark this check box to include the upper limit of the confidence interval (as specified in Confidence Level below) in the resulting chart.
- Confidence Level: Specify a percentage for the level of confidence.
Click Finish to finalize the chart and return to the layout. Return to the chart at any time via the regular Chart Properties dialog to make further adjustments.
