Funkcje Zgodności

Top  Previous  Next

Name

Description

Syntax

BETADIST

 

 

Returns the cumulative beta probability density function.

BETADIST(x,alpha,beta,[A],[B])

BETAINV

 

Returns the inverse of the cumulative beta probability density function for a specified beta distribution.

BETAINV(probability,alpha,beta,A,B)

BINOMDIST

 

Returns the individual term binomial distribution probability.

BINOMDIST(number_s,trials,probability_s,cumulative)

CHIDIST

 

Returns the one-tailed probability of the chi-squared distribution.

CHIDIST(x,degrees_freedom)

CHIINV

 

Returns the inverse of the right-tailed probability of the chi-squared distribution.

CHIINV(probability,degrees_freedom)

CHITEST

 

Returns the test for independence as the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom.

CHITEST(actual_range,expected_range)

CONFIDENCE

 

Returns the confidence interval for a population mean using a normal distribution.

CONFIDENCE(alpha,standard_dev,size)

COVAR

 

Returns covariance, the average of the products of deviations for each data point pair in two data sets.

COVAR(array1,array2)

CRITBINOM

 

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

CRITBINOM(trials,probability_s,alpha)

EXPONDIST

 

Returns the exponential distribution.

EXPONDIST(x,lambda,cumulative)

FDIST

 

Returns the F probability distribution (degree of diversity) for two data sets.

FDIST(x,degrees_freedom1,degrees_freedom2)

FINV

 

Returns the inverse of the F probability distribution.

FINV(probability,degrees_freedom1,degrees_freedom2)

FTEST

 

Returns the two-tailed probability that the variances in array1 and array2 are not significantly different.

FTEST(array1,array2)

GAMMADIST

 

Returns the gamma distribution.

GAMMADIST(x,alpha,beta,cumulative)

GAMMAINV

 

Returns the inverse of the gamma cumulative distribution.

GAMMAINV(probability,alpha,beta)

HYPGEOMDIST

 

Returns the hypergeometric distribution.

HYPGEOMDIST(sample_s,number_sample,population_s,number_pop)

LOGINV

 

Returns the inverse of the lognormal cumulative distribution function.

LOGINV(probability,mean,standard_dev)

LOGNORMDIST

 

Returns the cumulative lognormal distribution.

LOGNORMDIST(x,mean,standard_dev)

MODE

 

Returns the most frequently occurring, or repetitive, value in an array or data range.

MODE(number1,[number2],…])

NEGBINOMDIST

 

Returns the negative binomial distribution.

NEGBINOMDIST(number_f,number_s,probability_s)

NORMDIST

 

Returns the normal distribution for the specified mean and standard deviation.

NORMDIST(x,mean,standard_dev,cumulative)

NORMINV

 

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

NORMINV(probability,mean,standard_dev)

NORMSDIST

 

Returns the standard normal cumulative distribution function.

NORMSDIST(z)

NORMSINV

 

Returns the inverse of the standard normal cumulative distribution.

NORMSINV(probability)

PERCENTILE

 

Returns the k-th percentile of values in a range.

PERCENTILE(array,k)

PERCENTRANK

 

Returns the rank of a value in a data set as a percentage of the data set.

PERCENTRANK(array,x,[significance])

POISSON

 

Returns the Poisson distribution.

POISSON(x,mean,cumulative)

QUARTILE

 

Returns the quartile of a data set.

QUARTILE(array,quart)

RANK

 

Returns the rank of a number in a list of numbers.

RANK(number,ref,[order])

STDEV

 

Calculates standard deviation based on a sample.

STDEV(number1,[number2],…])

STDEVP

 

Calculates standard deviation based on the entire population.

STDEVP(number1,[number2],…])

TINV

 

Returns the two-tailed inverse of the Student’s t-distribution.

TINV(probability,degrees_freedom)

TDIST

 

Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed.

TDIST(x,degrees_freedom,tails)

TTEST

 

Returns the probability associated with a Student’s t-Test.

TTEST(array1,array2,tails,type)

VAR

 

Calculates variance based on a sample.

VAR(number1,[number2],…])

VARP

 

Calculates variance based on the entire population.

VARP(number1,[number2],…])

WEIBULL

 

Returns the Weibull distribution.

WEIBULL(x,alpha,beta,cumulative)

ZTEST

 

Returns the one-tailed probability-value of a z-test.

ZTEST(array,x,[sigma])