# PLOT.DISTRIBUTION

**AXCEL.PLOT.DISTRIBUTION function**

This function plots the density and cumulative density function (CDF) of a vector of the numbers and reports statistics such as the mean, median, 5 highest and lowest and dispersion (Gini).

**Syntax**

AXCEL.PLOT.DISTRIBUTION(data)

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

**data** Required. It is a vector of number for which we would like to plot the density and CDF.

The output of the function is the density plot and a table of statistics as follows:

n | number of data |

missing | number of missing values |

distinct | number of distinct values |

Info | odds/Wilcoxon test which shows how continuous the data is. |

Mean | Average |

Gmd | Gini’s mean difference as a measure of dispersion |

.05 | 5th percentile |

.10 | 10th percentile |

.25 | 25th percentile |

.50 | 50th percentile (Median) |

.75 | 75th percentile |

.90 | 90th percentile |

.95 | 95th percentile |

L1 | lowest value |

L2 | 2nd lowest value |

L3 | 3rd lowest value |

L4 | 4th lowest value |

L5 | 5th lowest value |

H5 | 5th highest value |

H4 | 4th highest value |

H3 | 3rd highest value |

H2 | 2nd highest value |

H1 | Highest value |

Example:

Imagine you have a set of numbers in A1:A100 cells. to plot the density and CDF of this vector, you can run:

=AXCEL.PLOT.DISTRIBUTION(A1:A100)

Here is the output: