quartile analysis

  1. N

    Summing Data by Quartile

    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...
  2. B

    Putting dates into quarters for quarterly report.

    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...
  3. B

    Retriving & Formatting Data Found by Array Formula

    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>...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top