Finding patterns and runs in my data set - Frequency function?

Hello all,

In order to get a better understanding of my various variables (columns), I thought it could be interesting to measure the runs in my data.

1. For example, I have a variable labeled % Change which is continuous and either positive or negative. So, binary. I'd then be interested in seeing how many days in the sample had:

2 positive days in a row
2 negative days in a row

3 positive days in a row
3 negative days in a row

4 positive days in a row
4 negative days in a row

I can't imagine that there's any more than 10 days in a row of anything, so maybe I'd stop at 10.

2.

I also have some data that is not numerical and consists of just letters. For example, "A", "B", "C"

Could I be able to do the same type of analysis with this?

3. Other stuff that might be interesting:

Finding the most occuring value after one value has occured. Say, today is "A". In 9/10 times the next day is "B". Is that possible?

What tools would I likely need for setting this up?

Could the frequency function be used?

PS: Attaching a sample sheet.

Thanks in advance!

Hi,

Perhaps you could add a results table to your file, plus a few manually-calculated expected results. That way we can give you the required formulas to populate that table.

Regards