Many thanks to you both, that is what I needed
Chris

"Jerry W. Lewis" wrote in message
...
Use the PERCENTILE() function.

Jerry

inquirer wrote:

I originally posted this in the excel.misc group but received no
replies. I
then found this group and it makes more sense to post here (I hope)...

Is there anyone who can tell me please how to make quantile-quantile
plots
in excel?
I have two sets of data (one with 500 records, one with 300) and I want
to
make a q-q plot of them. I am not sure how to handle data sets that do
not
have equal numbers of records.
Thanks
Chris