I've got a spreadsheet which has data in the first few columns, then another couple of columns which have formulae for calculations. The last column says "profit/loss" where I have two values based on an if statement: if(L3>0, "P", "L". What I want to do is analyse the trends in profit/loss - so I have a sequence that goes P P L L L L P L L P P P L L L L. How can I get excel to analyse these and put the values in a statistical distribution? I want to get statistics on how long each profit/loss session lasts. That is, I want a distribution that says:
Days profit Frequency
1 1
2 1
3 1
4 0
5 0
etc., and another for losses.
Bookmarks