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?

Hi,
What do you mean by the FIRST 25% of the users signed up €“ is it the
first (i.e, top) 25% of the rows (Case I) or the data corresponding to the
earliest (chronologically) 25% of the entire data (Case II)?
Regardless, the following approach should work. ( If it is Case II,
sort the spreadsheet by the Date column before doing the rest, unless the
rows are already in chronological order)
Let us imagine that the data start in row 2. (with row 1 showing the
column headings such as €œUser€�, €œDate€�, €œCycle time€�, €¦for columns A, B, C, €¦
respectively).

In an empty cell somewhere in the sheet (let's say F1), enter a
percentage (e.g., 25%).
In row 2 of an empty column somewhere in the sheet (lets say Column
D), i.e., in D2, enter the following formula, and drag the formula down the
column (the formula assumes that you dont have more than 10000 rows of data).

=IF(ROW(A2)ROW($A$1)+ROUND(COUNTA($A$2:$A$10001)* $F$1,0),"",C2)

The formula creates in Column D, a subset of column C data, based on
the percentage you have entered in F1 and makes the rest of the rows in
Column D blank. Now you can get the statistics you want using Column D, for
example:

=AVERAGE($D$2:$D$10001)
=MEDIAN($D$2:$D$10001)

You can change the percentage in Cell F1 to other values (50%, 75%, or
any other value); Column D and the average, median, etc., will update
accordingly.

Hope this helps,
B. R. Ramachandran



"Rum" 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?

See the replies to your earlier messages. Please don't start new threads
repeating your earlier question.
--
David Biddulph

"Rum" wrote in message
...
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?