Tutorial - One-Way F-Test Analysis - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 3Analytic Functions

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
yor1538171534879.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2302
Product Category
Software

In this example, an F-test analysis is performed on the fictitious banking data to analyze income by gender.

  1. Parameterize an F-Test analysis as follows:
    • Available Tables — twm_customer
    • Column of Interest — income
    • Columns — gender
    • Group By Columns — years_with_bank, nbr_children
    • Analysis Parameters
      • Threshold Probability — 0.01
  2. Run the analysis.
  3. Click Results when it completes.

    For this example, the F-Test analysis generated the following page. The F-Test was computed on income over gender for every combination of years_with_bank and nbr_children. Results were sorted by years_with_bank and nbr_children in the listing below.

    The tests shows whether significant differences exist in income for males and females, and does so separately for each value of years_with_bank and nbr_children. A ‘p’ means the difference was significant, and an ‘a’ means it was not significant. If the field is null, it indicates there was insufficient data for the test. The SQL is available for viewing but not listed below.

    F-Test (one-way)
    years_with_bank nbr_children DF DFErr F FPValue FPText FCallP_0.01
    0 0 1 53 0.99 0.25 >0.25 a
    0 1 1 8 1.87 0.22   a
    0 2 1 10 1.85 0.22   a
    0 3 1 6 0.00 0.25 >0.25 a
    0 4 1 0        
    0 5 0 0        
    1 0 1 55 0.00 0.25 >0.25 a
    1 1 1 6 0.00 0.25 >0.25 a
    1 2 1 14 0.00 0.25 >0.25 a
    1 3 1 2 0.50 0.25 >0.25 a
    1 4 0 0        
    1 5 0 0        
    2 0 1 55 0.82 0.25 >0.25 a
    2 1 1 14 1.54 0.24   a
    2 2 1 14 0.07 0.25 >0.25 a
    2 3 1 1 0.30 0.25 >0.25 a
    2 4 0 0        
    2 5 0 0        
    3 0 1 49 0.05 0.25 >0.25 a
    3 1 1 9 1.16 0.25 >0.25 a
    3 2 1 10 0.06 0.25 >0.25 a
    3 3 1 6 16.90 0.01   p
    3 4 1 1 4.50 0.25 >0.25 a
    3 5 0 0        
    4 0 1 52 1.84 0.20   a
    4 1 1 10 0.54 0.25 >0.25 a
    4 2 1 6 2.38 0.20   a
    4 3 0 0        
    4 4 0 0        
    4 5 0 1        
    5 0 1 46 4.84 0.04   a
    5 1 1 15 0.48 0.25 >0.25 a
    5 2 1 10 3.51 0.09   a
    5 3 1 2 2.98 0.24   a
    5 4 0 0        
    6 0 1 46 0.01 0.25 >0.25 a
    6 1 1 14 3.67 0.08   a
    6 2 1 15 0.13 0.25 >0.25 a
    6 3 0 0        
    6 5 0 0        
    7 0 1 41 4.99 0.03   a
    7 1 1 8 0.01 0.25 >0.25 a
    7 2 1 4 0.13 0.25 >0.25 a
    7 3 1 2 0.04 0.25 >0.25 a
    7 5 0 1        
    8 0 1 23 0.50 0.25 >0.25 a
    8 1 1 7 0.38 0.25 >0.25 a
    8 2 1 6 0.09 0.25 >0.25 a
    8 3 1 0        
    8 5 0 0        
    9 0 1 26 0.07 0.25 >0.25 a
    9 1 1 3 3.11 0.20   a
    9 2 1 1 0.09 0.25 >0.25 a
    9 3 1 1 0.12 0.25 >0.25 a