Constructing a Histogram

New Contributor

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

@Bornagain123 

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

Create a histogram

https://support.microsoft.com/en-us/office/create-a-histogram-85680173-064b-4024-b39d-80f17ff2f4e8

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

 

Nikolino

I know I don't know anything (Socrates)

@Bornagain123 

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.