glim | Static site generator which is semi-compatible with Jekyll | Static Site Generator library

You don't provide any sample data or expected results but - as the function can return one value only - you will most likely have to use the function in a subquery which you join to the main query on the field you group by in the main query. This way you will filter on the value you group by in the main query.

This will give you the requested Quartile(s). Min, Max, and Median can be obtained with the native function of Access.

Edit

Actually, it could be something like this:

This a classic merging problem. One way to solve is using straight loc and index-matching

I contacted the authors regarding this. The issue is that a negative binomial is only able to model over dispersion, whereas my data contains both under- and over-dispersed output variables, between different dependent variable groups. This results in the error for the sigma going to 0.

The problem could be that the data are underdispered. and sigma goes to zero and the derivatives produced NA’s. Try to fit double Poisson DPO() in this specific data set.

As recommended by the one of the authors, a distribution such as double poisson allows for fitting this because the standard deviation can be modelled being both more or less than the mean. When using this distribution, this solved the above problem for me and I was able to fit a model.