T检验excel工具

t-检验:样本均数与总体均数的比较（已知样本均数和标准差）总体均数μ0=72t值1.692307692自由度ν24例数n均数标准差SP值（单侧）0.052样本2574.26.5P值（双侧）0.104均数差－μ02.200XXt-检验:样本均数与总体均数的比较（已知样本原始数据）总体均数μ0=72t值2.453357564自由度ν9例数n均数标准差SP值（单侧）0.018样本1067.45.9292121P值（双侧）0.037均数差－μ0-4.600XX样本原始数据54676878706667706569配对t检验原始数据t-检验:成对双样本均值分析个体号X1X21101100X1X22131136平均110.8333109.53131126方差586.8788718.63644143150观测值12125124128泊松相关系数0.9569316137126假设平均差07126116df11895105tStat0.58374299087P(T=t)单尾0.285585106757t单尾临界1.795884118474P(T=t)双尾0.57116912101109t双尾临界2.200986患者X1健康人X2F-检验双样本方差分析0.840.541.050.64患者X1健康人X21.20.64平均1.5209090911.0846151.20.75方差0.1779090910.178211.390.76观测值11131.530.81df10121.671.16F0.9983100551.81.2P(F=f)单尾0.5063192931.871.34F单尾临界0.3432916172.071.352.111.481.561.87患者X1健康人X2t-检验:双样本等方差假设0.840.541.050.64患者X1健康人X21.20.64平均1.520909091.08461541.20.75方差0.177909090.17821031.390.76观测值11131.530.81合并方差0.178073361.671.16假设平均差01.81.2df221.871.34tStat2.523724052.071.35P(T=t)单尾0.009668522.111.48t单尾临界1.717144191.56P(T=t)双尾0.019337041.87t双尾临界2.07387529两样本无原始数据，只有均数、标准差、例数时的t检验样本1样本2均数45.7245.29标准差5.436.14例数5050检验水准0.05df98合并方差33.59225tStat0.370953022t值P(T=t)单尾0.355736601t单尾临界1.660551217P(T=t)双尾0.711473201t双尾临界1.984467455患者X1健康人X2t-检验:双样本异方差假设0.840.541.050.64患者X1健康人X21.20.64平均1.520909091.08461541.20.75方差0.177909090.17821031.390.76观测值11131.530.81假设平均差01.671.16df211.81.2tStat2.523909991.871.34P(T=t)单尾0.009865232.071.35t单尾临界1.720743512.111.48P(T=t)双尾0.019730471.56t双尾临界2.079614211.87样本1均数1.52090909090909标准差0.421792710829729例数11检验水准0.05假设平均差0df=(B4^2/B5+C4^2/C5)^2/((B4^2/B5)^2/(B5-1)+(C4^2/C5)^2/(C5-1))tStat=(B3-C3)/(B4^2/B5+C4^2/C5)^0.5P(T=t）单尾=TDIST(ABS(B9),B8,1)t单尾临界=TINV(B6*2,B8)P(T=t)双尾=TDIST(ABS(B9),B8,2)t双尾临界=TINV(B6,B8)两样本总体方差不齐的t检验(非原始数据)样本21.084615384615380.4221495663982813两样本总体方差不齐的t检验(非原始数据)z-检验:双样本均值分析变量1变量2平均4.654.22标准差0.550.44观测值15674检验水准0.05假设平均差0z6.371021468P(Z=z)单尾9.38867E-11z单尾临界1.644853627P(Z=z)双尾1.87773E-10z双尾临界1.959963985差值均数差值标准差对子数42.549t值11.2p值