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