Equation-Maker Workbooks
For a given data set and input parameters (number of terms and upper/lower bounds if any), the equation-maker workbooks below provide the exact equations of the metalog quantile and probability-density functions. These equations may then be copied, pasted, and used in other Excel workbooks or applications.
These workbooks, which add functionality to the Metalogs Workbook and ELD Single Data Set Workbook, provide the equations just below the main graphics. In the "auto-recalc" workbooks below, macros update these equations automatically with each keystroke. In the "button" workbooks below, the user clicks a button on the worksheet to update the equations. For getting started, the auto-recalc version is most convenient. However, if you run into difficulties (especially if you have other Excel workbooks open), switch to the button version.
|