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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Floating Bar with Quartile Ranks 2
Bubble Chart best fit Scatter plot 3
Convert Error Bars to Series and Colour 1
Statistical graphing - enhanced box&whiskers 1
90% line across line chart 3
percentile markers or boxplot on excel scatter graph 2
Ping Jon Peltier: Custom colors above & below horizontal lines 2
Ranking without skipping ranks and percentile 3

Back
Top