Probably the best histogram generator, loaded with a full breadth of statistical functions

Creating a visual histogram from a set of numerical data is probably the most comprehensive way for truly understanding its nature.


Histogram-Ultimate is a statistical utility aimed at generating interactive histograms from a range of numerical values located within an Excel workbook.

While other packages, even the most advanced ones, are a kind of statistical "calculators", Histogram-Ultimate is a "live" exploratory entity.

Instead of static and quite unexciting outputs, Histogram-Ultimate makes use of sliders and knobs for interactively exploring data.

Packed with a wealth of statistical functions, Histogram-Ultimate should fully answer all the needs involved in univariate analysis (the analysis of one variable at a time).

Histogram-Ultimate comes equipped with a full set of statistical interactive calculators.

Beyond its comprehensive statistical capabilities, Histogram-Ultimate's unique visual features make it a pedagogical tool of choice for teaching statistics, and may even contribute to make statistics a more appealing field.


  • Extremely rich descriptive and inferential techniques for analyzing a range of numerical values:-

  1.       An interactive  fully customizable histogram

  2.       Full set of descriptive statistics

  3.       Test of hypothesis for the mean/median/standard deviation with power calculations and unique visualization of the test

  4.       Confidence interval for the mean/median/variance/percentiles based on classical or Bootstrap approach

  5.       Tests of normality for the data  based on 4 different tests

  6.       Outlier's detection based on the Grubbs test, the Quartiles method, and Dixon Q test for very small samples

  7.       Percentiles visual calculations

  8.       PP-plot for 8 families of distribution including detrended plot and theoretical distribution

  9.       Kernel density plot

  10.       Complete set of statistical calculators

  • Truncation of the data: all the analysis may be carried out on interactive data truncation from left and/or right

  • Transformation of the data: all the analysis may be carried out on transformed data according to predefined functions

  • Unique Live interactivity through the use of sliders and knobs

  • Very fast: tens of thousands of values processed almost instantly

  • Robust choice of range: the selected range of range to analyze could be of any shape and contains both missing or text value

  • Very fast learning curve: clear interface. Does not require knowledge of macros or VBA

  • Reliable: thoroughly tested against statistical packages: SAS/SPSS/Minitab

  • Exportable results and arrays to Excel for further investigation

  • Equipped with a full set of statistical interactive calculators