Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 26
Default Freqencies over Time, in Columns -- Easy Question

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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Easy Sorting Question Yupkwondo Excel Discussion (Misc queries) 4 April 1st 06 01:13 PM
Elapsed time question Johnfli Excel Discussion (Misc queries) 5 March 2nd 06 05:19 PM
Easy question? Page numbers ATC Excel Discussion (Misc queries) 1 February 1st 06 04:27 AM
Formula TIME question Pharmagirl Excel Discussion (Misc queries) 1 November 14th 05 09:52 PM
merging columns - one date, one time batfish Excel Worksheet Functions 2 October 28th 05 04:02 AM


All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"