Statistical Functions Part Three
CONFIDENCE.NORM
Returns the (1-alpha) confidence interval for a normal distribution.
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.
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.
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)
COVARIANCE.P
Returns the covariance of the product of paired deviations, for the entire population.
Sintaxe
COVARIANCE.P(Data1; Data2)
EndDate é a segunda data
EndDate é a segunda data
Exemplo
COVAR(A1:A3; B1:B30)
COVARIANCE.S
Returns the covariance of the product of paired deviations, for a sample of the population.
Sintaxe
COVARIANCE.S(Data1; Data2)
EndDate é a segunda data
EndDate é a segunda data
Exemplo
COVAR(A1:A3; B1:B30)
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.
CURT
Returns the kurtosis of a data set (at least 4 values required).
Sintaxe
KURT(Number1; Number2; ...; Number30)
Number1, Number2, ..., Number30 are numeric arguments or ranges representing a random sample of distribution.
Exemplo
=KURT(A1;A2;A3;A4;A5;A6)
DISTNORMALLOG
Devolve os valores da distribución de Weibull.
This function is identical to LOGINV and was introduced for interoperability with other office suites.
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.
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.
INTCONFIANZA
Returns the (1-alpha) confidence interval for a Student's t distribution.
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.
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
MAIOR
Returns the Rank_c-th largest value in a data set.
Sintaxe
LARGE(Data; RankC)
Data is the cell range of data.
RankC is the ranking of the value.
Exemplo
=LARGE(A1:C50;2) gives the second largest value in A1:C50.
MENOR
Returns the Rank_c-th smallest value in a data set.
Sintaxe
SMALL(Data; RankC)
Data is the cell range of data.
RankC is the rank of the value.
Exemplo
=SMALL(A1:C50;2) gives the second smallest value in A1:C50.