urgent help please

For the sample project 1 on the institute's website, when they calculate the upper quartile, they use quartile (range, 2). I thought using 2 was for the 2nd quartile, not the upper quartile - can anyone shed any light on this please?

Thanks

catchy

 

The syntax for the Quartile function is:

Quartile( array, nth_quartile )

array is a range or array from which you want to return the nth quartile.

nth_quartile is the quartile value that you wish to return. It can be one of the following values:

Value Explanation
0 Smallest value in the data set
1 First quartile (25th percentile)
2 Second quartile (50th percentile)
3 Third quartile (75th percentile)
4 Largest value in the data set

 

Thanks amaster - are you saying that the upper quartile is the same as the 2nd quartile?

 

1st quartile - lower quartile;
2nd quartile - median;
3rd quartile - upper quartile

Unless I'm missing something, the "model" solution has the wrong formula for the upper quartile. should be quartile(range,3)

They also have the excel files (Project 1) labelled as
Spreadsheet of data - is actually the complete spreadsheet with calculations, audit trail etc.
Spreadsheet - is actually the raw data only.

which to my mind is misleading.