Skip to main content

Author Topic: Percentile calculation

T
  • Posts: 25
Percentile calculation
OP: September 28, 2014, 11:00:00 PM
How do you calculate the percentile of a portfolio (v. other lenders)...
What net return would you consider being in the 99th percentile?
  • IP logged

r
  • *****
  • Hero Member
  • Posts: 575
Percentile calculation
#1: September 28, 2014, 11:00:00 PM
You'd have to have an set of returns to compare.  I would use Excel's percentilerank function.  Or I guess you could use a Z-Test if it is normally distributed
  • IP logged

T
  • Posts: 6588
Percentile calculation
#2: September 28, 2014, 11:00:00 PM
Is there a file that has this data (net returns)?
  • IP logged

b
  • Posts: 152
Percentile calculation
#3: September 29, 2014, 11:00:00 PM
No, there is no publicly available file that has every investor's returns in it. The closest thing you can get is LC's nice "Understanding My Returns" chart from its account overview page.
  • IP logged

l
  • ****
  • Sr. Member
  • Posts: 323