The Metalog Distributions

ELD Metalogs Workbooks

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 workbook below is the same as the Metalogs Workbook.

These 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.  They are in ".xlsx" (Excel 2007 or later) format. For additional information, see the Excel Workbooks page. 


Single Data Set ELD Workbook

This workbook is set up to use with one set of input data at a time. To download this Excel workbook, click Excel icon.

Multi Data Set ELD Workbook

This workbook is set up to use up to 10 data sets. Otherwise its functionality is the same as the Single Data Set ELD Workbook. ELD metalogs are calculated for the data set of your choice.  By changing a single control, you can explore multiple data sets on a single worksheet. To download this Excel workbook, click Excel icon.

ELD Metalogs Workbook - single data set
ELD Metalog Workbook - multi data sets

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


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