1.1 - 8.10 - UnivariateStatistics Example: StatisticsGroups ('basic') - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

This example calculates and outputs only basic statistics.

Input

SQL Call

DROP TABLE basic_2; 
SELECT * FROM UnivariateStatistics(
    ON finance_data3 AS InputTable
    OUT TABLE BasicTableName(basic_2)
    USING
    ExcludeColumns('id','period')
    StatisticsGroups('BASIC')

) AS dt;

Output

 message                                                      
 ------------------------------------------------------------ 
 UnivariateStatistics succeeded. The output tables are saved.

The output table, basic_2, is the same as UnivariateStatistics Example: ExcludeColumns, All Statistics output table basic.

SELECT * FROM basic_2 ORDER BY 1;
 stats                     expenditure      income           investment       
 ------------------------- ---------------- ---------------- ---------------- 
 Bottom 5 (1)                         415.0            451.0            179.0
 Bottom 5 (2)                         421.0            465.0            180.0
 Bottom 5 (3)                         434.0            485.0            185.0
 Bottom 5 (4)                         448.0            493.0            192.0
 Bottom 5 (5)                         458.0            509.0            202.0
 Geometric mean            1020.53565750432 1176.50711695451 425.089198191843
 Harmonic mean             891.824091552794  1017.9035289329  381.44257427176
 Interquartile range                  997.0           1159.0            311.0
 Mean                      1166.67391304348 1355.08695652174 471.913043478261
 Median                              1013.0           1178.0            494.0
 Mode                                 574.0            799.0            519.0
 Number of negative values              0.0              0.0              0.0
 Number of NULL values                  0.0              0.0              0.0
 Number of positive values             92.0             92.0             92.0
 Number of unique values               91.0             91.0             83.0
 Number of zero values                  0.0              0.0              0.0
 Range                               1856.0           2200.0            691.0
 Standard deviation        590.923585337053 698.928750981727 210.746691977944
 Top 5 (1)                           2271.0           2651.0            870.0
 Top 5 (2)                           2250.0           2639.0            860.0
 Top 5 (3)                           2237.0           2628.0            853.0
 Top 5 (4)                           2235.0           2620.0            852.0
 Top 5 (5)                           2225.0           2618.0            844.0
 Variance                  349190.683707597 488501.398948877 44414.1681796464

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.