R
Rothman
I created a histogram using the FREQUENCY function for a dataset I'm working
with. As I was thinking things over, I'd like to see how the frequencies
"built up" over the period of time that the data was collected.
The catch is that I want my bins to go horizontal and the freqs to be able
to be pulled down vertically, like so:
10 20 30 40 50 60 <--Bins
Date1 1 0 1 1 0 1
Date2 2 1 1 1 0 2
Date3 2 2 1 1 0 2
Date4 2 3 1 1 0 2
Date5 2 3 2 2 1 2
Date6 2 3 2 2 1 2
....and so forth.
I've had trouble getting FREQUENCY recognizing the bins properly when
organizing the table like the one above (I want it this way to line up with
the dataset that I have); the closest I've gotten is having it decide all the
bins are from the limit provided to 0 (so, instead of 0 to 10, 11 to 20; it's
0 to 10, 0 to 20).
There's probably another way of doing this without using FREQUENCY, but I'd
thought I'd ask those who may have wanted to tweak it like this before.
Thanks yet again!
with. As I was thinking things over, I'd like to see how the frequencies
"built up" over the period of time that the data was collected.
The catch is that I want my bins to go horizontal and the freqs to be able
to be pulled down vertically, like so:
10 20 30 40 50 60 <--Bins
Date1 1 0 1 1 0 1
Date2 2 1 1 1 0 2
Date3 2 2 1 1 0 2
Date4 2 3 1 1 0 2
Date5 2 3 2 2 1 2
Date6 2 3 2 2 1 2
....and so forth.
I've had trouble getting FREQUENCY recognizing the bins properly when
organizing the table like the one above (I want it this way to line up with
the dataset that I have); the closest I've gotten is having it decide all the
bins are from the limit provided to 0 (so, instead of 0 to 10, 11 to 20; it's
0 to 10, 0 to 20).
There's probably another way of doing this without using FREQUENCY, but I'd
thought I'd ask those who may have wanted to tweak it like this before.
Thanks yet again!