Forum Discussion
Constructing a Histogram
How do I enter the data in Excel and create the Bin if I want the class width to be 10 for example and the boundaries are {19.5, 29.5, 39.5, 49.5, 59.5, 69.5, 79.5}. The frequencies of the six clas...
If you are looking for 6 frequencies you only need 5 boundaries, so omit the end two values. On versions of Excel other than 365, I believe you need to commit the formula with CSE.