Linear Regression

Note that SQL Frames already has some statistics capabilities without this plugin because of the statistics related SQL constructs. One of them is the most common type of statistical analysis called linear regression. This is available as an analytic function which makes it very powerful to perform multi-dimensional data distribution analysis. The API, agg.regryo provides the Ŷ (y-hat) estimated value from the linear regression analysis.

Together with the integrated charts plugin that is capable of Dynamic Grids, below is the linear regression analysis of the bill_length_mm field studied with separate model per species but the visualization is further broken down by both species and also sex of the penguins.