Skip to Main Content
Business Statistics, 3rd Edition
book

Business Statistics, 3rd Edition

by Naval Bajpai
April 2024
Intermediate to advanced content levelIntermediate to advanced
921 pages
37h 16m
English
Pearson India
Content preview from Business Statistics, 3rd Edition
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Business Statistics

Business Statistics

Bajpai
Applied Statistics

Applied Statistics

Dieter Rasch, Rob Verdooren, Jürgen Pilz
Data Analytics for Marketing

Data Analytics for Marketing

Guilherme Diaz-Bérrio

Publisher Resources

ISBN: 9789390168996