CDF/PDF and Inverse CDF for Erlang distribution in VBA
$30-5000 USD
Paid on delivery
Erlang distribution
I request that you provide in VBA for Excel user-defined functions that calculate the following functions of the distribution stated above: (1) Cumulative distribution function (CDF), (2) Inverse cumulative distribution function, and (3) Probability density function (PDF). It is important that you declare “Option Explicit?? at the top of your modules, which requires that you declare variable types. The final product should be incorporated into a spreadsheet like the one that is attached. It is a model example of what I would like.
You may call Excel functions for things like the gamma function, beta function, sin, cos, etcetera. Or you may incorporate and use the files from the open source project Alglib (<[url removed, login to view]>). But the distribution function itself must be original.
In addition to Wikipedia, which does not have sufficient detail for all of the distributions that I require, there are good resources on probability distributions available in the reference to commercial packages listed below.
<[url removed, login to view]>
<[url removed, login to view]>
## Deliverables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
## Platform
The code should be fine if it runs under Excel '97 or later. VBA has been the same (a stripped down version of VB 6) since Excel '97.
Project ID: #3549152
About the project
Awarded to:
5 freelancers are bidding on average $108 for this job
