Posljednja promjena 24.07.2005
| Statistical | ||||
| Name | Source | Type | Description | Syntax |
| AVEDEV | Built In | Statistical | Returns the average of the absolute deviations of data points from their mean | =AVEDEV(Number1,Number2,…) |
| AVERAGE | Built In | Statistical | Returns the average (arithmetic mean) of up to 30 numeric arguments | =AVERAGE(Number1,Number2,…) |
| AVERAGEA | Built In | Statistical | Returns the average (arithmetic mean) of its arguments and includes evaluation of text and logical arguments | =AVERAGEA(Value1,Value2,…) |
| BETADIST | Built In | Statistical | Returns the cumulative beta probability density function | =BETADIST(x,alpha,beta,A,B) |
| BETAINV | Built In | Statistical | Returns the inverse of the cumulative beta probability density function | =BETAINV(probability,alpha,beta,A,B) |
| BINOMDIST | Built In | Statistical | Returns the individual term binomial distribution probability | =BINOMDIST(number_s,trials,probability_s,cumulative) |
| CHIDIST | Built In | Statistical | Returns the one-tailed probability of the chi-squared distribution | =CHIDIST(x,degrees_freedom) |
| CHIINV | Built In | Statistical | Returns the inverse of the one-tailed probability of the chi-squared distribution | =CHIINV(probability,degrees_freedom) |
| CHITEST | Built In | Statistical | Returns the value from the chi-squared (γ2) distribution for the statistic and the appropriate degrees of freedom | =CHITEST(actual_range,expected_range) |
| CONFIDENCE | Built In | Statistical | Returns the confidence interval for a population mean | =CONFIDENCE(alpha,standard_dev,size) |
| CORREL | Built In | Statistical | Returns the correlation coefficient between two arrays of data | =CORREL(array1,array2) |
| COUNT | Built In | Statistical | Counts the number of cells that contain numbers and also numbers within the list of arguments | =COUNT(value1,value2, …) |
| COUNTA | Built In | Statistical | counts how many values are in the list of arguments | =COUNTA(value1,value2, …) |
| COVAR | Built In | Statistical | Returns covariance; the average of the products of deviations for each data point pair | =COVAR(array1,array2) |
| CRITBINOM | Built In | Statistical | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value | =CRITBINOM(trials,probability_s,alpha) |
| DEVSQ | Built In | Statistical | Returns the sum of the squares of the deviations from the sample mean | =DEVSQ(number1,number2,…) |
| EXPONDIST | Built In | Statistical | Returns the exponential distribution | =EXPONDIST(x,lambda,cumulative) |
| FDIST | Built In | Statistical | Returns the F probability distribution | =FDIST(x,degrees_freedom1,degrees_freedom2) |
| FINV | Built In | Statistical | Returns the inverse of the F probability distribution | =FINV(probability,degrees_freedom1,degrees_freedom2) |
| FISHER | Built In | Statistical | Returns the Fisher transformation at x | =FISHER(x) |
| FISHERINV | Built In | Statistical | Returns the inverse of the Fisher transformation | =FISHERINV(y) |
| FORECAST | Built In | Statistical | Calculates a predicted value of y for a given x value based on known values for x and y | =FORECAST(x,known_y’s,known_x’s) |
| FREQUENCY | Built In | Statistical | Counts how often values occur within given ranges of values and returns those counts as a vertical array of numbers | =FREQUENCY(data_array,bins_array) |
| FTEST | Built In | Statistical | Returns the result of an F-test; the one-tailed probability that the variances in array1 and array2 are not significantly different | =FTEST(array1,array2) |
| GAMMADIST | Built In | Statistical | Returns the gamma distribution | =GAMMADIST(x,alpha,beta,cumulative) |
| GAMMAINV | Built In | Statistical | Returns the inverse of the gamma distribution | =GAMMAINV(probability,alpha,beta) |
| GAMMALN | Built In | Statistical | Returns the natural logarithm of the gamma function Γ(x). | =GAMMALN(x) |
| GEOMEAN | Built In | Statistical | Returns the geometric mean of an array or range of positive data | =GEOMEAN(number1,number2, …) |
| GROWTH | Built In | Statistical | Calculates predicted exponential growth and returns the y-values for a series of specified new x-values by using known x-values and y-values | =GROWTH(known_y’s,known_x’s,new_x’s,const) |
| HARMEAN | Built In | Statistical | Returns the harmonic mean of a data set by calculating the reciprocal of the arithmetic mean of reciprocals | =HARMEAN(number1,number2, …) |
| HYPGEOMDIST | Built In | Statistical | Returns the hypergeometric distribution by calculating the probability of a given number of sample successes, given the sample size, population successes, and population size | =HYPGEOMDIST(sample_s,number_sample, population_s, number_population) |
| INTERCEPT | Built In | Statistical | Calculates from given x and y values the point at which a line will intersect the y-axis | =INTERCEPT(known_y’s,known_x’s) |
| KURT | Built In | Statistical | Returns the kurtosis of a data set; a measure that compares the relative peakedness or flatness of a distribution compared with the normal distribution | =KURT(number1,number2, …) |
| LARGE | Built In | Statistical | Returns the kth largest value in a data set | =LARGE(array,k) |
| LINEST | Built In | Statistical | Entered as an array formula, LINEST returns an array that describes a line of best fit by using the least squares method | =LINEST(known_y’s,known_x’s,const,stats) |
| LOGEST | Built In | Statistical | Entered as an array formula, LOGEST calculates an exponential curve that fits known data and returns an array of values that describes that curve | =LOGEST(known_y’s,known_x’s,const,stats) |
| LOGINV | Built In | Statistical | Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with given probability, mean, and standard deviation | =LOGINV(probability,mean,standard_dev) |
| LOGNORMDIST | Built In | Statistical | Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with known mean and standard deviation | =LOGNORMDIST(x,mean,standard_dev) |
| MAX | Built In | Statistical | Returns the maximum value in a list of arguments ignoring logical values and text | =MAX(number1,number2,…) |
| MAXA | Built In | Statistical | Returns the maximum value in a list of arguments including logical values and text | =MAXA(value1,value2,…) |
| MEDIAN | Built In | Statistical | Returns the median of the given numbers | =MEDIAN(number1,number2, …) |
| MIN | Built In | Statistical | Returns the minimum value in a list of arguments ignoring logical values and text | =MIN(number1,number2,…) |
| MINA | Built In | Statistical | Returns the minimum value in a list of arguments including logical values and text | =MINA(value1,value2,…) |
| MODE | Built In | Statistical | Returns the most common value in a data set | =MODE(number1,number2,…) |
| NEGBINOMDIST | Built In | Statistical | Returns the negative binomial distribution; the probability that there will be number_f failures before the number_s-th success, when the constant probability of a success is probability_s | =NEGBINOMDIST(number_f,number_s, probability_s) |
| NORMDIST | Built In | Statistical | Returns the cumulative distribution function or probability mass function for the value x with specified mean and standard deviation | =NORMDIST(x,mean,standard_dev,cumulative) |
| NORMINV | Built In | Statistical | Returns the inverse of the normal cumulative distribution for the specified probability, mean, and standard deviation | =NORMINV(probability,mean,standard_dev) |
| NORMSDIST | Built In | Statistical | Returns the standard normal cumulative distribution function. The distribution has a mean of 0 and a standard deviation of 1 | =NORMSDIST(z) |
| NORMSINV | Built In | Statistical | Returns the inverse of the standard normal cumulative distribution | =NORMSINV(probability) |
| PEARSON | Built In | Statistical | Returns the Pearson product moment correlation coefficient | =PEARSON(array1,array2) |
| PERCENTILE | Built In | Statistical | Returns the kth percentile of values in a range | =PERCENTILE(array,k) |
| PERCENTRANK | Built In | Statistical | Returns the percentage rank of a value in a data set | =PERCENTRANK(array,x,significance) |
| PERMUT | Built In | Statistical | Returns the number of permutations for a given number of objects that can be selected from a number of objects without replacement | =PERMUT(number,number_chosen) |
| POISSON | Built In | Statistical | Returns the Poisson distribution | =POISSON(x,mean,cumulative) |
| PROB | Built In | Statistical | Returns either the probability that values in a range are between two limits or if upper_limit is not specified, the probability that values in x_range are equal to lower_limit | =PROB(x_range,prob_range,lower_limit,upper_limit) |
| QUARTILE | Built In | Statistical | Returns the quartile of a data set | =QUARTILE(array,quart) |
| RANK | Built In | Statistical | Returns the rank of a number in a list of numbers | =RANK(number,ref,order) |
| RSQ | Built In | Statistical | Returns the square of the Pearson product moment correlation coefficient through data points in known_y’s and known_x’s | =RSQ(known_y’s,known_x’s) |
| SKEW | Built In | Statistical | Returns the skewness of a distribution | =SKEW(number1,number2,…) |
| SLOPE | Built In | Statistical | Returns the slope (vertical distance / horizontal distance) of the linear regression line through data points in known_y’s and known_x’s | =SLOPE(known_y’s,known_x’s) |
| SMALL | Built In | Statistical | Returns the kth smallest value in a data set | =SMALL(array,k) |
| STANDARDIZE | Built In | Statistical | Returns a normalized value from a distribution with known mean and standard_dev | =STANDARDIZE(x,mean,standard_dev) |
| STDEV | Built In | Statistical | Estimates standard distribution based on a sample ignoring text and logical values | =STDEV(number1,number2,…) |
| STDEVA | Built In | Statistical | Estimates standard deviation based on a sample including text and logical values | =STDEVA(value1,value2,…) |
| STDEVP | Built In | Statistical | Calculates standard distribution based on the entire population ignoring text and logical values | =STDEVP(number1,number2,…) |
| STDEVPA | Built In | Statistical | Calculates standard deviation based on the entire population including text and logical values | =STDEVPA(value1,value2,…) |
| STEYX | Built In | Statistical | Returns the standard error of the predicted y-value for each x in the regression | =STEYX(known_y’s,known_x’s) |
| TDIST | Built In | Statistical | Returns the probability for the Student t-distribution where a numeric value (x) is a calculated value of t for which the probability is to be computed | =TDIST(x,degrees_freedom,tails) |
| TINV | Built In | Statistical | Returns the t-value of the Student’s t-distribution based on given probability and degrees of freedom | =TINV(probability,degrees_freedom) |
| TREND | Built In | Statistical | Entered as an array formula, TREND fits a straight line using the least squares method to arrays of known_y’s and known_x’s and returns the y-values along that line for the array of specified new_x’s | =TREND(known_y’s,known_x’s, new_x’s,const) |
| TRIMMEAN | Built In | Statistical | Calculates the mean by excluding a specified percentage of data points from the top and bottom tails of a data set | =TRIMMEAN(array,percent) |
| TTEST | Built In | Statistical | Returns the probability associated with a student’s t-test | =TTEST(array1,array2,tails,type) |
| VAR | Built In | Statistical | Estimates variance based on a sample ignoring logical values and text | =VAR(number1,number2,…) |
| VARA | Built In | Statistical | Estimates variance based on a sample including text and logical values | =VARA(value1,value2,…) |
| VARP | Built In | Statistical | Calculates variance based on the entire population ignoring text and logical values | =VARP(number1,number2,…) |
| VARPA | Built In | Statistical | Calculates variance based on the entire population including text and logical values | =VARPA(value1,value2,…) |
| WEIBULL | Built In | Statistical | Returns the Weibull distribution | =WEIBULL(x,alpha,beta,cumulative) |
| ZTEST | Built In | Statistical | Returns the two-tailed P-value of a z-test | =ZTEST(array,x,sigma) |