《Excel在统计分析中的应用.pptVIP

教材P79【例4-4】某食品厂在甲乙两条生产线上各测了30个日产量如下表，试检验两条生产线的平均日产量有无显著差异？ 甲生产线（kg）（x1） 74 62 61 77 59 71 57 72 65 62 56 62 62 54 78 54 69 70 58 53 71 73 78 63 67 78 63 74 62 70 乙生产线（kg）（x1） 65 58 58 60 68 53 49 58 70 70 54 51 66 65 52 60 53 71 58 55 56 66 53 56 55 69 62 56 69 57 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 先用粘贴函数=VAR(数值)计算方差 输入格式单行或单列 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 将方差数值代入 用z-检验 Evaluation only. Created with Aspose.Slides for .NE