beautypg.com

Casio CLASSPAD 330 3.04 User Manual

Page 766

background image

20090601

S Q

3

Function: Returns the third quartile of the values contained in the range of specified cells.

Syntax: Q

3

(start cell:end cell[,start cell:end cell])

Example: To determine the third quartile of the values in the block whose upper left corner

is located at A7 and whose lower right corner is located at C12, and input the
result in cell A1:

S percentile

Function: Returns the nth percentile in the range of specified cells.

Syntax: percentile(start cell[:end cell],value)

Example: To determine the 50th percentile of the values in cells A7 through A12 and input

the result in cell A1:

13-7-10

Cell and List Calculations