CDF/PDF and Inverse CDF for Arcsine distribution in VBA
$30-5000 USD
进行中
已发布将近 14 年前
$30-5000 USD
货到付款
**Arcsine distribution**
I request that you provide in VBA the Excel user-defined functions for calculating 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.
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 (<[login to view URL]>). 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.
<[login to view URL]>
<[login to view URL]>
## 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.