# Tutorial - Lilliefors Test Analysis - Teradata Warehouse Miner

## Teradata Warehouse Miner User Guide - Volume 3Analytic Functions

Product
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
yuy1504291362546.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2302
Product Category
Software

In this example, a Lilliefors test analysis is performed on the fictitious banking data to analyze account usage.

1. Parameterize a Lilliefors Test analysis as follows:
• Available Tables — twm_customer_analysis
• Column of Interest — income
• Group By Columns — years_with_bank
• Analysis Parameters
• Threshold Probability — 0.05
2. Run the analysis.
3. Click Results when it completes.

For this example, the Lilliefors Test analysis generated the following table. The Lilliefors Test was computed for each distinct value of the group by variable “years_with_bank”. Results were sorted by years_with_bank. The tests show the user that all incomes were not normally distributed.

‘p’ means significantly nonnormal and an ‘a’ means accept the null hypothesis of normality.
The SQL is available for viewing but not listed below.
Lilliefors Test
years_with_bank Lilliefors M LillieforsPValue LillieforsPText LillieforsCallP_0.05
0 0.166465166 88 0.01 <0.01 p
1 0.123396019 87 0.01 <0.01 p
2 0.146792366 94 0.01 <0.01 p
3 0.156845809 86 0.01 <0.01 p
4 0.192756959 78 0.01 <0.01 p
5 0.144308699 82 0.01 <0.01 p
6 0.125268495 83 0.01 <0.01 p
7 0.141128127 65 0.01 <0.01 p
8 0.191869596 45 0.01 <0.01 p
9 0.111526787 39 0.20 >0.20 a