# Question in calculating the median, upper and lower quartiles

• Nov 11th 2009, 12:26 PM
Oblivionwarrior
Question in calculating the median, upper and lower quartiles
I have the data
1.63
1.79
1.79
2.36
2.54
2.60
3.01
3.25

I calculated the median to be 2.45, then to calculate the lower quartile (1.79+1.79)/2 = 1.79. But something is wrong with the upper quartile. I thought I would have to do (2.60+3.01)/2 = 2.805. But if I use excel to calculate the upper quartile I get 2.7025? What did I do wrong? Thanks.
• Nov 11th 2009, 12:35 PM
pickslides
Your hand calcs are correct, what formula did you use in excel?
• Nov 11th 2009, 02:28 PM
Oblivionwarrior
Quote:

Originally Posted by pickslides
Your hand calcs are correct, what formula did you use in excel?

I used =QUARTILE((range of data),3)
• Nov 11th 2009, 02:33 PM
pickslides
try =percentile("range of data",0.75)

Does it give a different answer?
• Nov 11th 2009, 02:53 PM
Oblivionwarrior
Quote:

Originally Posted by pickslides
try =percentile("range of data",0.75)

Does it give a different answer?

No I get the same thing as =quartile("range of data",3)
• Nov 11th 2009, 03:28 PM
pickslides
I see, I have the same problem.

Must be something quirky with how excel calculates this parameter.