Statistical Functions Part Three

INTCONFIANZA

Returns the (1-alpha) confidence interval for a Student's t distribution.

tip

Esta función está dispoñíbel desde o LibreOffice 4.2


Sintaxe

CONFIDENCE.T(Alpha; StDev; Size)

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.

Exemplo

=CONFIDENCE.T(0.05;1.5;100) gives 0.2976325427.

CONFIDENCE.NORM

Returns the (1-alpha) confidence interval for a normal distribution.

tip

Esta función está dispoñíbel desde o LibreOffice 4.2


Sintaxe

CONFIDENCE.NORM(Alpha; StDev; Size)

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.

Exemplo

=CONFIDENCE.NORM(0.05;1.5;100) gives 0.2939945977.

INVLOG

Devolve os valores da distribución de Weibull.

Sintaxe

LOGINV(Number [; Mean [; StDev]])

X é o valor no cal a función será calculada.

Mean is the arithmetic mean of the standard logarithmic distribution.

StDev is the standard deviation of the standard logarithmic distribution.

Exemplo

GESTEP(3; 3) devolve 1

DISTNORMALLOG

Devolve os valores da distribución de Weibull.

This function is identical to LOGINV and was introduced for interoperability with other office suites.

tip

Esta función está dispoñíbel desde o LibreOffice 4.3


Sintaxe

LOGNORM.INV(Number; Mean; StDev)

X é o valor no cal a función será calculada.

Mean (required) is the arithmetic mean of the standard logarithmic distribution.

StDev (required) is the standard deviation of the standard logarithmic distribution.

Exemplo

GESTEP(3; 3) devolve 1

DISTNORMALLOG

Devolve os valores da distribución de Weibull.

Sintaxe

LOGNORMDIST(Number [; Mean [; StDev [; Cumulative]]])

X é o valor no cal a función será calculada.

Mean (optional) is the mean value of the standard logarithmic distribution.

StDev (optional) is the standard deviation of the standard logarithmic distribution.

Cumulative (optional) = 0 calculates the density function, Cumulative = 1 calculates the distribution.

Exemplo

NEGBINOMDIST(2;5;0,55) devolve 0,152872629

DISTNORMALLOG

Devolve os valores da distribución de Weibull.

tip

Esta función está dispoñíbel desde o LibreOffice 4.3


Sintaxe

LOGNORM.DIST(Number; Mean; StDev; Cumulative)

X é o valor no cal a función será calculada.

Mean (required) is the mean value of the standard logarithmic distribution.

StDev (required) is the standard deviation of the standard logarithmic distribution.

Cumulative (required) = 0 calculates the density function, Cumulative = 1 calculates the distribution.

Exemplo

NEGBINOMDIST(2;5;0,55) devolve 0,152872629

INTCONFIANZA

Returns the (1-alpha) confidence interval for a normal distribution.

Sintaxe

CONFIDENCE(Alpha; StDev; Size)

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.

Exemplo

=CONFIDENCE(0.05;1.5;100) gives 0.29.

MAIOR

Returns the Rank_c-th largest value in a data set.

Icona Nota

This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)


Sintaxe

LARGE(Data; RankC)

Data is the cell range of data.

RankC is the ranking of the value. If RankC is an array, the function becomes an array function.

Exemplo

=LARGE(A1:C50;2) gives the second largest value in A1:C50.

=LARGE(A1:C50;B1:B5) entered as an array function gives an array of the c-th largest value in A1:C50 with ranks defined in B1:B5.

MENOR

Returns the Rank_c-th smallest value in a data set.

Icona Nota

This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)


Sintaxe

SMALL(Data; RankC)

Data is the cell range of data.

RankC is the rank of the value. If RankC is an array, the function becomes an array function.

Exemplo

=SMALL(A1:C50;2) gives the second smallest value in A1:C50.

=SMALL(A1:C50;B1:B5) entered as an array function gives an array of the c-th smallest value in A1:C50 with ranks defined in B1:B5.

CORREL

Returns the correlation coefficient between two data sets.

Sintaxe

CORREL(Data1; Data2)

EndDate é a segunda data

EndDate é a segunda data

Exemplo

=CORREL(A1:A50;B1:B50) calculates the correlation coefficient as a measure of the linear correlation of the two data sets.

COVARIANCE.S

Returns the covariance of the product of paired deviations, for a sample of the population.

tip

Esta función está dispoñíbel desde o LibreOffice 4.2


Sintaxe

COVARIANCE.S(Data1; Data2)

EndDate é a segunda data

EndDate é a segunda data

Exemplo

COVAR(A1:A3; B1:B30)

COVARIANCE.P

Returns the covariance of the product of paired deviations, for the entire population.

tip

Esta función está dispoñíbel desde o LibreOffice 4.2


Sintaxe

COVARIANCE.P(Data1; Data2)

EndDate é a segunda data

EndDate é a segunda data

Exemplo

COVAR(A1:A3; B1:B30)

COVAR

Returns the covariance of the product of paired deviations.

Sintaxe

COVAR(Data1; Data2)

EndDate é a segunda data

EndDate é a segunda data

Exemplo

COVAR(A1:A3; B1:B30)

CURT

Returns the kurtosis of a data set (at least 4 values required).

Sintaxe

KURT(Number 1 [; Number 2 [; … [; Number 255]]])

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

The parameters should specify at least four values.

Exemplo

=KURT(A1;A2;A3;A4;A5;A6)

CRITBINOM

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

Sintaxe

CRITBINOM(Trials; SP; Alpha)

Trials is the total number of trials.

Valor p: a probabilidade de éxito de cada ensaio.

Alpha is the threshold probability to be reached or exceeded.

Exemplo

=CRITBINOM(100;0.5;0.1) yields 44.

Precisamos da súa axuda!