1
$\begingroup$

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?

$\endgroup$
2
  • 3
    $\begingroup$ I am super curious as to the reason you wish to apply the Poisson distribution in a query. Can you elaborate. $\endgroup$
    – JahKnows
    Mar 10, 2017 at 17:29
  • 1
    $\begingroup$ Do you want the CDF, the PDF, samples from it? $\endgroup$
    – Spacedman
    May 11, 2017 at 13:29

2 Answers 2

1
$\begingroup$

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.

$\endgroup$
0
$\begingroup$

It seems that someone has managed to implement a Poisson sampling in SQL Server. Checkout this link: http://bilquist.com/poisson-sampling-in-sql/

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.