tidypredict_sql_interval

Arguments
Examples

Returns a SQL query with formula to calculate predicted interval

tidypredict_sql_interval(model, con, interval = 0.95)

Arguments

model	An R model or a tibble with a parsed model
con	Database connection object. It is used to select the correct SQL translation syntax.
interval	The prediction interval, defaults to 0.95

Examples

library(dbplyr)

model <- lm(mpg ~ wt + am + cyl, data = mtcars)
tidypredict_sql_interval(model, simulate_dbi())
#> <SQL> (2.04840714179524) * SQRT((((((-0.176776695296637) * (-0.176776695296637) * (6.8231093058295)) + (((-0.590557271637747) + (("wt") * (0.183559646169165))) * ((-0.590557271637747) + (("wt") * (0.183559646169165))) * (6.8231093058295))) + ((((0.769566489443368) + (("wt") * (-0.176199380745393))) + (("am") * (-0.498926847360626))) * (((0.769566489443368) + (("wt") * (-0.176199380745393))) + (("am") * (-0.498926847360626))) * (6.8231093058295))) + (((((-0.224404416240186) + (("wt") * (-0.23845787029348))) + (("am") * (-0.0214203331902853))) + (("cyl") * (0.161662223806132))) * ((((-0.224404416240186) + (("wt") * (-0.23845787029348))) + (("am") * (-0.0214203331902853))) + (("cyl") * (0.161662223806132))) * (6.8231093058295))) + (6.8231093058295))