Your hand calcs are correct, what formula did you use in excel?
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.