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.
These workbooks are easy to use. Click here for a YouTube video on how to do so. This video builds on prior videos: Metalogs Workbook and ELD Single Data Set Workbook. If you are not already familiar with them, you may wish to view them first.
Metalog Equation Maker Workbooks
equation maker with button
equation maker with auto recalc
ELD Single Data Set Equation Maker Workbooks
equation maker with button
equation maker with auto recalc
Website copyrighted by Tom Keelin 2016-2022. Free use of this website is encouraged,
including use of downloadable files. Contact: tomk@keelinreeds.com.
