Inference & Prediction API

Statistical testing and prediction interval functions.

OLS Inference

SELECT * FROM anofox_statistics_ols_inference(
    table_name,
    target_column,
    predictor_columns
);

Returns: t-statistics, p-values, confidence intervals for each coefficient

---

Prediction Intervals

SELECT * FROM anofox_statistics_ols_predict_interval(
    train_table,
    target_column,
    predictor_columns,
    new_data,
    confidence_level  -- 0.90, 0.95, 0.99
);

Returns:

• point_estimate - Predicted value
• lower_xx - Lower confidence/prediction bound
• upper_xx - Upper confidence/prediction bound

---

Batch Predict

SELECT * FROM anofox_statistics_model_predict(
    model_table,
    new_data,
    confidence_level
);

Efficient prediction with pre-fitted model.

---

Next Steps

• Diagnostics — Validation functions
• Aggregates — GROUP BY patterns