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.

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