Quadrant Logo

Quadrant Output and Options

Quadrant produces a standard histogram / chart and set of statistical measures for each selected output cell.

During the iteration process, Quadrant captures the results from each selected output cell and copies them to the working data sheet (named "qdata" by default). From this raw data, Quadrant then produces a frequency table, histogram / chart and raw data statistics on a separate output worksheet for each output cell.

The histogram / chart shows the both the frequency of output for equally-spaced ranges of output values ("graph bins") and a cumulative percentage line graph based on the same frequency table data.

To provide "sensible" output, both the number and "type" of graph bins can be specified at run-time.

The number is simply the number of different bars on the histogram.

The "type" takes (a little) more explanation.

Exact bins:

Strictly speaking, the most accurate way to represent the data on a histogram is to divide the complete range of output values (minimum to maximum) into equally-sized bands (bins). This is fine, but often results in bin sizes with loads of places of decimals.

Integer bins:

This is an option provided so that the graph makes sense when the model only produces integer output values.

Neat bins:

This option is a presentational kludge. It works very much the same as the Exact bins option, but instead of working to the maximum precision that Excel can manage, the bin size is rounded to about 2 significant figures. The graph output now looks much more presentable, though the range of the last bin extends a little way beyond the maximum recorded value.


Exact Bins - sets the size of subdivisions to the range of output values divided by the number of graph bins.

Graph with Exact bins

Integer Bins - sets the size of subdivisions to the nearest integer (particularly useful for graphing results that consist of integer values only).

Graph with Integer bins

Neat Bins - sets the size of subdivisions to values rounded to about two significant figures. Can result in empty subdivisions at end of histogram.

Graph with Neat bins

Top of Page