I am trying to do some work that is primarily based in SQL Server. I cannot seem to find a native function to SQL that supports the Poisson distribution. Has anyone had success with applying Poisson natively within SQL?
-
3$\begingroup$ I am super curious as to the reason you wish to apply the Poisson distribution in a query. Can you elaborate. $\endgroup$– JahKnowsMar 10, 2017 at 17:29
-
1$\begingroup$ Do you want the CDF, the PDF, samples from it? $\endgroup$– SpacedmanMay 11, 2017 at 13:29
2 Answers
Yes, SQL Server does support it, as a part of Data Analysis Expressions (DAX).
The documentation for the function for getting Poisson distribution data is here.
It seems that someone has managed to implement a Poisson sampling in SQL Server. Checkout this link: http://bilquist.com/poisson-sampling-in-sql/