стр. 28 |

Data requirements: Any array/range with real numbers.

RANK

The function RANK calculates the relative rank of a value within a series

of numbers data. You can choose to obtain the ranks on the basis of

ascending or descending values. X is the data point whose rank is desired

within the range. Order sets the sorting directionвЂ” 1 for ascending

ranking, 0 or blank for descending ranking. Cells with the same value

cells are given the same rank.

Menu path to function: INSERT / FUNCTION / STATISTICAL / RANK.

Data requirements: Any array/range with real numbers.

MEASURES OF DISPERSION (STANDARD

6.4

DEVIATION & VARIANCE)

Table 12: Standard Deviation & Variance.

Location within

INSERT /

Function Description Data Requirements

FUNCTION

Sample

The functions STDEV

dispersion: STATISTICAL / Any range with

and VAR estimate the

STDEVA sufficient number of

STDEV, VAR

sample standard

& numeric data points.

deviation and variance,

STATISTICAL / Text and logical values

respectively. VAR is

VARA are excluded.

the square of STDEV.

These are variants of Text and logical values

STDEVA, VARA

STATISTICAL /

the functions above but such as TRUE and

99

Statistical Analysis with Excel

Location within

INSERT /

Function Description Data Requirements

FUNCTION

with a wider range of FALSE are included in

STDEVA

acceptable data types the calculation. TRUE

as input data. is valued as 1; text or

&

FALSE is valued as 0.

STATISTICAL /

VARA

The less often used

population dispersion

functions are

sometimes also used

Population

for large sample sizes.

dispersion: STATISTICAL /

STDEVP assumes that

its data are the entire A large number of

STDEVP, STDEVA

population. Typically, observations.

VARP &

you use the sample

Text and logical values

formulae. For large

STATISTICAL /

are excluded.

sample sizes, STDEV

VARA

and STDEVP return

approximately equal

values. VARP is

square of STDEVP

Text and logical values

such as TRUE and

FALSE are included in

STATISTICAL /

STDEVPA, the calculation. TRUE

These are variants of

VARPA STDEVA is valued as 1; text or

the functions above but

FALSE is valued as 0.

&

with a wider range of

Text and logical values

acceptable data types

STATISTICAL / such as TRUE and

as input data

FALSE are included in

VARA

the calculation. TRUE

is valued as 1; text or

FALSE is valued as 0.

Figure 94: Dialog for STDEV

100

Chapter 6: Functions for Basic Statistics

Figure 95: Dialog for STDEVA. Note that the functions with the вЂњAвЂќ suffix request вЂњValuesвЂќ

as input while the equivalent nonвЂ“suffixed functions request вЂњNumbersвЂќ

SHAPE ATTRIBUTES OF THE DENSITY FUNCTION

6.5

(SKEWNESS, KURTOSIS)

стр. 28 |