OpenOffice.org OpenOffice - 3.3 Základní průvodce stáhnout pdf (Strana 394)

Syntax Description

CHIDIST(number;

degrees_freedom)

Returns the probability value that a hypothesis will

be confirmed from the indicated chi square. The

probability determined by CHIDIST can also be

determined by CHITEST. Number is the chi-square

value of the random sample used to determine the

error probability. Degrees_freedom is the degrees of

freedom of the experiment.

CHIINV(number;

degrees_freedom)

Returns the inverse of the one-tailed probability of

the chi-squared distribution. Number is the value of

the error probability. Degrees_freedom is the

degrees of freedom of the experiment.

CHITEST(data_B; data_E) Returns the chi-square distribution from a random

distribution of two test series based on the chi-square

test for independence. The probability determined by

CHITEST can also be determined with CHIDIST, in

which case the chi square of the random sample must

then be passed as a parameter instead of the data

row. Data_B is the array of the observations. Data_E

is the range of the expected values.

CONFIDENCE(alpha; STDEV;

size)

Returns the (1-alpha) confidence interval for a

normal distribution. Alpha is the level of the

confidence interval. STDEV is the standard deviation

for the total population. Size is the size of the total

population.

CORREL(data_1; data_2) Returns the correlation coefficient between two data

sets. Data_1 is the first data set. Data_2 is the

second data set.

COUNT(value_1; value_2; ...

value_30)

Counts how many numbers are in the list of

arguments. Text entries are ignored. Value_1;

value_2; ... value_30 are values or ranges which are

to be counted.

COUNTA(value_1; value_2; ...

value_30)

Counts how many values are in the list of arguments.

Text entries are also counted, even when they contain

an empty string of length 0. If an argument is an

array or reference, empty cells within the array or

reference are ignored. value_1; value_2; ...

value_30 are up to 30 arguments representing the

values to be counted.

COVAR(data_1; data_2) Returns the covariance of the product of paired

deviations. Data_1 is the first data set. Data_2 is the

second data set.

CRITBINOM(trials; SP; alpha) Returns the smallest value for which the cumulative

binomial distribution is less than or equal to a

criterion value. Trials is the total number of trials.

SP is the probability of success for one trial. Alpha is

the threshold probability to be reached or exceeded.

394 OpenOffice.org 3.3 Calc Guide

1 2 ... 389 390 391 392 393 394 395 396 397 398 399 ... 433 434

Komentáře k této Příručce

Žádné komentáře

OpenOffice.org OpenOffice - 3.3 Základní průvodce Strana 394

Komentáře k této Příručce

Související produkty a manuály pro Software OpenOffice.org OpenOffice - 3.3