Ex, if your variable ranges from 61 to 75 and you want to put it into bins of width 2, then you add a column D with the equation "=FLOOR(B?,2)". You have to break the data up into bins yourself to do this I suggest using FLOOR. If, however, you'd like to cluster it by a categorical variable in column C, then you did one of these: Let's say you have a numerical variable in column B and you want to do a histogram of it, then, sure, highlight column B and insert a histogram. There are a couple of ways to create a clustered/stacked histogram in Excel, but I can only remember one of them right now. The person who answered above misread the question. ) who needs this in future can maybe find it. I know you asked this three years ago, but I'll answer so that anyone (like me.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |