RiskAMP.HistogramTable

RiskAMP Simulation Analysis Functions

This function creates a histogram table describing the data distribution of the reference cell.

This is an array function. You must enter it into a range of cells using Ctrl + Shift + Enter. We can’t use Excel’s spill function, because we rely on the shape of the range to determine the number of buckets.

See SimulationHistogram for a version of this function that uses a dynamic array.

You can create histograms vertically or horizontally. If you enter the function into a single column (or row), the function will return only the bucket counts.

After you create the table, you can use standard Excel charting tools to create a column chart.

Example