t-检验:样本均数与总体均数的比较（已知样本均数和
标准
excel标准偏差excel标准偏差函数exl标准差函数国标检验抽样标准表免费下载红头文件格式标准下载
差）总体均数μ0=72t值1.692307692自由度ν24例数n均数标准差SP值（单侧）0.052样本2574.26.5P值（双侧）0.104均数差－μ02.200样本原始数据t-检验:样本均数与总体均数的比较（已知样本原始数据）5467总体均数μ0=72t值2.45335756468自由度ν978例数n均数标准差SP值（单侧）0.01870样本1067.45.929212052P值（双侧）0.03766均数差－μ0-4.60067706569配对t检验原始数据t-检验:成对双样本均值分析个体号X1X21101100X1X22131136平均110.8333333109.53131126方差586.8787879718.63636364143150观测值12125124128泊松相关系数0.95693087696137126假设平均差07126116df11895105tStat0.583742308199087P(T<=t)单尾0.2855846705106757t单尾临界1.795883691118474P(T<=t)双尾0.571169341112101109t双尾临界2.200986273患者X1健康人X2F-检验双样本方差分析0.840.541.050.64患者X1健康人X21.20.64平均1.5209090911.0846153851.20.75方差0.17790909090.17821025641.390.76观测值11131.530.81df10121.671.16F0.99831005521.81.2P(F<=f)单尾0.50631929281.871.34F单尾临界0.34329161742.071.352.111.481.561.87患者X1健康人X2t-检验:双样本等方差假设0.840.541.050.64患者X1健康人X21.20.64平均1.5209090911.0846153851.20.75方差0.17790909090.17821025641.390.76观测值11131.530.81合并方差0.1780733631.671.16假设平均差01.81.2df221.871.34tStat2.5237240462.071.35P(T<=t)单尾0.00966851982.111.48t单尾临界1.7171441871.56P(T<=t)双尾0.01933703961.87t双尾临界2.073875294两样本无原始数据，只有均数、标准差、例数时的t检验样本1样本2均数1.521.08标准差0.42180.4221例数1113检验水准0.05df22合并方差0.1780533327tStat2.545306115P(T<=t)单尾0.0092211945t单尾临界1.717144187P(T<=t)双尾0.018442389t双尾临界2.073875294患者X1健康人X2t-检验:双样本异方差假设0.840.541.050.64患者X1健康人X21.20.64平均1.5209090911.0846153851.20.75方差0.17790909090.17821025641.390.76观测值11131.530.81假设平均差01.671.16df211.81.2tStat2.5239099941.871.34P(T<=t)单尾0.00986523352.071.35t单尾临界1.7207435122.111.48P(T<=t)双尾0.0197304671.56t双尾临界2.0796142051.87两样本总体方差不齐的t检验(非原始数据)样本1样本2均数1.5209090911.084615385标准差0.42179271080.4221495664例数1113检验水准0.05假设平均差0df21tStat2.523909994P(T<=t）单尾0.0098652335t单尾临界1.720743512P(T<=t)双尾0.019730467t双尾临界2.079614205z-检验:双样本均值分析变量1变量2平均4.654.22标准差0.550.44观测值15674检验水准0.05假设平均差0z6.371021468P(Z<=z)单尾9.43148E-11z单尾临界1.644853476P(Z<=z)双尾0.0000000002z双尾临界1.959962787
浙公网安备 33021202002483