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检验，判断方差是否相等。