楼主需要确定数据服从什么分布，正态分布，t分布，卡方分布？

ZTEST

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

[TTEST]

Returns the probability associated with a Student's t-test

FTEST

Returns the result of an F-test

TDIST(x,degrees_freedom,tails)
X   is the numeric value at which to evaluate the distribution.
Degrees_freedom   is an integer indicating the number of degrees of freedom.
Tails   specifies the number of distribution tails to return. If tails = 1, TDIST returns the one-tailed distribution. If tails = 2, TDIST returns the two-tailed distribution.

FDIST(x,degrees_freedom1,degrees_freedom2)

X   is the value at which to evaluate the function.

Degrees_freedom1   is the numerator degrees of freedom.

Degrees_freedom2   is the denominator degrees of freedom.

楼主可以参阅excel的help文件。