Solved

# Calculating decile medians...

Posted on 2006-06-30

My spreadsheet currently has these three columns: CompanyID, FactorScore, StockReturn.

I need to create a second sheet that will calculate the median StockReturn for each decile of FactorScores. In other words, sort the factor scores and form into 10 equally-sized groups. Then calculate the median stock return within each decile group.

MedianStockReturn

Decile1 xxx

Decile2 xxx

Decile3 xxx

...

Decile10 xxx

The stock returns are live, so I'm looking for a solution that is continually recalculating.

Thansk!