When you open Excel and start working with data, you might wonder how to visualize the distribution of your data points. This is where a Histogram Chart comes into play.

In Excel, syntax for this function is NORMINV(probability,mean,standard deviation). Using the sales example, with a weekly sales average of $2,000 that fluctuates about $500 up or down, you know ...

For example, if you want to show a frequency distribution for every 10 units you would need to define that for Excel. The Frequency function refers to this limit as the "Bin Array." ...