《第8章 均值之差推断计算结果.xls》由会员分享，可在线阅读，更多相关《第8章 均值之差推断计算结果.xls（7页珍藏版）》请在三一办公上搜索。
1、会计专业财务专业t-检验:双样本等方差假设95%的置信区间56,40052,60050,60047,200会计专业财务专业52,40050,000平均54500.0051216.67观察均值差异3283.3355,80046,000方差11938181.82 15246969.7标准误差1505.1354,00055,800观测值1212t 统计量2.0752,40049,000合并方差13592575.76抽样极限误差3121.4656,20058,000假设平均差0估计下限161.8749,40054,800df22估计上限6404.7950,40047,000t Stat2.181458
2、,40053,800P(T=t)单尾0.020159,40052,400t 单尾临界1.717158,60048,000P(T=t)双尾0.0401t 双尾临界2.0739=E4-F4=(I4-E8)/E10=TINV(0.05,E9)=I6*I5=I4-I7=I4+I7旧灯泡新灯泡t-检验:双样本等方差假设42554645旧灯泡新灯泡6458平均47.5 52.4166675352方差90.54761905 21.5378793854观测值22124447合并方差66.825520836151假设平均差04461df325049t Stat-1.6759546056P(T=t)单尾0.051
3、7463143952t 单尾临界1.6938884075149P(T=t)双尾0.10349262842t 双尾临界2.036931619374565544642442652F-检验 双样本方差分析旧灯泡新灯泡平均47.5 52.416667方差90.54761905 21.537879观测值2212df2111F4.204110346P(F=f)单尾0.008838065双侧P值0.017676129F 单尾临界2.63583644t-检验:双样本异方差假设旧灯泡新灯泡平均47.5 52.41667方差90.54762 21.53788观测值2212假设平均差0df32t Stat-2.02
4、234P(T=t)单尾0.025783t 单尾临界1.693888P(T=t)双尾0.051567t 双尾临界2.036932男性周工资女性周工资341293t-检验:双样本异方差假设446418269248男性周工资女性周工资330275平均625.6307692494.3384615450378方差68349.4865437976.38365590534观测值6565526422假设平均差0869742df118766629t Stat3.246209074473384P(T=t)单尾0.000761233792514t 单尾临界1.657870143322253P(T=t)双尾0.001
5、522467970707t 双尾临界1.9802700997696063863167196559898126554736594174503783272963403006554737554936554733302754733843222531267959292259396337854632105973677870534129638130632729639226673259310597364343245163537745514823777787057696063922663922667196552842605515181059736719655764689760674284260733686328
6、26879159065547395066271152910597369898121267959旧新离差t-检验:成对双样本均值分析37,66131,9025,75942,34241,2031,139旧新31,10838,816-7,708 平均3721240303.7541,23943,305-2,066 方差23678506 43699518.3932,90335,375-2,472 观测值121242,65852,353-9,695 泊松相关系数0.73649040929,82930,883-1,054 假设平均差039,61649,424-9,808 df1134,62538,724-4,099 t Stat-2.3950919342,65043,234-584 P(T=t)单尾0.01776992431,92334,565-2,642 t 单尾临界1.79588369139,99043,861-3,871 P(T=t)双尾0.035539848均值-3,092 t 双尾临界2.200986273标准差4471.701标准误差 1290.869t 统计量-2.39509P值0.01777
