OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 395)

Syntax Description

DEVSQ(number_1;

number_2; ... number_30)

Returns the sum of squares of deviations based on a

sample mean. Number_1; number_2; ...

number_30 are numerical values or ranges

representing a sample.

EXPONDIST(number;

lambda; C)

Returns the exponential distribution. Number is the

value of the function. Lambda is the parameter

value. C is a logical value that determines the form of

the function. C = 0 calculates the density function,

and C = 1 calculates the distribution.

FDIST(number;

degrees_freedom_1;

degrees_freedom_2)

Calculates the values of an F probability distribution.

Number is the value for which the F distribution is

to be calculated. Degrees_freedom_1 is the degrees

of freedom in the numerator in the F distribution.

Degrees_freedom_2 is the degrees of freedom in the

denominator in the F distribution.

FINV(number;

degrees_freedom_1;

degrees_freedom_2)

Returns the inverse of the F probability distribution.

Number is probability value for which the inverse F

distribution is to be calculated. Degrees_freedom_1

is the number of degrees of freedom in the

numerator of the F distribution. Degrees_freedom_2

is the number of degrees of freedom in the

denominator of the F distribution.

FISHER(number) Returns the Fisher transformation for the given

number and creates a function close to a normal

distribution.

FISHERINV(number) Returns the inverse of the Fisher transformation for

the given number and creates a function close to a

normal distribution.

FORECAST(value; data_Y;

data_X)

Extrapolates future values based on existing x and y

values. Value is the x value, for which the y value of

the linear regression is to be returned. Data_Y is the

array or range of known y’s. Data_X is the array or

range of known x’s. Does not work for exponential

functions.

FTEST(data_1; data_2)

Returns the result of an F test. Data_1 is the first

record array. Data_2 is the second record array.

GAMMADIST(number; alpha;

beta; C)

Returns the values of a Gamma cumulative

distribution. Number is the value for which the

Gamma distribution is to be calculated. Alpha is the

parameter Alpha of the Gamma distribution. Beta is

the parameter Beta of the Gamma distribution. C = 0

calculates the density function, and C = 1 calculates

the distribution.

Appendix B Description of Functions 395

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

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 395

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3