excel常用函数

描述性统计量相关

#平均值

=average()

#最大值

=max()

#最小值

=min()

#中位值

=median()

假设检验相关

#F检验（目的是检验两组数A, B的方差是否有显著性差异）

=f.test(A, B)

#T检验（目的是检验两组数A， B的平均值是否有显著性差异）

=t.test(A, B, tails, type)

tails可选1或者2，1代表单尾，2代表双尾，大部分情况选双尾。选择标准如下：

The selection of a one or two-tailed t-test must be made before the experiment is performed. It is not “cricket” to find a that tOBS = -1.92, and then say “I really meant to do a one-tailed t-test.” Because reviewers of articles submitted for publication are sometimes suspicious when a one-tailed t-test is done, the recommendation is that if there is any doubt, a two-tailed test should be done.(1，有很强的证据表明一方比另一方大或者小；2，只对一侧的数据感兴趣。否则都应该用双尾检验)

type 可选1或2或3

1：配对样本的t检验

2：双样本等方差t检验

3：双样本异方差t检验

Note: 如果type选2或3，要先对A, B进行F检验，判断方差是否相等。