The Metalog Distributions

Excel Workbooks

We offer free, downloadable Excel workbooks for practical use. There are three categories of workbooks: general, ELD (equally likely data), and SPT (symmetric percentile triplet). The ELD and SPT metalogs are special cases of the general metalogs -- tailored to common applications.
(input data)

Metalogs (Fully functional metalog workbooks for general use.) 2 to 10,000 2 to 16
ELD metalogs (Equally likely data parameters: x-data equally likely, y-data not required.) 2 to 10,000 2 to 16
SPT metalogs (Symetric-percentile-triplet parameters. Ideal for decision analysis.)
3 3

For a brief summary of the equations implemented in each workbook, see the equations portion of this website.

Each Excel workbook contains a graphs-and-calculations worksheet, which provides instant recalculations of CDF and PDF plots for user-specified data, a table of quantiles, Excel equations for use in simulation, and, as appropriate, moments and metalog panels. The notation and graphics in these workbooks is consistent with the metalog-system notation and conventions.  Some workbooks contain an additional documentation sheet as well. All workbooks are programmed without named ranges, macros, or external references so they can be easily and safely copied into other Excel workbooks while retaining their full functionality.  All workbooks are in ".xlsx" (Excel 2007 or later) format.