Hi,
I have a list of numbers for each weekday going back about 4 years and I want to be able to count the number of times there are two, three, etc. consecutive days with positive and negative numbers. I then want to be able to perform basic statistical functions on these numbers. Here's an example of some of the data:
Jan 1, 2006 $.10
Jan 2, 2006 $.20
Jan 3, 2006 -$.15
Jan 4, 2006 -$.05
Jan 5, 2006 -$.07
Jan 6, 2006 $.12
Jan 7, 2006 -$.03
Jan 8, 2006 $.06
Jan 9, 2006 $.04
Jan 10, 2006 -$.09
I want to count the number of times there are two, three, etc. consecutive days that there are positive and negative numbers. For example, in the data above the number of two consecutive days of positive occurrences would be 2 (Jan 1 and Jan 2 and then again on Jan 8 and Jan 9).
Next, I want to sum the numbers that meet the criteria and determine averages.
How do I do this in Excel?
Thanks for your help.
Bookmarks