Exclusive Content & Downloads from ASQ

Distribution Selection with No Data Using VBA and Excel

Summary: [This abstract is based on the authors' abstract.] It is often necessary in statistical analyses or Monte Carlo simulations to assume distributions for variables with no data, but without the ability to select from potentially competing distributions, analysts often rely on traditional distributions that prevent them from constructing an accurate model. An algorithm and flowchart are described to help narrow the selection of distributions. A software program supporting the method that is particularly useful when selecting parameters for a chosen distribution is developed and illustrated.

Anyone with a subscription, including Site and Enterprise members, can access this article.

Other Ways to Access content:

Join ASQ

Join ASQ as a Full member. Enjoy all the ASQ member benefits including access to many online articles.

  • Topics:
  • Keywords: Monte Carlo methods,Bayesian methods,Flowcharts,Statistical methods,Ranking and selection,Statistical distribution,Goodness of fit
  • Author: Craney, Trevor A.; White, Nathan
  • Journal: Quality Engineering