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. 

Click here for a YouTube video on getting started with this workbook. This video builds on the prior Metalogs Workbook video. If you are not already familiar with the Metalogs Workbook, view this prior video first.

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 workbook, click the Excel icon.

Click here for a YouTube video on how to get started with this workbook. This video builds on prior videos: Metalogs Workbook and ELD Single Data Set Workbook. If you are not already familiar with this prior material, view the prior videos first.

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