#1   Report Post  
inquirer
 
Posts: n/a
Default q-q plots

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


  #2   Report Post  
John Mansfield
 
Posts: n/a
Default

Inquirer,

Here's a site that might help. It notes that the sample sizes do not need
to be the same:

http://www.itl.nist.gov/div898/handb...on3/qqplot.htm

You would need to use an XY Scatter Chart. To build the 45 degree line, set
up a series with data that moves on X and Y in a 1 to 1 relationship, i.e.

x y
10 10
20 20
30 30
40 40

At this point your other series are bases on your calculations of a quantile.

A Google Search using "Quantile - Quantile Plots" will bring up several
resources for calculations.

----
Regards,
John Mansfield
http://www.pdbook.com

"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



  #3   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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


  #4   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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


  #5   Report Post  
inquirer
 
Posts: n/a
Default

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
quantile plots inquirer Excel Discussion (Misc queries) 0 April 20th 05 12:43 AM
How do I show data on side by side plots within the same graph ra. LAL Charts and Charting in Excel 1 April 10th 05 10:40 PM
How do I remove empty chart plots from linked worksheet charts Lee IT Charts and Charting in Excel 3 January 31st 05 05:31 PM
scaling plots lengths Chris Charts and Charting in Excel 0 January 15th 05 12:35 PM
Can you get box plots on excel? yankovic-kid Charts and Charting in Excel 1 January 8th 05 12:17 AM


All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"