This example calculates and outputs only basic statistics.
Input
- finance_data3, as in VARMAX Example: No Exogenous Model
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.