statistics-histogram

%3CLINGO-SUB%20id%3D%22lingo-sub-2888228%22%20slang%3D%22en-US%22%3Estatistics-histogram%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2888228%22%20slang%3D%22en-US%22%3E%3CP%3Enew%20it%20statistics%20and%20I%20cant%20figure%20out%20give%20these%20numbers%20how%20to%20categorize%20them%20and%20put%20them%20in%20a%20histogram.%26nbsp%3B%20I%20have%20done%20the%20numbers%20but%20cant%20figure%20it%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2888228%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

new it statistics and I cant figure out give these numbers how to categorize them and put them in a histogram.  I have done the numbers but cant figure it out.

1 Reply

@sherma4 To get a histogram you need to have bins. But those bins depend on the data. For example your numbers could be 0 - 100 and want 10 bins evenly distributed 10, 20, 30, 40, ... but then again those numbers might be grades and you want bins to represent grades like 60, 70, 80, .... or they might be very skewed and have an average and most points around 20 with 1 outlier around 100 and want bins focused around the average.
Once you have the bins then you can either use the Histogram tool in the Data Analysis toolpack or some simple formulas like =COUNTIFS(A:A,">="&E2,A:A,"<"&E3)
assuming the bins are in column E and you will need to tweak the last to only be > as I give the attached example.  If you need to do this a lot you can get more clever with the formulas to make it easier but with the limited info you gave I don't even know if this is the right direction.