T
Tobias Weber
Hi
I have a lot of data like "list of dates it did not rain in London" and
want to do diagrams that show when something occurs more often than
usual.
I tried assigning a value of 1 to each date and doing subtotals by week.
Unfortunately this kind of histogram will smooth over a significant rise
in density if it rained on e.g. Saturday and Tuesday.
So I calculated in a column how many days ago the last event occured,
which projected over time and inverted kind of works, but breaks down
when the event occurs every third day on average but every day at high
times. The differences are just too small.
What I'd need is something that grows when dates cluster.
And, to get this on topic, I'd need it in Excel 2008 ;-)
I have a lot of data like "list of dates it did not rain in London" and
want to do diagrams that show when something occurs more often than
usual.
I tried assigning a value of 1 to each date and doing subtotals by week.
Unfortunately this kind of histogram will smooth over a significant rise
in density if it rained on e.g. Saturday and Tuesday.
So I calculated in a column how many days ago the last event occured,
which projected over time and inverted kind of works, but breaks down
when the event occurs every third day on average but every day at high
times. The differences are just too small.
What I'd need is something that grows when dates cluster.
And, to get this on topic, I'd need it in Excel 2008 ;-)