《可重复双因素方差分析.xls》由会员分享,可在线阅读,更多相关《可重复双因素方差分析.xls(4页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、专专家家型型号号1型型号号2型型号号3型型号号4型型号号5型型号号6型型号号7型型号号8156264545585885482785985758449495732385764856767651445614949261815695867329567582728264154538681704391725904629265652508791986545952696496076427585866761104648587625359071方差分析:无重复双因素分析SUMMARY观测数求和平均方差11053853.8224.421067167.1 254.988888931062462.4 356.7111
2、11141045345.3 423.788888951063163.1 485.433333361061761.7 349.344444471051751.7 490.455555681060160.1324.191060760.7 475.1222222101060160.1 444.5444444型号11053953.9 486.7666667型号21059159.1 551.2111111型号31056956.9 371.2111111型号41059359.3 320.0111111型号51057557.5 595.8333333型号61058258.2 453.0666667型号710
3、61861.8502.4型号81064464.4 200.4888889型号91058858.8 469.7333333型号101056156.1 206.7666667方差分析差异源SSdfMSFP-valueF crit行37309 414.444444 0.996515017 0.4497059 1.99760915列772.69 85.8444444 0.206409518 0.9927407 1.99760915误差3368781 415.893827总计3819099型型号号9型型号号105958864957767645255146528261596025307379产品男女方差分
4、析:可重复双因素分析甲6841SUMMARY男女总计7854甲2545观测数1010205928求和61644410607567平均61.644.4537671方差394.0444 411.1556 459.26315886236113乙3234观测数101020乙2156求和5472748215112平均54.727.441.056020方差434.4556 308.7111 548.15526371528116总计6948观测数20204215求和11637182124平均58.1535.96121方差404.9763 417.04217010方差分析差异源SSdfMSF样本1428.02511428.025 3.689113259列4950.62514950.625 12.78928333交互255.0251255.025 0.658823276内部13935.336 387.091667总计20568.9739P-valueF crit0.062716587 4.1131652190.001016855 4.1131652190.422310245 4.113165219