Computing Quartiles with Excel 2007

[Guest]

Hi,

I have the following problem, that I would think it would be easy to solve
but I haven't find a way to do it. I have a large set of data where I run
simple descriptive statistics from let's say A1:A100 to get the following
distributioin analyzis:

Minimum =MIN(A1:A100)
1st Quartile =QUARTILE(A1:A100,1)
Median =MEDIAN(A1:A100)
3rd Quartile QUARTILE(A1:A100,3)
Maximum =MAX(A1:A100)

No problem at this point. Now, the Excel spreadsheet cannot be modified by
changing the order of where the cells are.

New data comes in, it wasn't supposed to be new data, but furtehr down the
road we realized we accidentantly skipped 21 values BUT THERE IS NO WAY WE
CAN MODIFIED THE CELLS ON THIS SPREADSHEET. Instead, I decided to put the new
21 values of data at the very end of the spreadsheet.

MY QUESTIONS is this: how do you compute the quartiles for the set of data
when you have the location of the data separated on the spreadsheet? As you
can see, it is an easy fix for the Max, the Median and the Mean. But who cal
help me to figure this out? what do you do with the quartiles?

This is how my spreadsheet looks now:

Minimum =MIN(A1:A100,A201:A221)
1st Quartile =QUARTILE(A1:A100,1)
Median =MEDIAN(A1:A100,A201:A221)
3rd Quartile QUARTILE(A1:A100,3)
Maximum =MAX(A1:A100,A201:A221)

I am combining two arrays to cover all data, but how do you do the same with
the Quartile formula?

Please Help!

 

[Lori]

=QUARTILE((A1:A100,A201:A221),1)

for the first quartile, for the other values use 0,2,3,4 instead.

 

[Guest]

Excellent! Thank you!

=QUARTILE((A1:A100,A201:A221),1)

for the first quartile, for the other values use 0,2,3,4 instead.

 

[Lori]

No problem. Thanks for the reply

Excellent! Thank you!