How to plot percentile chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there a way in Excel that allows to plot a percentile chart, such as the median, nth and mth percentile

thanks

John
 
John

Excel has PERCENTILE and Median Functions. e.g.

=MEDIAN(D2:D20)
=PERCENTILE(D2:D20,0.9)

Use these on your data and chart the results or use an
AutoFilter on the data to show the top 10% values And plot
these

Regards
Peter
-----Original Message-----
is there a way in Excel that allows to plot a percentile
Click to expand...
chart, such as the median, nth and mth percentile?
 
Back
Top