Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com
Learn how to create Excel dashboards.

Random Functions For Excel

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Z Random Start

Excel Functions

The Mersenne Twister generator and all implemented distributions are implemented as excel formula's and can be accessed in spreadsheet cells and as part of other functions. The ZRandom functions ZRAND and ZRANDBETWEEN accept an optional seed and can return both single cell values and arrays for even greater speed.

 

 

The function ZSAMPLE can sample any value from a list of cells.

Bernoulli =ZBERNOULL(p)
Beta =ZBETA(a,b)
Burr =ZBURR(alpha,theta,gamma)
Exponential =ZEXPONENTIAL(mean)
Gamma =ZGAMMA(alpha,theta)
Geometric =ZGEOMETRIC(p)
Hypergeometric =ZHYPERGEOMETRIC(p)
Lognormal =ZLOGNORMAL(mu,sigma)
Negative Binomial =ZNEGATIVEBINOMIAL(r,p)
Normal =ZNORMAL(mean, stddev)
Pareto =ZPARETO(alpha,theta)
Poisson =ZPOISSON(lambda)
Triangular =ZTRIANGULAR(minimum,maximum [, peak])
Uniform (cont.) =ZUNIFORM(minimum,maximum)
Uniform =ZRAND(MIN, MAX)
Weibull =ZWEIBULL(theta, tau)

Z Random Start

More about Z Random: Continuous Distributions | Functions | A VBA Interface | Interactive User Interface | Generate Random Samples | random Sort

Z Random for Excel   Secure Payment Options 30 Day Money Back Guarantee

 

Pricing:
1 - 4 Licenses $29.95 USD
5 - 9 Licenses $24.95 USD
10 - 24 Licenses $19.95 USD
25+ Licenses $14.95 USD

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

See Also: OzGrid Excel Plus || Monte Carlo Add-In for Excel || Random Numbers Generator and Statistics || Numerical Searching Methods and Option Pricing Models || Finance and Statistics Models || Excel Add-ins or, All Software


Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS