quartile analysis

I have a bunch of stocks that I have ranked by tercile (1,2,3) according to their market value in a period. If a stock is in tercile 1 in Period 1, if the stock price moves a lot, it could end up in Tercile 2 in Period 2, and etc etc. By the way, if the market value is $0, that just means it...

How do I seperate multiple dates into quarters? In EXCEL 2007 I have > 33000 rows of dated data. The dates are unsorted & run from 1/1/2012 to 12/31/2012. I have used the month() formula to seperate these in monthly categories of 1 - 12 & then put the data to a pivot tbl and pivot chart. I...

I have a dataset that where each record has 26 columns of information. My needs require that I query this data in various ways. A typical array formula that I use looks like this: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p>...