Advanced Excel Functions 简明教程

Advanced Excel - Compatibility Functions

在 Excel 2010 或更高版本中，此类别中列出的函数已被提供改进的准确性和具有更能反映其使用情况的名称的新函数所取代。可在统计函数以及数学和三角函数中找到新函数。如果不需要向后兼容性，您应开始使用新函数。

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.

您仍然可以使用早期版本的函数来兼容早期版本的 Excel。如果您正在使用 Excel 2007，您将在“公式”选项卡上的“统计”或“数学和三角”类别中找到这些函数。

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	BETADISTReturns the cumulative beta probability density function
2	BETAINVReturns the inverse of the cumulative beta probability density function
3	BINOMDISTReturns the individual term binomial distribution probability
4	CEILINGRounds a number to the nearest integer or to the nearest multiple of significance
5	CHIDISTReturns the one-tailed probability of the chi-squared distribution
6	CHIINVReturns the inverse of the one-tailed probability of the chi-squared distribution
7	CHITESTReturns the test for independence
8	CONFIDENCEReturns the confidence interval for a population mean
9	COVARReturns covariance, the average of the products of paired deviations
10	CRITBINOMReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
11	EXPONDISTReturns the exponential distribution
12	FDISTReturns the F probability distribution
13	FINVReturns the inverse of the F probability distribution
14	FLOORRounds a number down, toward 0
15	FTESTReturns the result of an F-Test
16	GAMMADISTReturns the gamma distribution
17	GAMMAINVReturns the inverse of the gamma cumulative distribution
18	HYPGEOMDISTReturns the hypergeometric distribution
19	LOGINVReturns the inverse of the lognormal distribution
20	LOGNORMDISTReturns the cumulative lognormal distribution
21	MODEReturns the most common value in a data set
22	NEGBINOMDISTReturns the negative binomial distribution
23	NORMDISTReturns the normal cumulative distribution
24	NORMINVReturns the inverse of the normal cumulative distribution
25	NORMSDISTReturns the standard normal cumulative distribution
26	NORMSINVReturns the inverse of the standard normal cumulative distribution
27	PERCENTILEReturns the kth percentile of values in a range
28	PERCENTRANKReturns the percentage rank of a value in a data set
29	POISSONReturns the Poisson distribution
30	QUARTILEReturns the quartile of a data set
31	RANKReturns the rank of a number in a list of numbers
32	STDEVEstimates standard deviation based on a sample, ignoring text and logical values
33	STDEVPCalculates standard deviation based on the entire population, ignoring text and logical values
34	TDISTReturns the student’s t-distribution
35	TINVReturns the inverse of the student’s t-distribution
36	TTESTReturns the probability associated with a student’s t-Test
37	VAREstimates variance based on a sample, ignoring logical values and text
38	VARPCalculates variance based on the entire population, ignoring logical values and text
39	WEIBULLReturns the Weibull distribution
40	ZTESTReturns the two-tailed P-value of a z-test