FDIST FDIST(x,deg_freedom1,deg_freedom2) Returns the F probability distribution. EXPONDIST EXPONDIST(x,lambda,cumulative) Returns the exponential distribution. CRITBINOM CRITBINOM(trials,probability_s,alpha) Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
New function: COVARIANCE.P function and COVARIANCE.S function. COVAR COVAR(array1,array2) Returns covariance, the average of the products of paired deviations.
New function: CONFIDENCE.NORM function and CONFIDENCE.T function. CONFIDENCE CONFIDENCE(alpha,standard_dev,size) Returns the confidence interval for a population mean. CHITEST CHITEST(actual_range,expected_range) Returns the test for independence. New function: CHISQ.INV function and function. CHIINV CHIINV(probability,deg_freedom) Returns the inverse of the one-tailed probability of the chi-squared distribution. New function: CHISQ.DIST function and function. CHIDIST CHIDIST(x,deg_freedom) Returns the one-tailed probability of the chi-squared distribution. BINOMDIST BINOMDIST(number_s,trials,probability_s,cumulative) Returns the individual term binomial distribution probability. BETAINV BETAINV(probability,alpha,beta,) Returns the inverse of the cumulative distribution function for a specified beta distribution. BETADIST BETADIST(x,alpha,beta,) Returns the beta cumulative distribution function. You can still use them for compatibility with earlier versions of Excel, but if backward compatibility isn't required, you should start using the new functions instead. In Excel 2010 or later, these functions were replaced with new functions that provide improved accuracy and have names that better reflect their usage.
0 kommentar(er)
