Advanced Excel - Compatibility Functions


Advertisements


In Excel 2010 or later, the functions listed in this category were replaced with new functions that provide improved accuracy and have names that reflect their usage better. The new functions can be found in Statistical functions and Math and trigonometry functions. If backward compatibility is not required, you should start using the new functions.

You can still use these earlier versions of functions for compatibility with earlier versions of Excel. If you are using Excel 2007, you will find these functions in the Statistical or Math & Trig categories on the Formulas tab.

Compatibility Functions

The following table lists all the Compatibility functions −

S.No. Function and Description
1 BETADIST

Returns the cumulative beta probability density function

2 BETAINV

Returns the inverse of the cumulative beta probability density function

3 BINOMDIST

Returns the individual term binomial distribution probability

4 CEILING

Rounds a number to the nearest integer or to the nearest multiple of significance

5 CHIDIST

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

6 CHIINV

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

7 CHITEST

Returns the test for independence

8 CONFIDENCE

Returns the confidence interval for a population mean

9 COVAR

Returns covariance, the average of the products of paired deviations

10 CRITBINOM

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

11 EXPONDIST

Returns the exponential distribution

12 FDIST

Returns the F probability distribution

13 FINV

Returns the inverse of the F probability distribution

14 FLOOR

Rounds a number down, toward 0

15 FTEST

Returns the result of an F-Test

16 GAMMADIST

Returns the gamma distribution

17 GAMMAINV

Returns the inverse of the gamma cumulative distribution

18 HYPGEOMDIST

Returns the hypergeometric distribution

19 LOGINV

Returns the inverse of the lognormal distribution

20 LOGNORMDIST

Returns the cumulative lognormal distribution

21 MODE

Returns the most common value in a data set

22 NEGBINOMDIST

Returns the negative binomial distribution

23 NORMDIST

Returns the normal cumulative distribution

24 NORMINV

Returns the inverse of the normal cumulative distribution

25 NORMSDIST

Returns the standard normal cumulative distribution

26 NORMSINV

Returns the inverse of the standard normal cumulative distribution

27 PERCENTILE

Returns the kth percentile of values in a range

28 PERCENTRANK

Returns the percentage rank of a value in a data set

29 POISSON

Returns the Poisson distribution

30 QUARTILE

Returns the quartile of a data set

31 RANK

Returns the rank of a number in a list of numbers

32 STDEV

Estimates standard deviation based on a sample, ignoring text and logical values

33 STDEVP

Calculates standard deviation based on the entire population, ignoring text and logical values

34 TDIST

Returns the student’s t-distribution

35 TINV

Returns the inverse of the student’s t-distribution

36 TTEST

Returns the probability associated with a student’s t-Test

37 VAR

Estimates variance based on a sample, ignoring logical values and text

38 VARP

Calculates variance based on the entire population, ignoring logical values and text

39 WEIBULL

Returns the Weibull distribution

40 ZTEST

Returns the two-tailed P-value of a z-test



Advertisements
E-Books Store