Search Shortcut cmd + k | ctrl + k
anofox_statistics

A DuckDB extension for statistical regression analysis, providing OLS, Ridge, WLS, and time-series regression capabilities with complete diagnostics and inference directly in SQL.

Maintainer(s): sipemu

Installing and Loading

INSTALL anofox_statistics FROM community;
LOAD anofox_statistics;

Added Functions

function_name function_type description comment examples
aic scalar NULL NULL  
aid_agg aggregate NULL NULL  
aid_anomaly_agg aggregate NULL NULL  
alm_fit_agg aggregate NULL NULL  
anofox_stats_aic scalar NULL NULL  
anofox_stats_aid_agg aggregate NULL NULL  
anofox_stats_aid_anomaly_agg aggregate NULL NULL  
anofox_stats_alm_fit_agg aggregate NULL NULL  
anofox_stats_bic scalar NULL NULL  
anofox_stats_bls_fit_agg aggregate NULL NULL  
anofox_stats_elasticnet_fit scalar NULL NULL  
anofox_stats_elasticnet_fit_agg aggregate NULL NULL  
anofox_stats_elasticnet_fit_predict aggregate NULL NULL  
anofox_stats_jarque_bera scalar NULL NULL  
anofox_stats_jarque_bera_agg aggregate NULL NULL  
anofox_stats_nnls_fit_agg aggregate NULL NULL  
anofox_stats_ols_fit scalar NULL NULL  
anofox_stats_ols_fit_agg aggregate NULL NULL  
anofox_stats_ols_fit_predict aggregate NULL NULL  
anofox_stats_ols_predict_agg aggregate NULL NULL  
anofox_stats_poisson_fit_agg aggregate NULL NULL  
anofox_stats_predict scalar NULL NULL  
anofox_stats_residuals_diagnostics scalar NULL NULL  
anofox_stats_residuals_diagnostics_agg aggregate NULL NULL  
anofox_stats_ridge_fit scalar NULL NULL  
anofox_stats_ridge_fit_agg aggregate NULL NULL  
anofox_stats_ridge_fit_predict aggregate NULL NULL  
anofox_stats_rls_fit scalar NULL NULL  
anofox_stats_rls_fit_agg aggregate NULL NULL  
anofox_stats_rls_fit_predict aggregate NULL NULL  
anofox_stats_vif scalar NULL NULL  
anofox_stats_vif_agg aggregate NULL NULL  
anofox_stats_wls_fit scalar NULL NULL  
anofox_stats_wls_fit_agg aggregate NULL NULL  
anofox_stats_wls_fit_predict aggregate NULL NULL  
bic scalar NULL NULL  
bls_fit_agg aggregate NULL NULL  
elasticnet_fit scalar NULL NULL  
elasticnet_fit_agg aggregate NULL NULL  
elasticnet_fit_predict aggregate NULL NULL  
jarque_bera scalar NULL NULL  
jarque_bera_agg aggregate NULL NULL  
nnls_fit_agg aggregate NULL NULL  
ols_fit scalar NULL NULL  
ols_fit_agg aggregate NULL NULL  
ols_fit_predict aggregate NULL NULL  
ols_predict_agg aggregate NULL NULL  
poisson_fit_agg aggregate NULL NULL  
residuals_diagnostics scalar NULL NULL  
residuals_diagnostics_agg aggregate NULL NULL  
ridge_fit scalar NULL NULL  
ridge_fit_agg aggregate NULL NULL  
ridge_fit_predict aggregate NULL NULL  
rls_fit scalar NULL NULL  
rls_fit_agg aggregate NULL NULL  
rls_fit_predict aggregate NULL NULL  
vif scalar NULL NULL  
vif_agg aggregate NULL NULL  
wls_fit scalar NULL NULL  
wls_fit_agg aggregate NULL NULL  
wls_fit_predict aggregate NULL NULL