Constructing a Histogram

Occasional Visitor

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 classes are in order {7, 14, 9, 5, 4, 1}

2 Replies


To put it mildly, I'm not a histogram specialist. here is some information from microsoft on help for self-help.

Create a histogram

If you are not interested in this information, please just ignore it.

At the end, if you will allow me, I would like to recommend that you insert a file (without sensitive data) in which you explain your project in detail.

At the same time, it is advantageous if you know which version of Excel it is and which operating system you are using.


Thank you for your understanding and patience



I know I don't know anything (Socrates)


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.