4. Observe: construct a histogram

Excel offers a graphical style that allows you to see the histogram relative to the simulated values. It's easy to use, but it can be useful to know how to construct a histogram from a series of data. The procedure is as follows:

• find the "Min" and "Max" of the simulated series (Column A, for example): MIN(A:A), MAX(A:A) ;

• determine the number of classes (n = number of simulated values): NB _Classes = ENT(1 + LOG10( n ) * 10/3).

There are other ways of determining the number of classes in a histogram. This one, derived from Sturges' rule, is given as an example:

• determine the "PAS" width of classes: PAS = [MAX(A:A) – MIN(A:A)]/ NB _Classes ...