FIT.DISTRIBUTION

You are here:

AXCEL.FIT.DISTRIBUTION function

This function fits a distribution for an input data. It produces fitting specification and plots.

Syntax

AXCEL.FIT.DISTRIBUTION(data, [distribution], [method])

The AXCEL.CHOOSE.DISTRIBUTION function syntax has the following arguments:

data Required. It is a vector of number for which we would like to fit the distribution.

distribution Required. This is a the distribution which you would like to fit. The list of available distributions is:

      "norm": Normal
      "gamma": Gamma
      "exp": Exponential
      "pois": Poisson
      "logis": Logistic 
      "lnorm": Log-normal 
      "weibull": Weibull
      "beta": Beta
      "geom" Geometric

method Optional. Default is “mle”. The list of available methods is:

"mle": for 'maximum likelihood estimation (default)
"mme": for 'moment matching estimation
"mge": for 'maximum goodness-of-fit estimation
"mse": for 'maximum spacing estimation

Example:

Imagine you have a set of numbers in A1:A100 cells. To to fit a gamma distribution on this sample with “mle” (default) methodology, you can run:

=AXCEL.FIT.DISTRIBUTION(A1:A100, “gamma”)

It returns distribution fit parameters and reports fitting statistics in console and corresponding plots in the task pane as presented below: