ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   The first 25 percent (https://www.excelbanter.com/excel-worksheet-functions/246280-first-25-percent.html)

PAL

The first 25 percent
 
I have a multi-row, multi column spreadsheet. Of the columns, 3 of them are
the most crucial. Let's say,

Column A is: User
Column B is: Date
Column C is: Cycle Time (Calculated from B and another column)

What I would like to know is the average (median, etc...) Cycle Time for
the FIRST 25% (50%, 75% etc...) of the Users signed up.

Any ideas?


Glenn

The first 25 percent
 
PAL wrote:
I have a multi-row, multi column spreadsheet. Of the columns, 3 of them are
the most crucial. Let's say,

Column A is: User
Column B is: Date
Column C is: Cycle Time (Calculated from B and another column)

What I would like to know is the average (median, etc...) Cycle Time for
the FIRST 25% (50%, 75% etc...) of the Users signed up.

Any ideas?


One idea...follow up on one of the numerous previous threads that you started
with exactly the same question. You have received numerous suggestions. If
they are not what you need, then you aren't providing enough information.


All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com