You must organize the data in two columns on the worksheet. However, if you want to check if a sample follows a given distribution, you can use the distribution fitting tool to estimate the parameters of the distribution and if necessary check if the hypothesis is acceptable. To create a histogram in Excel, you provide two types of data the data that you want to analyze, and the bin numbers that represent the intervals by which you want to measure the frequency. Comparison to a theoretical distribution XLSTAT lets you compare the histogram with a theoretical distribution whose parameters have been set by you.Cumulative histogram Create cumulative histograms either by cumulating the values of the histogram or by using the empirical cumulative distribution.The intervals are considered as closed for the lower bound and open for the upper bound.
XLSTAT offers several options to create the histogram that will suit better your data: The histogram is one of the most frequently used display tools as it gives a very quick idea of the distribution of a sample of continuous or discrete data.
