Embeded Chart bins

[ajperot]

For a triangular distribution, when I use the Embed Charts function, the last bin of the frequency has an unexpectedly high count. It seems that's because the spread between the second-to-last and the last bin is wider than for the rest of the distribution. It should be symmetrical from the parameters I chose. The attached image illustrates the issue:

Very useful tool overall! Thanks!

[brandonherzog]

Thanks for the report @ajperot! You are correct; the issue you discovered is caused by non-uniform bin selection by the Embed Charts tool when creating the Excel chart--the last bin is too wide and the first bin is too narrow.

Because the issue is just with the bin selection, not with the random sampling, for the time being you can manually create a histogram chart with appropriate bin choices through Excel like in the attached workbook: triangular-histogram.xlsx. You may also use the Analysis Wizard tool to quickly view a distribution's histogram and CDF curve.