The Metalog Distributions

ELD (Equally Likely Data) Metalogs

Equally-likely-data (ELD) metalogs are ideal for applications in which a continuous distribution is needed to represent a set of independent and identically distributed (i.i.d.) discrete samples. Such samples typically consist of empirically-observed data (as in the fish biology and hydrology applications of The Metalog Distributions, Section 6.1). They may also be the output of a Monte Carlo simulation (as in the bidding decision simulations, The Metalog Distributions, Section 6.2). Users may specify up to 10,000 input data points (m=2 to 10,000) and choose among metalog distributions with numbers of terms ranging from 2 to 16 (n=2 to 16).

For ELD applications, only the x-axis CDF data is required.  The CDF y-values are calculated automatically by assigning equal probabilities to these data (see equation).  Otherwise, the ELD workbooks below are the same as the metalog workbooks.

This workbook is programmed without named ranges, macros, or external references so it can be easily and safely copied into other Excel workbooks while retaining its full functionality.  It is in ".xlsx" (Excel 2007 or later) format. For additional information, see the Excel Workbooks page. 

To download Excel workbook, click icon:
ELD Metalogs Workbook

To work in Excel Online with phone, tablet, or web browser, click this link and the one that follows.