I know that there's a lot of posts on this already but I am so confused by them.
So I have one column that has 2451 values in a random order and I want to make a histogram of them.
They range from 0-24.5 in intervals of 0.1 so I made another column that has the values 0.0, 0.1, 0.2, ... 24.4, 24.5
How do I make a histogram from this data?
The Histogram function make this job easier.
Here's an example from an earlier post of mine on the subject. Note the use of separate tables for the data and the summary.
So you don't have to type it, here's the expression in the Frequency column of the Summary Table.
=INDEX(FREQUENCY(Data :: A, A), ROW()-1)
Good luck, happy to help with the details if you need it.
Jerry
The Histogram function make this job easier.
Here's an example from an earlier post of mine on the subject. Note the use of separate tables for the data and the summary.
So you don't have to type it, here's the expression in the Frequency column of the Summary Table.
=INDEX(FREQUENCY(Data :: A, A), ROW()-1)
Good luck, happy to help with the details if you need it.
Jerry
Making a histogram in numbers
