
Chapter 3
PB
Measures of Central Tendency
111
3.7.2 Using MS Excel for Quartiles Computation
For computing quartiles using MS Excel, key in formula “=QUARTILES (A2:A8), 1” for the
rst quartile and “=QUARTILES (A2:A8), 3” for the third quartile (when data are placed in
column A) and press Enter. The quartiles will be computed in the concerned cell. The Function
Argument dialog box can also be used for computing rst and third quartiles. In this dialog box,
place the data range against Array and place 1 against Quart (for the rst quartile) and click
OK. MS Excel will compute the quartile in the concerned cell of the data sheet.
3.7.3 Using ...